Back

Clients in California (CA)

Found 5 record(s).

RECORDS - Clients in CA
ID	Name	Address 1	Address 2	City	State	Zip	Phone
2				San Mateo	CA	94402	(211) 107-2844
21				Davis	CA	95616	(143) 275-2569
25				Stratham	CA	03885	(330) 871-5564
26				Boulder	CA	80302	(131) 664-3716
27				Santa Clara	CA	95050	(642) 915-9286

CODE FOLLOWS


<?php

/** @var mysqli $con */

error_reporting(E_ALL);

include('includes/header.php');

include('includes/open-db.php');

?>



<h1>Clients in California (CA)</h1>



<table class="full">

    <tr>

        <th colspan="8" class="header1">RECORDS - Clients in CA</th>

    </tr>

    <tr class="header2">

        <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

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

    $result = mysqli_query($con, $query);



    if (!$result) {

        echo "<tr><td colspan='8' class='red'>Query failed: " . mysqli_error($con) . "</td></tr>";

    } elseif (mysqli_num_rows($result) > 0) {

        echo "<p>Found " . mysqli_num_rows($result) . " record(s).</p>";

        $i = 0;

        while ($row = mysqli_fetch_assoc($result)) {

            echo "<tr class='row" . ($i++ & 1) . "'>";

            echo "<td>{$row['id']}</td>";

            echo "<td>{$row['first_name']} {$row['last_name']}</td>";

            echo "<td>{$row['address1']}</td>";

            echo "<td>{$row['address2']}</td>";

            echo "<td>{$row['city']}</td>";

            echo "<td>{$row['state']}</td>";

            echo "<td>{$row['zip']}</td>";

            echo "<td>{$row['phone']}</td>";

            echo "</tr>";

        }

    } else {

        echo "<tr><td colspan='8' class='center red'>No clients found in California.</td></tr>";

    }



    include('includes/close-db.php');

    ?>

</table>



<?php

include('includes/footer.php');

?>

Back