mysqli_real_escape_string.phpt

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

--TEST--
mysqli_real_escape_string()
--SKIPIF--
<?php require_once('skipif.inc'); ?>
<?php require_once('skipifemb.inc'); ?>
--FILE--
<?php
    include "connect.inc";

    $dbname = 'test';    
    $tmp    = NULL;   
    $link   = NULL;    
    
    if (NULL !== ($tmp = @mysqli_real_escape_string()))
        printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        
    if (NULL !== ($tmp = @mysqli_real_escape_string($link)))
        printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);        
        
    require('table.inc');
    
    if (NULL !== ($tmp =@mysqli_real_escape_string($link, "foo", "foo")))
        printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
      
    if ('\\\\' !== ($tmp = mysqli_real_escape_string($link, '\\')))
        printf("[004] Expecting \\\\, got %s\n", $tmp);
        
    if ('\"' !== ($tmp = mysqli_real_escape_string($link, '"')))
        printf("[005] Expecting \", got %s\n", $tmp);        

    if ("\'" !== ($tmp = mysqli_real_escape_string($link, "'")))
        printf("[006] Expecting ', got %s\n", $tmp); 
        
    if ("\\n" !== ($tmp = mysqli_real_escape_string($link, "\n")))
        printf("[007] Expecting \\n, got %s\n", $tmp);                 
        
    if ("\\r" !== ($tmp = mysqli_real_escape_string($link, "\r")))
        printf("[008] Expecting \\r, got %s\n", $tmp);                 
        
    if ("foo\\0bar" !== ($tmp = mysqli_real_escape_string($link, "foo" . chr(0) . "bar")))
        printf("[009] Expecting %s, got %s\n", "foo\\0bar", $tmp);
        
    mysqli_close($link);
    
    if (NULL !== ($tmp = mysqli_real_escape_string($link, 'foo')))
        printf("[010] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        
    print "done!";
?>
--EXPECTF--
Warning: mysqli_real_escape_string(): Couldn't fetch mysqli in %s on line %d
done!