<?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'");

$result = $con->query("select * from clinics WHERE Cities = '".urldecode($_GET['city'])."'");

 
 $output[]=(object)array();
while($row = $result->fetch_array(MYSQLI_ASSOC)) {
        $output[]=$row;
}
 

$json = json_encode(array("result" => $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);
?>