leafer Posted February 8, 2010 Share Posted February 8, 2010 I've tried everything (htmlspecialchars, htmlentities, html_entity_decode with ENT_QUOTES) and nothing seems to work. It keeps displaying a blue boxed question mark in place of the single quote. The portion of the sentence not displaying properly is "john's". I've manually inserted the info using myphpadmin if that makes a difference. Thx Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/ Share on other sites More sharing options...
Goldeneye Posted February 8, 2010 Share Posted February 8, 2010 You said you manually inserted the sentence into your database. Does your single-quote happen to be an apostrophe? If it's an actual apostrophe, you might want to try: <?php htmlentities($str, ENT_COMPAT, 'UTF-8'); ?> Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1009052 Share on other sites More sharing options...
leafer Posted February 8, 2010 Author Share Posted February 8, 2010 You said you manually inserted the sentence into your database. Does your single-quote happen to be an apostrophe? If it's an actual apostrophe, you might want to try: <?php htmlentities($str, ENT_COMPAT, 'UTF-8'); ?> It's the key to the left of enter not the one with the tilde sign (~). I tried your method above but now the line itself doesn't display. Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1009079 Share on other sites More sharing options...
leafer Posted February 9, 2010 Author Share Posted February 9, 2010 No one? Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1009376 Share on other sites More sharing options...
jl5501 Posted February 9, 2010 Share Posted February 9, 2010 do you have the exact text that is stored in mysql that you can show us? Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1009442 Share on other sites More sharing options...
leafer Posted February 9, 2010 Author Share Posted February 9, 2010 do you have the exact text that is stored in mysql that you can show us? "I'm going over to John's house" Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1009466 Share on other sites More sharing options...
leafer Posted February 10, 2010 Author Share Posted February 10, 2010 Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1010246 Share on other sites More sharing options...
jl5501 Posted February 10, 2010 Share Posted February 10, 2010 so it is actually stored in the db like that not as "I\'m going over to John\'s house" which is how it would normally be stored if mysql_real_escape_string() or addslashes() had been used Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1010265 Share on other sites More sharing options...
leafer Posted February 10, 2010 Author Share Posted February 10, 2010 I've manually inserted the info using myphpadmin if that makes a difference. Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1010310 Share on other sites More sharing options...
sader Posted February 10, 2010 Share Posted February 10, 2010 Maybe something wrong with encode in your tables field? Mayebe u set some exotic charcase for document with <meta>? is your php file saved in utf-8 mode? thats some ideas that I got... Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1010315 Share on other sites More sharing options...
jl5501 Posted February 10, 2010 Share Posted February 10, 2010 It is reasonably certain that if the manually entered data was changed in line with my last post, then you would be able to extract it, apply stripslashes() to it, and have it displayed correctly. With an unescaped single quote in the db data, then in theory it ought to be displayable if placed in double quotes, and it would be interesting to hear anyone elses analysis of that situation Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1010318 Share on other sites More sharing options...
leafer Posted February 10, 2010 Author Share Posted February 10, 2010 It's not entered in with double quotes I just used double quotes to signify the entire sentence I used. Link to comment https://forums.phpfreaks.com/topic/191397-displaying-sentence-containing-a-single-quote-extracted-from-mysql/#findComment-1010321 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.