Please finish PHP code. I completed the fist portion here you add the state names. I am having trouble implementing the SELECT state_abbr statment at the very bottom of the instuctions. My PHP code is also below.

MY CODE:

Lab 7 Part 1

Homepage

From databases to forms and More databases to forms

'; echo 'Database query retrieved zero rows.'; } while ($row = mysqli_fetch_assoc($dbResult)) { $state_abbr = $row['state_abbr']; $state_name = $row['state_name']; } ?>

'; } while ($row = mysqli_fetch_assoc($dbResult)) { $tool_item_no = $row['tool_item_no']; $tool_name = $row['tool_name']; $tool_price = $row['tool_price']; $tool_weight = $row['tool_weight']; echo ""; echo ""; echo ""; echo ""; } ?>

Tool	Price	Weight	Quantity
'; echo 'Database query retrieved zero rows.
$tool_item_no	$tool_name	$tool_price	$tool_weight

Crescent Wrench: C-Clamp: Saw: First name: Last name: Shipping Address:

Select a state New Jersey California Texas Arizona Georgia Alabama Florida Zip Code:

Payment Type:

Visa Mastercard American Express

Part 1; From databases to forms: The database is named weblab and the table of states is named state t. The table was created as follows: CREATE TABLE state t state abbr char (2) PRIMARY KEY, state name char (20), state zone integer) i 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 Koption> 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. Koption value FL," Florida Koption value GA, Georgia Koption value TN" Tennessee