Back

Pull All Records from a Database Table (i.e., clients table)

RECORDS
ID	Name	Address 1	Address 2	City	State	Zip	Phone
1	Gorman Place			New Haven	CT	06510	(336) 902-1538
2	Lavaysse Circus			San Mateo	CA	94402	(211) 107-2844
3	Weisman Oil			Englewood	NJ	07631	(276) 673-3707
4	Garrett Mag			Melville	NY	11747	(521) 333-7762
5	Carie Max Stores			Brookline	MA	02446	(180) 351-8977
6	Mason Homes			Bonita Springs	FL	34134	(638) 895-7446
7	Bank of New York			New York	NY	10002	(123) 720-9779
8	Weitzman Construction			New York	NY	10009	(736) 854-3262
9	Lambert Homes			St Davids	PA	19087	(139) 523-8779
10	Rubin Sands			New York	NY	10024	(386) 634-8851
11	Rags to Riches Inc.			New York	NY	10003	(571) 811-5584
12	Jett Lee Sales			Christiansted	VI	00823	(841) 332-7923
13	HallMark Rentals			New York	NY	10025	(534) 289-1364
14	Jenkinson Loan			Mason	MI	48920	(825) 281-8880
15	Minnick Lands			Bellevue	WA	98004	(803) 918-7430
16	Walker Floors			Hoboken	NJ	07030	(351) 656-8438
17	Davis Lodge			Charlotte	NC	28204	(164) 963-3123
18	Richman Buick			Boulder	CA	80302	(131) 664-3716
19	Daly Autobody			Santa Clara	CA	95050	(642) 915-9286
20	Harbor Spa & Wellness			San Francisco	CA	94123	(415) 555-0127
21	Silver Lake Interiors			Los Angeles	CA	90027	(323) 555-0142
22	Mission Coffee Roasters			San Francisco	CA	94103	(415) 555-0199
23	Citrus Grove Markets			Anaheim	CA	92802	(714) 555-0177
24	Pacific Crest Builders			La Jolla	CA	92037	(858) 555-0114
25	Gold Rush Storage			Sacramento	CA	95816	(916) 555-0161
26	Sierra Cycle Co.			Fresno	CA	93721	(559) 555-0150
27	Redwood Outfitters			Santa Rosa	CA	95404	(707) 555-0106
28	Coastal Creative Media			Irvine	CA	92612	(949) 555-0185
29	South Bay Dental Group			Redwood City	CA	94063	(650) 555-0134

CODE FOLLOWS


<?php



error_reporting(E_ALL);    // set error reporting to all

include('includes/header.php');

$con = '';



?>

<h1>Pull All Records from a Database Table (i.e., clients table)</h1>



<table class="full">        <!-- start of table -->

    <tr>

        <th colspan=8 class="header1">

            RECORDS

        </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



    // get all records from the 'clients' table from the database



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



    // SQL for selecting all records from the clients table where their id is > 0



    $query = "SELECT * FROM clients WHERE id > '0' ";

    $result = mysqli_query($con, $query) or die("Could not get data: $query " . mysqli_error());



    // pull out and display those records



    $i = 0;

    while ($row = mysqli_fetch_array($result))

    {

        $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'];

        ?>



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

            <td>

                <?php echo($id); ?>

            </td>

            <td>

                <?php echo($name); ?>

            </td>

            <td>

                <?php echo($address_1); ?>

            </td>

            <td>

                <?php echo($address_2); ?>

            </td>

            <td>

                <?php echo($city); ?>

            </td>

            <td>

                <?php echo($state); ?>

            </td>

            <td>

                <?php echo($zip); ?>

            </td>

            <td>

                <?php echo($phone); ?>

            </td>

        </tr>



        <?php

    }

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

    ?>



</table>



<hr>



<?php



include('includes/footer.php');

?>

Back