Location: PHPKode > scripts > PHP MySQL Caching Wrapper > example.php
<?php
/*
 * @project: phpMysqlCachingWrapper 
 * @date: 04-12-2010
 * @version: 0.1 - php 4 
 * @author Bilge Hauser
 * @email: hide@address.com
 * @copyright: (c) 2010 Bilge Hauser 
 *  
 */  

$SITE_CONF = array();
$SITE_CONF['SITEROOT']        	= dirname ($_SERVER['SCRIPT_FILENAME']) . '/';
$SITE_CONF['DB_CACHE_PATH']   	= $SITE_CONF['SITEROOT'] . 'cache/';
$SITE_CONF['CLASS_PATH']         = $SITE_CONF['SITEROOT'];
$SITE_CONF['DB_HOST']      		= 'localhost';
$SITE_CONF['DB_DATABASE']   		= 'database';
$SITE_CONF['DB_USER']      		= 'user';
$SITE_CONF['DB_PASS']      		= 'password';
$SITE_CONF['DB_PERSISTENT']		= false;
$SITE_CONF['DB_USE_SOCKET']      = false;
$SITE_CONF['DB_SOCKET_PATH']     = '/var/lib/mysql/mysql.sock';
$SITE_CONF['DB_USE_CACHE']      	= true;
$SITE_CONF['DB_CACHE_TTL']      	= 360; //Seconds
$SITE_CONF['DEBUG']      			= true;
$SITE_CONF['DEBUG_LOGPATH']      = $SITE_CONF['SITEROOT'] . 'log/phpMysqlCachingWrapper.log';

require_once($SITE_CONF['CLASS_PATH'] . 'phpMysqlCachingWrapper.class.php');



$dbh = new mysql_wrapper($SITE_CONF);
// Result comes as asc. array
$countries = $dbh->get_rows('SELECT * FROM land ORDER BY title ASC;');

# $dbh->query('delete from land where land_id = 42');
# $row = $dbh->get_row('select * from land where land_id = 66');
# echo $row['title'];


# Add event handlers
# function to be executed in class using $self 
$onBeforeCacheRead = "\$self->setMessageQue('Injected Text Before Cache Read');";
$onAfterCacheRead = "\$self->setMessageQue('Injected Text After Cache Read');";

# set functions to events
$dbh->register_event('CACHE_READ_BEFORE', $onBeforeCacheRead);
$dbh->register_event('CACHE_READ_AFTER',  $onAfterCacheRead);

# Send mail if database is not conected
ini_set('sendmail_from', 'hide@address.com');
$onDBConnectError = "mail('hide@address.com', \$_SERVER['SERVER_NAME'].': Database connection error', 'Warning: Database could no be conected on '.\$_SERVER['SERVER_NAME']);";
$dbh->register_event('CLASS_WRAPPER_CONNECT_ERROR',  $onDBConnectError);
# Send mail if database querie returns error
$onDBQueryError = "mail('hide@address.com', \$_SERVER['SERVER_NAME'].': Database query error', 'Warning: Database queries had an error on '.\$_SERVER['SERVER_NAME']);";
$dbh->register_event('CLASS_WRAPPER_QUERY_ERROR',  $onDBQueryError);



echo "<html>";
echo "<body>";

if ($dhh->getError()) echo "<p><b>".$dhh->getError()."</b></p>";

if ($SITE_CONF['DEBUG']) echo implode('<br>', $dbh->getMessageQue());

echo "<p>";
foreach($countries as $country){
	echo $country['title'].'<br>';
}
echo "</p>";
echo "</body>";
echo "</html>";

?>
Return current item: PHP MySQL Caching Wrapper