PHP - foreach how to store the array to mysql

Question

I want to store array into mysql db something like this

item_row  = nike,adidas,puma
qty_row   = 1,3,2
total_row = 100,200,150

foreach

  foreach ($_SESSION['order'] as $values) {
      $item_name = $values['item-name'];
      $item_qty = $values['item-qty'];
      $item_price = $values['item-price'];
  }

Let me know how to do that?

update

  foreach ($_SESSION['order'] as $values) {
      $item_name[] = $values['item-name'];
      $item_qty[] = $values['item-qty'];
      $item_price[] = $values['item-price'];
  }

  $item_row = implode(",", $item_name);
  $qty_row = implode(",", $item_qty);
  $total_row = implode(",", $item_price);

Answer 1

item_row = implode(',', $_SESSION['order']['item-name']);
qty_row = implode(',', $_SESSION['order']['item-qty']);
total_row = implode(',', $_SESSION['order']['item-price']);

Answer 2

foreach ($_SESSION['order'] as $values) {

 mysql_query('INSERT INTO tablename (name, qty, price) VALUES("'.$values['item-name'].'", "'.$values['item-qty'].'", "'.$values['item-price'].'"');
}

Answer 3

Hi bob!!

I'm using a class to manage the connection to the data base and the query execution let me add it to you:

class DbConnection
{
var $ReturnQuery;
function Connect()
{
 $connection = mysql_connect("serverName", "user", "password");
 $DbSelect = mysql_select_db("databaseName", $connection);
 if ($DbSelect)
  return true;
 else
  return false;
}
function Execute($Query)
{
 $ExecuteQuery = mysql_query($Query);
 $affected = mysql_affected_rows();
 if ($affected != -1)
 {
  if ($affected != 0)
  {
      if ($ExecuteQuery != 1)
      {
          while($row=mysql_fetch_assoc($ExecuteQuery))
       {
        $ResulArray[] = $row;
       }
       $this->ReturnQuery = $ResulArray;
      }
   return 1;
  }
  else
  {
      $this->ReturnQuery = '';
      return 0;

  }
 }
 else
 {
     $this->ReturnQuery = '';
  return -1;
 }
}

}

and then you can create instances to execute your query:

require_once('Includes/DbConnection.php');
 $this->db = new DbConnection();
 $this->db->Connect();

$query = "insert into items (item_name, item_qty, item_price) values ('".$item_name."', '".$item_qty."', '"$item_price"');

$query_safe = mysql_real_escape_string($query);
$this->db->Execute($query_safe);

I hope it helps!!

Regards from Guadalajara Mexico!!