NB: The database management system installed on the weblab server is MariaDB, wh
ID: 3709371 • Letter: N
Question
NB: The database management system installed on the weblab server is MariaDB, which uses the MySQL calls; you will need to use mysqli_ API functions for this assignment. Just follow the examples in the link that's in Part 1 and you'll be OK.
Part 1; From databases to forms: Read Database Access with PHP. Copy your form from Lab Exercise6 to l7p1.php and change it to read the states from a database table instead of putting them into a PHP array yourself.
The database is named weblab and the table of states is named state_t. The table was created as follows:
Display the state name in the drop-down, but transmit the state abbreviation through the form. You do this by using a value attribute on the <option> element. The form area for State will look something like the following. Of course, you have to build this using PHP, and not just type it in.
You will not use the state_zone attribute. In "real life" it would be used for calculating shipping, maybe.
Present the state names in alphabetical order on your form. The easy way to do this is to have the database management system sort them for you using an ORDER BY clause in your SQL. For those of you who took Database long ago and far away (or not at all!), a suitable query for populating the array is this:
Make a link to this program from your index page.
Part 2, More databases to forms: The database weblab has a table of tools named tool_t. The table was created as follows:
Change your order form to construct the item names, prices and weights by extracting the items from the database rather than hard-coding them. Display every item from the database. Do not assume that there will be a given number of items.
In the database table definition above, numeric(6, 2) means the item has a total of six digits, of which two are to the right of the decimal point.
Your order form should display the following items for each tool:
Name
Price
Shipping Weight
Each idem of your form should have a box to allow the customer to enter quantity as you did in earlier assignments.
You will not need the tool_picture or tool_description attributes. Present the tool names in alphabetical order. The following is a suitable query for retrieving from the database:
This is a modification of l7p1.php, and I will test it when I test Part 1. Your program will still be named l7p1.php.
Note: This change will "break" your JavaScript validation routines if you still have them in your form. In real life, you would have to fix this. However, in real life, you would have started with the database-driven form, so you would not have to back-track. You do not have to change your validation routines, but see Part 4 below.
Part 3; Thinking about database items: Answer the following question: The query you were given in Part 2 retrieved the tool_item_no attribute from the database. Did you do anything with it? Why, or why not? Hint: Is it remotely possible that two different tools may have the same name? Another hint: See Part 4.
Put your answer on a Web page, l7p3.html and make a link to it from your index page.
Part 4; Thinking about form data validation: Explain in no more than a paragraph each what you would have to do with your JavaScript validation to make it work with the database-driven order form. You may put your answer on the same page as Part 3. Please be sure I can tell which answer is which.
Part 5; Reflecting on what you've learned: Tell at least one thing, more if possible, that you expected to get out of this course, but did not. (Please note: I'm asking for help to improve the course. A list of things that were missing is muchmore useful to me than a statement that the course was perfect in every way.) Put your notes on on the same page as Part 3. Please be sure I can tell which answer is which.
Explanation / Answer
code to copy:
<!DOCTYPE html>
<html>
<head>
<title>Lab 8</title>
<meta charset="UTF-8">
<link rel="shortcut icon" href="http://webdev.spsu.edu/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="l2p4.css" />
</head>
<body>
<h1>Fruit for Sale!</h1>
<h2>Price is based on unit weight</h2>
<form action="http://webdev.spsu.edu/formtest.php" method="post" id="form">
<table>
<tr>
<th>Fruit</th>
<th>Price per Pound ($/lb)</th>
<th>Weight</th>
<th>Quantity</th>
</tr>
<?php
$db = pg_connect("dbname=webdev");
$query = "select fruit_item_no, fruit_name, fruit_price, fruit_weight";
$query .= " from fruit_t order";
$query .= " by fruit_name;";
$dbResult = pg_query($query);
if(!$dbResult){
die("Database error....");
}
$num = pg_num_rows($dbResult);
if($num == 0) {
echo '<tr><td colspan="2">';
echo 'Database query retrieved nothing!</td></tr>';
}
$i = 0;
while($i < $num) {
$fruit_item_no = pg_Result($dbResult, $i, 'fruit_item_no');
$name = pg_Result($dbResult, $i, 'fruit_name');
$price = pg_Result($dbResult, $i, 'fruit_price');
$weight = pg_Result($dbResult, $i, 'fruit_weight');
echo '<tr><td>'.$name.'</td><td>'.$price.'</td><td>'.$weight.'.</td><td>';
echo '<input type="text" name="'.$fruit_item_no.'" id="'.$fruit_item_no.'" size="10" /></td></tr>';
$i++;
}
?>
</table>
<divi class="custInfo">
<label>First Name
<input type="text" id="fname" name="firstName" size="30" />
</label>
<label>Last Name
<input type="text" id="lname" name="lastName" size="30" />
</label>
<br />
<label>Street Address
<input type="text" id="streetAdr" name="streetAddress" size="45" />
</label>
<br />
<label>City
<input type="text" id="city" name="City" size="30" />
</label>
<label>State</label>
<select id="state" name="State">
<?php
$db=pg_connect("dbname=webdev");
$query = "select state_abbr, state_name from state_t order by state_name";
$dbResult = pg_query($query);
if(!$dbResult){
die("Database error....");
}
$num = pg_num_rows($dbResult);
if($num == 0) {
echo '<p>';
echo 'Database query retrieved nothing!</p>';
}
$i = 0;
while($i < $num) {
$state = pg_Result($dbResult, $i, 'state_name');
$abbr = pg_Result($dbResult, $i, 'state_abbr');
if($state == "Georgia") {
echo '<option value="'.$abbr.'" selected="selected">'.$state.'</option>';
echo " ";
} else {
echo '<option value="'.$abbr.'">'.$state.'</option>';
echo " ";
}
$i++;
}
?>
</select>
<label>Zip Code
<input type="text" id="zip" name="zipCode" size="10" />
</label>
<br />
<label>Payment:
<br />
<input type="radio" name="radio" name="payment" value="visa" />Visa
<input type="radio" name="radio" name="payment" value="master" />Mastercard
<input type="radio" name="radio" name="payment" value="discover" />Discover
<input type="radio" name="radio" name="payment" value="amex" />American Express
</label>
<br />
<br />
<input type="submit" value="Submit" />
</div>
</form>
<br /><br />
<p>Part 3:</p>
<p>I used it for my name and id field for the text box. This way when I go to look up the fruit again later on I already have the primary key and thus have to supply less information.
I can send back the primary key and the quantity and everything else I can look up. Now if prices change frequently this may not be a good way to do it initially since then I could possibly give them
the wrong price but only fairly staticly priced items it should be fine.
</p>
<p>Part 4:</p>
<p>To get the validation to work I would have to connect to the database and figure out what possible fields I have, based on how many unique ID's I have. From there it wouldn't require much to change, put the various ID's into an
array. Then loop over them and check to make sure it's a number.
</p>
<p>Part 5:</p>
<p>The small time I was in your course I had no problems with it. I was hoping to learn more PHP and database driven sites than what we did. I was also hoping to learn more frameworks and the backend of stuff more. I know this wasn't meant to be an advanced web programming course and thus basics have to be covered.
I know you would like a list but overall this was my only complaint which isn't much of one to begin with. Hope you have a great summer!
</p>
</body>
</html>
1
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.