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! Improve your build process with IBM Rational Build Forge, Part 1: Create a continuous build and integration environment Learn how to implement a build management system that uses and extends your existing automation technologies. This tutorial shows, step-by-step, how to install and configure IBM Rational Build Forge to manage builds for Jakarta Tomcat from source code. FREE! Go There Now!

NEW! Applying lean thinking to the governance of software development Effective governance for lean development isn’t about command and control. Instead, the focus is on enabling the right behaviors and practices through collaborative and supportive techniques. Hear from Scott Ambler on how it is far more effective to motivate people to do the right thing than it is to force them to do so. Learn how to form a lightweight, collaboration-based framework that reflects the realities of modern IT organizations. FREE! Go There Now!

NEW! Webcast: Application security testing and Web compliance Join the IBM Watchfire team for an informative discussion on techniques and best practices to proactively manage Web application security and how to effectively build application security testing into the software development lifecycle (SDLC). In this Software Delivery Platform webcast you will learn: How to better understand potential web application security vulnerabilities, best practices and how to effectively integrate application security testing into the software development lifecycle, the importance of detecting and removing software vulnerabilities during application development. FREE! Go There Now!

NEW! Krugle, developerWorks, and code search Ken Krugler, co-founder of code search company Krugle, and Laura Merling, vice president of Marketing and Business Development for Krugle, join to talk about the ins and outs of code search and what it means as a new feature for developerWorks users. FREE! Go There Now!

NEW! Implement new security capabilities in DB2 9.5, Part 1: Understanding roles in DB2 9.5 IBM DB2 9.5 provides new options for tighter security, and allows for more granularity and flexibility in administration of the database. This tutorial is the first of two tutorials that cover roles and trusted contexts. Follow the exercises in this tutorial, and learn how to take advantage of the new DB2 feature roles in combination with other essential e-business technologies such as Web services, Web application server, and DB2 database server. FREE! Go There Now!

NEW! Write REST services This tutorial discusses the concepts of REST and the Atom Publishing Protocol (APP) and shows how they apply to services. It also shows how to use Java technology to implement REST/APP-based services. FREE! Go There Now!

NEW! Successful Change and Release Management for .NET Join this webcast to discover the key requirements for successful change and release management. Learn how to extend your .NET environment to improve productivity and collaboration, and address core problems afflicting team development. In this webcast, we’ll review typical challenges faced by customers and how to resolve them with the IBM Rational Change and Release Management solution, including Rational ClearCase, Rational ClearQuest and Rational Build Forge. Replay is available for 9 months. 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! Rational 'Talks to You' Teleconference Series This Fall, IBM Rational talks to you directly through a special teleconference series giving you access to the best minds in IBM Rational - product experts and market thought leaders who will answer your questions during these pre-scheduled telephone conference calls. Register today! FREE! Go There Now!

NEW! Download IBM WebSphere Portal V6.1 beta code Download the IBM WebSphere Portal V6.1 beta code and learn more about the rich features and enhancements in IBM WebSphere Portal V6.1. WebSphere Portal provides a composite application or business mashup framework and the advanced tooling needed to build flexible, SOA-based solutions, and scalability to meet the needs of any size organization. FREE! Go There Now!

All FREE IBM® developerWorks Tools!