/** * _logQuery * * @param String $sql sql-query * @param int $duration * @param int $results result counter * * @return bool */ private function _logQuery($sql, $duration, $results) { $logLevelUse = strtolower($this->logger_level); if ($logLevelUse != 'trace' && $logLevelUse != 'debug') { return false; } $info = 'time => ' . round($duration, 5) . ' - ' . 'results => ' . $results . ' - ' . 'SQL => ' . UTF8::htmlentities($sql); $fileInfo = $this->getFileAndLineFromSql(); $this->logger(array('debug', '<strong>' . date('d. m. Y G:i:s') . ' (' . $fileInfo['file'] . ' line: ' . $fileInfo['line'] . '):</strong> ' . $info . '<br>', 'sql')); return true; }
/** * Convert all applicable characters to HTML entities. * * @param int|null $flags Optional flags * * @return Stringy Object with the resulting $str after being html encoded. */ public function htmlEncode($flags = ENT_COMPAT) { $str = UTF8::htmlentities($this->str, $flags, $this->encoding); return static::create($str, $this->encoding); }
/** * Log the current query via "$this->logger". * * @param string $sql sql-query * @param int $duration * @param int $results field_count | insert_id | affected_rows * @param bool $sql_error * * @return bool */ public function logQuery($sql, $duration, $results, $sql_error = false) { $logLevelUse = strtolower($this->logger_level); if ($sql_error === false && ($logLevelUse !== 'trace' && $logLevelUse !== 'debug')) { return false; } // set log-level if ($sql_error === true) { $logLevel = 'error'; } else { $logLevel = $logLevelUse; } // get extra info $infoExtra = \mysqli_info($this->_db->getLink()); if ($infoExtra) { $infoExtra = ' | info => ' . $infoExtra; } // // logging // $info = 'time => ' . round($duration, 5) . ' | results => ' . (int) $results . $infoExtra . ' | SQL => ' . UTF8::htmlentities($sql); $fileInfo = $this->getFileAndLineFromSql(); return $this->logger(array($logLevel, '<strong>' . date('d. m. Y G:i:s') . ' (' . $fileInfo['file'] . ' line: ' . $fileInfo['line'] . '):</strong> ' . $info . '<br>', 'sql')); }