php search form for filtering data on a mysql database

I have a mysql database with a table called sms_in. the structure for sms_in is: CREATE TABLE sms_in (id int NOT NULL auto_increment, sms_text varchar(1600), sender_number varchar(50), sent_dt datetime, PRIMARY KEY (id)) default charset=utf8; The table is constantly receiving data after every hour. This data comes from mobile phones in form of an sms and is saved in the table sms_in. sample data can be found in the attached database The time the message was received is stored in the field sender_number, the time it was received is stored in the field sent_dt and the SMS message itself is stored in the fields sms_text Only two kinds of sms data are received. The one starting with DAILYREPORT and the one starting with TRIPSUMMARY. Each SMS message has parameters with different values You are needed to create two php webforms to be able to filter the data in the table for a user and for an administrator. For the user, you first filter the data by a date range, then by a keyword to be input by the user. Once the user enters the date range and the keyword, he will press the update button and data filtered in that criteria is displayed. Now for the filtered data, you should display the sum of individual variables as indicated in the user interface. He can also download the filtered data to his computer For the Administrator, you also filter the data by a date range, then by a keyword. The only difference here is that the keyword is preset and the administrator does not type it on the form. The keyword is preset as DAILYREPORT. So once administrator enters the date range, the form filters the data in sms_in table based on the date range and the keyword DAILYREPORT. The filtered data is then displayed on the form. Now for the filtered data, the sum of all the individual parameters is displayed as shown in the Admin user interface attached. he can also download the filtered data The administrator can also add/remove another administrator, add/remove another user and view the audit trail of who logged in/out and when Deliverable: all files and any scripts for the database that I can upload to my subdomain to display the two search forms A sample of the two kinds of SMS is as below SMS 1: TRIPSUMMARY, KBM920Y, TripNo=8, Destination=thika,nakuru, Begin=14:23, End=19:39, TripCardTickets=0, TripCashTickets=21, TripTotalTickets=21, TripCashSales=1200, TripCardSales=700, TripGrossSales=1900, TripFuel&Other=8000, TripCardTopUp=3000 SMS 2: DAILYREPORT, KBM920Y, DailyFuel&Other=3000, DailyCardTickets=60, DailyCashTickets=90, DailyTotalTickets=150, DailyCardSales=300, DailyCashSales=5000, DailyGrossSales=7000, DailyCardTopUp=40000