Database Tool

********
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