44 lines
941 B
PHP
44 lines
941 B
PHP
|
|
<?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();
|
|
?>
|
|
|