PHP mysql_thread_id函数代码示例

 function getDBCon($force = 0)
 {
     if ($force || !isset($this->a['db_con'])) {
         if (!$this->createDBCon()) {
             return false;
         }
     }
     if (!$force && !@mysql_thread_id($this->a['db_con'])) {
         return $this->getDBCon(1);
     }
     return $this->a['db_con'];
 }

function sql_disconnect_slave()
{
    global $opt, $db;
    if ($db['dblink_slave'] === false) {
        return;
    }
    if ($opt['db']['pconnect'] == true && $db['dblink'] !== false) {
        if (count($db['temptables']) > 0) {
            foreach ($db['temptables'] as $k => $table) {
                if (isset($db['temptables_slave'][$table])) {
                    sqlf_slave("DROP TEMPORARY TABLE IF EXISTS &tmpdb.`&1`", $table);
                    unset($db['temptables_slave'][$table]);
                    unset($db['temptables'][$k]);
                }
            }
            if (count($db['temptables_slave']) > 0) {
                sqlf_slave("DELETE FROM &db.`sys_temptables` WHERE `threadid`='&1'", mysql_thread_id($db['dblink_slave']));
            }
            $db['temptables_slave'] = array();
        }
    }
    if ($db['dblink'] === $db['dblink_slave']) {
        $db['dblink_slave'] = false;
        return;
    }
    //is connected and no persistent connect used?
    if ($opt['db']['pconnect'] == false && $db['dblink_slave'] !== false) {
        mysql_close($db['dblink_slave']);
    }
    $db['dblink_slave'] = false;
}

function db_thread_id()
{
    return mysql_thread_id();
}

 /**
  * get thread id.
  * get the mysql thread id of the current connection
  * when one gets reconnected the threadid will be changed
  *
  * @access public
  * @return void
  */
 public function getThreadId()
 {
     if ($this->connect()) {
         return mysql_thread_id($this->_connection);
     }
     return null;
 }

}
echo "Explicit connection on close\n";
$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket);
$link1_thread_id = mysql_thread_id($link);
$default1_thread_id = mysql_thread_id();
echo 'Expect same thread id for $link and default conn: ';
var_dump($link1_thread_id == $default1_thread_id);
var_dump($link);
mysql_close($link);
var_dump($link);
// we sohuld have no default link anymore
mysql_close();
echo "\nClosing default link\n";
$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket);
$link2_thread_id = mysql_thread_id($link);
$default2_thread_id = mysql_thread_id();
echo 'Expect same thread id for $link and default conn but not the previous: ';
var_dump($link1_thread_id == $default1_thread_id && $link1_thread_id != $link2_thread_id);
var_dump($link);
mysql_close();
var_dump($link);
mysql_close($link);
var_dump($link);
echo "\nExplicit resource and pconnect\n";
$link = my_mysql_pconnect($host, $user, $passwd, $db, $port, $socket);
var_dump($link);
mysql_close($link);
var_dump($link);
// we sohuld have no default link
mysql_close();
echo "\nDefault link and pconnect\n";

<?php

require_once 'connect.inc';
$conn = mysql_connect($host, $user, $passwd);
var_dump(mysql_thread_id() > 0);

 function threadId()
 {
     /* 返回当前线程的 ID */
     return mysql_thread_id($this->LinkId);
 }

