โค้ด: เลือกทั้งหมด
$sql = "select True as status, s.stdCode ,s.stdFName ,s.stdLName from students s, classrooms c where c.classShort = 'คต.5/1' and c.classCode = s.classCode";
$result = $conn->query($sql);
if($result->num_rows)
{
echo json_encode($result->fetch_assoc());
}else
{
echo '{"status":"0","msg":"ไม่พบข้อมูล"}';
}
$conn->close();