What is QDBA?
QDBA is a small php/javascript tool to view / browse a mysql database.
But i have phpmyadmin, does that not cover it?
Yes, phpmyadmin is a state of the art tool, and this one does NOT intend to replace it. It's only an alternative to it. (a very simplistic one !!)
Why do i need it?
You don't. It's only a tool for lazy admins. If you do not have access to phpmyadmin, or you are to lazy to upload all the files, QDBA is the right tool for you.
So how is everything in one file, i do not understand, there are pictures too.
This is actually a trick. While QDBA, the php file is ONE, the actual images (which are 2, the icons, and the fvicon, it's very helpful to identify easily the tab) you can store on a separate location. Modify the path inside the file to an absolute path.
Like put the images on http://www.domain.com/qdba_icons.gif and than link inside the code to it. Than you can upload only the qdba toll to your servers/accounts.
Are there any limitation to it?
YES !! This is a VERY simple tool, and since all code is in one file, it's NOT fully idiot proof.
While it allows multiple queries, if you do not have addslashes to your export, it will crash.
Incorrect: ' ... then John's daughter ... ' -> this will cause the queries to die.
Correct: ' ... then John\'s daughter ...' -> works
Will it crash a lot ?
Hopefully not, it's still pretty robust.
So will it screw my db data ?
No, if you only browse through it, editing content is also pretty solid as well as inserting. mainly if you know what you do, it is safe.
What is Clear session in the very bottom?
Pressing the link will clear all session information, including the SQL history. This is usefull if you want to start all over again, or you want to login as a different user/password.
Can i make it login automatically inside my DB?
Yes, edit the qdba.php and put REAL username and password. However this is a security issue !! anone knowing your qdba file access link might be able to look into your db and alter the content.
How can i disallow access to it, for other users?
I think entering dummy username and password, will fail in mysql authentication, therefore anyone accessing the link will not get directly inside. It will prompt you to enter the username and password. Get you browser to save this infor and you will easily access it yoursef, from your own machine.
Where is the history stored?
The SQL history is stored in the current session, which means it will be LOST once you close your browser.
If you have more questions, please ask them in the forum.