prepare("
SELECT * FROM jbs_customers
WHERE
customer_name LIKE :search
OR mobile_no LIKE :search
OR username LIKE :search
OR customer_id LIKE :search
ORDER BY id DESC
");
$stmt->execute([
':search' => "%$search%"
]);
$customers = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
?>
Alliance Broadband Customer Search
| ID |
Customer ID |
Customer Name |
Mobile Number |
Username |
Address |
|
|
|
|
|
|
|
|