This is a post for an addon project already awarded
Create single page input for multiple sql database queries
The current page design can be viewed at
[url removed, login to view]~familytr/genealogy/[url removed, login to view]
The page code needs to be modified so that this one input form is used to select the database table to be searched.
Currently, I have placed temp links to a second input form so that I could test each of the separate searches.
Additionally I plan on adding a description of each database index in an open/close view content link (I will be working on this but if you can contribute , it would be appreciated)
You can test searching for Last Names that start with "Van" to get a result for every search.
The user will only be able to use the two fields to input data, LastName and FirstName.
Currently, the code does not test for a Last Name input minimum of at least three charcters, which needs to be added.
I have labeled each database table with the identical field names for these two fields (LastName and FirstName)
The search output needs to resemble the output that is generated by the first search on Biographies, so that is looks like the output on the rest of the site.
These search pages need to fit within the existing web site (which the initial search page does at this time)
The attached zip file contains some of the pages of code for review, including each of the tables and the fields in each table.
The budget for this project is $150.
Please make sure you list at least two samples of work similar to this for references.