Richard Castera

This is a class that I've used in my projects for years. It's a simple wrapper to MySQL written in PHP5 that allows you to connect, run queries and get results. It's been used in production sites for some time now and I've re-factored it several times.

A Select Statement

<?php
require_once('Class.Database.php');

// Establish a connection.
$Db = new Database('localhost', 'database', 'username', 'password');

// Execute a query.
$rows = $Db->executeQuery("SELECT * FROM table_name");

// Print the results.
print_r($rows);
?>

An Insert Statement

<?php
require_once('Class.Database.php');

// Establish a connection.
$Db = new Database('localhost', 'database', 'username', 'password');

// Execute a query.
$row_id = $Db->executeQuery("INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3)");

// Print the results.
echo($row_id);
?>

An Update Statement

<?php
require_once('Class.Database.php');

// Establish a connection.
$Db = new Database('localhost', 'database', 'username', 'password');

// Execute a query.
$success = $Db->executeQuery("UPDATE table_name SET column1 = value, column2 = value, column3 = value WHERE some_column = some_value");

// Print the results.
echo($success);
?>

A Delete Statement

<?php
require_once('Class.Database.php');

// Establish a connection.
$Db = new Database('localhost', 'database', 'username', 'password');

// Execute a query.
$success = $Db->executeQuery("DELETE FROM table_name WHERE some_column = some_value");

// Print the results.
echo($success);
?>