1--TEST-- 2mysqli_real_escape_string() - sjis 3--EXTENSIONS-- 4mysqli 5--SKIPIF-- 6<?php 7require_once 'skipifconnectfailure.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, 'sjis')) 14 die(sprintf("skip Cannot set charset 'sjis'")); 15mysqli_close($link); 16?> 17--FILE-- 18<?php 19 require_once 'table.inc'; 20 21 var_dump(mysqli_set_charset($link, "sjis")); 22 23 if ('?p??\\\\?p??' !== ($tmp = mysqli_real_escape_string($link, '?p??\\?p??'))) 24 printf("[004] Expecting \\\\, got %s\n", $tmp); 25 26 if ('?p??\"?p??' !== ($tmp = mysqli_real_escape_string($link, '?p??"?p??'))) 27 printf("[005] Expecting \", got %s\n", $tmp); 28 29 if ("?p??\'?p??" !== ($tmp = mysqli_real_escape_string($link, "?p??'?p??"))) 30 printf("[006] Expecting ', got %s\n", $tmp); 31 32 if ("?p??\\n?p??" !== ($tmp = mysqli_real_escape_string($link, "?p??\n?p??"))) 33 printf("[007] Expecting \\n, got %s\n", $tmp); 34 35 if ("?p??\\r?p??" !== ($tmp = mysqli_real_escape_string($link, "?p??\r?p??"))) 36 printf("[008] Expecting \\r, got %s\n", $tmp); 37 38 if ("?p??\\0?p??" !== ($tmp = mysqli_real_escape_string($link, "?p??" . chr(0) . "?p??"))) 39 printf("[009] Expecting %s, got %s\n", "?p??\\0?p??", $tmp); 40 41 var_dump(mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, '?p')")); 42 43 mysqli_close($link); 44 print "done!"; 45?> 46--EXPECT-- 47bool(true) 48bool(true) 49done! 50