Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

php mysql addslashes problem

Comment:

Hi all I am trying to write a search query to search my MYSQL database and it works perfectly except if the search string contains an apostrophe I have checked the database and the search terms are stored with slashes added eg can't is stored as can\'t Now no matter how I manipulate my query I cannot get results for those search terms that contain apostrophes, it just returns "no products found" the query I use is 'select * from product where prod_search_term like "%'.$keyw.'%"' I have tried adding slashes to the $keyw variable but that doesn't make a difference Any help would be appreciated

Reply:

No worries fixed it used the below $keyw = str_replace("\'", "\\\\'", $keyw); $keyw = addslashes($keyw); I think my server may have had magic quotes on

0

Java - Order of files in ...

IE message

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I'm new to both PHP and MySQL. I've created a simple web database where users can store specific information for different contacts. Of this information that a user can submit is: Desk phonenumber, ho...

Summary: hi, i'm just starting to learn PHP/MySQL, my question is how can i check to see if a table exist in the given database, for example i have a database(Movies), i have different tables for genre(horror,...

Summary: Hi, Hope you can help.. This is what i have: using PHP & MySQL ComboBox1 (Named Carriers) ComboBox2 (Named Brand) ComboBox3 (Named Model) Text Box1, Text Box2, Text Box3 When you select an itme...