Query with special character

Questions › Query with special character

Cedric asked 6 years ago

Hello,
I can not make this query work in phpgrig.
The query works fine when it’s called in a MySQL tool like SQLyog
http://rextester.com/LOV64823
With phpgrid it always returns the error right syntax to use near ”\nf_nt4 … I have tried several options but can’t make it work.
Do you have any tips to fix this?
Thanks,
Cedric

Question Tags: Query special character \

4 Answers

0 Vote Up Vote Down

Abu Ghufran Staff answered 6 years ago

There seems to be some limitation in escaping function of library.
One way to solve it is by escaping \ character again: e.g.
$g->select_command = str_replace(‘\\’,’\\\\’,$g->select_command);
This will skip the error. However when it comes to rendering, grid will remove \ character again as it assumes it as escaped character. To fix display edit lib/inc/jqgrid_dist.php and remove these lines:
foreach($row as $k=>$r)
$row[$k] = stripslashes($row[$k]);

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework

0 Vote Up Vote Down

Cedric answered 6 years ago

ok thanks for the tips. I will look in creating a view in Mysql to avoir editing your library.

0 Vote Up Vote Down

Cedric answered 6 years ago

Hello Abu,
I am still stuck with this.
Can you hekp me in fixing the escape characters?
This does not work:
$g->select_command = str_replace(‘\\’,’\\\\’,$g->select_command);
nor this
$g->select_command = str_replace(‘\\’,’\\\\’,$sql);

Thanks,
Cedric