{"id":608,"date":"2012-07-12T09:54:25","date_gmt":"2012-07-12T09:54:25","guid":{"rendered":"http:\/\/codeatelier.wordpress.com\/?p=52"},"modified":"2012-07-12T09:54:25","modified_gmt":"2012-07-12T09:54:25","slug":"creating-json-file-with-php","status":"publish","type":"post","link":"https:\/\/codethataint.com\/blog\/creating-json-file-with-php\/","title":{"rendered":"Creating JSON File With PHP"},"content":{"rendered":"<pre>    mysql_connect('localhost', 'root', '');\n\u00a0\u00a0 \u00a0mysql_select_db('sampleDB');\n\u00a0\u00a0 \u00a0\n\u00a0\u00a0 \u00a0$strSQL = 'SELECT * \n\u00a0 \u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0 FROM tbAmenities \n\u00a0\u00a0 \u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0 LIMIT 10';\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0 \n\u00a0\u00a0 \u00a0$Result = mysql_query($strSQL); \n\n\u00a0\u00a0 \u00a0$Response = array();\n\u00a0\u00a0 \u00a0$Posts \u00a0\u00a0 = array();\n\u00a0\u00a0 \u00a0\n\u00a0\u00a0 \u00a0while($row=mysql_fetch_array($Result)) \n\u00a0\u00a0 \u00a0{ \n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$id\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0=\u00a0\u00a0 \u00a0$row['id']; \n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$amenityname\u00a0\u00a0 \u00a0= $row['amenityname']; \n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$amenity[] = array('id'=&gt; $id, 'amenity'=&gt; $amenityname);\u00a0\u00a0 \u00a0\n\u00a0\u00a0 \u00a0} \n\n\u00a0\u00a0 \u00a0$Response['posts'] = $amenity;\n\n\u00a0\u00a0 \u00a0$fp = fopen('results.json', 'w');\n\u00a0\u00a0 \u00a0fwrite($fp, json_encode($Response));\n\u00a0\u00a0 \u00a0fclose($fp);<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>mysql_connect(&#8216;localhost&#8217;, &#8216;root&#8217;, &#8221;); \u00a0\u00a0 \u00a0mysql_select_db(&#8216;sampleDB&#8217;); \u00a0\u00a0 \u00a0 \u00a0\u00a0 \u00a0$strSQL = &#8216;SELECT * \u00a0 \u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0 FROM tbAmenities \u00a0\u00a0 \u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0 LIMIT 10&#8217;; \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0 \u00a0\u00a0 \u00a0$Result = mysql_query($strSQL); \u00a0\u00a0 \u00a0$Response = array(); \u00a0\u00a0 \u00a0$Posts \u00a0\u00a0 = array(); \u00a0\u00a0 \u00a0 \u00a0\u00a0 \u00a0while($row=mysql_fetch_array($Result)) \u00a0\u00a0 \u00a0{ \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0$id\u00a0\u00a0\u00a0&hellip; <a href=\"https:\/\/codethataint.com\/blog\/creating-json-file-with-php\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[90],"tags":[],"class_list":["post-608","post","type-post","status-publish","format-standard","hentry","category-php-file-handling"],"_links":{"self":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/comments?post=608"}],"version-history":[{"count":0,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/posts\/608\/revisions"}],"wp:attachment":[{"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/media?parent=608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/categories?post=608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codethataint.com\/blog\/wp-json\/wp\/v2\/tags?post=608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}