Due: see class web page

0. Preparations

• To do this project, you must obtain a copy of the prepared files with these commands (run on lab0z.mathcs.emory.edu):

  In a UNIX window running on lab0z: ssh -X holland (and login with your Emory NetID passwd) In the same window after you log in to "holland": scp lab0z:/home/cs377001/Handouts/PHP/php-form.html ~/public_html/ (enter your Emory NetID password)

  To verify that you have copied the file php-form.html correctly, type the following URL in a web browser (firefox, IE, Safari, ...) (on your laptop or on a lab machine):

  http://holland.mathcs.emory.edu/~Your-NetID/php-form.html

  You should see the following form with the title CS377 PHP project :

1. Assignment

You must work on this assignment on holland.mathcs.emory.edu.

You can login to holland.mathcs.emory.edu with this command from any lab machine or from lab0z.mathcs.emory.edu:

ssh -X holland (enter your Emory NetID passwd) On holland: cd public_html (You will be working in this directory to do the PHP project)

---

The assignment consists of 2 parts:

Edit the php-form.html webpage (that you have downloaded in the preparation step) to run a PHP program that you need to write in step 2 To edit a file, use this command: gedit filename Example: gedit php-form.html Look for this line in the php-form.html webpage: <form action="http://holland.mathcs.emory.edu/~YOUR-ID-HERE/your-prog-name.php" method="post"> Change the YOUR-ID-HERE to your Emory Net ID (do not remove the ~ character when you make the change !!!) Change the your-prog-name into whatever name you want to call your PHP program. You can pick a program name yourself.           (This part is very easy, should be done in 1 minute) Write a PHP program (work on holland !!!) to process the request made through the php-form.html webpage. To write the PHP program (work on holland !!!), do: gedit your-prog-name.php (on holland !!) The PHP program will be executed by the form (webpage) that you made in step 1 above. The php-form.html webpage is used to list shipment information from the spjDB database (same database you used in the SQL projects). More details on what the PHP program must do follows.... Execute the following command to make the PHP program executable: chmod 755 your-prog-name.php

---

---

The user can make queries on the spjDB database by entering one or more values for supplier name, supplier city, part name, part city, project name and/or project city:

and then click Submit Query to send the 6 input fields to the web server.

In response, the web server will execute the PHP program (describe in step 2) and retrieve all shipment information that matches the input field criterias.

Examples:

If the user fills in Supplier City = 'London' (while leaving all other fields blank), then the query returns all shipment data on suppliers whose city is 'London'. If the user fills in Supplier City = 'London' and Project Name = 'ProductX', then the query returns all shipment data on suppliers whose city is 'London' to project whose name is 'ProductX'.

Furthermore, the input must allow for UNIX style wildcards:

• * = matches 0 or more characters
• ? = matches 1 character

Example:

If the user fills in Supplier City = 'A*', then the query returns all shipments by suppliers whose city name starts with the letter 'A'.

---

---

• The format of the output (return as a webpage) must be as follows:

  Supplier Name	Supplier City	Part Name	Part City	Project Name	Project City	Quantity Shipped
  ...	...	...	...	...	...	...
  ...	...	...	...	...	...	...
  ...	...	...	...	...	...	...

  • The attributes in the output are:
    • Supplier name and city
    • Part name and city
    • Project name and city
    • Quantity of the shipment

    The other attributes must not be listed

  The header (first row containing the attribute names) must have a different background color from the data rows.

Some notes to help you work on this project

• Testing your PHP program
  • Do not test a PHP program using a browser !!!

    Instead, run the PHP program as a stand-alone PHP program that you execute with a line command

    ---

    ---

  • I have written a tool to help you test the PHP program of the CS377 project

    To test your CS377 project, use the following command on holland:

    If you haven't done so: go to your public_html directory: cd ~/public_html To test your PHP projetc, run: /home/cs377001/bin/test-php YourPHPprog.php sname pname jname scity pcity jcity

    ---

  • Example: assuming your PHP program is called PHPproj.php

    /home/cs377001/bin/test-php PHPProj.php Lofton "" "" "" "" "" (Should get all shipment for supplier Loftus) (An empty field is denoted by "")

    The /home/cs377001/bin/test-php command will initialize all 6 variables in the form (see the content of the webpage file) before it execute your PHP program

    ---

    ---

  • The output of the stand-alone PHP program is text; and it won't look a nice as a webpage.

    But at least you will have more information when the program crashes (in a webpage version, you get a blank webpage when your program crashes)

  ---

  ---

  ---

  ---

• Use print() instead of mysql_query() to debug

  • If your PHP program crashes without an error message, you should:

    Replace the mysql_query( ) call by a print( ) call. This will echo the SQL command that you would use to retrieve the data Maybe you did not formulate the query correctly.

  ---

  ---

  ---

  ---

• Handling UNIX style wild cards
  • You can handle the UNIX style wild card by replacing the the UNIX style wild card characters by SQL-style wild card characters before you send the query to the server for processing

  • This small PHP program shows you how to replace the charater o by the character u:

    <?php $x = "Hello World"; print $x."\n"; for ( $i = 0; $i < strlen($x); $i++ ) { if ( $x[$i] == 'o' ) $x[$i] = 'u'; } print $x."\n"; ?>

  ---

  ---

  ---

  ---

• Empty input field in the form
  • The user can leave some input fields in the form empty.

    In fact, if every field in the webpage form is empty, the query must retrieve all shipment tuples !!!

  • You must figure out how you can detect whether a input field has an empty entry !!

  • Figure out what you must do in the query formulation when an input field is empty/not empty.

  ---

  ---

  ---

  ---

• Use aliasing in the SQL query
  • The result set in the PHP program will be stored and fetched from an associative array.

  • The elements in the associative array is accessed by keys

  • The keys used in the associative array is the same as the name of the attributes in the select clause.

  • Problem:

    The attribute name city will be used multiple times in the select clause. Result: The same associative array element is used to store different city values

    Solution:

    To resolve this problem, use SQL aliasing to distinguish any ambigious attribute names in the select clause.

2. Turn in

• Turn in your PHP program file using the command:

  /home/cs377001/turnin Your-PHP-program.php php

  Note:

  You cannot use the turn in program on the machine holland.mathcs.emory.edu !!!

  ---

  If you have the final version of your code on holland.mathcs.emory.edu, you must transfer the PHP program from holland.mathcs.emory.edu to a lab machine using the following command:

  On holland.mathcs.emory.edu: Transfer your PHP prog to lab0z using these commands: 1. cd ~/public_html 2. scp your-PHP-prog.php lab0z:~/cs377 (Enter your Emory NetID passwd) On a lab machine: Turn in your PHP program file using these commands: 1. cd ~/cs377 2. /home/cs377001/turnin Your-PHP-program.php php

Extension request

• To request an extension for the PHP project, you must execute the following command before the deadline of the homework:

  /home/cs377001/req-ext php

  You request will be successful if you have not exceeded the maximum number of "free" (no-questions-asked) requests allowed