How can PHP be used to check if a value in a MySQL table matches another value in the same table?

To check if a value in a MySQL table matches another value in the same table, you can use a SELECT query with a WHERE clause to compare the two values. You can fetch the result of the query and check if any rows are returned, indicating a match. 

<?php
// Connect to MySQL database
$mysqli = new mysqli("localhost", "username", "password", "database");

// Check connection
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Query to check if value1 matches value2 in the table
$query = "SELECT * FROM table_name WHERE value1 = value2";
$result = $mysqli->query($query);

// Check if any rows are returned
if ($result->num_rows > 0) {
    echo "Value1 matches Value2 in the table";
} else {
    echo "Value1 does not match Value2 in the table";
}

// Close connection
$mysqli->close();
?>

Keywords

PHP MySQL table value matching query

Related Questions