MySQL PHP Class

This is a very simple class designed to connect with and perform queries on a MySQL database.

Contents 1 Table of Contents 2 Sample Code 3 Features 4 Current Version 5 Requirements

Table of Contents

• Function reference
• Creating a new MySQL object
• Connecting to a database
• Compiling a query
• Performing a query
• Closing a connection

Sample Code

$mysql = new mysqlClass($mysql_address,$mysql_username,$mysql_password,
$mysql_database);
$result = $mysql->query('select * from table_name');

The above variable $result will be an associative array of all the database rows the query returned. Which might look something like the following if it were to be printed:

array(1) {
   [0] => array(5) {
       ["id"] => string(4) "1000"
       ["name"] => string(16) "John Jingle"
   }
}

Features

• Connect to a MySQL server and select a database with one command
• Perform any type of MySQL query
• Compile your own queries
• Access MySQL errors from a global associative array

Current Version

The current version of this software is 3.8.

Requirements

PHP 4.3.0+