This tutorial
is a continuation of the "Record Insertion" tutorial and will create
what is called the "whoswho.php" page. This page will display the member's
information that gets entered into our database from "insert.php."
In order
for the "Dynamic Table" that we place in whoswho.php to work properly
we have to install a "recordset" on the page. This tutorial will include
the "recordset" instructions.
- Create
a new php page and call it whoswho.php
- Make
sure you have a database connection. If you have not closed your insert.php
page in DreamWeaver, then you will still see it showing "inserting"
Select the "Recordset" icon.
The
recordset applet will appear. Fill out the form entries as in this image:
Adding
the Dynamic Table
Place
your cursor anywhere on the design area of whoswho.php
Click
the "Dynamic Table" dropdown icon:
Dynamic
Table Applet - Set the parameters the same as the image:
The
recordset name is the same as the default name. We are also setting
it to show a table that will only provide 10 records at a time. If our
Members goes higher than 10, then another page link will be provided
so that you can navigate through your members. Click OK.
Resulting
Page:
Don't
forget to save this as "whoswho.php"
At this
point you will need to upload the following files and directories:
- insert.php
- whoswho.php
- Connections
folder
DreamWeaver
is set up to include files that are linked to other files when you use
their FTP client. A warning that states "Include dependant files" pops
up when you upload a page or directory. If this is the case, select
"YES" if this pop up should appear.
If it does
not, make sure that you have uploaded all of the files listed above
in your web root directory.
Once you
have done this, open a Browser and go to www.yoursite.com/insert.php
and submit
a username, password and enter your e-mail.
If all goes
well, the whoswho.php page will show up next and show you your information.
You can look at whoswho.php without having to insert info as well. This
makes for a great inventory control page.
Also, you
can apply CSS to change the style of your HTML tables so that it mirrors
the design of your site. This applications can introduced into fully
designed pages.
- Check
out PHPMyAdmin on your server and you'll see in the "members" table
that "Browse" is now active. Select it and you'll see the structure
of your database table and the same information you entered into insert.php
|