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.


Click to Download File

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.

More Database Code Articles
More By Codewalkers

 

developerWorks - FREE Tools!

IBM DB2 Deep Compression ROI Tool The IBM DB2 Deep Compression ROI tool is designed for DBA’s and IT management personnel to perform a clinical analysis of the cost savings gained from the Storage Optimization feature of DB2 9 for Linux, UNIX and Windows. The feature, also known as Deep Compression, compresses data that lies within a database by up to 80% at times. FREE! Go There Now!

NEW! Discovering the value of WebSphere Process Server WebSphere Process Server delivers a unique integration framework that simplifies existing IT resources. Often, as IT assets grow to support business demand, so too does their complexity and manageability. In this webcast, we’ll discuss how WebSphere Process Server helps deliver an SOA infrastructure that provides a common model to orchestrate, mediate, connect, map, and execute the underlying IT functions. Discover how WebSphere Process Server simplifies integration of business processes by leveraging existing IT assets as reusable services without the complexities of traditional integration methodologies. FREE! Go There Now!

NEW! Download a free trial of Lotus Quickr 8.0 Visit IBM developerWorks to download a free trial version of Lotus Quickr 8.0, which enables collaboration by transforming the way everyday business content such as documents, rich media, photos, and video can be shared. Lotus Quickr makes it faster and easier to share content of all types (not just documents) within virtual teams. It is designed to make it easier to collaborate across organizational boundaries, while continuing to work within the context of familiar desktop applications. FREE! Go There Now!

NEW! Evaluate IBM Rational Developer for System i V7.1 Download a free trial version of IBM Rational Developer for System i V7.1, which provides a complete development environment for traditional i5/OS application development. IBM Rational Developer for System i is a new eclipse-based workstation offering for i5/OS application development that provides a comprehensive Integrated Development Environment for edit/compile/debug of traditional RPG/COBOL/C/C++ i5/OS applications. FREE! Go There Now!

NEW! Evaluate Rational Business Developer V7.1 Visit IBM developerWorks to download a free trial version of IBM Rational Business Developer V7.1. Rational Business Developer offers rapid and simplified development of business applications and services through Enterprise Generation Language (EGL) tools, generating Java or mainframe solutions while shielding developers from technical complexities. FREE! Go There Now!

NEW! Improve your build process with IBM Rational Build Forge, Part 2: Automate builds for a real-world Tomcat project Learn how Rational Build Forge can extend a simple compile and package build process by adding customization and deployment capability. Go from a manual method to automating: checking for code changes; getting the latest source; compiling and packaging; customizing; copying to and restarting a deployment server; and sending e-mail notification that a new version is available. FREE! Go There Now!

NEW! Software Change and Configuration Management Solution Guidelines This whitepaper provides areas to consider when evaluating any software configuration management solution. It addresses how the IBM solutions (Rational ClearCase and Rational ClearQuest) meet the needs and requirements of both project leaders and developers to provide successful Software Change and Configuration Management. FREE! Go There Now!

NEW! Trial download: IBM Rational Method Composer V7.2 Get a free trial download of the latest version of IBM Rational Method Composer V7.2 which helps you deliver customized yet consistent process guidance to your project teams and IT organization, and includes the latest version of IBM Rational Unified Process (RUP), which has provided process guidance to teams since 1996. FREE! Go There Now!

NEW! Using Rational Business Developer to enhance your developer productivity Join this Rational Talks to You teleconference, to hear how Enterprise Generation Language (EGL) eliminates the need for tedious and error-prone low level coding, so developers can focus on business requirements. EGL extends the Rational software development platform with a simplified programming language that enables developers who have little or no experience with Java, Web technologies or Service Oriented Architecture, to create enterprise-class applications and services quickly and easily. It also allows developers who may have little or no mainframe programming experience to quickly create traditional mainframe components. FREE! Go There Now!

Refresh! IBM Rational Systems Development Solution eKit With IBM Rational Systems Development Solution, you can deliver products faster with higher quality. Within this kit, Read the “Model Driven Systems Development” white paper to see how to improve product quality and communication. Then check out the rest of the e-Kit to learn more about important topics that can affect the success of any software project through customer examples, tutorials, informative Webcasts, and best practices for designing, building and managing systems. From start to finish, at every stage in your projects, Rational Systems Development Solution can help your company reach its full potential. FREE! Go There Now!

All FREE IBM® developerWorks Tools!