Create a PHP + AJAX form and fetch/insert data in DB
$30-250 USD
Cancelled
Posted over 13 years ago
$30-250 USD
Paid on delivery
Hi,
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);
*press connect*
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 !
Hello, We are interested to do this project. Amazing SoftTech is here to provide you with excellent quality solutions and ensure to complete the project within given time. We have well experienced and Brilliant Software Professional. Looking for a long term relationship with you. For more information please contact us. Regards, Amazing SoftTech