{"id":689,"date":"2019-04-08T02:12:48","date_gmt":"2019-04-08T01:12:48","guid":{"rendered":"https:\/\/www.kolkataonweb.com\/code-bank\/?p=689"},"modified":"2019-03-12T11:35:52","modified_gmt":"2019-03-12T11:35:52","slug":"php-and-mysql-storing-quotes","status":"publish","type":"post","link":"https:\/\/www.kolkataonweb.com\/code-bank\/php\/php-and-mysql-storing-quotes\/","title":{"rendered":"PHP and MySQL &#8211; storing quotes"},"content":{"rendered":"<p>The best way to store quotes<\/p>\n<pre class='wp-code-highlight prettyprint'>htmlentities(<em>$campaignsubject<\/em>, ENT_QUOTES|ENT_SUBSTITUTE|ENT_HTML401);<\/pre>\n<p>And to decode it back use<\/p>\n<pre class='wp-code-highlight prettyprint'>html_entity_decode($rowsCampaigns['content'],ENT_QUOTES|ENT_SUBSTITUTE|ENT_HTML401);<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>The best way to store quotes htmlentities($campaignsubject, ENT_QUOTES|ENT_SUBSTITUTE|ENT_HTML401); And to decode it back use html_entity_decode($rowsCampaigns[&#8216;content&#8217;],ENT_QUOTES|ENT_SUBSTITUTE|ENT_HTML401);<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[181,179,180],"class_list":["post-689","post","type-post","status-publish","format-standard","hentry","category-php","tag-html-entities","tag-mysql","tag-quotes","entry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/posts\/689","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/comments?post=689"}],"version-history":[{"count":1,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/posts\/689\/revisions"}],"predecessor-version":[{"id":690,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/posts\/689\/revisions\/690"}],"wp:attachment":[{"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/media?parent=689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/categories?post=689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kolkataonweb.com\/code-bank\/wp-json\/wp\/v2\/tags?post=689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}