Annotation of embedaddon/php/ext/mysqli/tests/mysqli_real_escape_string_euckr.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: mysqli_real_escape_string() - euckr
! 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, 'euckr'))
! 18: die(sprintf("skip Cannot set charset 'euckr'"));
! 19: mysqli_close($link);
! 20: ?>
! 21: --FILE--
! 22: <?php
! 23: require_once("connect.inc");
! 24: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
! 25: {
! 26: printf("[001] Cannot connect to the server using host=%s, user=%s,
! 27: passwd=***, dbname=%s, port=%s, socket=%s - [%d] %s\n", $host, $user, $db,
! 28: $port, $socket, mysqli_connect_errno(), mysqli_connect_error());
! 29: }
! 30:
! 31: if (!mysqli_query($link, 'DROP TABLE IF EXISTS test')) {
! 32: printf("Failed to drop old test table: [%d] %s\n", mysqli_errno($link),
! 33: mysqli_error($link));
! 34: }
! 35:
! 36: if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY
! 37: KEY(id)) ENGINE=' . $engine . " DEFAULT CHARSET=euckr")) {
! 38: printf("Failed to create test table: [%d] %s\n", mysqli_errno($link),
! 39: mysqli_error($link));
! 40: }
! 41:
! 42: var_dump(mysqli_set_charset($link, "euckr"));
! 43:
! 44: if ('±Ç´ë¼º\\\\±Ç´ë¼º' !== ($tmp = mysqli_real_escape_string($link, '±Ç´ë¼º\\±Ç´ë¼º')))
! 45: printf("[004] Expecting \\\\, got %s\n", $tmp);
! 46:
! 47: if ('±Ç´ë¼º\"±Ç´ë¼º' !== ($tmp = mysqli_real_escape_string($link, '±Ç´ë¼º"±Ç´ë¼º')))
! 48: printf("[005] Expecting \", got %s\n", $tmp);
! 49:
! 50: if ("±Ç´ë¼º\'±Ç´ë¼º" !== ($tmp = mysqli_real_escape_string($link, "±Ç´ë¼º'±Ç´ë¼º")))
! 51: printf("[006] Expecting ', got %s\n", $tmp);
! 52:
! 53: if ("±Ç´ë¼º\\n±Ç´ë¼º" !== ($tmp = mysqli_real_escape_string($link, "±Ç´ë¼º\n±Ç´ë¼º")))
! 54: printf("[007] Expecting \\n, got %s\n", $tmp);
! 55:
! 56: if ("±Ç´ë¼º\\r±Ç´ë¼º" !== ($tmp = mysqli_real_escape_string($link, "±Ç´ë¼º\r±Ç´ë¼º")))
! 57: printf("[008] Expecting \\r, got %s\n", $tmp);
! 58:
! 59: if ("±Ç´ë¼º\\0±Ç´ë¼º" !== ($tmp = mysqli_real_escape_string($link, "±Ç´ë¼º" . chr(0) . "±Ç´ë¼º")))
! 60: printf("[009] Expecting %s, got %s\n", "±Ç´ë¼º\\0±Ç´ë¼º", $tmp);
! 61:
! 62: var_dump(mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, '±Ç')"));
! 63:
! 64: mysqli_close($link);
! 65: print "done!";
! 66: ?>
! 67: --CLEAN--
! 68: <?php
! 69: require_once("clean_table.inc");
! 70: ?>
! 71: --EXPECTF--
! 72: bool(true)
! 73: bool(true)
! 74: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>