{"id":1454,"date":"2021-12-05T09:27:04","date_gmt":"2021-12-05T03:57:04","guid":{"rendered":"https:\/\/myfreeonlinetools.com\/blog\/?p=1454"},"modified":"2021-12-05T09:30:50","modified_gmt":"2021-12-05T04:00:50","slug":"create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php","status":"publish","type":"post","link":"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/","title":{"rendered":"Create Rest API with JSON output form MySQL Database Tables Data in PHP"},"content":{"rendered":"<h2>Developed Simple Rest API data in array convert into JSON fetch from MySQL Database Tables.<\/h2>\n<p>Below is code for creating JSON Array API data fetch from MySQL database. I use this simple API to get all records entered in a database table. I developed this on localhost requires database configuration changes in the top 4 variables.\u00a0 It fetches all records in JSON output which can use by Ajax in the index.php page or any other page.<\/p>\n<h3>Create PHP Rest API Data From MySQL Database<\/h3>\n<pre>&lt;?php \r\n$host = 'localhost';\r\n$username = 'root';\r\n$password = 'password';\r\n$dbname = 'international_rates'; \r\n\r\n$conn = new mysqli($host, $username, $password, $dbname);\r\n\r\nif ($conn-&gt;connect_error) {\r\n  die(\"Connection failed: \" . $conn-&gt;connect_error);\r\n}\r\n\r\n\/\/echo \"Connected successfully\";\r\n\r\n$sql = $conn-&gt;query(\"SELECT * FROM international_rates_table\");\r\n$response = array(); \r\n\r\n    while($row = $sql-&gt;fetch_assoc())\r\n\t\t{\r\n\t\t\t$remove[] = \"'\";\r\n\t\t\t$remove[] = '\"';\r\n\t\t\t\/\/$remove[] = '?';\r\n\t\t\t$remove[] = chr(054);\r\n\r\n\t\t\t$response[] = str_replace( $remove, \"\", $row );\r\n\t\t\t\/\/$response[] = mb_convert_encoding($row,'HTML-ENTITIES','UTF-8');\r\n\t\t}\r\n\r\n\t\theader('Content-type: application\/json; charset=utf-8');\r\n\t\techo json_encode($response);\r\n\r\n?&gt;<\/pre>\n<h4>Change the first 4 line PHP variable need to change as your database configuration.<\/h4>\n","protected":false},"excerpt":{"rendered":"<p>Developed Simple Rest API data in array convert into JSON fetch from MySQL Database Tables. Below is code for creating JSON Array API data fetch from MySQL database. I use [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[46,29],"tags":[],"class_list":["post-1454","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create Rest API with JSON output form MySQL Database Tables Data in PHP - MyFreeOnlineTools<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create Rest API with JSON output form MySQL Database Tables Data in PHP - MyFreeOnlineTools\" \/>\n<meta property=\"og:description\" content=\"Developed Simple Rest API data in array convert into JSON fetch from MySQL Database Tables. Below is code for creating JSON Array API data fetch from MySQL database. I use [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/\" \/>\n<meta property=\"og:site_name\" content=\"MyFreeOnlineTools\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/LearnSchoolOnline\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-05T03:57:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-05T04:00:50+00:00\" \/>\n<meta name=\"author\" content=\"myfreeonlinetools\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"myfreeonlinetools\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/\"},\"author\":{\"name\":\"myfreeonlinetools\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c\"},\"headline\":\"Create Rest API with JSON output form MySQL Database Tables Data in PHP\",\"datePublished\":\"2021-12-05T03:57:04+00:00\",\"dateModified\":\"2021-12-05T04:00:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/\"},\"wordCount\":110,\"publisher\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\"},\"articleSection\":[\"MySQL\",\"PHP\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/\",\"name\":\"Create Rest API with JSON output form MySQL Database Tables Data in PHP - MyFreeOnlineTools\",\"isPartOf\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#website\"},\"datePublished\":\"2021-12-05T03:57:04+00:00\",\"dateModified\":\"2021-12-05T04:00:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/myfreeonlinetools.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create Rest API with JSON output form MySQL Database Tables Data in PHP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#website\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/\",\"name\":\"MyFreeOnlineTools\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/myfreeonlinetools.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\",\"name\":\"MyFreeOnlineTools\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png\",\"contentUrl\":\"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png\",\"width\":387,\"height\":79,\"caption\":\"MyFreeOnlineTools\"},\"image\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c\",\"name\":\"myfreeonlinetools\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g\",\"caption\":\"myfreeonlinetools\"},\"description\":\"Live in Delhi, Working in Gurgaon as Web Designer and Graphic Designer. Developed and Design myfreeonlinetools for online free tools. Also having youtube channel Name with LearnSchoolOnline. Traveling, watching movies, coding are the hobbies.\",\"sameAs\":[\"https:\/\/myfreeonlinetools.com\/\",\"https:\/\/www.facebook.com\/LearnSchoolOnline\/\",\"https:\/\/www.youtube.com\/learnschoolonline\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create Rest API with JSON output form MySQL Database Tables Data in PHP - MyFreeOnlineTools","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/","og_locale":"en_US","og_type":"article","og_title":"Create Rest API with JSON output form MySQL Database Tables Data in PHP - MyFreeOnlineTools","og_description":"Developed Simple Rest API data in array convert into JSON fetch from MySQL Database Tables. Below is code for creating JSON Array API data fetch from MySQL database. I use [&hellip;]","og_url":"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/","og_site_name":"MyFreeOnlineTools","article_author":"https:\/\/www.facebook.com\/LearnSchoolOnline\/","article_published_time":"2021-12-05T03:57:04+00:00","article_modified_time":"2021-12-05T04:00:50+00:00","author":"myfreeonlinetools","twitter_card":"summary_large_image","twitter_misc":{"Written by":"myfreeonlinetools","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/#article","isPartOf":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/"},"author":{"name":"myfreeonlinetools","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c"},"headline":"Create Rest API with JSON output form MySQL Database Tables Data in PHP","datePublished":"2021-12-05T03:57:04+00:00","dateModified":"2021-12-05T04:00:50+00:00","mainEntityOfPage":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/"},"wordCount":110,"publisher":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization"},"articleSection":["MySQL","PHP"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/","url":"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/","name":"Create Rest API with JSON output form MySQL Database Tables Data in PHP - MyFreeOnlineTools","isPartOf":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#website"},"datePublished":"2021-12-05T03:57:04+00:00","dateModified":"2021-12-05T04:00:50+00:00","breadcrumb":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/myfreeonlinetools.com\/blog\/create-array-rest-api-with-json-output-form-mysql-database-tables-data-in-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/myfreeonlinetools.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Create Rest API with JSON output form MySQL Database Tables Data in PHP"}]},{"@type":"WebSite","@id":"https:\/\/myfreeonlinetools.com\/blog\/#website","url":"https:\/\/myfreeonlinetools.com\/blog\/","name":"MyFreeOnlineTools","description":"","publisher":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/myfreeonlinetools.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization","name":"MyFreeOnlineTools","url":"https:\/\/myfreeonlinetools.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png","contentUrl":"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png","width":387,"height":79,"caption":"MyFreeOnlineTools"},"image":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c","name":"myfreeonlinetools","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g","caption":"myfreeonlinetools"},"description":"Live in Delhi, Working in Gurgaon as Web Designer and Graphic Designer. Developed and Design myfreeonlinetools for online free tools. Also having youtube channel Name with LearnSchoolOnline. Traveling, watching movies, coding are the hobbies.","sameAs":["https:\/\/myfreeonlinetools.com\/","https:\/\/www.facebook.com\/LearnSchoolOnline\/","https:\/\/www.youtube.com\/learnschoolonline"]}]}},"_links":{"self":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts\/1454","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/comments?post=1454"}],"version-history":[{"count":0,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts\/1454\/revisions"}],"wp:attachment":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/media?parent=1454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/categories?post=1454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/tags?post=1454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}