PHPNewbie55 Posted March 13, 2010 Share Posted March 13, 2010 I am pulling in for from a MySQL Database... and some of the info contains %20 %22 etc... How can I replace these with spaces and ' single quotes... and all the other entities as well...?? I have tried: html_entity_decode() htmlentities() htmlspecialchars_decode() htmlspecialchars() I can't find the right "decode" to use..... Quote Link to comment https://forums.phpfreaks.com/topic/195077-20-and-22-replace-with-php/ Share on other sites More sharing options...
trq Posted March 13, 2010 Share Posted March 13, 2010 How is the tainted data getting in the database in the first place is probably the question you should be asking. Quote Link to comment https://forums.phpfreaks.com/topic/195077-20-and-22-replace-with-php/#findComment-1025466 Share on other sites More sharing options...
PHPNewbie55 Posted March 13, 2010 Author Share Posted March 13, 2010 I am writing a little tracker script for myself... just playing around with the SE referring urls.... SO if someone search for "Some" Keyword... Those characters get put in the database... I have been trying to figure out how to strip them out... either when they get inserted or when they get displayed it doesn't matter to me... But I can't get anything to strip them out or display them as usual... any help would be appreciated.... Quote Link to comment https://forums.phpfreaks.com/topic/195077-20-and-22-replace-with-php/#findComment-1025469 Share on other sites More sharing options...
PHPNewbie55 Posted March 13, 2010 Author Share Posted March 13, 2010 I guess there isn't a way to strip those out... Quote Link to comment https://forums.phpfreaks.com/topic/195077-20-and-22-replace-with-php/#findComment-1025529 Share on other sites More sharing options...
PHPNewbie55 Posted March 13, 2010 Author Share Posted March 13, 2010 urldecode() Gee Thanks!!!!! Quote Link to comment https://forums.phpfreaks.com/topic/195077-20-and-22-replace-with-php/#findComment-1025541 Share on other sites More sharing options...
Tazerenix Posted March 13, 2010 Share Posted March 13, 2010 check php.net for it, or w3schools, they have great function references for things like this Quote Link to comment https://forums.phpfreaks.com/topic/195077-20-and-22-replace-with-php/#findComment-1025542 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.