/**
*/
function get_last_query_info()
{
if (!$this->db_connect_id) {
return false;
}
// Example: Records: 42 Deleted: 0 Skipped: 0 Warnings: 0
return mysqli_info($this->db_connect_id);
}
$notify = '<div class="notify_deleted">Query contains a forbidden command.</div>';
break;
}
}
if ($continue !== false) {
$queries = explode(">>BREAK<<", $code);
foreach ($queries as $query) {
if (!mysqli_query($GLOBALS["___mysqli_ston"], "" . $query . "")) {
$error = mysqli_error($GLOBALS["___mysqli_ston"]);
$notify = '<div class="notify_deleted">Execution failed:<br />' . $error . '</div>';
} else {
if ($rows = mysqli_num_rows(mysqli_query($GLOBALS["___mysqli_ston"], "" . $query . ""))) {
$error = mysqli_info($GLOBALS["___mysqli_ston"]);
$notify = '<div class="notify_success">Query succesfully executed.<br />' . $error . '<br />Rows: ' . number_format($rows) . '</div>';
} else {
$error = mysqli_info($GLOBALS["___mysqli_ston"]);
$notify = '<div class="notify_success">Query succesfully executed.<br />' . $error . '</div>';
}
}
}
}
}
?>
<!-- codemirror -->
<link type="text/css" rel="stylesheet" href="/source/Vendor/codemirror/lib/codemirror.css">
<script type="text/javascript" src="/source/Vendor/codemirror/lib/codemirror.js"></script>
<script type="text/javascript" src="/source/Vendor/codemirror/addon/placeholder.js"></script>
<script type="text/javascript" src="/source/Vendor/codemirror/mode/sql/sql.js"></script>
<div class="entries">
function dump_properties($mysqli)
{
printf("\nClass variables:\n");
$variables = array_keys(get_class_vars(get_class($mysqli)));
sort($variables);
foreach ($variables as $k => $var) {
printf("%s = '%s'\n", $var, var_export(@$mysqli->{$var}, true));
}
printf("\nObject variables:\n");
$variables = array_keys(get_object_vars($mysqli));
foreach ($variables as $k => $var) {
printf("%s = '%s'\n", $var, var_export(@$mysqli->{$var}, true));
}
printf("\nMagic, magic properties:\n");
assert(@mysqli_affected_rows($mysqli) === @$mysqli->affected_rows);
printf("mysqli->affected_rows = '%s'/%s ('%s'/%s)\n", @$mysqli->affected_rows, gettype(@$mysqli->affected_rows), @mysqli_affected_rows($mysqli), gettype(@mysqli_affected_rows($mysqli)));
assert(@mysqli_get_client_info() === @$mysqli->client_info);
printf("mysqli->client_info = '%s'/%s ('%s'/%s)\n", @$mysqli->client_info, gettype(@$mysqli->client_info), @mysqli_get_client_info(), gettype(@mysqli_get_client_info()));
assert(@mysqli_get_client_version() === @$mysqli->client_version);
printf("mysqli->client_version = '%s'/%s ('%s'/%s)\n", @$mysqli->client_version, gettype(@$mysqli->client_version), @mysqli_get_client_version(), gettype(@mysqli_get_client_version()));
assert(@mysqli_errno($mysqli) === @$mysqli->errno);
printf("mysqli->errno = '%s'/%s ('%s'/%s)\n", @$mysqli->errno, gettype(@$mysqli->errno), @mysqli_errno($mysqli), gettype(@mysqli_errno($mysqli)));
assert(@mysqli_error($mysqli) === @$mysqli->error);
printf("mysqli->error = '%s'/%s ('%s'/%s)\n", @$mysqli->error, gettype(@$mysqli->error), @mysqli_error($mysqli), gettype(@mysqli_error($mysqli)));
assert(@mysqli_field_count($mysqli) === @$mysqli->field_count);
printf("mysqli->field_count = '%s'/%s ('%s'/%s)\n", @$mysqli->field_count, gettype(@$mysqli->field_count), @mysqli_field_count($mysqli), gettype(@mysqli_field_count($mysqli)));
assert(@mysqli_insert_id($mysqli) === @$mysqli->insert_id);
printf("mysqli->insert_id = '%s'/%s ('%s'/%s)\n", @$mysqli->insert_id, gettype(@$mysqli->insert_id), @mysqli_insert_id($mysqli), gettype(@mysqli_insert_id($mysqli)));
assert(@mysqli_sqlstate($mysqli) === @$mysqli->sqlstate);
printf("mysqli->sqlstate = '%s'/%s ('%s'/%s)\n", @$mysqli->sqlstate, gettype(@$mysqli->sqlstate), @mysqli_sqlstate($mysqli), gettype(@mysqli_sqlstate($mysqli)));
assert(@mysqli_get_host_info($mysqli) === @$mysqli->host_info);
printf("mysqli->host_info = '%s'/%s ('%s'/%s)\n", @$mysqli->host_info, gettype(@$mysqli->host_info), @mysqli_get_host_info($mysqli), gettype(@mysqli_get_host_info($mysqli)));
/* note that the data types are different */
assert(@mysqli_info($mysqli) == @$mysqli->info);
printf("mysqli->info = '%s'/%s ('%s'/%s)\n", @$mysqli->info, gettype(@$mysqli->info), @mysqli_info($mysqli), gettype(@mysqli_info($mysqli)));
assert(@mysqli_thread_id($mysqli) > @$mysqli->thread_id);
assert(gettype(@$mysqli->thread_id) == gettype(@mysqli_thread_id($mysqli)));
printf("mysqli->thread_id = '%s'/%s ('%s'/%s)\n", @$mysqli->thread_id, gettype(@$mysqli->thread_id), @mysqli_thread_id($mysqli), gettype(@mysqli_thread_id($mysqli)));
assert(@mysqli_get_proto_info($mysqli) === @$mysqli->protocol_version);
printf("mysqli->protocol_version = '%s'/%s ('%s'/%s)\n", @$mysqli->protocol_version, gettype(@$mysqli->protocol_version), @mysqli_get_proto_info($mysqli), gettype(@mysqli_get_proto_info($mysqli)));
assert(@mysqli_get_server_info($mysqli) === @$mysqli->server_info);
printf("mysqli->server_info = '%s'/%s ('%s'/%s)\n", @$mysqli->server_info, gettype(@$mysqli->server_info), @mysqli_get_server_info($mysqli), gettype(@mysqli_get_server_info($mysqli)));
assert(@mysqli_get_server_version($mysqli) === @$mysqli->server_version);
printf("mysqli->server_version = '%s'/%s ('%s'/%s)\n", @$mysqli->server_version, gettype(@$mysqli->server_version), @mysqli_get_server_version($mysqli), gettype(@mysqli_get_server_version($mysqli)));
assert(@mysqli_warning_count($mysqli) === @$mysqli->warning_count);
printf("mysqli->warning_count = '%s'/%s ('%s'/%s)\n", @$mysqli->warning_count, gettype(@$mysqli->warning_count), @mysqli_warning_count($mysqli), gettype(@mysqli_warning_count($mysqli)));
printf("\nAccess to undefined properties:\n");
printf("mysqli->unknown = '%s'\n", @$mysqli->unknown);
@($mysqli->unknown = 13);
printf("setting mysqli->unknown, @mysqli_unknown = '%s'\n", @$mysqli->unknown);
$unknown = 'friday';
@($mysqli->unknown = $unknown);
printf("setting mysqli->unknown, @mysqli_unknown = '%s'\n", @$mysqli->unknown);
printf("\nAccess hidden properties for MYSLQI_STATUS_INITIALIZED (TODO documentation):\n");
assert(@mysqli_connect_error() === @$mysqli->connect_error);
printf("mysqli->connect_error = '%s'/%s ('%s'/%s)\n", @$mysqli->connect_error, gettype(@$mysqli->connect_error), @mysqli_connect_error(), gettype(@mysqli_connect_error()));
assert(@mysqli_connect_errno() === @$mysqli->connect_errno);
printf("mysqli->connect_errno = '%s'/%s ('%s'/%s)\n", @$mysqli->connect_errno, gettype(@$mysqli->connect_errno), @mysqli_connect_errno(), gettype(@mysqli_connect_errno()));
}
function mysqli_info_array($dblink)
{
# Getting our mysqli info
$info = mysqli_info($dblink);
# No results found
if (!$info) {
return false;
}
# Matching our numbers and strings
preg_match_all('!\\d+!', $info, $matches);
preg_match_all('/ (.*?):/', $info, $match);
array_unshift($match[1], explode(':', $info, 2)[0]);
# Creating our info array
$results = [];
for ($i = 0, $len = count($match[1]); $i < $len; $i++) {
$results[$match[1][$i]] = $matches[0][$i];
}
# Returning the results
return $results;
}
function mysqli_insert_array($table, $data, $exclude = array())
{
$con = mysqli_connect("localhost", "root", "", "test");
$fields = $values = array();
if (!is_array($exclude)) {
$exclude = array($exclude);
}
foreach (array_keys($data) as $key) {
if (!in_array($key, $exclude)) {
$fields[] = "`{$key}`";
$values[] = "'" . mysql_real_escape_string($data[$key]) . "'";
}
}
$fields = implode(",", $fields);
$values = implode(",", $values);
if (mysqli_query($con, "INSERT INTO `{$table}` ({$fields}) VALUES ({$values})")) {
return array("mysql_error" => false, "mysql_insert_id" => mysqli_insert_id($con), "mysql_affected_rows" => mysqli_affected_rows($con), "mysql_info" => mysqli_info($con));
} else {
return array("mysql_error" => mysqli_error($con));
}
}
$password = "******";
$dbname = "dbname";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
set_time_limit(0);
// Sets the Time Limit to Unlimited - saves you from Maximum execution time of 30 seconds exceeded ERROR of PHP
// Get all the tables in your database
$sql = "select TABLE_NAME from information_schema.tables where table_schema = 'DBNAME-IMPORTANT'";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
$sql = "UPDATE " . $row["TABLE_NAME"] . " SET Date = STR_TO_DATE(`Date`, '%d/%m/%Y')";
if (mysqli_query($conn, $sql)) {
echo mysqli_info($conn) . " ---> Table Name > " . $row["TABLE_NAME"] . "<br/>";
// if(true) exit; // Uncomment this line if you wanna test the Output with one table
} else {
echo '<span style="color: red;">Error Occured -- ' . mysqli_error($conn) . '</span> ---> Table Name > ' . $row["TABLE_NAME"] . '<br/>';
// if(true) exit; // Uncomment this line if you wanna test the Output with one table
}
}
} else {
echo "0 results";
}
mysqli_close($conn);
?>
<?php
require_once "connect.inc";
/*** test mysqli_connect 127.0.0.1 ***/
$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
mysqli_select_db($link, $db);
mysqli_query($link, "DROP TABLE IF EXISTS test_032_table_1");
mysqli_query($link, "CREATE TABLE test_032_table_1 (a INT)");
mysqli_query($link, "INSERT INTO test_032_table_1 VALUES (1),(2),(3)");
$afc = mysqli_info($link);
var_dump($afc);
mysqli_query($link, "DROP TABLE IF EXISTS test_032_table_1");
mysqli_close($link);
print "done!";
error_reporting(0);
require_once "connect.inc";
if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) {
printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
}
if (!mysqli_query($link, "DROP TABLE IF EXISTS test_032_table_1")) {
printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
mysqli_close($link);
public function status()
{
if (is_array($this->_connection)) {
$this->connect();
}
$rs = mysqli_info($this->_connection);
$rs0 = $this->_query("show variables like '%char%'");
while (null !== ($r = mysqli_fetch_row($rs0))) {
$rs[$r[0]] = $r[1];
}
return $rs;
}
function info()
{
if ($this->LinkID) {
return mysqli_info($this->LinkID);
}
}
public function mysqlInfo()
{
return mysqli_info($this->conn);
}
/**
* Returns the number of matched rows in a SQL query
*
* @access public
* @return int Number of matched rows
*/
function serendipity_db_matched_rows()
{
global $serendipity;
preg_match("/^[^0-9]+([0-9]+)[^0-9]+([0-9]+)[^0-9]+([0-9]+)/", mysqli_info($serendipity['dbConn']), $arr);
// mysqli_affected_rows returns 0 if rows were matched but not changed.
// mysqli_info returns rows matched
return $arr[0];
}
public function get_info()
{
$this->output->info("Getting info");
return mysqli_info($this->con);
}
assert(mysqli_error_list($link) === $mysqli->error_list);
assert(is_array($mysqli->error_list));
}
assert(mysqli_field_count($link) === $mysqli->field_count);
printf("mysqli->field_count = '%s'/%s ('%s'/%s)\n", $mysqli->field_count, gettype($mysqli->field_count), mysqli_field_count($link), gettype(mysqli_field_count($link)));
assert(mysqli_insert_id($link) === $mysqli->insert_id);
printf("mysqli->insert_id = '%s'/%s ('%s'/%s)\n", $mysqli->insert_id, gettype($mysqli->insert_id), mysqli_insert_id($link), gettype(mysqli_insert_id($link)));
assert(mysqli_sqlstate($link) === $mysqli->sqlstate);
printf("mysqli->sqlstate = '%s'/%s ('%s'/%s)\n", $mysqli->sqlstate, gettype($mysqli->sqlstate), mysqli_sqlstate($link), gettype(mysqli_sqlstate($link)));
assert(soundex(mysqli_stat($link)) == soundex($mysqli->stat));
printf("mysqli->stat = '%s'/%s ('%s'/%s)\n", $mysqli->stat, gettype($mysqli->stat), mysqli_stat($link), gettype(mysqli_stat($link)));
assert(mysqli_get_host_info($link) === $mysqli->host_info);
printf("mysqli->host_info = '%s'/%s ('%s'/%s)\n", $mysqli->host_info, gettype($mysqli->host_info), mysqli_get_host_info($link), gettype(mysqli_get_host_info($link)));
/* note that the data types are different */
assert(mysqli_info($link) == $mysqli->info);
printf("mysqli->info = '%s'/%s ('%s'/%s)\n", $mysqli->info, gettype($mysqli->info), mysqli_info($link), gettype(mysqli_info($link)));
assert(mysqli_thread_id($link) > $mysqli->thread_id);
assert(gettype($mysqli->thread_id) == gettype(mysqli_thread_id($link)));
printf("mysqli->thread_id = '%s'/%s ('%s'/%s)\n", $mysqli->thread_id, gettype($mysqli->thread_id), mysqli_thread_id($link), gettype(mysqli_thread_id($link)));
assert(mysqli_get_proto_info($link) === $mysqli->protocol_version);
printf("mysqli->protocol_version = '%s'/%s ('%s'/%s)\n", $mysqli->protocol_version, gettype($mysqli->protocol_version), mysqli_get_proto_info($link), gettype(mysqli_get_proto_info($link)));
assert(mysqli_get_server_info($link) === $mysqli->server_info);
printf("mysqli->server_info = '%s'/%s ('%s'/%s)\n", $mysqli->server_info, gettype($mysqli->server_info), mysqli_get_server_info($link), gettype(mysqli_get_server_info($link)));
assert(mysqli_get_server_version($link) === $mysqli->server_version);
printf("mysqli->server_version = '%s'/%s ('%s'/%s)\n", $mysqli->server_version, gettype($mysqli->server_version), mysqli_get_server_version($link), gettype(mysqli_get_server_version($link)));
assert(mysqli_warning_count($link) === $mysqli->warning_count);
printf("mysqli->warning_count = '%s'/%s ('%s'/%s)\n", $mysqli->warning_count, gettype($mysqli->warning_count), mysqli_warning_count($link), gettype(mysqli_warning_count($link)));
printf("\nAccess to undefined properties:\n");
printf("mysqli->unknown = '%s'\n", @$mysqli->unknown);
@($mysqli->unknown = 13);
printf("setting mysqli->unknown, mysqli_unknown = '%s'\n", @$mysqli->unknown);
/**
* Run a SQL query
*
* @param string $sql
* @param string $file
* @param string $line
* @author Mauri Kujala <*****@*****.**>
*/
function run_sql($sql, $file, $line)
{
//write_log("Running query: " . $sql, $file, $line);
$this->link->query($sql) or write_log(mysqli_error($this->link), $file, $line);
$info = mysqli_info($this->link);
write_log($info, $file, $line);
}
/**
*
* @param string $sanitizedQueryText
* @return boolean|mysqli_result // FALSE (on failure), mysqli_result (for select,show,describe,explain), or TRUE (for other queries)
*/
public function query($sanitizedQueryText)
{
$wo = WOOOF::$instance;
$this->affectedRows = null;
$result = mysqli_query($this->connection, $sanitizedQueryText);
$this->affectedRows = mysqli_affected_rows($this->connection);
if ($this->error() != '') {
$debugInfo = debug_backtrace();
$lastLevel = count($debugInfo) - 1;
//$wo->log(WOOOF_loggingLevels::WOOOF_CRITICAL_ERROR,
// "Query Failed ! at ". $debugInfo[$lastLevel]['file'] ." on line ". $debugInfo[$lastLevel]['line'] ." Query text: \n\n$sanitizedQueryText\n\nMysql Error:". $this->error());
$wo->log(WOOOF_loggingLevels::WOOOF_CRITICAL_ERROR, self::_ECP . "0030 Mysql Error: " . $this->error());
if ($wo->getConfigurationFor('displayDatabaseErrors') && !$wo->isAjax) {
echo '<br><span style="font-size:14px;color:red;background-color:yellow;">' . nl2br("Query Failed ! at " . $debugInfo[0]['file'] . " on line " . $debugInfo[0]['line'] . "</font> Query text: \n\n{$sanitizedQueryText}\n\nMysql Error:" . $this->error() . "\n" . '</span><br>');
}
return FALSE;
}
$this->lastQueryInfo = mysqli_info($this->connection);
if (!$this->lastQueryInfo && $result !== TRUE) {
if (@mysqli_num_rows($result)) {
$this->lastQueryInfo = "Returned Rows: " . mysqli_affected_rows($this->connection);
} elseif (mysqli_affected_rows($this->connection)) {
$this->lastQueryInfo = "Affected Rows: " . mysqli_affected_rows($this->connection);
}
}
$displaySqlLevel = $wo->getConfigurationFor('displaySQLStatementsLevel');
if (!($displaySqlLevel == 0 || $displaySqlLevel == 1 && strpos($sanitizedQueryText, '__') !== FALSE)) {
echo $sanitizedQueryText . PHP_EOL . '<br/>';
}
//always call logging, better safe than sorry
$this->logQuery($sanitizedQueryText);
return $result;
}
function mysql_compat_info($link = NULL)
{
if (!isset($link)) {
$link = $GLOBALS['mysql_compat_last_link'];
}
return mysqli_info($link);
}
function mysql_info($link = NULL)
{
$link = mysql_resolve_link($link);
return mysqli_info($link);
}
function mysql_info($link_identifier = null)
{
return mysqli_info(mysql_ensure_link($link_identifier));
}
function mysql_info(\mysqli $link = null)
{
return mysqli_info(\Dshafik\MySQL::getConnection($link));
}
function mysql_info($c = null)
{
if (($c = mysql_global_resource($c, 1 - func_num_args())) == null) {
return;
}
return mysqli_info($c);
}
/**
* Retrieves information about the most recently executed query.
* @return array
*/
public function getInfo()
{
$res = array();
preg_match_all('#(.+?): +(\\d+) *#', mysqli_info($this->connection), $matches, PREG_SET_ORDER);
foreach ($matches as $m) {
$res[$m[1]] = (int) $m[2];
}
return $res;
}
echo mysqli_info($con); echo mysqli_error($con); echo "Création de la table questions."; mysqli_query($con, $qTbQst); echo mysqli_info($con); echo mysqli_error($con); echo "Création de la table reponses."; mysqli_query($con, $qTbRps); echo mysqli_info($con); echo mysqli_error($con); echo "Création de la table votes."; mysqli_query($con, $qTbVot); echo mysqli_info($con); echo mysqli_error($con); echo "Création de Hello1."; mysqli_query($con, $qInitTbHello1); echo mysqli_info($con); echo mysqli_error($con); echo "Création de Hello2."; mysqli_query($con, $qInitTbHello2); echo mysqli_info($con); echo mysqli_error($con); echo "Création du Vote."; mysqli_query($con, $qInitTbVote); echo mysqli_info($con); echo mysqli_error($con); echo "Mise à jour réponse."; mysqli_query($con, $qInitTbVote1); echo mysqli_info($con); echo mysqli_error($con); mysqli_close($con);
/**
* read query info and analyse it and return array contain result
* @return [type] [description]
*/
public static function qry_info($_needle = null)
{
preg_match_all('/(\\S[^:]+): (\\d+)/', mysqli_info(self::$link), $matches);
$info = array_combine($matches[1], $matches[2]);
if ($_needle && isset($info[$_needle])) {
$info = $info[$_needle];
}
return $info;
}
// NOTE: no LOAD DATA INFILE test_mysqli_info_table_1
if ($dir = sys_get_temp_dir()) {
do {
$file = $dir . '/' . 'mysqli_info_phpt.cvs';
if (!($fp = fopen($file, 'w'))) {
/* ignore this error */
break;
}
if (!fwrite($fp, "100;'a';\n") || !fwrite($fp, "101;'b';\n") || !fwrite($fp, "102;'c';\n")) {
@unlink($file);
break;
}
fclose($fp);
if (!mysqli_query($link, "DELETE FROM test_mysqli_info_table_1")) {
printf("[015] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
break;
}
if (!@mysqli_query($link, sprintf("LOAD DATA LOCAL INFILE '%s' INTO TABLE test_mysqli_info_table_1 FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\\'' LINES TERMINATED BY '\n'", $file))) {
/* ok, because we might not be allowed to do this */
@unlink($file);
break;
}
if (!is_string($tmp = mysqli_info($link)) || '' == $tmp) {
printf("[016] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp);
}
unlink($file);
} while (false);
}
print "done!";
$test_table_name = 'test_mysqli_info_table_1';
require_once "clean_table.inc";
FlushPackets();
break 2;
} else {
if (!$result) {
$Packet = "";
$Packet .= PackLength(mysqli_affected_rows($mysqli));
$Packet .= PackLength(mysqli_insert_id($mysqli));
if ($MorePackets || mysqli_more_results($mysqli)) {
$Packet .= pack('v', 0x8);
} else {
$Packet .= pack('v', 0x0);
}
// Server Status
$Packet .= pack('v', mysqli_warning_count($mysqli));
if (version_compare(phpversion(), '4.3.0') >= 0 && mysqli_info($mysqli)) {
$Packet .= PackLength(strlen(mysqli_info($mysqli))) . mysqli_info($mysqli);
}
SendPacket($Packet);
FlushPackets();
} else {
$Packet = PackLength(mysqli_num_fields($result));
SendPacket($Packet);
while ($Field = mysqli_fetch_field($result)) {
$Packet = '';
if (!isset($Field->catalog)) {
$Packet .= "û";
} else {
$Packet .= PackLength(strlen($Field->catalog)) . $Field->catalog;
}
if (!isset($Field->db)) {
$Packet .= "û";
/**
* @param array $row
* @param string $table tablename
* @param array $exclude keys, which shall not be updated
* @return boolean
*/
protected function wsqlInsertSingleRow($row, $table, $exclude = array())
{
if (empty($row)) {
$this->logMe('empty row', 0);
return false;
}
if (!is_array($row)) {
$this->logMe('row is not an array (' . $row . ')', 0);
return false;
}
$fields = $values = $update = array();
if (!is_array($exclude)) {
$exclude = array($exclude);
}
foreach (array_keys($row) as $key) {
$fields[] = "`{$key}`";
$values[] = "'" . (isset($GLOBALS["___mysqli_ston"]) && is_object($GLOBALS["___mysqli_ston"]) ? mysqli_real_escape_string($GLOBALS["___mysqli_ston"], $row[$key]) : (trigger_error("[MySQLConverterToo] Fix the mysql_escape_string() call! This code does not work.", E_USER_ERROR) ? "" : "")) . "'";
if (!in_array($key, $exclude)) {
$update[] = "`{$key}` = '" . (isset($GLOBALS["___mysqli_ston"]) && is_object($GLOBALS["___mysqli_ston"]) ? mysqli_real_escape_string($GLOBALS["___mysqli_ston"], $row[$key]) : (trigger_error("[MySQLConverterToo] Fix the mysql_escape_string() call! This code does not work.", E_USER_ERROR) ? "" : "")) . "'";
}
}
$fields = implode(",", $fields);
$values = implode(",", $values);
$update = implode(",", $update);
$sql = "INSERT INTO `{$table}` ({$fields}) VALUES ({$values})\r\n ON DUPLICATE KEY UPDATE " . $update . "\r\n\t\t";
$result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
if ($result) {
$mysql_info = array("mysql_error" => false, "mysql_insert_id" => is_null($___mysqli_res = mysqli_insert_id($GLOBALS["___mysqli_ston"])) ? false : $___mysqli_res, "mysql_affected_rows" => mysqli_affected_rows($GLOBALS["___mysqli_ston"]), "mysql_info" => mysqli_info($GLOBALS["___mysqli_ston"]));
return $mysql_info;
} else {
$this->logMe('mysql error: ' . (is_object($GLOBALS["___mysqli_ston"]) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)) . ' sql: ' . $sql, 0);
return false;
}
}
DibiDriverException(mysqli_error($this->connection),mysqli_errno($this->connection),$sql);}elseif(is_object($res)){return$this->createResultDriver($res);}}function
getInfo(){$res=array();preg_match_all('#(.+?): +(\d+) *#',mysqli_info($this->connection),$matches,PREG_SET_ORDER);if(preg_last_error())throw
new
DibiPcreException;foreach($matches
as$m){$res[$m[1]]=(int)$m[2];}return$res;}function
/**
* Retrieves information about the most recently executed query.
* @return array
*/
public function getInfo()
{
$res = array();
preg_match_all('#(.+?): +(\\d+) *#', mysqli_info($this->connection), $matches, PREG_SET_ORDER);
if (preg_last_error()) {
throw new DibiPcreException();
}
foreach ($matches as $m) {
$res[$m[1]] = (int) $m[2];
}
return $res;
}
/**
* 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'));
}
