Back

Clients in California (CA)

Found 13 record(s).

ID	Name	Address 1	Address 2	City	State	Zip	Phone
RECORDS - CLIENTS IN CA
23	Citrus Grove Markets	7800 Orangewood Ave		Anaheim	CA	92802	(714) 555-0177
18	Richman Buick	PO BOX 4971		Boulder	CA	80302	(131) 664-3716
26	Sierra Cycle Co.	118 N Van Ness Ave		Fresno	CA	93721	(559) 555-0150
28	Coastal Creative Media	18881 Von Karman Ave	Suite 500	Irvine	CA	92612	(949) 555-0185
24	Pacific Crest Builders	9455 La Jolla Shores Dr	Floor 3	La Jolla	CA	92037	(858) 555-0114
21	Silver Lake Interiors	4411 Sunset Blvd	Suite 210	Los Angeles	CA	90027	(323) 555-0142
29	South Bay Dental Group	2505 El Camino Real	Suite 2B	Redwood City	CA	94063	(650) 555-0134
25	Gold Rush Storage	2150 J St	Unit B	Sacramento	CA	95816	(916) 555-0161
20	Harbor Spa & Wellness	1220 Bay St		San Francisco	CA	94123	(415) 555-0127
22	Mission Coffee Roasters	329 Valencia St		San Francisco	CA	94103	(415) 555-0199
2	Lavaysse Circus	27 Woodland Avenue		San Mateo	CA	94402	(211) 107-2844
19	Daly Autobody	4388 Folsom Street	Suite 673	Santa Clara	CA	95050	(642) 915-9286
27	Redwood Outfitters	701 4th St	Suite 120	Santa Rosa	CA	95404	(707) 555-0106

CODE FOLLOWS


<?php

error_reporting(E_ALL);



include('includes/header.php');   // your class header / styles / Back button

include('includes/open-db.php');  // opens $con (mysqli)

?>

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



<?php

$sql = "

  SELECT id, name, address1, address2, city, state, zip, phone

  FROM clients

  WHERE state = 'CA'

  ORDER BY city ASC, name ASC

";



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

if (!$result) {

    echo '<p class="red">Query failed: ' . htmlspecialchars(mysqli_error($con)) . '</p>';

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

    include('includes/footer.php');

    exit;

}



$count = mysqli_num_rows($result);

echo '<p>Found ' . (int)$count . ' record(s).</p>';

?>



    <table class="full" style="border-collapse:collapse;width:100%;">

        <tr>

            <td colspan="8" class="header2">RECORDS - CLIENTS IN CA</td>

        </tr>

        <tr class="header3">

            <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

        if ($count > 0) {

            $i = 0;

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

                $cls = ($i % 2 === 0) ? 'rowA' : 'rowB'; // zebra rows if your CSS defines these

                ?>

                <tr class="<?= $cls ?>">

                    <td><?= htmlspecialchars($row['id']) ?></td>

                    <td><?= htmlspecialchars($row['name']) ?></td>

                    <td><?= htmlspecialchars($row['address1']) ?></td>

                    <td><?= htmlspecialchars($row['address2']) ?></td>

                    <td><?= htmlspecialchars($row['city']) ?></td>

                    <td><?= htmlspecialchars($row['state']) ?></td>

                    <td><?= htmlspecialchars($row['zip']) ?></td>

                    <td><?= htmlspecialchars($row['phone']) ?></td>

                </tr>

                <?php

                $i++;

            }

        } else {

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

        }

        ?>

    </table>



<?php

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

include('includes/footer.php');

Back