Simple PHP MYSQL Task for Someone with Basic Skills

I could have done this but got other important tasks to perform. Simple PHP MYSQL project. Expenditure tracking: Check if databases exist and if not then create Three MySql Tables with following attributes. Material Procurement: • Serial number (primary auto increment) • Date • Particular • Quantity • Rate • Amount (must be the product of quantity and rate ) • Vender ID (auto suggestion ajax from a separate table with vendor lists and then store the Vendor ID) Yes! Create a separate table named vendors with following fields • ID (primary auto increment) • Name (unique) • GSTIN no • Pan No • Contact number 1 • Contact number 2 • Email address 1 • Email address 2 • Whatsapp number Commission Table: Then create a table with following fields: • Serial number • Name • Amount Labour Payment: Then create a table with following fields: • Serial number • Labor name • Amount • Payment mode (Cash, cheque, or bank transfer) • Date • Timestamp Associate the Labour name with the labor id of labor profile table: • ID (primary auto increment) • Name • Bank account number • Contact number 1 • Contact number 2 • Email address 1 • Email address 2 • Whatsapp number Note: Your task is to develop Insert update and delete forms for all table entries. And ability to sort expenditures on a single click. …………………………………………………………………………………………………………………………………………………………………………………………………………………… On the [login to view URL] 1. One initial run Ask for a prefix. Then the user will provide input and press submit button. 2. Then on post check, if tables exist. If exists then just alert (do not overwrite, it’s important), Else, Create all three tables and their related tables programmatically with the mentioned prefix in all tables. 3. Once this happens the user should not be prompted again to enter a prefix. I need separate forms to insert update and delete the items as per requirement. Material Procurement Form needs to insert the following information. • Serial number (INT 10 primary key autoincrement) • Date (date selector) • Particular (text varchar 256) • Quantity (float) • Rate (float) • Amount (must be the product of quantity and rate ) • Vender ID (auto suggestion ajax from a separate table with vendor lists and then store the Vendor ID) I need the ability to sort and search different expenditures. Search by vendor and find out the sum of expenditures associated to it. The similar ability for Labour payment based on labour ID. Finally, Mobile friendliness of HTML is a must to get paid. More details In PM.