rows); if ($row) { db_lift_row($row, $this->rows); return true; } else { return false; } } function DBIterator($rows) { $this->rows = $rows; } } function db_open_connection() { global $num_queries; global $mysql_link; require("config.php"); $mysql_link = mysql_connect($mysql_server, $mysql_user, $mysql_pwd) or die("Error in: $PHP_SELF Error: " .mysql_error()); mysql_select_db($mysql_database,$mysql_link)or die("Error in: $PHP_SELF Error: " .mysql_error()); } function db_setup_and_query($request) { global $num_queries; global $mysql_link; if ($mysql_link==false){ db_open_connection(); } $num_queries = $num_queries +1; $result=mysql_query($request,$mysql_link) or die("$request
Error in: " .mysql_error()); return $result; } function db_lift_row($row, $rows) { $num_fields = mysql_num_fields($rows); $cmd = ""; for ($i = 0; $i < $num_fields; $i = $i + 1) { $cmd = $cmd . "global \$" . mysql_field_name($rows, $i) . ";\n"; $cmd = $cmd . "\$" . mysql_field_name($rows, $i) . "=\$row[$i];\n"; } eval ($cmd); } function db_one_row($query) { $rows = db_setup_and_query($query); if (($rows != 1) && (mysql_num_rows($rows) > 0) ) { $row = mysql_fetch_array($rows); db_lift_row($row, $rows); } } function db_multi_row($query) { $rows = db_setup_and_query($query); return new DBIterator($rows); } ?>