link = @mysql_connect($host, $user, $pass) or @MySQL::_reportError(); if($db) { if(!mysql_select_db($db)) @MySQL::_reportError(); $this->db = $db; } $staticLink = $this->link; } function close() { global $logtype; $value = @mysql_close($this->link) or @MySQL::_reportError(); return $value; } function dbSelect($db) { global $logtype; $value = @mysql_select_db($db) or @MySQL::_reportError(); return $value; } function getLink() { global $staticLink; if ($staticLink) return $staticLink; else @MySQL::_reportError("can't get database link"); } function _getDebugInfo() { $debugInfoArray = debug_backtrace(); $i = 0; while((realPath($debugInfoArray[$i]["file"]) != realPath($_SERVER["SCRIPT_FILENAME"])) && ($iLine: %d\n
Called function: %s\n
Contained class: %s\n
Passed arguments: %s\n
Reported error: %s
", $debugInfo["file"], $debugInfo["line"], $debugInfo["function"], $debugInfo["class"], implode(", ", $debugInfo["args"]), $txt . ($errno==-1 ? "" : " (" . $errno . ")")); if($type==-1) $type = $logType; switch($type) { case "1": if($debug) { $msg = sprintf("MySQL error reported! %s\n

\nReported by: http://%s%s\n

Refering page: %s

", $txt, $_SERVER["HTTP_HOST"], $_SERVER["REQUEST_URI"], $_SERVER["HTTP_REFERER"]); error_log($msg, 1, $admin, sprintf("From: %s", $_SERVER["HTTP_HOSTS"])); } break; case "3": if($debug) { $stamp = date("[d/M/Y:G:i:s]"); $msg = sprintf("%s %s (%s%s)\r\n\r\n", $stamp, $txt, $_SERVER["HTTP_HOST"], $_SERVER["REQUEST_URI"]); error_log($msg, 3, $logFile); } break; default: die("Exiting: wrong call to _reportError()\n"); } echo $msg; exit; } } class Query extends MySQL { /* * int/resource Query(string query) */ function Query($query) { global $staticLink, $logtype, $defaultMethod; if(!$staticLink) @MySQL::_reportError(); $this->result = @mysql_query($query, $staticLink); if($this->result) { if(ereg("^insert", strtolower($query))) { $this->insertId = mysql_insert_id(); return $this->result; } elseif(ereg("^select", strtolower($query))) { $this->numrows = mysql_num_rows($this->result); return $this->result; } else return; } else @MySQL::_reportError($query); } /* * int getInsertId() */ function getInsertId(){ return $this->insertId; } /* * array/object next([const method]) */ function next($method = -1) { global $defaultMethod; if($method == -1) $method = $defaultMethod; if($method == ROW_AS_OBJECT) return $this->_fetchObjectRow(); elseif($method == ROW_AS_ARRAY) return $this->_fetchArrayRow(); } /* * Return number of rows */ function numrows() { if(!($num = @mysql_num_rows($this->result))) return false; else return $num; } /* * object _fetchObjectRow() */ function _fetchObjectRow() { if(!($row = @mysql_fetch_object($this->result))) return false; else return $row; } /* * array _fetchArrayRow() */ function _fetchArrayRow() { if(!($row = @mysql_fetch_array($this->result))) return false; else return $row; } /* * array fetchObjects() */ function fetchObjects() { $obj = Array(); while($val = @mysql_fetch_object($this->result)) { $obj[] = $val; } return $obj; } /* * array fetchArrays() */ function fetchArrays() { $arr = Array(); while($val = @mysql_fetch_array($this->result)) { $arr[] = $val; } return $arr; } /* * void free() */ function free() { @mysql_free_result($this->result) or @MySQL::_reportError(); } /* * void reset() */ function reset() { @mysql_data_seek($this->result, 0) or @MySQL::_reportError(); } } //MySQL::connect($dbname, $dbhost, $dbuser, $dbpass); $myconec = new MySQL(); $myconec->connect($AD_dbname, $AD_dbhost, $AD_dbuser, $AD_dbpass); ?>