Database Code

  Home arrow Database Code arrow FastMySQL
DATABASE CODE

FastMySQL
By: Codewalkers
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 4
    2006-02-01

    Table of Contents:

     
     

    SEARCH CODEWALKERS

    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

    blog comments powered by Disqus

    DATABASE CODE ARTICLES

    - Converting CSV Files to MySQL Insert Queries...
    - Examples and Tools for Database Design
    - Relationships, Entities and Database Design
    - Modeling and Designing Databases
    - Data extract to Excel
    - Oracle database class 0.76
    - The opposite of mysql_fetch_assoc
    - On line Thermal Transmitance Calculation
    - pjjTextBase
    - PHP Object Generator
    - FastMySQL
    - RC4PHP
    - SQL function with integrated sprintf()
    - DB Interaction Classes v1.1
    - deeMySQLParser

    Developer Shed Affiliates

     



    © 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap