PHP my_mysqli_connect函数代码示例

 public function connect()
 {
     require_once "connect.inc";
     $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
     var_dump($link);
     $link = mysqli_init();
     /* @ is to suppress 'Property access is not allowed yet' */
     @var_dump($link);
     $mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
     $mysql->query("DROP TABLE IF EXISTS test_bug34810_table_1");
     $mysql->query("CREATE TABLE test_bug34810_table_1 (a int not null)");
     $mysql->query("SET sql_mode=''");
     $mysql->query("INSERT INTO test_bug34810_table_1 VALUES (1),(2),(NULL)");
     $warning = $mysql->get_warnings();
     if (!$warning) {
         printf("[001] No warning!\n");
     }
     if ($warning->errno == 1048 || $warning->errno == 1253) {
         /* 1048 - Column 'a' cannot be null, 1263 - Data truncated; NULL supplied to NOT NULL column 'a' at row */
         if ("HY000" != $warning->sqlstate) {
             printf("[003] Wrong sql state code: %s\n", $warning->sqlstate);
         }
         if ("" == $warning->message) {
             printf("[004] Message string must not be empty\n");
         }
     } else {
         printf("[002] Empty error message!\n");
         var_dump($warning);
     }
 }

function get_connection()
{
    global $host, $user, $passwd, $db, $port, $socket;
    if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) {
        printf("[001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
    }
    return $link;
}

<?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_037_table_1");
mysqli_query($link, "CREATE TABLE test_037_table_1 (a int, b varchar(10)) ENGINE = " . $engine);
mysqli_query($link, "INSERT INTO test_037_table_1 VALUES (1, 'foo')");
$ir[] = mysqli_field_count($link);
mysqli_real_query($link, "SELECT * FROM test_037_table_1");
$ir[] = mysqli_field_count($link);
var_dump($ir);
mysqli_query($link, "DROP TABLE IF EXISTS test_037_table_1");
mysqli_close($link);
print "done!";
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_037_table_1")) {
    printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
mysqli_close($link);

<?php

require_once "connect.inc";
if (!($link = my_mysqli_connect($host, 'shatest', 'shatest', $db, $port, $socket))) {
    printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, "shatest", $db, $port, $socket);
} else {
    if (!($res = $link->query("SELECT id FROM test WHERE id = 1"))) {
        printf("[002] [%d] %s\n", $link->errno, $link->error);
    }
    if (!($row = mysqli_fetch_assoc($res))) {
        printf("[003] [%d] %s\n", $link->errno, $link->error);
    }
    if ($row['id'] != 1) {
        printf("[004] Expecting 1 got %s/'%s'", gettype($row['id']), $row['id']);
    }
    $res->close();
    $link->close();
}
print "done!";
$test_table_name = 'test_mysqli_pam_sha256_table_1';
require_once "clean_table.inc";
$link->query('DROP USER shatest');
$link->query('DROP USER shatest@localhost');

if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) {
    printf("[005] Cannot connect [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
} else {
    $link->query("SELECT id FROM test WHERE id = 1");
    printf("[006] Connect allowed, query fail, [%d] %s\n", $link->errno, $link->error);
    $link->close();
}
/* allow connect, fix pw */
$link = mysqli_init();
$link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 1);
if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) {
    printf("[007] Cannot connect [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
} else {
    $link->query("SET PASSWORD=PASSWORD('expiretest')");
    printf("[008] Connect allowed, pw set, [%d] %s\n", $link->errno, $link->error);
    if ($res = $link->query("SELECT id FROM test WHERE id = 1")) {
        var_dump($res->fetch_assoc());
    }
    $link->close();
}
/* check login */
if (!($link = my_mysqli_connect($host, 'expiretest', "expiretest", $db, $port, $socket))) {
    printf("[001] Cannot connect [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
} else {
    $link->query("SELECT id FROM test WHERE id = 1");
    if ($res = $link->query("SELECT id FROM test WHERE id = 1")) {
        var_dump($res->fetch_assoc());
    }
    $link->close();
}
print "done!";

<?php

require_once "connect.inc";
$test = "";
/*** test mysqli_connect localhost:port ***/
$link = my_mysqli_connect($host, $user, $passwd, "", $port, $socket);
$test .= $link ? "1" : "0";
mysqli_close($link);
/*** test mysqli_real_connect ***/
$link = mysqli_init();
$test .= my_mysqli_real_connect($link, $host, $user, $passwd, "", $port, $socket) ? "1" : "0";
mysqli_close($link);
/*** test mysqli_real_connect with db ***/
$link = mysqli_init();
$test .= my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket) ? "1" : "0";
mysqli_close($link);
/*** test mysqli_real_connect with port ***/
$link = mysqli_init();
$test .= my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket) ? "1" : "0";
mysqli_close($link);
/* temporary addition for Kent's setup, Win32 box */
for ($i = 0; $i < 10; $i++) {
    if (!($link = mysqli_init())) {
        printf("[001 + %d] mysqli_init() failed, [%d] %s\n", $i, mysqli_connect_errno(), mysqli_connect_error());
    }
    if (!my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket)) {
        printf("[002 + %d] mysqli_real_connect() failed, [%d] %s\n", $i, mysqli_connect_errno(), mysqli_connect_error());
    }
    mysqli_close($link);
}
/*** test mysqli_real_connect compressed ***/

<?php

require_once "connect.inc";
$mysqli = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
$result = $mysqli->query('select 1');
$result->close();
echo $result->num_rows;
$mysqli->close();
echo $result->num_rows;
echo "Done\n";

    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());
    }
    if ($link = my_mysqli_real_connect($link, $host, $user . 'unknown_really', $passwd . 'non_empty', $db, $port, $socket)) {
        printf("[013] 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) {

for ($i = 0; $i < $num; $i++) {
    if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) {
        printf("[004] Connect failed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
    }
    $connections[] = $link;
}
$left = $num;
while (count($connections) && $left > 0) {
    do {
        $index = mt_rand(0, $num);
    } while (!isset($connections[$index]) && $left > 0);
    if (mt_rand(0, 1) > 0) {
        $left--;
        mysqli_close($connections[$index]);
        unset($connections[$index]);
    } else {
        $left--;
        if (!($connections[$index] = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) {
            printf("[004] Connect failed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
        }
    }
    flush();
}
while (count($connections)) {
    do {
        $index = mt_rand(0, $num);
    } while (!isset($connections[$index]));
    mysqli_close($connections[$index]);
    unset($connections[$index]);
}
print "done!";

<?php

include "connect.inc";
$link1 = my_mysqli_connect($host, $user, $passwd, null, $port, $socket);
mysqli_select_db($link1, $db);
$link1->query("SELECT 'test'", MYSQLI_ASYNC);
$all_links = array($link1);
$links = $errors = $reject = $all_links;
mysqli_poll($links, $errors, $reject, 1);
echo "links: ", sizeof($links), "\n";
echo "errors: ", sizeof($errors), "\n";
echo "reject: ", sizeof($reject), "\n";
echo "all_links: ", sizeof($all_links), "\n";
$link1->close();

}
if ($num_plinks_kill > $num_plinks) {
    printf("[011] Expecting Active Persistent Links < %d, got %d\n", $num_plinks, $num_plinks_kill);
}
if (!($plink = my_mysqli_connect('p:' . $host, 'pcontest', 'newpass', $db, $port, $socket))) {
    printf("[012] Cannot connect using the new password, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
}
if (!($res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1'))) {
    printf("[013] Cannot run query on persistent connection of second DB user, [%d] %s\n", mysqli_errno($plink), mysqli_error($plink));
}
if (!($row = mysqli_fetch_assoc($res))) {
    printf("[014] Cannot run fetch result, [%d] %s\n", mysqli_errno($plink), mysqli_error($plink));
}
mysqli_free_result($res);
var_dump($row);
if ($plink2 = my_mysqli_connect('p:' . $host, 'pcontest', 'newpass', $db, $port, $socket)) {
    printf("[015] Can open more persistent connections than allowed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
    var_dump(mysqli_get_links_stats());
}
ob_start();
phpinfo();
$phpinfo = strip_tags(ob_get_contents());
ob_end_clean();
$phpinfo = substr($phpinfo, stripos($phpinfo, 'MysqlI Support => enabled'), 500);
if (!preg_match('@Active Persistent Links\\s+=>\\s+(\\d+)@ismU', $phpinfo, $matches)) {
    printf("[016] Cannot get # of active persistent links from phpinfo()\n");
}
$num_plinks = $matches[1];
if ($num_plinks > (int) ini_get('mysqli.max_persistent')) {
    printf("[017] mysqli.max_persistent=%d allows %d open connections!\n", ini_get('mysqli.max_persistent'), $num_plinks);
}