Return to mysqli_real_escape_string_nobackslash.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_nobackslash.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: mysqli_real_escape_string() - SQL Mode NO_BACKSLASH_ESCAPE
        !             3: --SKIPIF--
        !             4: <?php
        !             5: require_once('skipif.inc');
        !             6: require_once('skipifemb.inc');
        !             7: require_once('skipifconnectfailure.inc');
        !             8: ?>
        !             9: --FILE--
        !            10: <?php
        !            11:        require_once("connect.inc");
        !            12:        require_once('table.inc');
        !            13: 
        !            14:        if (!mysqli_query($link, 'SET @@sql_mode="NO_BACKSLASH_ESCAPES"'))
        !            15:                printf("[001] Cannot set NO_BACKSLASH_ESCAPES, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        !            16: 
        !            17:        if ('\\' !== ($tmp = mysqli_real_escape_string($link, '\\')))
        !            18:                printf("[002] Expecting \\, got %s\n", $tmp);
        !            19: 
        !            20:        if ('"' !== ($tmp = mysqli_real_escape_string($link, '"')))
        !            21:                printf("[003] Expecting \", got %s\n", $tmp);
        !            22: 
        !            23:        if ("''" !== ($tmp = mysqli_real_escape_string($link, "'")))
        !            24:                printf("[004] Expecting '', got %s\n", $tmp);
        !            25: 
        !            26:        if ("\n" !== ($tmp = mysqli_real_escape_string($link, "\n")))
        !            27:                printf("[005] Expecting \\n, got %s\n", $tmp);
        !            28: 
        !            29:        if ("\r" !== ($tmp = mysqli_real_escape_string($link, "\r")))
        !            30:                printf("[006] Expecting \\r, got %s\n", $tmp);
        !            31: 
        !            32:        assert("foo" . chr(0) . "bar" === "foo" . chr(0) . "bar");
        !            33:        if ("foo" . chr(0) . "bar" !== ($tmp = mysqli_real_escape_string($link, "foo" . chr(0) . "bar")))
        !            34:                printf("[007] Expecting %s, got %s\n", "foo" . chr(0) . "bar", $tmp);
        !            35: 
        !            36:        if (!mysqli_query($link, sprintf('INSERT INTO test(id, label) VALUES (100, "%s")',
        !            37:                        mysqli_real_escape_string($link, "\\"))))
        !            38:                printf("[009] Cannot INSERT, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        !            39: 
        !            40:        if (!($res = mysqli_query($link, 'SELECT label FROM test WHERE id = 100')) ||
        !            41:                        !($row = mysqli_fetch_assoc($res)))
        !            42:                printf("[010] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        !            43: 
        !            44:        var_dump($row);
        !            45:        mysqli_free_result($res);
        !            46: 
        !            47:        if (!mysqli_query($link, 'SET @@sql_mode=""'))
        !            48:                printf("[011] Cannot disable NO_BACKSLASH_ESCAPES, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        !            49: 
        !            50:        if ('\\\\' !== ($tmp = mysqli_real_escape_string($link, '\\')))
        !            51:                printf("[012] Expecting \\, got %s\n", $tmp);
        !            52: 
        !            53:        if ("foo\\0bar" !== ($tmp = mysqli_real_escape_string($link, "foo" . chr(0) . "bar")))
        !            54:                printf("[013] Expecting %s, got %s\n", "foo" . chr(0) . "bar", $tmp);
        !            55: 
        !            56:        mysqli_close($link);
        !            57: 
        !            58:        print "done!";
        !            59: ?>
        !            60: --EXPECTF--
        !            61: array(1) {
        !            62:   [%u|b%"label"]=>
        !            63:   %unicode|string%(1) "\"
        !            64: }
        !            65: done!