Page 1 of 1

Has anyone created a MySQL/PHP interface?

Posted: Wed Mar 10, 2004 7:05 pm
by struggling_student
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

Posted: Wed Mar 10, 2004 8:00 pm
by Pyrite
Why not just view the phpMyAdmin code?

Posted: Wed Mar 10, 2004 8:01 pm
by struggling_student
where can i view it? I did think of that but couldnt locate any code for it

Posted: Wed Mar 10, 2004 8:42 pm
by Deemo
just download it and open up all the .php files

Posted: Thu Mar 11, 2004 3:57 am
by malcolmboston
ive done this before, for a clients site

it isnt meant to replace PHPmyAdmin, because i use MYSQL Front mainly, but i believe the site required a simple MySQL viewer

it is alot easier than you would think