\nUse a php file which simply outputs json data. E.g.\n<\/p>\n
\r\n\r\n<?php\r\n\r\n\/\/Get some data from a table\r\n$my_array = array();\r\n$result1 = @mysql_query("SELECT field1, field2 FROM table1 ORDER BY field1");\r\nwhile ($row = @mysql_fetch_array($result1))\r\n{\r\n $my_array[] = $row;\r\n}\r\n\r\n\/\/Add it and some other data to an array\r\n$data = array(\r\n "results" => array(\r\n "my_field1" => "abcd",\r\n\t\t"my_array" => "my_array",\r\n "my_manual_array" => array(\r\n "item" =>\r\n array(\r\n array(\r\n "item_field1" => "123456",\r\n "item_field2" => "Hello 1"\r\n ),\r\n array(\r\n "item_field1" => "7890",\r\n "item_field2" => "Hello 2"\r\n )\r\n )\r\n )\r\n )\r\n);\r\n\r\n\/\/Output it as json\r\necho json_encode($data);\r\n?>\r\n<\/code><\/pre>\n\n <\/p>\n","protected":false},"excerpt":{"rendered":"
Use a php file which simply outputs json data. E.g. <?php \/\/Get some data from a table $my_array = array(); $result1 = @mysql_query("SELECT field1, field2 FROM table1 ORDER BY field1"); while ($row = @mysql_fetch_array($result1)) { $my_array[] = $row; } \/\/Add it and some other data to an array $data = array( "results" => array( "my_field1" […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[109],"tags":[],"class_list":["post-1048","post","type-post","status-publish","format-standard","hentry","category-json"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1048","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/comments?post=1048"}],"version-history":[{"count":4,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1048\/revisions"}],"predecessor-version":[{"id":1337,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1048\/revisions\/1337"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/media?parent=1048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/categories?post=1048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/tags?post=1048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}