How can you prevent a specific ID from being displayed when fetching data from a MySQL database in PHP?

To prevent a specific ID from being displayed when fetching data from a MySQL database in PHP, you can use a WHERE clause in your SQL query to exclude that specific ID from the results. By specifying the condition to exclude the specific ID, you can ensure that it is not included in the fetched data. 

<?php
// Database connection
$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);
}

// Prevent specific ID from being displayed
$specific_id = 123; // Specify the ID to exclude
$sql = "SELECT * FROM table_name WHERE id != $specific_id";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"] . " - Name: " . $row["name"] . "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();
?>

Keywords

PHP MySQL database query filtering

Related Questions