PHP Examples for CSCI 5633 Web Database Development


 [Return to Dr. Liaw's Homepage]


1. PHP Essentials

Ch # PHP Examples Description
02 01 First A Hello World script Windows/IIS
02 02 Calc01 Calculates Hard-Coded Values Windows/IIS
02 03 Calc02      Does Some Formatting (Uses sprintf()). Windows/IIS
02 04 Show_calculate Perform Calculation Using HTML Form Inputs Windows/IIS
02 05 Show_calculate-b      Using Pull-Down Menus for Values Windows/IIS
02 06 Show_menu Redirect to New Location - HTML Form  Windows/IIS
02 07 PHP Info PHP Environment Variables Windows/IIS
02 08 Remote_address Capture User's IP Address Windows/IIS
02 09 Browser_match Displaying Browser-Specific Code Using preq_match() Windows/IIS
02 10 Show_feedback Sending E-Mail Windows/IIS
02 11 Write_data Writing Data File Windows/IIS
02 12 Read_data Reading Data File Windows/IIS
03 13 mysql_connect Connect to testDB and Display Table Friend_Info Windows/IIS
04 14 Show_createtable1 Create a Database Table Windows/IIS
04 15 Show_addrecord Inserting Data into Table My Products Windows/IIS
04 16 Display_menu Display Data in Table My Products Windows/IIS
05 17 Login      Using HTML Forms Windows/IIS
05 18 Login2 Combine HTML & PHP Using include() Windows/IIS
05 19 LimitbyIP Limit by IP Address Windows/IIS
05 20 LimitbyIP2 Limit by A Range of IP Address Windows/IIS
06 21 Setcookie Setting Cookies Windows/IIS
06 22 Count_me Starting a Session and Registering Variables Windows/Apache
06 23 Count_me_reset Reset Count_me Windows/Apache
06 24 Session1 Managing User Preferences with Sessions Windows/Apache
06 25 Session2 Managing User Preferences with Sessions Windows/Apache
07 26 Admin_menu Web-Based Database Administration Windows/IIS
07 27 secret_form.htm ? Data Encryption Windows/IIS
07   28 Shop_menu.php ? A Shopping System Windows/IIS
09 29 Parse.php Parsing XML Windows/IIS
09 30 Markup.php Parse and Display Content from XML Files Windows/IIS

2. PHP Fast & Easy

01 11 db_connect Connecting to MySQL Windows/IIS
02 11 db_listdb Listing Databases on a Server Windows/IIS
03 11 db_listtables Listing Tables in a Database Windows/IIS
04 11 db_createdb Creating a New Database Windows/IIS
05 11 db_dropdb Deleting a Database Windows/IIS
06 12 show_createtable Creating a Database Table Windows/IIS
07 13 show_addrecord Inserting Data Into Table My Music Windows/IIS
08 14 my_menu Selecting and Displaying Data in My Music Windows/IIS
09 15 show_adduser Adding User Windows/IIS
10 15 show_login User Authentication Windows/IIS
11 16 setcookie Setting a Test Cookie Windows/IIS
12 16 show_login Using Cookies with Authentication Windows/IIS
13 16 secretB Checking for the Authentication Cookie Windows/IIS
14 17 session Starting a Session Windows/Apache
15 17 countme Modifying Session Variables Windows/Apache
count_me_reset Reset countme Windows/Apache
16 17 session01 Start a Session and Register Preferences Windows/Apache
17 17 session02 Change Preferences Windows/Apache
18 18 show_createtable Create Table Modified Version Windows/IIS
19 18
~22
contact_menu ? Contact Management System Windows/IIS