mysqli_info.phpt

来自「linux下安装不上mysql5与php5的可用此关联」· PHPT 代码 · 共 53 行

--TEST--
mysqli_info()
--SKIPIF--
<?php require_once('skipif.inc'); ?>
<?php require_once('skipifemb.inc'); ?>
--FILE--
<?php
    include "connect.inc";
        
    if (!is_null($tmp = @mysqli_info()))
        printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        
    if (!is_null($tmp = @mysqli_info(NULL)))
        printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);        
    
    require "table.inc";
    if (!$res = mysqli_query($link, 'INSERT INTO test(id, label) VALUES (100, "a")'))
        printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        
    // NOTE: empty string, no multiple insert syntax
    if (!is_string($tmp = mysqli_info($link)))
        printf("[004] Expecting string/empty, got %s/%s\n", gettype($tmp), $tmp);
   
    if (!$res = mysqli_query($link, 'INSERT INTO test(id, label) VALUES (101, "a"), (102, "b")'))
        printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        
    if (!is_string($tmp = mysqli_info($link)) || ('' == $tmp))
        printf("[006] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp);       
        
    if (!$res = mysqli_query($link, 'INSERT INTO test(id, label) SELECT id + 200, label FROM test'))
        printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        
    if (!is_string($tmp = mysqli_info($link)) || ('' == $tmp))
        printf("[008] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp);
                
    if (!$res = mysqli_query($link, 'ALTER TABLE test MODIFY label CHAR(2)'))
        printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        
    if (!is_string($tmp = mysqli_info($link)) || ('' == $tmp))
        printf("[010] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp);               
    
    if (!$res = mysqli_query($link, 'UPDATE test SET label = "b" WHERE id >= 100'))
        printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        
    if (!is_string($tmp = mysqli_info($link)) || ('' == $tmp))
        printf("[012] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp);
        
    // NOTE: no LOAD DATA INFILE test        

    print "done!";
?>
--EXPECTF--
done!