//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'file=' . basename($file) . ',line=' . $line . ',sql=' . $GLOBALS['last_sql']);
$result = mysqli_query(getSqlLink(), $GLOBALS['last_sql'])
or logSqlError($file, $line, 'file='. basename($file) . ',line=' . $line . ':mysqli_error()=' . mysqli_error(getSqlLink()) . ',last_query=' . $GLOBALS['last_sql']);
- //* DEBUG: */ logDebugMessage($file, $line, 'sql=' . $GLOBALS['last_sql'] . ',affected=' . sqlAffectedRows() . ',numRows='.(isValidSqlLink($result) ? sqlNumRows($result) : gettype($result)));
+ //* DEBUG: */ logDebugMessage($file, $line, 'sql=' . $GLOBALS['last_sql'] . ',affected=' . sqlAffectedRows() . ',numRows='.(isValidSqlResult($result) ? sqlNumRows($result) : gettype($result)));
// Calculate query time
$queryTime = microtime(TRUE) - $querytimeBefore;
} // END - if
// Append debug line
- appendLineToFile(getCachePath() . 'mysql.log', basename($file) . '|LINE=' . $line . '|NUM=' . (isValidSqlLink($result) ? sqlNumRows($result) : 'false') . '|AFFECTED=' . sqlAffectedRows() . '|QUERYTIME:' . ($queryTime * 1000) . 'ms): ' . str_replace(array(chr(13), PHP_EOL), array('', ' '), $GLOBALS['last_sql']));
+ appendLineToFile(getCachePath() . 'mysql.log', basename($file) . '|LINE=' . $line . '|NUM=' . (isValidSqlResult($result) ? sqlNumRows($result) : 'false') . '|AFFECTED=' . sqlAffectedRows() . '|QUERYTIME:' . ($queryTime * 1000) . 'ms): ' . str_replace(array(chr(13), PHP_EOL), array('', ' '), $GLOBALS['last_sql']));
} // END - if
// Increment stats entry
// SQL fetch row
function sqlFetchRow ($resource) {
// Is $resource valid?
- if ((!isValidSqlLink($resource)) || (!isSqlLinkUp())) return FALSE;
+ if ((!isValidSqlResult($resource)) || (!isSqlLinkUp())) return FALSE;
// Fetch the data and return it
return mysqli_fetch_row($resource);
// SQL fetch array
function sqlFetchArray ($resource) {
// Is $resource valid?
- if ((!isValidSqlLink($resource)) || (!isSqlLinkUp())) return FALSE;
+ if ((!isValidSqlResult($resource)) || (!isSqlLinkUp())) return FALSE;
// Load row as array from database
$row = mysqli_fetch_assoc($resource);
// SQL result
function sqlResult ($resource, $row, $field = '0') {
// Is $resource valid?
- if ((!isValidSqlLink($resource)) || (!isSqlLinkUp())) return FALSE;
+ if ((!isValidSqlResult($resource)) || (!isSqlLinkUp())) return FALSE;
// Run the result command
$result = mysqli_result($resource, $row, $field);
// SQL free result
function sqlFreeResult ($resource) {
- if ((!isValidSqlLink($resource)) || (!isSqlLinkUp())) {
+ if ((!isValidSqlResult($resource)) || (!isSqlLinkUp())) {
// Abort here
return FALSE;
} // END - if
// Checks whether given link is a valid SQL link
function isValidSqlLink ($linkInstance) {
// Is it an object?
- $isValid = (($linkInstance instanceof mysqli) || ($linkInstance instanceof mysqli_result));
+ $isValid = ($linkInstance instanceof mysqli);
// Debug message
//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'linkInstance[]=' . gettype($linkInstance). ',isValid=' . intval($isValid));
}
// Checks whether given result is really a result
-function isSqlResult ($resultInstance) {
+function isValidSqlResult ($resultInstance) {
// Is it a resource?
$isValid = ($resultInstance instanceof mysqli_result);