Ternstyle

MySQL PHP Class

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

Download

Download Version: 3.8

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(2) {
       ["id"] => string(4) "1000"
       ["name"] => string(16) "John Jingle"
   }
}

Current Version

The current version of this software is 3.8.

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

Requirements

• PHP 4.3.0+

Documentation

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