Your second database assignment will also be taken from the textbook PHP amd MySQL for Dummies (35-36. (This text is no longer available in electronic format from the Thompson Library, but I have scanned the pages, which you can view here (same password as lectures).
This should perhaps have been your first assignment since you will be using a program to test whether you can access MySQL by using PHP. On page 35 of the book, it displays a program named mysql_up.php. (Since this program using commands available with PHP 5 and above, and the profhicks server supports just the PHP 4 version, you will have to user the version specific to PHP 4. The text indicates that you can download all of the example programs from this text from the authors web site at: http://www.dummies.com/DummiesTitle/productCd-0470096004.html ( http://www.dummies.com/store/product/PHP-MySQL-For-Dummies-3rd-Edition.productCd-0470096004,navId-322468,descCd-DOWNLOAD.html ) Here you can download a zipped file with all programs.
Note: there will be two versions of
the files one: mysql_up.php has mysql functions for php 5 and a
version ending in 4, mysql_up-4.php in this case, which will work
on your profhicks account.
(These files are also on my
progdata folder at:
HICKS/363/FinalProjectFiles/ch04 )
Open the file mysql_up-4.php in your text editor of choice. The lines 10 & 11 need to be changed to add your user name and your password. Your user name will be of the form: $user="hickslm_hickslm", where you use your profhicks account name instead of hickslm. then fill in your password within the " marks.
$user="";
$password="";
Once you have made this change, upload the file to your profhicks server account. When you open the page in a web browser you should see something like this page:
Place a link to this page from your course home page. (See link in my demo student page )
This assignment is worth 20 points.
[top]