What are the best practices for handling SQL queries in PHP to display data with different styles?

When displaying data with different styles in PHP using SQL queries, it is best to separate the logic of querying the data from the presentation of the data. This can be achieved by fetching the data from the database using SQL queries and then iterating over the results to display them in different styles based on certain conditions. 

// 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 the database for the data
$sql = "SELECT * FROM table";
$result = $conn->query($sql);

// Display the data with different styles
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        if ($row['type'] == 'style1') {
            echo '<div style="color: red;">' . $row['data'] . '</div>';
        } elseif ($row['type'] == 'style2') {
            echo '<div style="color: blue;">' . $row['data'] . '</div>';
        } else {
            echo $row['data'];
        }
    }
} else {
    echo "0 results";
}

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

Keywords

SQL queries PHP data display styles error handling

Related Questions