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..... 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. 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.... 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... 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!!!!! 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 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
Archived
This topic is now archived and is closed to further replies.