1--TEST-- 2mysqli_real_escape_string() - big5 3--SKIPIF-- 4<?php 5if (ini_get('unicode.semantics')) 6 die("skip Test cannot be run in unicode mode"); 7 8require_once('skipif.inc'); 9require_once('skipifemb.inc'); 10require_once('skipifconnectfailure.inc'); 11require_once('connect.inc'); 12 13if (!$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} 17if (!mysqli_set_charset($link, 'big5')) 18 die(sprintf("skip Cannot set charset 'big5'")); 19mysqli_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, 28passwd=***, 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), 34mysqli_error($link)); 35 } 36 37 if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY 38KEY(id)) ENGINE=' . $engine . " DEFAULT CHARSET=big5")) { 39 printf("Failed to create test table: [%d] %s\n", mysqli_errno($link), 40mysqli_error($link)); 41 } 42 43 var_dump(mysqli_set_charset($link, "big5")); 44 45 if ('���H�U���e\\\\���H�U���e' !== ($tmp = mysqli_real_escape_string($link, 46'���H�U���e\\���H�U���e'))) 47 printf("[004] Expecting \\\\, got %s\n", $tmp); 48 49 if ('���H�U���e\"���H�U���e' !== ($tmp = mysqli_real_escape_string($link, 50'���H�U���e"���H�U���e'))) 51 printf("[005] Expecting \", got %s\n", $tmp); 52 53 if ("���H�U���e\'���H�U���e" !== ($tmp = mysqli_real_escape_string($link, 54"���H�U���e'���H�U���e"))) 55 printf("[006] Expecting ', got %s\n", $tmp); 56 57 if ("���H�U���e\\n���H�U���e" !== ($tmp = mysqli_real_escape_string($link, 58"���H�U���e\n���H�U���e"))) 59 printf("[007] Expecting \\n, got %s\n", $tmp); 60 61 if ("���H�U���e\\r���H�U���e" !== ($tmp = mysqli_real_escape_string($link, 62"���H�U���e\r���H�U���e"))) 63 printf("[008] Expecting \\r, got %s\n", $tmp); 64 65 if ("���H�U���e\\0���H�U���e" !== ($tmp = mysqli_real_escape_string($link, "���H�U���e" 66. chr(0) . "���H�U���e"))) 67 printf("[009] Expecting %s, got %s\n", "���H�U���e\\0���H�U���e", $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-- 80bool(true) 81bool(true) 82done! 83