How can you negate a database query in PHP when selecting data?

Negating a database query in PHP when selecting data involves using the NOT operator in the WHERE clause to exclude specific records that meet certain criteria. This can be useful when you want to retrieve data that does not match a particular condition. Example PHP code snippet: 

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

// Query to select data where a certain condition is not met
$sql = "SELECT * FROM table_name WHERE column_name != 'value'";

$result = $conn->query($sql);

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

$conn->close();
?>

Keywords

negate database query PHP selecting data SQL

Related Questions