$value) { if (is_array($arr[$key])) FmtReq_TraverseRequestArray($arr[$key]); else $arr[$key] = FmtReq_FormatValue($value); } } foreach($_REQUEST as $key => $value) { if (is_array($_REQUEST[$key])) FmtReq_TraverseRequestArray($_REQUEST[$key]); else $_REQUEST[$key] = FmtReq_FormatValue($value); } ?> ErrNo: $errno
Error: $errmsg"; $_SESSION['issend'] = $issend; trigger_error("exception", E_USER_ERROR); } // Buat query function QueryDb($sql) { global $mysqlconnection; $result = @mysql_query($sql, $mysqlconnection); if (mysql_errno() > 0) { // Save Error Information $errmsg = mysql_error(); $errno = mysql_errno(); // Force Closing Database Connection CloseDb(); // Handle Error HandleQueryError($sql, $errno, $errmsg, true); exit(); } return $result; } function QueryDbTrans($sql, &$success) { global $mysqlconnection; $result = @mysql_query($sql, $mysqlconnection); $success = ($result && 1); if (!$success) { // Save Error Information $errmsg = mysql_error(); $errno = mysql_errno(); // Force Rolling Back and Closing Database Connection RollbackTrans(); CloseDb(); // Handle Error HandleQueryError($sql, $errno, $errmsg, true); exit(); } return $result; } function QueryDbEx($sql) { global $mysqlconnection; $result = @mysql_query($sql, $mysqlconnection); LogQuery($sql); if (mysql_errno() > 0) { LogIfError($sql); throw new DbException(mysql_error(), mysql_errno()); } return $result; } function FetchSingleEx($sql) { $res = QueryDbEx($sql); LogQuery($sql); LogIfError($sql); if (mysql_num_rows($res) > 0) { $row = mysql_fetch_row($res); return $row[0]; } else { return NULL; } } function LogIfError($sql) { if (mysql_errno() == 0) return; echo "SQL Error Logged
"; LogError($sql, mysql_errno(), mysql_error()); } function LogError($sql, $errno, $error) { global $G_ENABLE_QUERY_ERROR_LOG, $G_FILE_LOG_QUERY_ERROR; if (!$G_ENABLE_QUERY_ERROR_LOG) return; $logPath = @realpath(@dirname(__FILE__)) . "\\..\\log"; echo "$logPath
"; $logExists = @file_exists($logPath) && @is_dir($logPath); if (!$logExists) @mkdir($logPath, 0755); $logFile = @realpath(@dirname(__FILE__)) . "\\..\\log\\". $G_FILE_LOG_QUERY_ERROR; echo "$logFile
"; $modeFile = (@file_exists($logFile) && @filesize($logFile) > 1024 * 1024) ? "w" : "a"; $fp = @fopen($logFile, $modeFile); @fwrite($fp, "-- Query Error on " . date('d-M-Y H:i:s') . " --------\r\n"); @fwrite($fp, " SCRIPT > " . $_SERVER['SCRIPT_NAME'] . "\r\n"); @fwrite($fp, " QUERY > $sql\r\n"); @fwrite($fp, " ERRNO > $errno\r\n"); @fwrite($fp, " ERROR > $error\r\n"); @fwrite($fp, "\r\n"); @fclose($fp); } function LogQuery($sql) { global $G_ENABLE_QUERY_LOG, $G_FILE_LOG_QUERY; if (!$G_ENABLE_QUERY_LOG) return; $logPath = @realpath(@dirname(__FILE__)) . "/../../log"; $logExists = @file_exists($logPath) && @is_dir($logPath); if (!$logExists) @mkdir($logPath, 0644); $logFile = @realpath(@dirname(__FILE__)) . "/../../log/" . $G_FILE_LOG_QUERY; $modeFile = (@file_exists($logFile) && @filesize($logFile) > 1024 * 1024) ? "w" : "a"; $fp = @fopen($logFile, $modeFile); @fwrite($fp, "-- Query Executed on " . date('d-M-Y H:i:s') . " --------\r\n"); @fwrite($fp, " SCRIPT > " . $_SERVER['SCRIPT_NAME'] . "\r\n"); @fwrite($fp, " QUERY > $sql\r\n"); @fwrite($fp, "\r\n"); @fclose($fp); } function BeginTrans() { global $mysqlconnection; @mysql_query("SET AUTOCOMMIT=0", $mysqlconnection); @mysql_query("BEGIN", $mysqlconnection); } function CommitTrans() { global $mysqlconnection; @mysql_query("COMMIT", $mysqlconnection); @mysql_query("SET AUTOCOMMIT=1", $mysqlconnection); } function RollbackTrans() { global $mysqlconnection; @mysql_query("ROLLBACK", $mysqlconnection); @mysql_query("SET AUTOCOMMIT=1", $mysqlconnection); } function GetValue($tablename, $column, $where) { $sql = "SELECT $column FROM $tablename WHERE $where"; $result_get_value = QueryDb($sql); $row_get_value = mysql_fetch_row($result_get_value); return $row_get_value[0]; } function FetchSingle($sql) { global $mysqlconnection; $res = QueryDb($sql); $row = @mysql_fetch_row($res); return $row[0]; } function FetchRow($sql) { global $mysqlconnection; $res = QueryDb($sql); $row = @mysql_fetch_row($res); return $row; } ?>