jQuery Grid Plugin - jqGrid - Topic: Advanced Search: Works on WAMP failed on LAMP after small change http://www.trirand.com/blog/?page_id=393/help/advanced-search-works-on-wamp-failed-on-lamp-after-small-change Simple:Press Version 5.7.5.3 davykiash on Advanced Search: Works on WAMP failed on LAMP after small change http://www.trirand.com/blog/?page_id=393/help/advanced-search-works-on-wamp-failed-on-lamp-after-small-change#p18216 Help http://www.trirand.com/blog/?page_id=393/help/advanced-search-works-on-wamp-failed-on-lamp-after-small-change#p18216 Hi

I changed the following piece of code in search_adv.

From

//mysql_real_escape_string is better
            if($oper=='bw' || $oper=='bn') return "'" . addslashes($val) . "%'";
            else if ($oper=='ew' || $oper=='en') return "'%" . addcslashes($val) . "'";
            else if ($oper=='cn' || $oper=='nc') return "'%" . addslashes($val) . "%'";
            else return "'" . addslashes($val) . "'";

to

//mysql_real_escape_string is better
            if($oper=='bw' || $oper=='bn') return "'" . mysql_real_escape_string($val) . "%'";
            else if ($oper=='ew' || $oper=='en') return "'%" . mysql_real_escape_string($val) . "'";
            else if ($oper=='cn' || $oper=='nc') return "'%" . mysql_real_escape_string($val) . "%'";
            else return "'" . mysql_real_escape_string($val) . "'";

 It worked as expected on my windows machine. However when I staged in on a linux environment the Advanced Search failed to work as expected.

What is it with the mysql_real_escape_string that am missing on my LAMP environment that is in my WAMP.

I have tried figuring this out all day.

Thanks

]]> Sat, 26 Jun 2010 10:07:26 +0300