Search Clients

Search by NameCityStateZipPhone Text Search

---

---

The following are All the Records in the Clients Table

ALL RECORDS
ID	Name	Address 1	Address 2	City	State	Zip	Phone
1	Gorman Place	8 Horizon Road		New Haven	CT	06510	(336) 902-1538
2	Lavaysse Circus	27 Woodland Avenue		San Mateo	CA	94402	(211) 107-2844
3	Weisman Oil	3 Cindy Court		Englewood	NJ	07631	(276) 673-3707
4	Garrett Mag	83 Gentry Drive		Melville	NY	11747	(521) 333-7762
5	Carie Max Stores	236 Stanton Street		Brookline	MA	02446	(180) 351-8977
6	Mason Homes	587 Nathan Hale Road		Bonita Springs	FL	34134	(638) 895-7446
7	Bank of New York	2461 Riverside Dr.	Apt. 9079	New York	NY	10002	(123) 720-9779
8	Weitzman Construction	442 W. 98th St #886		New York	NY	10009	(736) 854-3262
9	Lambert Homes	841 Central Park West	Apt. 774	St Davids	PA	19087	(139) 523-8779
10	Rubin Sands	134 Iven Avenue	Suite 2E	New York	NY	10024	(386) 634-8851
11	Rags to Riches Inc.	9739 85th Street		New York	NY	10003	(571) 811-5584
12	Jett Lee Sales	918 Central Ave. #313		Christiansted	VI	00823	(841) 332-7923
13	HallMark Rentals	Livio Andronico 22		New York	NY	10025	(534) 289-1364
14	Jenkinson Loan	8 Sundance Drive	Main Road	Mason	MI	48920	(825) 281-8880
15	Minnick Lands	80 Hudson Street	Suite 159	Bellevue	WA	98004	(803) 918-7430
16	Walker Floors	794 A Fairmont Ave.		Hoboken	NJ	07030	(351) 656-8438
17	Davis Lodge	492 Locust Road		Charlotte	NC	28204	(164) 963-3123
18	Richman Buick	PO BOX 4971		Boulder	CA	80302	(131) 664-3716
19	Daly Autobody	4388 Folsom Street	Suite 673	Santa Clara	CA	95050	(642) 915-9286
20	Harbor Spa & Wellness	1220 Bay St		San Francisco	CA	94123	(415) 555-0127
21	Silver Lake Interiors	4411 Sunset Blvd	Suite 210	Los Angeles	CA	90027	(323) 555-0142
22	Mission Coffee Roasters	329 Valencia St		San Francisco	CA	94103	(415) 555-0199
23	Citrus Grove Markets	7800 Orangewood Ave		Anaheim	CA	92802	(714) 555-0177
24	Pacific Crest Builders	9455 La Jolla Shores Dr	Floor 3	La Jolla	CA	92037	(858) 555-0114
25	Gold Rush Storage	2150 J St	Unit B	Sacramento	CA	95816	(916) 555-0161
26	Sierra Cycle Co.	118 N Van Ness Ave		Fresno	CA	93721	(559) 555-0150
27	Redwood Outfitters	701 4th St	Suite 120	Santa Rosa	CA	95404	(707) 555-0106
28	Coastal Creative Media	18881 Von Karman Ave	Suite 500	Irvine	CA	92612	(949) 555-0185
29	South Bay Dental Group	2505 El Camino Real	Suite 2B	Redwood City	CA	94063	(650) 555-0134

---

CODE FOLLOWS

<?php
error_reporting(E_ALL);

include('includes/header.php');    // header / Back button
include('includes/open-db.php');   // opens $con (mysqli)
?>

    <h1>Search Clients</h1>

    <form method="get" action="">
        <label for="field">Search by</label>
        <select id="field" name="field">
            <?php
            // whitelist columns
            $allowed = [
                'name'  => 'Name',
                'city'  => 'City',
                'state' => 'State',
                'zip'   => 'Zip',
                'phone' => 'Phone'
            ];
            $field = (isset($_GET['field']) && isset($allowed[$_GET['field']]))
                ? $_GET['field']
                : 'name';

            foreach ($allowed as $col => $label) {
                echo '<option value="'.$col.'"'.($field === $col ? ' selected' : '').'>'.$label.'</option>';
            }
            ?>
        </select>

        <label for="q" style="margin-left:12px;">Text</label>
        <input type="text" id="q" name="q"
               value="<?= isset($_GET['q']) ? htmlspecialchars($_GET['q']) : '' ?>" />

        <button type="submit">Search</button>
    </form>

    <hr />

<?php
// ---------- SEARCH RESULTS ----------
$term = isset($_GET['q']) ? trim($_GET['q']) : '';

if ($term !== '') {

    $safe = mysqli_real_escape_string($con, $term);

    if ($field === 'state') {
        $where = "state = '" . strtoupper($safe) . "'";
    } else {
        $where = "$field LIKE '%$safe%'";
    }

    $sql = "
    SELECT id, name, address1, address2, city, state, zip, phone
    FROM clients
    WHERE $where
    ORDER BY name ASC
  ";

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

    if (!$result) {
        echo '<p class="red">Query failed: '
            . htmlspecialchars(mysqli_error($con)) . '</p>';
    } else {
        $count = mysqli_num_rows($result);
        echo '<p>Found ' . (int)$count . ' record(s).</p>';
        ?>

        <table class="full" style="width:100%;border-collapse:collapse;">
            <tr>
                <td colspan="8" class="header2">SEARCH RESULTS</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';
                    ?>
                    <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 matches found.</td></tr>';
            }
            ?>
        </table>

        <?php
    }
}
?>

    <hr />

    <h2>The following are All the Records in the Clients Table</h2>

<?php
// ---------- FULL TABLE  ----------
$sqlAll = "
  SELECT id, name, address1, address2, city, state, zip, phone
  FROM clients
  ORDER BY id ASC
";

$resultAll = mysqli_query($con, $sqlAll);

if (!$resultAll) {
    echo '<p class="red">Query failed: '
        . htmlspecialchars(mysqli_error($con)) . '</p>';
} else {
    ?>
    <table class="full" style="width:100%;border-collapse:collapse;">
        <tr>
            <td colspan="8" class="header2">ALL RECORDS</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
        $i = 0;
        while ($row = mysqli_fetch_assoc($resultAll)) {
            $cls = ($i % 2 === 0) ? 'rowA' : 'rowB';
            ?>
            <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++;
        }
        ?>
    </table>
    <?php
}
?>

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


---