1--TEST-- 2mysqli_real_escape_string() - gbk 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifconnectfailure.inc'); 7require_once('connect.inc'); 8 9if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 10 die(sprintf("skip Cannot connect to MySQL, [%d] %s\n", 11 mysqli_connect_errno(), mysqli_connect_error())); 12} 13if (!mysqli_set_charset($link, 'gbk')) 14 die(sprintf("skip Cannot set charset 'gbk'")); 15 16mysqli_close($link); 17?> 18--FILE-- 19<?php 20 21 require_once("connect.inc"); 22 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 23{ 24 printf("[001] Cannot connect to the server using host=%s, user=%s, 25passwd=***, dbname=%s, port=%s, socket=%s - [%d] %s\n", $host, $user, $db, 26$port, $socket, mysqli_connect_errno(), mysqli_connect_error()); 27 } 28 29 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test')) { 30 printf("Failed to drop old test table: [%d] %s\n", mysqli_errno($link), 31mysqli_error($link)); 32 } 33 34 if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(3), PRIMARY 35KEY(id)) ENGINE=' . $engine . " DEFAULT CHARSET=gbk")) { 36 printf("Failed to create test table: [%d] %s\n", mysqli_errno($link), 37mysqli_error($link)); 38 } 39 40 var_dump(mysqli_set_charset($link, "gbk")); 41 42 if ('�İ汾\\\\�İ汾' !== ($tmp = mysqli_real_escape_string($link, '�İ汾\\�İ汾'))) 43 printf("[004] Expecting \\\\, got %s\n", $tmp); 44 45 if ('�İ汾\"�İ汾' !== ($tmp = mysqli_real_escape_string($link, '�İ汾"�İ汾'))) 46 printf("[005] Expecting \", got %s\n", $tmp); 47 48 if ("�İ汾\'�İ汾" !== ($tmp = mysqli_real_escape_string($link, "�İ汾'�İ汾"))) 49 printf("[006] Expecting ', got %s\n", $tmp); 50 51 if ("�İ汾\\n�İ汾" !== ($tmp = mysqli_real_escape_string($link, "�İ汾\n�İ汾"))) 52 printf("[007] Expecting \\n, got %s\n", $tmp); 53 54 if ("�İ汾\\r�İ汾" !== ($tmp = mysqli_real_escape_string($link, "�İ汾\r�İ汾"))) 55 printf("[008] Expecting \\r, got %s\n", $tmp); 56 57 if ("�İ汾\\0�İ汾" !== ($tmp = mysqli_real_escape_string($link, "�İ汾" . chr(0) . "�İ汾"))) 58 printf("[009] Expecting %s, got %s\n", "�İ汾\\0�İ汾", $tmp); 59 60 var_dump(mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, '��')")); 61 62 mysqli_close($link); 63 print "done!"; 64?> 65--CLEAN-- 66<?php 67 require_once("clean_table.inc"); 68?> 69--EXPECT-- 70bool(true) 71bool(true) 72done! 73