I need to create a simple PHP form that would do the following :
1- Ask the user to input server IP or hostname, password, DB name and type (MsSQL and MySQL);
2- Once it's connected to the DB, it populates a dropdown menu with all available tables on the database. The user chooses a table.
*press view fields*
3- Another dropdown is populated with all the available fields of type nText, Varchar, nVar (if MsSSQL was chosen), and Text, varchar (if MySQL was chosen). The user chooses a field to select.
4- There is an empty input box for "Condition" where the user can input a condition (eg: WHERE id=5);
*press view data*
5- If the MsSQL or MySQL SELECT query is valid, it will populate a WYSIWIG editor with the data of the chosen field. There must be only one row or there is an error "Too many results". The user can modify the data with the WYSIWIG.
*press save data*
6- When the user saves the data, it is saved back to the right field/row with an UPDATE statement.
This work should be done in 2 days. Thank you !