File: /home/suanchonac/domains/suanchon.ac.th/private_html/admission-2568-1/ajax/readUserDetailsFa.php
<?php
// include Database connection file
include("../conn.php");
// check request
if(isset($_POST['id']) && isset($_POST['id']) != "")
{
// get User ID
$user_id = $_POST['id'];
//$user_id = 5;
// Get User Details
$query = "SELECT * FROM sas_studentdata WHERE NID = '$user_id'";
if (!$result = mysql_query($query)) {
exit(mysql_error());
}
$response = array();
if(mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$response = $row;
}
}
else
{
$response['status'] = 200;
$response['message'] = "Data not found!";
}
// display JSON data
echo json_encode($response);
}
else
{
$response['status'] = 200;
$response['message'] = "Invalid Request!";
}