Help with Warning: Invalid argument supplied for foreach()

[bambinou1980]

Hello,

 

Here is my code, I am getting the error:

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\food\admin\crud\orders\index.php on line 97

 

This line corresponds to            foreach( $product_name as $key => $n ) {

I am not understanding why the $product_name is not working.

 

Normally you should get a form with one product per line, front of each product, 3 prices.

I am trying to get all the dynamic info from the generated field into an $_POST but I struggle....

 

<?php ob_start();session_start();$admin_permission = $_SESSION['admin_permission'];if(($admin_permission) == 1){//Session admin ID equal 1}else{header('Location: http://' . $_SERVER['HTTP_HOST'] . '/index.php');exit();}?><?php include($_SERVER["DOCUMENT_ROOT"] . "/admin/includes/admin-header.php"); ?>    <!--Content--> <div class="container-fluid"><div class="row"><div class="col-md-12"><div class="row"><div class="col-md-3"></div><div class="col-md-6"><h3>Create an Order</h3>  <?php  // detect form submissionif (isset($_POST['submit'])) {// set default values using ternary operator//   boolean_test ? value_if_true : value_if_false//It means if $_POST['username'] isset "set it to" $_POST['username'] "or set it to" to "empty"$name = isset($_POST['name']) ? $_POST['name'] : "";$surname = isset($_POST['surname']) ? $_POST['surname'] : "";$company = isset($_POST['company']) ? $_POST['company'] : "";   $address = isset($_POST['address']) ? $_POST['address'] : "";$phone = isset($_POST['phone']) ? $_POST['phone'] : "";$email = isset($_POST['email']) ? $_POST['email'] : "";$vat = isset($_POST['vat']) ? $_POST['vat'] : "";  // Escape all strings           $name = mysqli_real_escape_string($connection, $name);$surname = mysqli_real_escape_string($connection, $surname);$company = mysqli_real_escape_string($connection, $company);$address = mysqli_real_escape_string($connection, $address);$phone = mysqli_real_escape_string($connection, $phone);$email = mysqli_real_escape_string($connection, $email);$vat = mysqli_real_escape_string($connection, $vat);           // 2. Perform database query           $query  = "INSERT INTO customers (cust_name,cust_surname,cust_company,cust_address,cust_phone,cust_email,cust_vat) VALUES ('{$name}','{$surname}','{$company}','{$address}','{$phone}','{$email}','{$vat}')";           $result = mysqli_query($connection, $query);      if ($result) {// Success                 header("Location: list-customers.php");    } else {// Failure// $message = "Subject creation failed";die("Database query failed. " . mysqli_error($connection));header("Location: index.php");    }  } else {$name = "";$surname = "";$company = "";$address = "";$phone = "";$email = "";$vat = "";}?> <?php  $random_number = rand(999 ,99999999999 );/* $str will now be a string with the value "Glue This Into A String Please" */ ?>  <?php $_POST['product_name'] = "";                        $_POST['product_price'] = "";$product_name = $_POST['product_name'];                        $product_price = $_POST['product_price'];                         foreach( $product_name as $key => $n ) {                        print "The product name is ".$n." and the price 1 is ".$product_price1[$key]."\n";                        }?>     <form role="form" method="post" action="index.php">       <div class="form-group"><label for="order_id">Order ID</label><input type="text" name="cust_order_id" class="form-control" value="<?php echo "FP" .$random_number; ?>" readonly="readonly" /></div>     <div class="form-group"><label for="name_id">Company *</label> <select name="cust_company" class="form-control" id="cust_company_id">                        <?php $query_field1 = "SELECT * FROM customers ORDER BY cust_company desc";                        $result_field1 = mysqli_query($connection, $query_field1) or die (mysqli_error());$number1 = 0;                        $number2 = 0;                        $number3 = 0;                        while($row_field1 = mysqli_fetch_array($result_field1)){$cust_name = htmlspecialchars($row_field1['cust_name']);$cust_surname =  htmlspecialchars($row_field1['cust_surname']);$cust_company =  htmlspecialchars($row_field1['cust_company']);                        $cust_address = htmlspecialchars($row_field1['cust_address']);                        $cust_phone =  htmlspecialchars($row_field1['cust_phone']);                        $cust_email =  htmlspecialchars($row_field1['cust_email']);                        $cust_vat =  htmlspecialchars($row_field1['cust_vat']);?>   <option value="<?php echo $cust_company; ?>" data-name="<?php echo $cust_name; ?>" data-surname="<?php echo $cust_surname; ?>" data-address="<?php echo $cust_address; ?>" data-phone="<?php echo $cust_phone; ?>" data-email="<?php echo $cust_email; ?>" data-vat="<?php echo $cust_vat; ?>"><?php echo $cust_company; ?></option>                        <?php } ?>   </select>                     </div> <div class="form-group"><label for="address_id">Address *</label><textarea name="cust_address" placeholder="Company's Address" rows="4" cols="50" class="form-control" readonly="readonly" ></textarea></div> <div class="form-group"><label for="name_id">Name *</label><input type="text" name="cust_name" placeholder="Customer Name" class="form-control" value="" readonly="readonly" /></div>                                                <div class="form-group"><label for="surname_id">Surname *</label><input type="text" name="cust_surname" placeholder="Customer Surname" class="form-control" value=""  readonly="readonly" /></div> <div class="form-group"><label for="phone_id">Phone</label><input type="text" name="cust_phone" placeholder="Customer Phone" class="form-control" value=""  readonly="readonly" /></div> <div class="form-group"><label for="email_id">Email</label><input type="email" name="cust_email" placeholder="Customer Email" class="form-control" value=""  readonly="readonly" /></div> <div class="form-group"><label for="vat_id">V.A.T Number(ie:MT20343324)</label><input type="text" name="cust_vat" placeholder="V.A.T Number"  class="form-control" value="" readonly="readonly" /></div>                                                 <div class="form-group"><label for="due_date_id">Due Date *</label><div class="form-inline well">                            <div class="input-append date" id="dp3" data-date="12-02-2012" data-date-format="dd-mm-yyyy">                              <input name="due_date" class="form-control" size="25" type="text" id="dp1" value="12-02-2012">                                <span class="add-on"><i class="icon-th"></i></span></div>                            </div>                        </div>  <script>$('#dp1').datepicker({          format: 'dd-mm-yyyy'           });</script>  <?php //Query all the prices $query_field2 = "SELECT * FROM products ORDER BY name desc";                        $result_field2 = mysqli_query($connection, $query_field2) or die (mysqli_error());$id_1 = 0;$id_2 = 0;$id_3 = 0;$quantity = 0;                          while($row_field2 = mysqli_fetch_array($result_field2)){$name = htmlspecialchars($row_field2['name']);$price1 = htmlspecialchars($row_field2['price1']);$price2 = htmlspecialchars($row_field2['price2']);$price3 = htmlspecialchars($row_field2['price3']);  ?><div class="form-inline well"><label for="product1_id">Choose Product <?php echo ++$number1; ?></label><div class="form-group">                        <input name="product_name" type="text" class="form-control" value="<?php echo $name; ?>" disabled>                          <!--Price 1-->                        <label class="btn btn-default">                        <input type="radio" name="product_price" value="<?php echo $price1;?>" id="<?php echo ++$id_1; ?>" />€ <?php echo $price1; ?>                        </label>                         <!--Price 1-->                         <!--Price 2--> <?php   //Do not show second price if not setif(($price2) != null) {echo "<label class=\"btn btn-default\">                        <input type=\"radio\" name=\"product_price\" value=\"{$price2}\" id=\"".(++$id_2)."\" /> € {$price2}                        </label>";} ?>                        <!--Price 2-->                     <!--Price 3--> <?php                        //Do not show third price if not setif(($price3) != null) {echo "<label class=\"btn btn-default\">                        <input type=\"radio\" name=\"product_price\" value=\"{$price3}\"  id=\"".(++$id_3)."\" /> € {$price3}                        </label>";} ?>                        <!--Price 3-->  <label for="product1_id">Qty</label><input name="<?php echo "quantity".++$quantity; ?>" type="text" class="form-control" maxlength="4" size="4"> </div> </div><?php } ?>                        <div class="form-inline well text-center"><button type="submit" name="submit" class="btn btn-success btn-lg">Create Order</button></div></div> </form>                    </div> </div></div></div></div> <script>      $('#cust_company_id').change(function() {    selectedOption = $('option:selected', this);    $('textarea[name=cust_address]').val( selectedOption.data('address') );$('input[name=cust_name]').val( selectedOption.data('name') );$('input[name=cust_surname]').val( selectedOption.data('surname') );    $('input[name=cust_phone]').val( selectedOption.data('phone') );    $('input[name=cust_email]').val( selectedOption.data('email') );    $('input[name=cust_vat]').val( selectedOption.data('vat') );}); </script>                                              <!--Content--><?php  // 5. Close database connection if(isset($connection)){ mysqli_close($connection);} ob_flush();?>
 <?php include($_SERVER["DOCUMENT_ROOT"] . "/admin/includes/admin-footer.php"); ?>
 
 

[scootstah]

It doesn't work because $_POST['product_name'] is a string and not an array.