How can developers effectively implement a search feature that checks for a specific word within a text using PHP and MySQL?

To implement a search feature that checks for a specific word within a text using PHP and MySQL, developers can use the LIKE operator in SQL queries to search for the word in the database. They can also use PHP to handle the search input from the user and execute the query. The search functionality can be further enhanced by using full-text search indexes in MySQL for more efficient searching. 

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

// Get the search term from the user input
$searchTerm = $_GET['search'];

// Query to search for the specific word in the text column of a table
$sql = "SELECT * FROM table_name WHERE text_column LIKE '%$searchTerm%'";

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

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

$conn->close();
?>

Keywords

PHP MySQL search feature text search implementation

Related Questions