real_escape_string($query); $condition = "WHERE applications.applicant_name LIKE '%$query%' OR applications.appjob_id LIKE '%$query%' OR applications.postname2 LIKE '%$query%' OR applications.postname3 LIKE '%$query%' OR applications.status LIKE '%$query%' OR applications.mobile LIKE '%$query%' OR applications.alt_mobile LIKE '%$query%'"; } $sql = "SELECT * FROM applications $condition ORDER BY id DESC"; $result = $conn->query($sql); $count = 0; if ($result->num_rows > 0) { while ($meta = mysqli_fetch_assoc($result)) { $count++; echo " {$count} " . date('d M Y', strtotime($meta['appliaction_date'])) . " " . ucfirst($meta['appjob_id']); if (!empty($meta['postname2'])) echo "
" . ucfirst($meta['postname2']); if (!empty($meta['postname3'])) echo "
" . ucfirst($meta['postname3']); echo " " . ucfirst($meta['applicant_name']) . " " . htmlspecialchars($meta['mobile']) . "
" . htmlspecialchars($meta['alt_mobile']) . " Manage Profile "; } } else { echo "No records found."; } $conn->close(); ?>