Back

California Records (from Database)

This table shows all of the records from the database that have California as the state

Pulled Records
ID	NAME	ADDRESS 1	ADDRESS 2	CITY	STATE	ZIP	PHONE NUMBER
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

error_reporting(E_ALL);



include("includes/header.php");



$con = '';

?>

<h1>California Records (from Database)</h1>

<h2>This table shows all of the records from the database that have California as the state</h2>

<table class="full">

    <tr>

        <th colspan="10" class="header1">Pulled 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 NUMBER</th>

    </tr>

<?php

   include("open-db.php");



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

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



$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('close-db.php');    //====== close dB

?>



    </table>



    <hr>

<?php

include("includes/footer.php");

?>







?>

}

Back

?> }