0){
$row = mysqli_fetch_array($res, MYSQLI_ASSOC);
$name = $row['fullname'];
// $fname = $row['name'];
// $khun = mb_substr($name, 0, 3);
$split = explode(" ", $name);
$fname = $split[0];
//echo $fname;
$lname = $split[2];
//echo " " . $lname;
$occu = $row['occupation'];
$pname = $row['pname'];
$firstname = $row['fname'];
$arr = array($fname, $lname);
if ($occu == '203'){
require "data/203Sailor.php";
$newpname = $pnamedata[$pname];
if ($newpname) {
$name_format = " '$newpname$firstname '$arr[1]";
}else {
$name_format = " '$fname '$arr[1]";
}
}elseif ($occu == '205'){
require "data/205Police.php";
$newpname = $pnamedata[$pname];
if ($newpname) {
$name_format = " '$newpname$firstname '$arr[1]";
}else {
$name_format = " '$fname '$arr[1]";
}
}elseif ($occu == '202'){
require "data/202Army.php";
$newpname = $pnamedata[$pname];
if ($newpname) {
$name_format = " '$newpname$firstname '$arr[1]";
}else {
$name_format = " '$fname '$arr[1]";
}
}elseif ($occu == '204'){
require "data/204Air.php";
$newpname = $pnamedata[$pname];
if ($newpname) {
$name_format = " '$newpname$firstname '$arr[1]";
}else {
$name_format = " '$fname '$arr[1]";
}
}else{
require "data/general.php";
$newpname = $pnamedata[$pname];
if ($newpname) {
$name_format = " '$newpname$firstname '$arr[1]";
}else {
$name_format = " '$fname '$arr[1]";
}
}
// if ($row['marrystatus'] == '6'){
// $new_name = " '$newpname$marryname '$arr[1]";
// }else {
// $new_name = " '$newpname$marryname '$arr[1]";
// }
$lower = strtolower($name_format);
$ucfirst = ucfirst($lower);
echo $ucfirst;
}else{
echo "";
}
//$data = ['name' => $new_name];
//echo json_encode($data);