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! Build Web services with transport-level security using Rational Application Developer V7, Part 1: Build Web services and Web services clients Build secure Web services with transport-level security using IBM Rational Application Developer V7 and IBM WebSphere Application Server V6.1. Follow this three-part series for step-by-step instructions about how to develop Web services and clients, configure HTTP basic authentication, and configure HTTP over SSL (HTTPS). This first part of the series walks you through building a Web service for a simple calculator application. You generate and test two different types of Web services clients: a Java Platform, Enterprise Edition (Java EE) client and a stand-alone Java client. You also handle user-defined exceptions in Web services. FREE! Go There Now!

NEW! Cook up Web sites fast with CakePHP, Part 4: Use CakePHP's Session and Request Handler components CakePHP is a stable production-ready, rapid-development aid for building Web sites in PHP. This "Cook up Web sites fast with CakePHP" series shows you how to build an online product catalog using CakePHP. 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: WebSphere Service Registry and Repository Manage, govern, and share services across your organization by using WebSphere Service Registry and Repository. Follow the hands-on exercises to learn how to navigate the Web interface to publish, find, reuse, and update services. FREE! Go There Now!

NEW! IBM Enterprise Modernization Sandbox for System z IBM Enterprise Modernization solutions help organizations evolve core IT systems towards modern architectures and technologies—reducing the burden of maintenance and freeing up resources to develop new business requirements and capabilities. With the IBM Enterprise Modernization Sandbox for System z you can evaluate IBM Enterprise Modernization solutions focused on five key areas: Assets, Architectures, Skills, Processes and Infrastructures, and Investment. Each solution is based upon real customer experiences and offers a proven path to get you started with your modernization projects. 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! IBM Rational Systems Development e-Kit As systems increase in complexity, communication between systems and software teams becomes more and more difficult. Now, there’s a way to improve product quality and communication.<br />Read the “Model Driven Systems Development” white paper to see how. Also included in this kit are more educational white papers, customer examples, tutorials, informative Webcasts, and best practices for designing, building and managing systems.<br /> FREE! Go There Now!

NEW! Trial download: IBM Lotus Forms V3.0 Get a free trial download of IBM Lotus Forms V3.0 (formerly Workplace Forms), which provides a zero-footprint eForms solution to help you automate and move forms-based business processes off the desktop and onto the Web. With Lotus Forms, you can extend applications beyond the firewall by creating a single electronic form document ready for use in both thick and Web 2.0 thin client format. 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!

NEW! Webcast: Quickly provide customized, integrated user interfaces with Lotus Notes 8 IBM Lotus Notes 8 provides a wide range of developers the ability to provide customized, integrated user interfaces via composite applications and via custom sidebar and toolbar plug-ins. This webcast provides you with tips and techniques to use with out-of-the-box capabilities of Lotus Notes 8, and survey how you can share useful components within your own company and within a larger community. FREE! Go There Now!

All FREE IBM® developerWorks Tools!