On the following page I want the user to input a last name and pull that data and POST the results into the form below. I think one of my problems is I shouldn't have a foreach and it should just be an echo. Also, does anyone have any tips for me, I've been stuck on this for a couple days and can't solve it.

CUSTOMER_SEARCH.PHP:

PHP Code:
<?php include '../view/header.php'?>

<div id="main">
            <h1>Customer Search</h1>
            
            
                <div id="content">
      <form action="." method="post" id="aligned"
              <input type="hidden" name="action" value="get_customers" />
            <label>Last Name</label>
            <input type="text" name="last_name" />
            <br />
            <label>&nbsp;<label>
            <input type="submit" value="Search" />
         
         
                </div>
            <div id="content">
          <h2>Results</h2>
          
            <table>
            <tr>
                <th>Name</th>
                <th>Email Address</th>
                <th>City</th>
                <th>&nbsp;</th>
            </tr>
         <?php foreach ($customers as $customer) :?>
            <tr>
                <td><?php echo $customer['firstName'] .' '$customer['lastName']; ?></td>
                <td><?php echo $customer['email']; ?></td>
                <td><?php echo $customer['city']; ?></td>
                <td><form action="customer_display.php" method="post">
                    <input type="hidden" name="action" value="get_customer" />
                    <input type="hidden" name="customer_id"
                           value="<?php echo $customer['customer_ID']; ?>" />
                    <input type="submit" value="Select" />
            
                </form>
           <?php endforeach;?>
The customer_db.php page:

PHP Code:
<?php
function get_customers() {
    global 
$db;
    
$query 'SELECT * FROM customers
                ORDER BY lastName'
;
    
$customers $db->query($query);
        return 
$customers;
}

function 
get_customers_by_last_name($last_name) {
    global 
$db;
    
$query "SELECT * FROM customers
            WHERE lastName = '
$last_name'
            ORDER BY lastName"
;
    
$customers $db->query($query);
    return 
$customers;
}

function 
get_customer($customer_id) {
    global 
$db;
    
$query "SELECT * FROM customers
            WHERE customerID = '
$customer_id'";
    
$customers $db->query($query);
        return 
$customers;
}

function 
get_customer_by_email($email) {
    global 
$db;
    
$query "SELECT * FROM customers
            WHERE email = '
$email'";
        
$customers $db->query($query);
        return 
$customers;
              
}

function 
delete_customer($first_name) {
    global 
$db;
    
$query "DELETE FROM customers
                WHERE firstName = '
$first_name'";
        
$db->exec($query);
}

function 
add_customer($first_name$last_name$address$city$state$postal_code$country_code,
                    
$phone$email$password) {
        global 
$db;
        
$query "INSERT INTO customers
                (firstName, lastName, address, city, state, postalCode, countryCode,
                phone, email, password)
            VALUES ('
$first_name', '$last_name', '$address', '$city', '$state', '$postal_code', '$country_code',
                    '
$phone', '$email', '$password')";
        
$db->exec($query);
}

function 
update_customer($customer_id$first_name$last_name$address$city$state$postal_code$country_code,
                    
$phone$email$password) {
        global 
$db;
        
$query "UPDATE customers
                SET firstName = '
$first_name'
                    lastName = '
$last_name'
                    address = '
$address'
                    city = '
$city'
                    state = '
$state'
                    postalCode = '
$postal_code'
                    countryCode = '
$country_code'
                    phone = '
$phone'
                    email = '
$email'
                    password = '
$password'
                WHERE customerID = '
$customer_id'";
        
$db->exec($query);
}
?>
This is the customer_display.php page which when the user SELECTS the results will display the CUSTOMER data. I'm just not sure how to fix this. Any help is appreciated, thanks guys.

PHP Code:
<?php include '../view/header.php'?>
<div id="main">

    <div id="content">
        <!-- display a table of customer info. -->
        <h2>View/Update Customer</h2>
                
        <form action="customer_display.php" method="post" id="aligned">
                    <input type="hidden" name="action" value="add_customer" />
        
                   
        <label>First Name:</label>
        <input type="text" name="first_name" /> <br />
        
        <label>Last Name:</label>
        <input type="text" name="last_name" value="<?php echo $customer['lastName'];?>" /> <br />
        
        <label>Address:</label>
        <input type="text" name="address" value="<?php echo $customer['address'];?>" /> <br />
        
        <label>City:</label>
        <input type="text" name="city" value="<?php echo $customer['city'];?>"/><br />
        
        <label>State:</label>
        <input type="text" name="state" value="<?php echo $customer['state'];?>"/><br />
        
        <label>Postal Code:</label>
        <input type="text" name="postal_code" value="<?php echo $customer['postalCode'];?>"/><br />
        
        <label>Country Code:</label>
        <input type="text" name="country_code" value="<?php echo $customer['countryCode'];?>"/><br />
        
        <label>Phone:</label>
        <input type="text" name="phone"  value="<?php echo $customer['phone'];?>"/><br />
        
        <label>Email:</label>
        <input type="text" name="email" value="<?php echo $customer['email'];?>"/><br />
        
        <label>Password:</label>
        <input type="text" name="password" value="<?php echo $customer['password'];?>"/><br />
        
        <label>&nbsp;</label>
        <input type="submit" name="action" value="Update Customer" />
        <br />
            </form>
    <p><a href="index.php">Search Customers</a></p>
</div>

</div>
<?php include '../view/footer.php'?>
Here's the INDEX.PHP

PHP Code:
<?php
require('../model/database.php');
require(
'../model/customer_db.php');


if (isset(
$_POST['action'])) {
    
$action $_POST['action'];
} else if (isset(
$_GET['action'])) {
    
$action $_GET['action'];
} else {
    
$action 'list_customers';
}

if (
$action == 'list_customers') {
    
$customers get_customers();


    
// Display the customer list
    
include('customer_search.php');
} else if (
$action == 'delete_customer') {
    
$customer_id $_POST['customer_id'];
    
delete_customer($customer_id);
    
header("Location: .");
} else if (
$action == 'show_add_form') {
        
$customers get_customers();
    include(
'customer_display.php');
} else if (
$action == 'add_customer') {
    
$first_name $_POST['firstName'];
    
$last_name $_POST['lastName'];
    
$address $_POST['address'];
    
$city $_POST['city'];
        
$state $_POST['state'];
        
$postal_code $_POST['postalCode'];
        
$country_code $_POST['countryCode'];
        
$phone $_POST['phone'];
        
$email $_POST['email'];
        
$password $_POST['password'];
        


    
// Validate the inputs
    
if (empty($first_name) || empty($last_name) || empty($address) || empty($city) || empty($state
        || empty(
$postal_code) || empty($country_code) || empty($phone) || empty($email
        || empty(
$password)) {
        
$error "Invalid product data. Check all fields and try again.";
        include(
'../errors/error.php');
    } else {
        
add_customer($first_name$last_name$address$city$state$postal_code$country_code$phone,
        
$email$password);
        
header("Location: .");
    }
}
?>