MySimple.php - A lightweight PHPMyAdmin substitute

Kaddi needed to fix something in her employer's database today. Unfortunately she had FTP access only. So the database change had to be made through a PHP script. The usual approach would have been to install PHPMyAdmin which is an excellent database management interface. But for this little one time change I considered this to be overkill.

I looked for a basic MySQL PHP interface but couldn't find one. So I quickly wrote it my self. It is called MySimple.php and is completely self contained in a single file. Just upload, fix your DB and delete it.

The interface is very basic (see screenshot on the right). It lets you connect to a server/database and submit one or more queries. Results are shown in tables below the input form.

The code is BSD licensed and available at my wiki: mysimple.php.

Tags:: mysql,; php,; webinterface

Similar posts:

Posted on Tuesday December the 18th, 2007 (5 months ago).

Comments

This is really great, though I don't have any use of it at the moment!
I was just thinking that the name was too simple for me. I would have tried to get My.S.Q.L. as initials. Something like 'MySimpleQueryLauncher'.
But I guess you plan to support other db engines...

2007-12-19 08:26:45

Grahack

Well, I didn't thought much about the name. I just needed any name for the file ;-). I don't have any plans to extend this. It's just a simple tool for a simple job.

2007-12-19 09:15:29

Andi

Very nice, although I'm sure I'll be sticking with PHPMyAdmin for awhile ;D

2007-12-20 03:13:19

mc2w

You might be interested in MyClient, a MySQL Web Interface. It serves a similar purpose with a bit more polish. :) It has a tabbed interface that allows you to connect to multiple databases and is backed by session. Along with a few other features. You can learn more at the project site: http://myclient.polarlava.com/

2007-12-21 18:07:24

PolarLava

Kevin, I had a look at your project before building my own. It still had too much files for my taste ;-)

2007-12-21 19:10:47

Andi