<?php
/*
* @project: phpMysqlCachingWrapper
* @date: 04-12-2010
* @version: 0.1 - php 4
* @author Bilge Hauser
* @email: [email protected]
* @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', '[email protected]');
$onDBConnectError = "mail('[email protected]', \$_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('[email protected]', \$_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>";
?>
|
Download
