Question: Please I want this answer now 2. Given also the following HTML form page and its source code that is used to search data in

Please I want this answer now

Please I want this answer now 2. Given also the following HTML

2. Given also the following HTML form page and its source code that is used to search data in MySQL database Web Browser Output 1.

Searching Customer's Data 2. Name: 3. Wilayat: Gender: Organization Individual 6. Type:organization Save Data 8. Individual 9. Note the following: Assume that the user entered at least one value so that Do NOT write the validation part. Assume that the database connection id is Sconn Write PHP code to do the following (use the box below to type your answer) 1. Return ONLY the input value of the Name and Type fields and display them as follows Name: Lul Type: Organization (assume only these 2 values were entered in the form) Use the array: $types=['O'=>'Organization' T=>'Individual'); 2. Build up the query based on the 3 input values in the form to retrieve the data from the customers table described above. 3. Write the statements that will execute this query and store the result in $r; 4. Display the search result as shown below assuming that the result data is stored in the variable $r. Search Result Seq. No Name Balance Start Date Type Wilayat 1 Lulu Hypermarke 980 2010-05-12 Organization Nizwa Type your answer in the box shown below, no file upload is required

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!