looping through multi array

Question

I am having a hard time looping through the following array -

array("newProduct"=>array('rmsId' => '123456789','departmentName' => 'Britax','categoryName' => 'Car Seat','productName' => 'Test Product For Britax Car Seat','productPrice' => 33.99,'productQty' => 10),
      "newProduct"=>array('rmsId' => '987654321','departmentName' => 'Stokke','categoryName' => 'Highchairs','productName' => 'Test Product For Stokke Highchair','productPrice' => 83.99,'productQty' => 20),
      "newProduct"=>array('rmsId' => '13579','departmentName' => 'Maclaren','categoryName' => 'Buggy','productName' => 'Test Product For Maclaren Buggy','productPrice' => 183.99,'productQty' => 5)
                );

Can someone set me off on the right track to achieving this? My goal is to add each into a MySQL db

Thanks

Another Code · Accepted Answer · 2012-03-02 11:05:45Z

2

You array is invalid; a key can only exist once. You should probably make numeric indexes, then loop through it with foreach().

answered Mar 2, 2012 at 11:05

Another Code

3,14123 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

P. Galbraith · Accepted Answer · 2012-03-02 11:07:48Z

Firstly you need to give each array key a unique identifier. Then you can loop through them.

$items = array(
               "product1"=>array('rmsId' => '123456789','departmentName' => 'Britax','categoryName' => 'Car Seat','productName' => 'Test Product For Britax Car Seat','productPrice' => 33.99,'productQty' => 10),
               "product2"=>array('rmsId' => '987654321','departmentName' => 'Stokke','categoryName' => 'Highchairs','productName' => 'Test Product For Stokke Highchair','productPrice' => 83.99,'productQty' => 20),
               "product3"=>array('rmsId' => '13579','departmentName' => 'Maclaren','categoryName' => 'Buggy','productName' => 'Test Product For Maclaren Buggy','productPrice' => 183.99,'productQty' => 5)
                );

foreach($items as $product) {
   echo $product['rmsId'];
   echo $product['departmentName'];
   // ... and so on
}

Milap · Accepted Answer · 2012-03-02 11:13:07Z

Try out this one :-

<?php
$var = array("0"=>array('rmsId' => '123456789','departmentName' => 'Britax','categoryName' => 'Car Seat','productName' => 'Test Product For Britax Car Seat','productPrice' => 33.99,'productQty' => 10),
      "1"=>array('rmsId' => '987654321','departmentName' => 'Stokke','categoryName' => 'Highchairs','productName' => 'Test Product For Stokke Highchair','productPrice' => 83.99,'productQty' => 20),
      "2"=>array('rmsId' => '13579','departmentName' => 'Maclaren','categoryName' => 'Buggy','productName' => 'Test Product For Maclaren Buggy','productPrice' => 183.99,'productQty' => 5)
                );
          foreach ($var as $key=>$val) {
            $id = $val['rmsId'];
            $dname = $val['departmentName'];
            $cname = $val['categoryName'];
            $pname = $val['productName'];
            $price = $val['productPrice'];
            $qnt = $val['productQty'];
         $query = mysql_query("INSERT INTO TABLENAME (rmsId,departmentName,categoryName,productName,productPrice,productQty) VALUE(".$id.",".$dname.",".$cname.",".$pname.",".$price.",".$qnt.")");
           }
?>

Poonam · Accepted Answer · 2012-03-02 11:17:38Z

$array = array(array('rmsId' => '123456789','departmentName' => 'Britax','categoryName' => 'Car Seat','productName' => 'Test Product For Britax Car Seat','productPrice' => 33.99,'productQty' => 10),
      array('rmsId' => '987654321','departmentName' => 'Stokke','categoryName' => 'Highchairs','productName' => 'Test Product For Stokke Highchair','productPrice' => 83.99,'productQty' => 20),
      array('rmsId' => '13579','departmentName' => 'Maclaren','categoryName' => 'Buggy','productName' => 'Test Product For Maclaren Buggy','productPrice' => 183.99,'productQty' => 5)
                );


foreach($array as $value){
    $query = "insert into (columnname,columnname) values (".$value['rmsId'].",'".$value['departmentName']."')";
    //fire query

}

assuming your array format as shown Your array stucture is not proper,try as shown

Collectives™ on Stack Overflow

looping through multi array

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related