Here you will find the notes I used to review the material in Build Your Own Database Driven Website Using PHP and MySQL, by Kevin Yank. 2nd Edition, published by Sitepoint Pty. Ltd. ISBN 0-9579218-1-0. These are summaries; the book contains much more information, and I recommend that you go ahead and buy it.
As I warned you, we did review Chapter 4, at the December 2004 Database SIG meeting. Using (mostly) the information in that chapter, I developed some forms that gather information and enter it into a database, sort the records, and delete selected records. Below you will see links to these forms, which are working examples.
A contact form.
A form to sort the records.
A form to delete selected records.
Here are the PHP scripts (called by the forms) that actually carry out the tasks of adding to, sorting, or deleting the information in the database, as well as displaying the current database contents. NOW NOTICE ONE THING: These are NOT provided with the .php extension. They are provided with a .txt extension, because you would not be able to see them in your browser otherwise. When you click on the links, the scripts will be displayed in your browser in text format. You can use them to follow the code and see how they work. If you want actually to use them, remember that they have to be processed by a web server, either locally or on your website, and that you will therefore have to change the extensions to .php and change the user id and passwords to others of your choice, matching those you have created for your own database. You can copy and paste the scripts from your browser window into your favorite html or text editor so that you can modify them.
To update the database.
To view the current database listing.
To sort the database records.
To delete selected records. (Don't go crazy, now.)
We completed the review of Chapter 3 in September, through the Chapter 3 notes, page 3 (see below, Notes from 08-21-04.) We will cover Chapter 4 in future meetings. The Chapter 4 notes are below, and they include live links to a database.
At the August 21st, 2004 meeting, we reviewed Chapter 2 and some of Chapter 3 (through the Chapter 3 notes, page 1.) Pages 2 and 3 of the Chapter 3 notes include a series of html and php pages as examples. When you use these example pages, you will need to use the Back button on your browser to return to the notes page!
Now, here's an incentive to read these notes.
There will be a test.