Annotation of embedaddon/php/ext/mysqli/tests/mysqli_real_escape_string_big5.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: mysqli_real_escape_string() - big5
                      3: --SKIPIF--
                      4: <?php
                      5: if (ini_get('unicode.semantics'))
                      6:        die("skip Test cannot be run in unicode mode");
                      7: 
                      8: require_once('skipif.inc');
                      9: require_once('skipifemb.inc');
                     10: require_once('skipifconnectfailure.inc');
                     11: require_once('connect.inc');
                     12: 
                     13: if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
                     14:        die(sprintf("skip Cannot connect to MySQL, [%d] %s\n",
                     15:                mysqli_connect_errno(), mysqli_connect_error()));
                     16: }
                     17: if (!mysqli_set_charset($link, 'big5'))
                     18:        die(sprintf("skip Cannot set charset 'big5'"));
                     19: mysqli_close($link);
                     20: ?>
                     21: --FILE--
                     22: <?php
                     23:        require_once("connect.inc");
                     24: 
                     25:        if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
                     26: {
                     27:                printf("[001] Cannot connect to the server using host=%s, user=%s,
                     28: passwd=***, dbname=%s, port=%s, socket=%s - [%d] %s\n", $host, $user, $db,
                     29: $port, $socket, mysqli_connect_errno(), mysqli_connect_error());
                     30:        }
                     31: 
                     32:        if (!mysqli_query($link, 'DROP TABLE IF EXISTS test')) {
                     33:                printf("Failed to drop old test table: [%d] %s\n", mysqli_errno($link),
                     34: mysqli_error($link));
                     35:        }
                     36: 
                     37:        if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY
                     38: KEY(id)) ENGINE=' . $engine . " DEFAULT CHARSET=big5")) {
                     39:                printf("Failed to create test table: [%d] %s\n", mysqli_errno($link),
                     40: mysqli_error($link));
                     41:        }
                     42: 
                     43:        var_dump(mysqli_set_charset($link, "big5"));
                     44: 
                     45:        if ('找到以下內容\\\\找到以下內容' !== ($tmp = mysqli_real_escape_string($link,
                     46: '找到以下內容\\找到以下內容')))
                     47:                printf("[004] Expecting \\\\, got %s\n", $tmp);
                     48: 
                     49:        if ('找到以下內容\"找到以下內容' !== ($tmp = mysqli_real_escape_string($link,
                     50: '找到以下內容"找到以下內容')))
                     51:                printf("[005] Expecting \", got %s\n", $tmp);
                     52: 
                     53:        if ("找到以下內容\'找到以下內容" !== ($tmp = mysqli_real_escape_string($link,
                     54: "找到以下內容'找到以下內容")))
                     55:                printf("[006] Expecting ', got %s\n", $tmp);
                     56: 
                     57:        if ("找到以下內容\\n找到以下內容" !== ($tmp = mysqli_real_escape_string($link,
                     58: "找到以下內容\n找到以下內容")))
                     59:                printf("[007] Expecting \\n, got %s\n", $tmp);
                     60: 
                     61:        if ("找到以下內容\\r找到以下內容" !== ($tmp = mysqli_real_escape_string($link,
                     62: "找到以下內容\r找到以下內容")))
                     63:                printf("[008] Expecting \\r, got %s\n", $tmp);
                     64: 
                     65:        if ("找到以下內容\\0找到以下內容" !== ($tmp = mysqli_real_escape_string($link, "找到以下內容"
                     66: . chr(0) . "找到以下內容")))
                     67:                printf("[009] Expecting %s, got %s\n", "找到以下內容\\0找到以下內容", $tmp);
                     68: 
                     69:        var_dump(mysqli_query($link, "INSERT INTO test(id, label) VALUES (100,
                     70: '找')"));
                     71: 
                     72:        mysqli_close($link);
                     73:        print "done!";
                     74: ?>
                     75: --CLEAN--
                     76: <?php
                     77:        require_once("clean_table.inc");
                     78: ?>
                     79: --EXPECTF--
                     80: bool(true)
                     81: bool(true)
                     82: done!

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>