query($sql);
$response = "";
$count = 0;
if ($result && $result->num_rows > 0) {
while ($data = mysqli_fetch_assoc($result)) {
$count++;
$photo = empty($data['photo_copy'])
? 'img/vouchersimg_1.png'
: "../admin/" . $uploadpath . $data['photo_copy'];
$response .= "
| {$count} |
 |
" . ucfirst($data['gender_typ']) . " " . ucfirst($data['first_name']) . " " . ucfirst($data['middle_name']) . " " . ucfirst($data['last_name']) . "
" . $data['phone1'] . ($data['phone2'] ? " / " . $data['phone2'] : "") . " |
|
|
";
}
} else {
$response = "| No results found |
";
}
echo $response;
$conn->close();
?>