Has anyone created a MySQL/PHP interface?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
struggling_student
Forum Newbie
Posts: 15
Joined: Mon Feb 23, 2004 3:51 pm

Has anyone created a MySQL/PHP interface?

Post 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
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

Why not just view the phpMyAdmin code?
struggling_student
Forum Newbie
Posts: 15
Joined: Mon Feb 23, 2004 3:51 pm

Post by struggling_student »

where can i view it? I did think of that but couldnt locate any code for it
Deemo
Forum Contributor
Posts: 418
Joined: Sun Jan 18, 2004 11:48 am
Location: Washington DC

Post by Deemo »

just download it and open up all the .php files
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post 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
Post Reply