<?php
// Require the class
require_once('MySQL.php');
// Database info
require_once('db.php');
// Instantiate the MySQL Class
// Parameters: Database Host, Database User, Database Password, Database Name, Persistent Connection (true or false)
$mysql = new MySQL($dbHost,$dbUser,$dbPass,$dbName);
// Check to see if errors occured
if ($mysql->isError()) {
// Print the error message
die($mysql->getMessage());
}
// The SQL to execute
$sql = "SELECT field FROM table";
// Execute the query
$result = $mysql->query($sql);
// Check for errors
if (! $result) {
// Print the error message
die($mysql->getMessage());
}
// Loop through the rows using the fetch() method
// Parameters: [optional] fetch mode (FETCH_ARRAY , FETCH_ASSOC or FETCH_OBJECT)
while ($row = $result->fetch(FETCH_OBJECT)) {
echo $row->field.'<br />';
}
echo 'Rows: '.$result->numRows();
// Free the result in memory
$result->free();
// Close the connection
$mysql->close();
?>
|
Download
