CSC/CIS 363 Final Project Part II: 

Modify the following programs from the chapters indicated from the textbook PHP and MySQL FOR DUMMIES, so that they work with your database. This book is available through the Thompson Library in ebook format, you need to use your UM-Flint ID and LAN password to be able to access the complete text.

Deliverables:

When you have completed this final project add a list of links to your course home page which link to your files PetShopFront.php, PetCatalog.php and mysql_send.php 
(See my demo student home page at: http://hickslm.profhicks.com/ )

Textbook Data files:

You can download all program examples in this text from the publishers' web site at: http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470096004.html   Here you will also be able to download pdf versions of  chapter 1, Contents and Index. (Unfortunately, the pictures used in the textbook examples are not available for download, but you can download the images I used in may examples in zipped format, or use your own images.)

When you have finished modifications to the indicated php files, upload your php files along with images you will be using to your profhicks server account, then place a link to the files from your course home page.

Modifying Textbook Data Files

The example programs, for the most part will not execute without some minor modification.  You will need to update the files with the names of your database, login name and password.  For example, there is a file INCLUDED in many of the examples, named misc.inc containing data:

<?php

$host = "localhost";
$user = "";
$passwd = "";
$dbname = "PetCatalog";

?>
 Changes I made for my site listed to the right.  You will need to replace my account username hickslm with your profhicks account name.
$user="hickslm_hickslm";
$host="localhost";
$passwd ="CSC363F08";
$dbname = "hickslm_PetCatalog";

PHP Versions on profhicks:

In one of your earlier labs I mentioned that your profhicks account doesn't support php 5.0.  That is incorrect, both php 4 & php 5 are supported on your profhicks account.

Testing Table Data:

The file mysql_send.php  is used to input MySQL queries to verify you have set up your database and tables with data. If you have set up your database correctly you should be able to query the information using your mysql_send.php.  (It should query YOUR DATABASE NOT mine!)

I illustrate issuing a MySQL  command and the corresponding output below.

Click on an image to load the full-sized picture.

      

More Queries Demonstrated:

More Queries Demonstrated:

 

[top] [363 Course Home] [Blackboard]

This page was last updated on 12/07/2008 by L.M. Hicks