Test Build: CUBRID 2008 R4.1 (8.4.1.1018) (64bit release build for linux_gnu)
OS: Linux 64
Description:
After using cubrid_real_escape_string() method for the two single quotations , query value about two single quotations is one single quotations.
NO using this method for two single quotations, select query value about two single quotations is also one single quotations.
Would the select query value be two single quotations after using cubrid_real_escape_string() method for the two single quotations
Repro steps:
1. execute real_test2.phpt
statement in real_test2.phpt
{noformat}
$conn = cubrid_connect(localhost, 33113, demodb,dba,);
cubrid_execute($conn, DROP TABLE IF EXISTS cubrid_test);
cubrid_execute($conn, CREATE TABLE cubrid_test (id int, t varchar(20)));
$unescaped1='\\';
$escaped1=cubrid_real_escape_string($unescaped1,$conn);
cubrid_execute($conn, INSERT INTO cubrid_test (id,t) VALUES(1,'$escaped1'));
$req1 = cubrid_execute($conn, SELECT * FROM cubrid_test where id=1 );
while($row = cubrid_fetch_assoc($req1)){
var_dump($row);
}
cubrid_free_result($req1);
$unescaped2=\\;
cubrid_execute($conn, INSERT INTO cubrid_test (id,t) VALUES(2,'$unescaped2'));
$req2 = cubrid_execute($conn, SELECT * FROM cubrid_test where id=2 );
while($row = cubrid_fetch_assoc($req2)){
var_dump($row);
}
cubrid_free_result($req2);
cubrid_disconnect($conn);
printf(Finished!);
{noformat}
Actual result
array(2) {
[id]=
string(1) 1
[t]=
string(1) \
}
array(2) {
[id]=
string(1) 2
[t]=
string(1) \
}
Expect result
May be the select query value of using cubrid_fetch_assoc() method is difference from not using that method