Hi tutors,

I got stuck with 2 questions of my JSON and AJAX homework.

This homework needed to reuse the database (WAMPSERVER) in the previous task.

Question 1:

\f\fCreate a html file La bB'S . html to search records in customers table by using radio button to select gender. Search Customer by Gender Gender. 0 Male C' Female Search i. Show message No record is found if cannot find any record 1with search gender . iii. Show message No. of records found: at if an}r record is found and x is total number of found records. Search Customer by Gender Gem: CI Male Female Cost 11] Cum: Name Ens: Password Cost Gunning] 1004 Fiona 193.5504 E 1008 Suki pasa E No. of records found: 2 phpMyAdmin Server: MySQL:3306 > Database: testdb > Table: customers Browse Structure SQL Search Insert Export Import Privileges Operations 8 Triggers Current server: Showing rows 0 - 8 (9 total, Query took 0.0002 seconds.) MySQL SELECT * FROM ' customers" Recent Favorites Profiling [Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh] New information_schema Show all | Number of rows: 25 v Filter rows: Search this table Sort by key: None mysql performance schema + Options +T- custID custName custPswd custGender sys 0 Edit Copy @ Delete 1001 Stanley pass01 M testdb New 0 Edit = Copy @ Delete 1002 Jennifer pass02 Hicustomers 0 Edit Copy @ Delete 1003 Kevin pass03 M testdb2 0 Edit E Copy @ Delete 1004 Fiona pass04 F testdb3 0 Edit Copy @ Delete 1005 Jason pass05 M 0 Edit = Copy @ Delete 1006 Whitney pass06 F 0 Edit Copy @ Delete 1007 William pass07 M 0 Edit Copy @ Delete 1008 Suk pass08 F 0 Edit Copy @ Delete 1009 Alan pass09 M O Check all With selected: Edit Copy Delete Export O Show all | Number of rows: 25 v Filter rows: Search this table Sort by key: None Query results operations Print Copy to clipboard Export Display chart Create view Console