Pull All Records from California (CA)

RECORDS
ID	Name	Address 1	Address 2	City	State	Zip	Phone
2	Lavaysse Circus	27 Woodland Avenue		San Mateo	CA	94402	(211) 107-2844
21	Sherwood Oaks	1941 aberdeen way		Davis	CA	95616	(143) 275-2569
25	Easter Travel	4114 W. Elm	Suite 370	Stratham	CA	03885	(330) 871-5564
26	Richman Buick	PO BOX 4971		Boulder	CA	80302	(131) 664-3716
27	Daly Autobody	4388 Folsom Street	Suite 673	Santa Clara	CA	95050	(642) 915-9286

---

---

CODE FOLLOWS

<?php

// Enable error reporting for all types of errors
error_reporting(E_ALL);

// Include the header file for page setup
include('includes/header.php');

// Initialize an empty connection variable (though it should be set later)
$con = '';

?>
    <h1>Pull All Records from California (CA)</h1>

    <!-- Start of table to display client records -->
    <table class="full">
        <tr>
            <!-- Table header with a colspan of 8 for styling purposes -->
            <th colspan="8" class="header1">RECORDS</th>
        </tr>
        <tr class="header2">
            <!-- Column headers -->
            <th>ID</th>
            <th>Name</th>
            <th>Address 1</th>
            <th>Address 2</th>
            <th>City</th>
            <th>State</th>
            <th>Zip</th>
            <th>Phone</th>
        </tr>

        <?php
        // Include the database connection file
        include('includes/open-db.php');

        // Define the SQL query to retrieve records from the clients table where state is 'CA'
        $query = "SELECT * FROM clients WHERE state = 'CA'";

        // Execute the query; handle errors if the query fails
        $result = mysqli_query($con, $query) or die("Could not get data: $query " . mysqli_error($con));

        // Loop through each row in the result set and display it in the table
        $i = 0;
        while ($row = mysqli_fetch_array($result)) {
            // Extract data from each row into individual variables
            $id = $row['id'];
            $name = $row['name'];
            $address_1 = $row['address_1'];
            $address_2 = $row['address_2'];
            $city = $row['city'];
            $state = $row['state'];
            $zip = $row['zip'];
            $phone = $row['phone'];
            ?>

            <!-- Display each row's data in a table row, with alternating classes for styling -->
            <tr class="row<?php echo($i++ & 1); ?>">
                <td><?php echo htmlspecialchars($id); ?></td>
                <td><?php echo htmlspecialchars($name); ?></td>
                <td><?php echo htmlspecialchars($address_1); ?></td>
                <td><?php echo htmlspecialchars($address_2); ?></td>
                <td><?php echo htmlspecialchars($city); ?></td>
                <td><?php echo htmlspecialchars($state); ?></td>
                <td><?php echo htmlspecialchars($zip); ?></td>
                <td><?php echo htmlspecialchars($phone); ?></td>
            </tr>

            <?php
        }

        // Close the database connection
        include('includes/close-db.php');
        ?>

    </table>

    <hr>

<?php
// Include the footer file to close the HTML structure
include('includes/footer.php');
?>

---