CodeIgniter Forums
Parse single quotes in query - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Parse single quotes in query (/showthread.php?tid=34501)



Parse single quotes in query - El Forum - 10-01-2010

[eluser]Arun Joshi[/eluser]
Hi,

How to parse single quotes in query? (Normally I replace single quotes with two single quotes by using str_replace function. )
Is there any CI way to do this?

I tried
$this->input->xss_clean() and $this->db->escape() .
But its not working.

Thanks
Arun


Parse single quotes in query - El Forum - 10-01-2010

[eluser]n0xie[/eluser]
Did you try using active record?


Parse single quotes in query - El Forum - 10-01-2010

[eluser]Arun Joshi[/eluser]
am using $this->db->query("my query here");


Parse single quotes in query - El Forum - 10-01-2010

[eluser]shelton_dev_guy[/eluser]
Have you tried to escape each qoute?