Forum
November 2nd, 2014
A
A
A
Topic RSS
Offline
1
Log In
Home
The forums are currently locked and only available for read only access
Topic RSS
Advanced Search: Works on WAMP failed on LAMP after small change
26/06/2010
10:07
10:07
davykiash
Member
Members
Forum Posts: 6
Member Since:
05/02/2010
05/02/2010
Offline
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) . "'";
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) . "'";
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
Forum Timezone: Europe/Sofia
Most Users Ever Online: 715
Currently Online:
48 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66
