Has anyone created a MySQL/PHP interface?
Posted: Wed Mar 10, 2004 7:05 pm
Hi,
I've been given a uni project to create a PHP interface to MySQL. The system has to operate in much the same way as phpMyAdmin or MySQL-front and allow different users to log onto their account and access their information as well as create, drop and modify tables and databases.
I can make the system log the user in using their username and password, display their databases and tables and there is a function to enter a MySQL query and return the results. I am having issues with creating databases, modifying table descriptions and adding, deleting and modifying rows in tables. Basically the majority of the functionality. Because the database and table names will be different depending on what user is logged on and what database they are looking at, the queries cannot be coded directly.
Has anyone attempted to do this before with a more successful outcome? Or knows of a site which can offer advice or give me some helpful code?
Thanks for any help in advance
I've been given a uni project to create a PHP interface to MySQL. The system has to operate in much the same way as phpMyAdmin or MySQL-front and allow different users to log onto their account and access their information as well as create, drop and modify tables and databases.
I can make the system log the user in using their username and password, display their databases and tables and there is a function to enter a MySQL query and return the results. I am having issues with creating databases, modifying table descriptions and adding, deleting and modifying rows in tables. Basically the majority of the functionality. Because the database and table names will be different depending on what user is logged on and what database they are looking at, the queries cannot be coded directly.
Has anyone attempted to do this before with a more successful outcome? Or knows of a site which can offer advice or give me some helpful code?
Thanks for any help in advance