jwhite68 Posted October 25, 2007 Share Posted October 25, 2007 I have a string thats displayed from a database table, and when the database value contains a string in quotes, its not displayed in the output form. So if the value of advtitle is - this is an advert, as "featured on tv" When displayed it shows - this is an advert, as So its missing the "featured on tv" part. Here is the code: <tr> <td class="td135" style="text-align:right !important"><span<?=$hlight4?>>Ad title</span></td> <td colspan="5" class="td675"><input type="text" name="advtitle" maxlength="128" value="<?=$advtitle?>" style="width:385px"></td> </tr> Can anyone advise what I need to do in PHP to the <=?advtitle?> code. I tried addslashes but that didnt work. Quote Link to comment https://forums.phpfreaks.com/topic/74711-solved-help-with-double-quotes-issue/ Share on other sites More sharing options...
ToonMariner Posted October 25, 2007 Share Posted October 25, 2007 check you magic quotes setting... Quote Link to comment https://forums.phpfreaks.com/topic/74711-solved-help-with-double-quotes-issue/#findComment-377683 Share on other sites More sharing options...
Zane Posted October 25, 2007 Share Posted October 25, 2007 how are you putting the information into your database most likely your aren't escaping your double quotes you need to put backslashes in front of them when you insert it this is an advert, as \"featured on tv\" Quote Link to comment https://forums.phpfreaks.com/topic/74711-solved-help-with-double-quotes-issue/#findComment-377686 Share on other sites More sharing options...
Thierry Posted October 25, 2007 Share Posted October 25, 2007 Try using a single double quote and see if the query gives an error. If it does, you forgot to escape your double quotes. Since your query is probably written in double quotes, it causes an error as it gets all messy. You can either use addslashes($_POST["YOUR_FORM_ITEM"]); or htmlspecialchars($_POST["YOUR_FORM_ITEM"], ENT_QUOTES);. Add slashes will simply add a \ to the " which will tell PHP to see it as a character instead of a double quote and the latter will change the doublequote into its HTML code ('), you can use html_entity_decode to bring it back if needed. Quote Link to comment https://forums.phpfreaks.com/topic/74711-solved-help-with-double-quotes-issue/#findComment-377688 Share on other sites More sharing options...
jwhite68 Posted October 25, 2007 Author Share Posted October 25, 2007 I was able to resolve it by just changing <?=$advtitle?> to <?=htmlspecialchars($advtitle)?> Does anyone see an issue in resolving it this way? Quote Link to comment https://forums.phpfreaks.com/topic/74711-solved-help-with-double-quotes-issue/#findComment-377690 Share on other sites More sharing options...
kenrbnsn Posted October 25, 2007 Share Posted October 25, 2007 That is the correct way of solving the problem. Escaping the quotes is for PHP & MySQL. Ken Quote Link to comment https://forums.phpfreaks.com/topic/74711-solved-help-with-double-quotes-issue/#findComment-377710 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.