Return to mysqli_real_escape_string_gb2312.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysqli / tests

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

1.1       misho       1: --TEST--
                      2: mysqli_real_escape_string() - gb2312
                      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, 'gb2312'))
                     18:        die(sprintf("skip Cannot set charset 'gb2312'"));
                     19: mysqli_close($link);
                     20: ?>
                     21: --FILE--
                     22: <?php
                     23: 
                     24:        require_once("connect.inc");
                     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=gb2312")) {
                     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, "gb2312"));
                     44: 
                     45:        if ('首先\\\\首先' !== ($tmp = mysqli_real_escape_string($link, '首先\\首先')))
                     46:                printf("[004] Expecting \\\\, got %s\n", $tmp);
                     47: 
                     48:        if ('首先\"首先' !== ($tmp = mysqli_real_escape_string($link, '首先"首先')))
                     49:                printf("[005] Expecting \", got %s\n", $tmp);
                     50: 
                     51:        if ("首先\'首先" !== ($tmp = mysqli_real_escape_string($link, "首先'首先")))
                     52:                printf("[006] Expecting ', got %s\n", $tmp);
                     53: 
                     54:        if ("首先\\n首先" !== ($tmp = mysqli_real_escape_string($link, "首先\n首先")))
                     55:                printf("[007] Expecting \\n, got %s\n", $tmp);
                     56: 
                     57:        if ("首先\\r首先" !== ($tmp = mysqli_real_escape_string($link, "首先\r首先")))
                     58:                printf("[008] Expecting \\r, got %s\n", $tmp);
                     59: 
                     60:        if ("首先\\0首先" !== ($tmp = mysqli_real_escape_string($link, "首先" . chr(0) . "首先")))
                     61:                printf("[009] Expecting %s, got %s\n", "首先\\0首先", $tmp);
                     62: 
                     63:        var_dump(mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, '首')"));
                     64: 
                     65:        mysqli_close($link);
                     66:        print "done!";
                     67: ?>
                     68: --CLEAN--
                     69: <?php
                     70:        require_once("clean_table.inc");
                     71: ?>
                     72: --EXPECTF--
                     73: bool(true)
                     74: bool(true)
                     75: done!