Annotation of embedaddon/php/ext/mysqli/tests/mysqli_real_escape_string_euckr.phpt, revision 1.1.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>