This is a simple interface to a MySQL installation, written in PHP, that runs in any internet browser (well, Internet Explorer, Netscape, Firefox, and Opera anyway!;). It is intended for the casual, occasional SQL user who does not have SQL statement syntax on the tip of their tongue (or the tip of anything else!;) and does not wish to constantly refer to documention for syntax for basic, common SQL queries. It is form driven and implemented in HTML frames.
By : dsilvia
This is a simple interface to a MySQL installation, written in PHP, that runs in any internet browser (well, Internet Explorer, Netscape, Firefox, and Opera anyway!;). It is intended for the casual, occasional SQL user who does not have SQL statement syntax on the tip of their tongue (or the tip of anything else!;) and does not wish to constantly refer to documention for syntax for basic, common SQL queries. It is form driven and implemented in HTML frames.
The driver script or 'main' if you will, is FastMySQLframes.php. This script sets everything up for the subsequent scripts and serves as the 'event message' handler. The events being when a user indicates form completion by pressing the 'submit' button associated with a given frame's form.
The secondary driver is FastMySQLforms.php. This script handles formatting the forms for each frame and the ultimate 'decoding' of form data into an SQL statement.
Below these are FastMySQLaccess.php and FastMySQLutils.php. FastMySQLaccess.php serves as a 'layer' between the 'raw' MySQL data as returned by PHP and the 'cooked' data used by FastMySQLforms.php. FastMySQLutils.php is the 'primitive' 'layer' directly on top of PHP/MySQL, handling connection, disconnection, and querying.
FastMySQL.php is the entry point that 'exec'-s the whole thing. It serves mainly to get login data and secondarily initializes the execution information ('Info') arrays that are passed everywhere.
Just place the scripts where they are readily available to your server and start up the code by invoking FastMySQL.php from the browser URL address bar: i.e.
http://myserver/php-script-loc/FastMySQL.php
This will start up with the default host of 'localhost', the default user of 'root' and no password. You can change these within the code, or specify them in the form presented.
See the 'usage.txt' file for a description of operation.
DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.
