How can one retrieve a random entry from a database in PHP?

To retrieve a random entry from a database in PHP, you can use the RAND() function in your SQL query to randomize the results. You can then fetch the random entry using PHP's database connection and query execution functions. 

// Connect to the 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 a random entry from the database
$sql = "SELECT * FROM table_name ORDER BY RAND() LIMIT 1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data of the random entry
    $row = $result->fetch_assoc();
    echo "Random entry: " . $row["column_name"];
} else {
    echo "0 results";
}

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

Keywords

PHP database random query entry

Related Questions