What are best practices for checking if a word is in a database in PHP?

When checking if a word is in a database in PHP, it is best practice to use prepared statements to prevent SQL injection attacks. You can use a SELECT query with a WHERE clause to check if the word exists in the database. If the query returns a result, then the word is in the database. 

<?php

// Assuming $word is the word you want to check
$word = "example";

// Establish a connection to the database
$pdo = new PDO("mysql:host=localhost;dbname=your_database", "username", "password");

// Prepare a SELECT query to check if the word exists in the database
$stmt = $pdo->prepare("SELECT * FROM your_table WHERE word = :word");
$stmt->bindParam(':word', $word);
$stmt->execute();

// Check if the query returned any rows
if($stmt->rowCount() > 0) {
    echo "The word '$word' is in the database.";
} else {
    echo "The word '$word' is not in the database.";
}

?>

Keywords

PHP database SQL query validation

Related Questions