******** IF YOU NEED HELP SETTING UP THE APPLICATION, EMAIL ME ********
Database Tool allows users to easily view and query database tables. Use of this app requires the upload of a web services written in PHP to your server. This gives an extra layer of security since you will not be forced to allow remote connections to your database, like the other apps on the Android Market require.
This application does not directly allow you to query. Instead, it assembles queries based on your preferences. It allows you to sort and search columns. View the screenshots for more examples.
Based on the popularity of this app, I may come out with a professional version that allows for custom queries, which would be very useful when you need to join tables.
As of now, the Tool is only compatible with MySQL databases. There are plans for MSSQL compatibility in the future as well.
You can download the PHP code at : https://sites.google.com/site/jstn455/databaseviewer
Directions for getting the application to work are as follows:
Step 1: Download .zip or .tgz file from https://sites.google.com/site/jstn455/databaseviewer
Step 2: Extract the folder (unzip or tar -zxvf "filename.tgz")
Step 3: Transfer the directory via FTP client into your public html folder
Step 4: Confirm the web address through your browser. There should be a confirmation message.If you transferred the directory to the root public html file, it should be http://yoursite.com/mysql-tool
Step 5: Go into the settings.php file in a text editor and fill out lines 14-18 For $password, you could use any password you want. It does not have to be your database password, and as a precaution it should not be your database password.
Step 6: Download the Android application
Step 7: Add the database to your application. Match the password from your settings.php file to the password field in the application
If you prefer extra security, you can use also set up an htaccess authentication for the directory. The app will prompt you for your username and password.
Features: Single Table viewing Multiple column searching Sorting Paginated Data view Export to CSV MySQL Database Viewing
A Google User
Good app It does not take your root pass, you host the files on your own server and choose your own password. Read the instructions.