include "table.inc";
if ($socket) {
    $myhost = sprintf("%s:%s", $host, $socket);
} else {
    if ($port) {
        $myhost = sprintf("%s:%s", $host, $port);
    } else {
        $myhost = $host;
    }
}
if (!($plink = mysql_pconnect($myhost, $user, $passwd))) {
    printf("[001] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $myhost, $user, $db, $port, $socket);
}
mysql_select_db($db, $plink);
$pthread_id = mysql_thread_id($plink);
$thread_id = mysql_thread_id($link);
if (!($res = mysql_query("SHOW FULL PROCESSLIST", $link))) {
    printf("[002] Cannot get processlist, [%d] %s\n", mysql_errno($link), mysql_error($link));
}
$processlist = array();
while ($row = mysql_fetch_assoc($res)) {
    $processlist[$row['Id']] = $row;
}
mysql_free_result($res);
if (!isset($processlist[$thread_id])) {
    printf("[003] Cannot find regular connection thread in process list, [%d] %s\n", mysql_errno($link), mysql_error($link));
}
if (!isset($processlist[$pthread_id])) {
    printf("[004] Cannot find persistent connection thread in process list, [%d] %s\n", mysql_errno($link), mysql_error($link));
}
if (!mysql_query(sprintf("KILL %d", $pthread_id), $link)) {

 /**
  * stores query, filenames, errors in TradeBanqDb::queries and TradeBanqDb::errors
  * @param  string $query
  * @return void
  */
 private function end_query($query, $records = 0)
 {
     if ($this->enable_log) {
         $error = mysql_error();
         $this->queries[] = array('start' => date("Y-m-d H:i:s"), 'query' => $query, 'records' => $records, 'time' => microtime(true) - $this->start_time, 'error' => $error, 'connection' => $this->last_connection_used && $this->master_connection && mysql_thread_id($this->last_connection_used) == mysql_thread_id($this->master_connection) ? "master" : "slave");
     }
     $this->start_time = 0;
 }

 /**
  * Retrieve the current thread id
  *
  * @return	@e integer
  */
 public function getThreadId()
 {
     return mysql_thread_id($this->connection_id);
 }

    printf("FAILURE: [%d] %s\n", mysql_errno(), mysql_error());
} else {
    print "SUCCESS: connect\n";
}
if (!mysql_select_db($db, $con)) {
    printf("FAILURE: [%d] %s\n", mysql_errno($con), mysql_error($con));
}
$id_default = mysql_thread_id();
$id_con = mysql_thread_id($con);
if ($id_default != $id_con) {
    printf("FAILURE: Different values for default and specified connection\n");
}
if (!is_int($id_con)) {
    printf("FAILURE: Function should have returned an integer value, got %s value\n", gettype($id_con));
}
$id_con = mysql_thread_id($illegal_link_identifier);
if (!is_null($id_con)) {
    printf("FAILURE: Function should have returned a NULL value, got %s value\n", gettype($id_con));
}
if ($id_con !== NULL) {
    printf("FAILURE: Should return NULL because of illegal link identifier\n");
}
mysql_close($con);
?>
--EXPECT-EXT/MYSQL-OUTPUT--
SUCCESS: connect

--EXPECT-EXT/MYSQL-PHP-ERRORS--
--EXPECT-EXT/MYSQLI-OUTPUT--
SUCCESS: connect

 /**
  * Starts a timer which will kill the DB thread after $timeout seconds
  */
 function startTimer($timeout)
 {
     global $IP;
     if (function_exists('mysql_thread_id')) {
         # This will kill the query if it's still running after $timeout seconds.
         $tid = mysql_thread_id($this->mConn);
         exec("php {$IP}/includes/killthread.php {$timeout} {$tid} &>/dev/null &");
     }
 }

<?php

require_once "connect.inc";
require_once "table.inc";
if ($plink = my_mysql_connect($host, $user, $passwd, $db, $port, $socket, NULL, true)) {
    printf("[001] Can connect to the server.\n");
}
if (($res = mysql_query('SELECT id FROM test ORDER BY id ASC', $plink)) && ($row = mysql_fetch_assoc($res)) && mysql_free_result($res)) {
    printf("[002] Can fetch data using persistent connection! Data = '%s'\n", $row['id']);
}
$thread_id = mysql_thread_id($plink);
mysql_close($plink);
if (!($plink = my_mysql_connect($host, $user, $passwd, $db, $port, $socket, NULL, true))) {
    printf("[003] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error());
}
if (mysql_thread_id($plink) != $thread_id) {
    printf("[004] Looks like the second call to pconnect() did not give us the same connection.\n");
}
$thread_id = mysql_thread_id($plink);
mysql_close($plink);
if (!($plink = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))) {
    printf("[005] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error());
}
if (mysql_thread_id($plink) == $thread_id) {
    printf("[006] Looks like connect() did not return a new connection.\n");
}
print "done!";
require_once "clean_table.inc";

}
mysql_free_result($res);
var_dump($row);
// change the password for the second DB user and kill the persistent connection
if (!($res = mysql_query("SELECT CURRENT_USER() AS _user", $link))) {
    printf("[006] [%d] %s", mysql_errno($link), mysql_error($link));
}
$row = mysql_fetch_assoc($res);
mysql_free_result($res);
$host = substr($row['_user'], strrpos($row['_user'], "@") + 1, strlen($row['_user']));
$sql = sprintf('SET PASSWORD FOR pcontest@"%s" = PASSWORD("newpass")', mysql_real_escape_string($host, $link));
if (!mysql_query($sql, $link)) {
    printf("[007] Cannot change PW of second DB user, [%d] %s\n", mysql_errno($link), mysql_error($link));
}
// persistent connections cannot be closed but only be killed
$pthread_id = mysql_thread_id($plink);
if (!mysql_query(sprintf('KILL %d', $pthread_id), $link)) {
    printf("[008] Cannot KILL persistent connection of second DB user, [%d] %s\n", mysql_errno($link), mysql_error($link));
}
// give the server a second to really kill the thread
sleep(1);
if (!($res = mysql_query("SHOW FULL PROCESSLIST", $link))) {
    printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link));
}
$running_threads = array();
while ($row = mysql_fetch_assoc($res)) {
    $running_threads[$row['Id']] = $row;
}
mysql_free_result($res);
if (isset($running_threads[$pthread_id])) {
    printf("[010] Persistent connection has not been killed\n");

 /**
  * Test pconnect
  *
  * @return boolean
  */
 public function MySQL_Pconnect_Test()
 {
     // We need to make sure that the connection ids are the same
     $lastMySQLId = false;
     $lastOurId = false;
     for ($x = 0; $x <= 5; $x++) {
         // Connect
         $mysql = mysql_pconnect(TEST_HOST, TEST_USER, TEST_PASS);
         $ourDb = $this->_object->mysql_pconnect(TEST_HOST, TEST_USER, TEST_PASS);
         // Keep track of resource
         $this->_cached[] = $mysql;
         // Get thread ids
         $thisMySQLId = mysql_thread_id();
         $thisOurId = $this->_object->mysql_thread_id();
         // Get original ids if not set
         if ($lastMySQLId == false) {
             $lastMySQLId = $thisMySQLId;
             $lastOurId = $thisOurId;
         }
         // Keep checking that the ids are the same
         if ($thisMySQLId !== $lastMySQLId || $thisOurId !== $lastOurId) {
             return false;
         }
     }
     return true;
 }