MAINHACK

Viewing / Editing File: search_customers.php

<?php
 include("../admin/includes/functions/functions.php");
 include("../admin/db/db.php");
$shopname = isset($_GET['shopname']) ? $_GET['shopname'] : '';
$term = isset($_GET['term']) ? '%' . $_GET['term'] . '%' : '';

// Prepare the query with optimized conditions
$stmt = $con->prepare("
  SELECT client_id, first_name, last_name, phone_number 
  FROM clients 
  WHERE business_name = ? 
  AND (
    CONCAT(LOWER(first_name), ' ', LOWER(last_name)) LIKE LOWER(?) 
    OR phone_number LIKE ? 
    OR client_id LIKE ?
  )
  ORDER BY first_name, last_name
  LIMIT 10
");
$stmt->execute([$shopname, $term, $term, $term]);
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

$results = [];
foreach ($rows as $row) {
  $results[] = [
    'client_id' => $row['client_id'],
    'first_name' => $row['first_name'],
    'last_name' => $row['last_name'],
    'mobile' => $row['phone_number'],
    'display_name' => $row['first_name'] . ' ' . $row['last_name'] . ' (' . $row['phone_number'] . ')'
  ];
}

header('Content-Type: application/json');
echo json_encode($results);
exit;

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: search_customers.php

Server Info

System Features

User Info