Html Code Given Exercise 3 Label Width 150px Display Inline Block Customer Number Title Se Q43828449
HTML code given :
<!DOCTYPE html>
<html>
<head>
<meta charset=”utf-8″>
<meta http-equiv=”X-UA-Compatible” content=”IE=edge”>
<title>Exercise 3</title>
<style>
label { width:150px; display:inline-block; }
</style>
</head>
<body>
<form action=”exercise-3.php” method=”POST”>
<p>
<label for=”custNum”>Customer Number:</label>
<input id=”custNum” name=”custNum” type=”text”>
</p>
<p>
<label for=”title”>Title:</label>
<select name=”title” id=”title”>
<option value=”” selected disabled>SelectTitle</option>
<option value=”Mr”>Mr</option>
<option value=”Miss”>Miss</option>
<option value=”Ms”>Ms</option>
<option value=”Dr”>Dr</option>
<option value=”Prof”>Prof</option>
</select>
</p>
<p>
<label for=”firstName”>First Name:</label>
<input type=”text” name=”firstName” id=”firstName”>
</p>
<p>
<label for=”familyName”>Family Name:</label>
<input type=”text” name=”familyName” id=”familyName”>
</p>
<p>
<label for=”contact”>Contact:</label>
<input type=”text” name=”contact” id=”contact”>
</p>
<p>
<label for=”email”>Email:</label>
<input type=”text” name=”email” id=”email”>
</p>
<p>
<label for=”houseNum”>House Number:</label>
<input type=”text” name=”houseNum” id=”houseNum”>
</p>
<p>
<label for=”street”>Street:</label>
<input type=”text” name=”streat” id=”street”>
</p>
<p>
<label for=”suburb”>Suburb:</label>
<input type=”text” name=”suburb” id=”suburb”>
</p>
<p>
<label for=”state”>State:</label>
<select name=”state” id=”state”>
<option value=”” selected disabled>SelectState</option>
<option value=”NSW”>NSW</option>
<option value=”QLD”>QLD</option>
<option value=”VIC”>VIC</option>
<option value=”TAS”>TAS</option>
<option value=”NT”>NT</option>
<option value=”WA”>WA</option>
<option value=”SA”>SA</option>
</select>
</p>
<p>
<label for=”postCode”>Post Code:</label>
<input type=”text” name=”postCode” id=”postCode”>
</p>
<p>
<input type=”submit” value=”Submit” name=”Submit”>
</p>
</form>
</body>
</html>
—
could you please write me the php code and a screenshotof the output who it works
thank you
For this exercise, you have been given the file exercise-3.html. Within this file is a form with the fields required to insert a new record into the customer database table. You are to create another file, exercise-3.php, which will process the input from exercise-3.html which is sent via the POST method. Using the schema in figure 2 and the data received from exercise-3.html insert a new record into the database. Upon success, print to the page “Successfully Added a New Record to the Customer Table with the ID of: #”. The ‘#’ represents the last inserted ID. If it fails, “Failed to insert new record” should be printed to the page. To view if a record has been inserted successfully, use the listdata. php file found within the Major Assignment folder on VUWS. Don’t forget you have to put your database details in the connection settings of the file for it to work. For maximum marks for this exercise your data needs to be sanitised and validate for type and size in PHP. customer id INT(11) custNum INT(11) title VARCHAR(20) firstName VARCHAR(20) familyName VARCHAR(30) contact VARCHAR(10) email VARCHAR(60) houseNum VARCHAR(10) street VARCHAR(20) suburb VARCHAR(20) state VARCHAR(3) postCode VARCHAR(4) Indexes customercar id INT(11) custNum INT(11) rego VARCHAR(6) make VARCHAR(15) model VARCHAR(30) year Man VARCHAR(4) Indexes Figure 2 Show transcribed image text For this exercise, you have been given the file exercise-3.html. Within this file is a form with the fields required to insert a new record into the customer database table. You are to create another file, exercise-3.php, which will process the input from exercise-3.html which is sent via the POST method. Using the schema in figure 2 and the data received from exercise-3.html insert a new record into the database. Upon success, print to the page “Successfully Added a New Record to the Customer Table with the ID of: #”. The ‘#’ represents the last inserted ID. If it fails, “Failed to insert new record” should be printed to the page. To view if a record has been inserted successfully, use the listdata. php file found within the Major Assignment folder on VUWS. Don’t forget you have to put your database details in the connection settings of the file for it to work. For maximum marks for this exercise your data needs to be sanitised and validate for type and size in PHP.
customer id INT(11) custNum INT(11) title VARCHAR(20) firstName VARCHAR(20) familyName VARCHAR(30) contact VARCHAR(10) email VARCHAR(60) houseNum VARCHAR(10) street VARCHAR(20) suburb VARCHAR(20) state VARCHAR(3) postCode VARCHAR(4) Indexes customercar id INT(11) custNum INT(11) rego VARCHAR(6) make VARCHAR(15) model VARCHAR(30) year Man VARCHAR(4) Indexes Figure 2
Expert Answer
Answer to HTML code given : Exercise 3 label { width:150px; display:inline-block; } Customer Number: Title: Select Title Mr Miss M…
OR