What are the considerations when retrieving and displaying 150 names from a MySQL database for use in a contact form with auto-suggestion in PHP?

When retrieving and displaying 150 names from a MySQL database for use in a contact form with auto-suggestion in PHP, it is important to optimize the query to only fetch the necessary data and limit the number of results to improve performance. Additionally, using AJAX to fetch data dynamically as the user types can enhance the user experience. 

<?php
// Establish a connection to the MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

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

// Retrieve and display 150 names with auto-suggestion
$query = "SELECT name FROM contacts LIMIT 150";
$result = $conn->query($query);

$names = array();
while ($row = $result->fetch_assoc()) {
    $names[] = $row['name'];
}

echo json_encode($names);

// Close the connection
$conn->close();
?>

Keywords

MySQL database PHP contact form auto-suggestion retrieval

Related Questions