Tyler's PHP Example

Name: Lavaysse Circus
City: San Mateo
State: CA

Name: Sherwood Oaks
City: Davis
State: CA

Name: Easter Travel
City: Stratham
State: CA

Name: Richman Buick
City: Boulder
State: CA

Name: Daly Autobody
City: Santa Clara
State: CA

CODE FOLLOWS


<?php

include "../includes/header.php";

$con = '';
include('mysql/open-db.php');

$query = "SELECT * FROM clients WHERE state = 'CA'";


$result = mysqli_query($con, $query) or die("Query failed: " . mysqli_error($con));


while ($row = mysqli_fetch_assoc($result)) {
    echo "Name: " . htmlspecialchars($row['name']) . "<br>";
    echo "City: " . htmlspecialchars($row['city']) . "<br>";
    echo "State: " . htmlspecialchars($row['state']) . "<br>";
    echo "<hr>";
}

include('mysql/close-db.php');
include("../includes/footer.php");
?>

Back