Say I have a tables with the following columns: ID, FirstName, LastName, Email, Password ID, Date, Signup, Name, User The script needs to create an easy to use interface to interact with the data. *Needed Functions* 1. Display all the rows and some of the columns I specify - Example: I tell it show me ID, FirstName, Email and order by ID, the script will then display all the rows in the specific table with the specified columns - There should be two arrows by each column field (ID, FirstName, etc) that will allow me to sort ASC or DESC. - Should paginate (Say there are 200 rows in the database, it should show 20 at a time.) 2. If I click on one of the rows, it should allow me to edit the row - Should validate data based on database structure, IE, int field cannot take characters - A lot of my tables have two password fields, one encrypted and one not encrypted - On the edit page, it should only show the non-encrypted one. But, if I edit the password, it should change the non-encrypted one and encrypt the password and insert that into the encrypted password field (simple MySQL function PASSWORD($pass)) - ID and any other auto-increments should not be edittable - I should also have the ability to allow only certain fields to be edited. 3. Search functions - I should be able to search any of the fields in the database table - Results should be displayed as in Function 1 (table format, pagination, sorting functions, allow me to edit, etc...) - I should be able to specify a table, and the script will handle everything else. - Needs to validate search before actually searching (Please NO JS validation, validation should be done in PHP) 4. Add a row - only thing that I cannot add in the row is the ID (which is an auto-increment) *Requirements* MUST work with any table style and/or data types. I do not mind if you combine any freeware scripts into this project, as long as it functions correctly.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
*NIX, PHP4, PHP5, MySQL