Kôd:
class mysql_link {
var $link_id;
var $queries=0;
var $sqldump;
function mysql_link_connect($hostname,$username,$password,$database) {
$link_id=mysql_connect($hostname,$username,$password);
if (!$link_id) {
echo('Database server is down - symptom: invalid username, password or server URI');
echo(' <a href="mailto:'.ADMIN_EMAIL.'?subject=Database is down!">Click here to email to administrator that site is down</a>. Press the back button, please. Sorry for the inconvenience.');
die(); }
if (!mysql_select_db($database)) {
echo('Database server is down - symptom: site cannot select database specified');
echo(' <a href="mailto:'.ADMIN_EMAIL.'?subject=Database is down!">Click here to email to administrator that site is down</a>. Press the back button, please. Sorry for the inconvenience.');
die(); }
return $link_id;
}
function mysql_link_release() {
mysql_close($link_id);
}
function mysql_link_query($query_db) {
global $queries,$sqldump;
$result_db=mysql_query($query_db);
if (!$result_db) die("Problematic SQL query ::: <br /><br />".$query_db."<br /><br />Please <a href=\"mailto:".ADMIN_EMAIL."?subject=Bug in SQL at domain ".$_SERVER["SERVER_NAME"]."\">email to administrator</a> that there are technical difficulties");
$queries=$queries+1;
$sqldump=$sqldump."\n".$query_db;
return $result_db;
}
function dump_sql() {
global $sqldump;
return $sqldump;
}
function dump_query_number() {
global $queries;
return $queries;
}
}
$queries i $sqldump su globalno vidljive. nesto poput
Kôd:
function dump_sql() {
return $this->$sqldump;
}
Nece da radi (dobijam cannot reference empty resource ili sl). Kako $queries i $sqldump da budu vidljive samo unutar klase mysql_link. Primer mogu i echo $link_id->dump_query_number(); i echo $queries;