php mysql json restful webservice display data based on id
db.php <?php $servername="localhost"; $username="root"; $password=""; $database="tg"; //create connection$ $conn=new mysqli($servername, $username, $password, $database); //check connection if ($conn->connect_error) { die("connection failed: ".$conn->connect_error); } ?> Display full list <?php include 'includes/db.php'; $cat_query="select * from coachings"; $cat_result=$conn->query($cat_query); if ($cat_result->num_rows > 0) { while($cat_row = $cat_result->fetch_assoc()) { $cat_msg[]=array("name" => $cat_row['c_name'], "address" => $cat_row['c_address'], "city" => $cat_row['c_city'],"state" => $cat_row['c_state'], "country" => $cat_row['c_country'], "pincode" => $cat_row['c_pincode'], "category...