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 no longer available through the Thompson Library in ebook format, so I have scanned relavant pages for you and posted them in my lectures password protected folder. See: Chapter 11. Building an Online Catalog for the catalog part of this final project, and Chapter 4. Building the Database for the last part of the assignment.

Files you will need to modify form the textbook PHP and MySQL FOR DUMMIES, zipped together. See zipped files ch11.zip & ch4.zip at: http://profhicks.com/lmhLectures/dummiesCh/

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 demo student pages at http://profhicks.com/labs/finalProj/DemoFinalProjectLinks.htm )

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 ="CSC363Sp10";
$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 06/20/2010 by L.M. Hicks