Create database driven web page with tabs and paging. Use PHP, CSS, Javascript, HTML. Display data from mysql database in the first tab with paging (prev, next). When I click the next tab, the related contents from tab 1 should be shown in tab2 and similarly for tab3 and tab4.
Project details:
1. Create the following table in mysql
employee (id, name, dept_name, salary,? hr_rate, ot_rate, bonus, total_vacation, used_vacation, carry_fdw_vacation,? street, city, state, zip, country)
2. Insert 20 records into the employee table.
2. Create a simple search page that searches employees by salary range, hr_rate range, dept_name.
3. Display results (max 5) based on the search criteria in a new page with? 4 tabs: employee details, employee rate, employee vacation, employee address (the default tab shown is employee details).
4. Create a paging mechanism outside the tabbed navigation window, so that when next or prev is clicked, it refreshes the data in all the tabs. When I click next in 'employee details' and click on the "employee vacation" tab, it should show the related data from the previous tab.
## Deliverables
In this project, consistent paging across tabs is important.
Prepare complete instructions with how to deploy the code and provide all the necessary DDLs, CSS, Javascrip, PHP code. Do as modular as possible.