<?php $servername = "localhost"; $username = "beambpej_wp790"; $password = "4-67SpMx5]"; $con = mysqli_connect($servername, $username, $password,"beambpej_wp790"); if ( $con -> connect_errno) {print("Not connected". $con -> connect_error);} mysqli_set_charset($conn,"utf8"); $con->query("SET NAMES 'utf8'"); if(($_GET['province'])=='all'){ $result = $con->query("select * from districts"); }else{ $result = $con->query("select * from districts WHERE Province = '".urldecode($_GET['province'])."'"); } $output[]=(object)array(); while($row = $result->fetch_array(MYSQLI_ASSOC)) { $output[]=$row; } $json = json_encode(array("districts" => $output)); $error = json_last_error(); if ($error !== JSON_ERROR_NONE) { echo json_last_error_msg(); } else { header('Access-Control-Allow-Origin: *'); header('Content-type: application/json; charset=utf-8'); echo $json; } $con -> close(); exit(1); ?>