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!

NEW! A Layered approach to delivering security-rich Web applications As businesses grow increasingly dependent upon Web applications to provide services to customers, employees and partners, these complex applications become more difficult to secure. Although traditional security solutions protect Internet infrastructure layers, they do not guard against HTTP and HTML attacks. Many organizations that conduct security testing still deploy applications that allow attackers to manipulate their logic and wreak havoc on their business. To mitigate this risk, development and delivery teams must address Web application security throughout the lifecycle, addressing the many layers detailed in this paper. FREE! Go There Now!

NEW! Download a free trial of WebSphere Business Modeler Advanced V6.1.1 Visit IBM developerWorks to download a free trial version of WebSphere Business Modeler Advanced V6.1.1, IBM’s premier business process modeling and analysis tool for business users that offers process modeling, simulation, and analysis capabilities. IBM WebSphere Business Modeler helps you visualize, understand, and document business processes for continuous improvement. FREE! Go There Now!

NEW! Download IBM Rational Developer for System z Download a free trial version of IBM Rational Developer for System z, software that can help you deliver core development capabilities; the power of Java Platform, Enterprise Edition (Java EE); and rapid application development support to diverse enterprise application development teams. With comprehensive development tools to help create, deploy and maintain traditional enterprise and composite applications, Rational Developer for System z enables developers with different technical backgrounds to easily participate in important technology projects. FREE! Go There Now!

NEW! Evaluate Rational Host Access Transformation Services (HATS) Toolkit V7.1 Visit IBM developerWorks to download a free trial of the Rational Host Access Transformation Services (HATS) Toolkit. The HATS toolkit provides a set of plug-ins for the IBM Rational Software Delivery Platform to help you easily extend your legacy applications. HATS makes your 3270 and 5250 applications available as HTML through the most popular Web browsers, while converting your host screens to a Web look and feel and it also enables you to develop new Web, portal, and rich-client applications. FREE! Go There Now!

NEW! Hello World: Monitor a simple business process using WebSphere Business Monitor V6.0.2 This tutorial shows new users of IBM WebSphere Business Monitor Version 6.0.2 how to perform the "Hello World" equivalent for monitoring business process applications. It is intended to help you get familiar with the capabilities of the product. FREE! Go There Now!

NEW! IBM Enterprise Modernization Sandbox for System z: Architecture Analysts, architects, and developers who have existing COBOL or PL/I skills and want to extend those skills to deploy new workloads on the mainframe can use the IBM Enterprise Modernization Sandbox for System z to find hands-on walkthroughs of common real world scenarios. The scenarios provide examples of how to rapidly design, create, assemble, test, and deploy high-quality Web, Web services, portal, and SOA applications for IBM CICS, IBM IMS, and IBM WebSphere Application Server. 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 Performance Tester V7.0.1 Get a free trial download of the latest version of IBM Rational Performance Tester V7.0.1, a load and performance testing solution for teams concerned about the scalability of their Web-based applications. Combining multiple ease-of-use features with granular detail, Rational Performance Tester simplifies the test-creation, load-generation and data-collection processes that help teams ensure the ability of their applications to accommodate required user loads. FREE! Go There Now!

NEW! Try the IBM SOA Sandbox for People Visit IBM developerWorks to try the IBM SOA Sandbox for people. The SOA Sandbox for people provides a trial environment with the necessary tooling and components required to enable consistent human and process interaction and collaboration, showing how you can improve user experience and business productivity. FREE! Go There Now!

NEW! Try the IBM SOA Sandbox for Process Visit IBM developerWorks to try the IBM SOA Sandbox for process. The SOA Sandbox for process focuses on providing a trial environment with the necessary tooling and components required to gain a better understanding of business processes and how to best improve existing business processes to derive value quickly. FREE! Go There Now!

All FREE IBM® developerWorks Tools!