Jenna's PHP Example

Back

California Clients

The following are all records from the contacts table where the state is California (CA).

Id	First Name	Last Name	Address	City	State	Zip	Phone
2	Lavaysse	Circus	27 Woodland Avenue	San Mateo	CA	94402	(211) 107-2844
21	Anne	Oaks	1941 aberdeen way	Davis	CA	95616	(143) 275-2569
26	Richman	Blue	PO BOX 4971	Boulder	CA	80302	(131) 664-3716
27	Ann	Arms	4388 Folsom Street, Suite 673	Santa Clara	CA	95050	(642) 915-9286

CODE FOLLOWS


<?php

error_reporting(E_ALL);

$db_name = '';
$con = '';

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

// pull field names from the table
$field = array();
$field_text = array();

$query = "SHOW COLUMNS FROM contacts FROM $db_name";
$result = mysqli_query($con, $query) or die(report($query, __LINE__, __FILE__));

while ($row = mysqli_fetch_array($result))
{
    $a = $row[0];
    $field[] = $a;
    $a = str_replace('_', ' ', $a);
    $field_text[] = ucwords($a);
}
?>

<h2>California Clients</h2>

<p>The following are all records from the contacts table where the state is California (CA).</p>

<table class="full">

    <tr class="header2">
        <?php
        foreach ($field_text as $field_name)
        {
            echo("<th>$field_name</th>");
        }
        ?>
    </tr>

    <?php

    $query = "SELECT * FROM contacts WHERE state = 'CA' ORDER BY id asc";
    $result = mysqli_query($con, $query) or die(report($query, __LINE__, __FILE__));

    if (mysqli_num_rows($result) > 0)
    {
        $i = 0;

        while ($row = mysqli_fetch_array($result))
        {
            $id = $row['id'];
            $first_name = $row['first_name'];
            $last_name = $row['last_name'];
            $address = $row['address'];
            $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($first_name); ?></td>
                <td><?php echo($last_name); ?></td>
                <td><?php echo($address); ?></td>
                <td><?php echo($city); ?></td>
                <td><?php echo($state); ?></td>
                <td><?php echo($zip); ?></td>
                <td><?php echo($phone); ?></td>
            </tr>

            <?php
        }
    }
    else
    {
        echo('<tr><td class="red center" colspan="8">NO CALIFORNIA RECORDS FOUND!</td></tr>');
    }

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

</table>

<div class="clear">
    <hr>
</div>

<?php
include('../includes/footer.php');
?>

Back