How can one display all columns related to specific values in a table using PHP and SQL?

When you want to display all columns related to specific values in a table using PHP and SQL, you can achieve this by querying the database with a SELECT statement that includes the specific values you are interested in. You can then fetch the results and display them in a tabular format on your webpage. 

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

// Define the specific values you are interested in
$specific_value = "example";

// Query the database to retrieve all columns related to the specific value
$sql = "SELECT * FROM your_table WHERE column_name = '$specific_value'";
$result = $conn->query($sql);

// Display the results in a table
if ($result->num_rows > 0) {
    echo "<table><tr>";
    // Output table headers
    while ($row = $result->fetch_assoc()) {
        foreach ($row as $key => $value) {
            echo "<th>$key</th>";
        }
        break;
    }
    echo "</tr>";
    
    // Output table data
    while ($row = $result->fetch_assoc()) {
        echo "<tr>";
        foreach ($row as $value) {
            echo "<td>$value</td>";
        }
        echo "</tr>";
    }
    echo "</table>";
} else {
    echo "0 results";
}

// Close the database connection
$conn->close();
?>

Keywords

PHP SQL display columns specific values

Related Questions