PHP - Foreach Vs While Loop In Pdo Database Retrieval

        // validate input
        $valid = true;
        if (empty($store_name)) {
            $storeNameError = 'Please enter a Store Name';
            $valid = false;
        }

        if (empty($item_description)) {
            $itemDdescriptionError = 'Please enter an Item Description';
            $valid = false;
        }

        if (empty($qty_pkg)) {
            $qtyPkgError = 'Please enter Quantity or Package';
            $valid = false;
        }

        if (empty($pkg_of)) {
            $pkgOfError = 'Please enter the Count/Quantity';
            $valid = false;
        }

    // Create an array of the fields we want to capture, along with their labels
    $fields = array(
        'store_name'=>'Store Name',
        'item_description'=>'Item Description',
        'qty_pkg'=>'Qty / Pkg',
        'pkg_of'=>'Pkg. Of',
        'price'=>'Price',
        'flyer_page'=>'Flyer Page #',
        'limited_time_sale'=>'Limited Time Sale Days',
        'nos_to_purchase'=>'Nos. to Purchase'
    );

    // Create an array-type variable to keep track of validation errors
    $fieldsErrorMsgs = array(
        'storeNameError'=>'Please enter a Store Name',
        'itemDescriptionError'=>'Please enter an Item Description',
        'qtyPkgError'=>'Please enter Qty or Pkg',
        'pkgOfError'=>'Please enter the Qty',
        'priceError'=>'Please enter the Price',
        'flyerPageError'=>'Please enter the Flyer Page #',
        'limitedTimeSaleError'=>'Please enter the Limited Time Sale Days',
        'nosToPurchaseError'=>'Please enter the No(s). to Purchase'
    );

        $valid = true;
        $errors = array();
        
        foreach($fields AS $field=>$label){
            //The following line is using the ternary operator, it's basically a shorthand if/else assignment.  
            $errors[$field] = (!isset($values['store_name']) || !strlen($values['store_name'])) ? $errors[$label] = 'Mandatory field, input required!' : NULL;

            if(!strlen($errors[$label])){
                $valid = false;            
            }
        }  
 
        // insert data
        if ($valid) {
            $pdo = Database::connect();
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $sql = "INSERT INTO shoplist (store_name,item_description,qty_pkg,pkg_of,price,flyer_page,limited_time_sale,nos_to_purchase,shopper1_buy_flag,shopper2_buy_flag,purchased_flag,purchase_later_flag)
                    VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            $q = $pdo->prepare($sql);
            $q->execute(array($store_name,$item_description,$qty_pkg,$pkg_of,$price,$flyer_page,$limited_time_sale,$nos_to_purchase,$initialize_flag,$initialize_flag,$initialize_flag,$initialize_flag));
            Database::disconnect();
            header("Location: index.php");
        }

            <form class="form-horizontal" action="create.php" method="post">            
                <?php
                    foreach($fields AS $field=>$label){
                        //Print the form element for the field.
                        echo "<label>{$label}:<br>";
                        //If the field had an error, display it.
                        if(isset($errors[$field])){
                            echo ' <span class="error">'.$errors[$field].'</span><br>';
                        }
                        //Echo the actual input. If the form is being displayed with errors, we'll have a value to fill in from the user's previous submission.
                        echo '<input type="text" name="'.$field.'"';
                        if(isset($values[$field])){
                            echo ' value="'.$values[$field].'"';
                        }
                        echo '/></label>';
                    }
                ?>
                <div class="form-actions">
                    <button type="submit" class="btn btn-success">Create</button>
                    <a class="btn" href="index.php">Back</a>
                </div>
            </form> 

function displayMenuCategories($menu_category){
        $display_menu ="";
        $category_id =  $menu_category['menu_cat_id'];
        $display_menu .=   "<div class='menu_cat'>{$menu_category['menu_cat_name']}</div><br>\n";
        if(!empty($menu_category['menu_cat_desc'])) {
        $display_menu .= "<div class='menu_desc'>{$menu_category['menu_cat_desc']}</div>\n";
        }


    $category_info = array("display" => $display_menu, "category_id" => $category_id );

    return $category_info;
}

$left_menu_categories // Is the array that contains all the menu categories 

foreach($left_menu_categories as $left_menu_category){

    $get_categories =  displayMenuCategories($left_menu_category);

}
var_dump($get_categories);

Hello. 

I was wondering if anyone could please help with a problem I seem to be having a problem with my foreach loops. I have an array that holds other arrays. When I am trying to populate the database tables with the information in each array, things are going horribly wrong.

This is my code:

$tabledata = $this->db->get('tableinfo');

$i = 0;
$_temp = array();
foreach($tabledata->result() as $row) {
	$data[$i] = $this->callAPI("lateststandings&records=3&category=" . $row->category . "&distance=" . $row->distance_id);
	array_push($_temp, $row->dbname);
	$i++;
}

$j = 0;
foreach($data[$j]['Records']['Record'] as $record) {
	$record['FirstName'] .= " " . $record['LastName'];
	$this->db->replace($_temp[$j], $record);
	$j++;
}

When this is run 2 things are happening:

1) What I am expecting to happen is, there should be 3 rows added to each table. But only 1 is being added to each table.
2) The 3 rows that are being created (1 in each table), are the 3 rows I am expecting to see in the first table.

I am not sure what I am doing wrong in these loops.