
<?php
header("Content-Type: application/json");

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

include('Connections/bkngstm.php');

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$lastname = $_POST['lastname'];

$sql = "SELECT first_name, last_name, email FROM auth_users WHERE last_name LIKE ?";
$stmt = $conn->prepare($sql);
$param = "%" . $lastname . "%";
$stmt->bind_param("s", $param);
$stmt->execute();
$result = $stmt->get_result();

$response = ['success' => false, 'users' => []];

while ($row = $result->fetch_assoc()) {
    $response['success'] = true;
    $response['users'][] = [
        'first_name' => $row['first_name'],
        'last_name' => $row['last_name'],
        'email' => $row['email']
    ];
}

echo json_encode($response);


$stmt->close();
$conn->close();
?>