PHP mysqli_kill函数代码示例

 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);
 }