Sir I have a search engine on my website which get input by user and search it for the results and i am storing those keywords into seperate table name keywords, but now a days i m checking that there is a bunch of unknown characters into query strings, i have used htmlspecialchars() funcntion and mysql_real_escape_string() functions to check if it will help me but i m not success i have attached the db image to you guyz to check and help me out, and also give me a mysql query to so with at once i can remove those chars from my db and can clean my db and in future i want to prevent those keywrods from inserting into my db thans! and tell me which of the keyboard keys which making this type of keywords thanks!
4fridi
0
Newbie Poster
Recommended Answers
Jump to PostThat looks like incorrect saving of unicode characters, so my guess is that someone is using arabic, cyrillic or any other non latin encoding in your search.
Jump to PostYou might be able to run some query like:
DELETE FROM table_name WHERE some_column LIKE '%<some special character>%'
The percent signs are wild cards, so you would just take what ever character you are looking for (copy and paste?) and stick in between the %%. I …
All 8 Replies
tkdchamp
-1
Newbie Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
4fridi
0
Newbie Poster
pixelsoul
272
Red Pill
Featured Poster
4fridi
0
Newbie Poster
4fridi
0
Newbie Poster
pixelsoul
272
Red Pill
Featured Poster
4fridi
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.