<?php
header('Content-Type: application/json');
include "config.php";
$id=$_REQUEST['id'];

$query="SELECT t1.id, t1.course_name, t1.course_code, t1.display_order, t1.status FROM sp_courses as t1

where t1.id='$id'";
$sql=$db->prepare($query);
$sql->execute();
$row=$sql->fetch();

echo json_encode($row,TRUE);
?>