public function close()
{
foreach (array(self::LINK_TYPE_SLAVE, self::LINK_TYPE_MASTER) as $type) {
if (array_key_exists($type, $this->links) && $this->links[$type] instanceof \mysqli) {
$tid = mysqli_thread_id($this->links[$type]);
if ($tid !== false) {
mysqli_kill($this->links[$type], $tid);
}
mysqli_close($this->links[$type]);
unset($this->links[$type]);
}
}
$this->links = array();
}
public function insertInto($table, $values)
{
if (is_array($values)) {
$str = "INSERT INTO `{$table}` VALUES (NULL,";
foreach ($values as $value) {
$str .= "'" . $value . "',";
}
$str = substr($str, 0, strlen($str) - 1);
$str .= ")";
$nc = $this->c();
$q = mysqli_query($nc, $str);
mysqli_kill($nc, mysqli_thread_id($nc));
mysqli_close($nc);
if ($q) {
return true;
} else {
return false;
}
} else {
return false;
}
}
}
if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) {
printf("[010] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
}
if (!mysqli_stmt_execute($stmt)) {
printf("[011] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
}
$id = NULL;
$label = NULL;
if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) {
printf("[012] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
}
if (true !== ($tmp = mysqli_stmt_fetch($stmt))) {
printf("[013] Expecting boolean/true, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
}
if (!mysqli_kill($link, mysqli_thread_id($link))) {
printf("[014] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
if (true !== ($tmp = mysqli_stmt_fetch($stmt))) {
printf("[015] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
}
mysqli_stmt_close($stmt);
if (NULL !== ($tmp = mysqli_stmt_fetch($stmt))) {
printf("[016] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
}
mysqli_close($link);
/* Check that the function alias exists. It's a deprecated function,
but we have not announce the removal so far, therefore we need to check for it */
if (!is_null($tmp = @mysqli_stmt_fetch())) {
printf("[017] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
}
<div id="boxlinks2">
<?php
include 'inc/boxlinks2.php';
?>
</div>
<div id="content2">
<h2><?php
echo nl2br($daten['titel_' . $lang]);
?>
</h2><br />
<?php
echo nl2br($daten[$lang]);
?>
</div><div id="nebennavigation"><div id="nebennavigationinnen"><?php
include 'inc/nebennavigation_' . $lang . '.php';
?>
</div> </div></div>
</div>
</body>
</html>
<?php
$thread_id = mysqli_thread_id($link);
mysqli_kill($link, $thread_id);
mysqli_close($link);
include "../scripts/db.php";
if (!isset($_SESSION["uid"], $_SESSION["user"])) {
exit("<div class='m_s_g'>Invalid Authentication<div>");
}
$uid = intval($_SESSION["uid"]);
if ($uid != 0 && isset($uid)) {
$con = new db();
$conc = $con->c();
$num = 0;
$subjres = mysqli_query($conc, "SELECT `id` FROM `msg_subj` WHERE `u1` = {$uid} OR `u2` = {$uid}");
if ($subjres) {
while ($sb = mysqli_fetch_array($subjres)) {
$msg = mysqli_query($conc, "SELECT `new`,`uid` FROM `msg` WHERE `new` = 1 AND `cid` = " . $sb[0] . " ORDER BY `id` DESC");
if ($msg) {
$ltv = mysqli_fetch_array($msg);
$numr = mysqli_num_rows($msg);
if ($numr > 0 && $ltv[1] != $uid) {
$num = $num + $numr;
}
}
}
}
$num = $num > 0 ? $num : "";
$subjres = NULL;
$sb = NULL;
echo $num;
$_SESSION["msg_num"] = $num;
}
mysqli_kill($conc, mysqli_thread_id($con->c()));
mysqli_close($con->c());
exit;
mysqli_query($link, "FOO");
mysqli_change_user($link, "0123456789-10-456789-20-456789-30-456789-40-456789-50-456789-60-456789-70-456789-80-456789-90-456789", "password", $db);
mysqli_kill($link, -1);
// mysqli_ping() cannot be tested, because one would need to cause an error inside the C function to test it
mysqli_real_query($link, "FOO");
if (@mysqli_select_db($link, "Oh lord, let this be an unknown database name")) {
printf("[009] select_db should have failed\n");
}
// mysqli_store_result() and mysqli_use_result() cannot be tested, because one would need to cause an error inside the C function to test it
// Check that none of the above would have caused any error messages if MYSQL_REPORT_ERROR would
// not have been set. If that would be the case, the test would be broken.
mysqli_report(MYSQLI_REPORT_OFF);
mysqli_multi_query($link, "BAR; FOO;");
mysqli_query($link, "FOO");
mysqli_change_user($link, "This might work if you accept anonymous users in your setup", "password", $db);
mysqli_kill($link, -1);
mysqli_real_query($link, "FOO");
mysqli_select_db($link, "Oh lord, let this be an unknown database name");
mysqli_report(MYSQLI_REPORT_OFF);
mysqli_report(MYSQLI_REPORT_STRICT);
try {
if ($link = my_mysqli_connect($host, $user . 'unknown_really', $passwd . 'non_empty', $db, $port, $socket)) {
printf("[010] Can connect to the server using host=%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n", $host, $user . 'unknown_really', $db, $port, $socket);
}
mysqli_close($link);
} catch (mysqli_sql_exception $e) {
printf("[011] %s\n", $e->getMessage());
}
try {
if (!($link = mysqli_init())) {
printf("[012] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
public function close_db_con($nc)
{
mysqli_kill($nc, mysqli_thread_id($nc));
return mysqli_close($nc);
}
} else {
if (mysqli_errno($mysqli) > 0) {
printf("[015] %d/%s\n", mysqli_errno($mysqli), mysqli_error($mysqli));
}
}
$processed++;
}
if (microtime(true) - $begin > 5) {
printf("[016] Pulling the emergency break after 5s, something is wrong...\n");
break;
}
} while ($processed < 2);
// Killing connection - 3
$link = get_connection();
$thread_id = mysqli_thread_id($link);
mysqli_kill(get_connection(), $thread_id);
// Sleep 0.1s to ensure the KILL gets recognized
usleep(100000);
if (false !== ($tmp = mysqli_query($link, "SELECT 1 AS 'processed before killed'", MYSQLI_ASYNC | MYSQLI_USE_RESULT))) {
printf("[017] Expecting boolean/false got %s/%s\n", gettype($tmp), var_export($tmp, true));
}
$links = array($link);
$errors = array($link);
$reject = array($link);
if (0 !== ($tmp = mysqli_poll($links, $errors, $reject, 0, 10000))) {
printf("[018] Expecting int/0 got %s/%s\n", gettype($tmp), var_export($tmp, true));
}
if (!is_array($links) || empty($links)) {
printf("[019] Expecting non-empty array got %s/%s\n", gettype($links), var_export($links, true));
} else {
foreach ($links as $link) {
public function Clsoe()
{
$thread_id = mysqli_thread_id($this->con);
mysqli_kill($this->con, $thread_id);
}
