Insert into table from array

[Rachel]

I am trying to insert records from an foreach array, it only inserts the first record and I cannot work out how to get it to loop through all of the records.

 

Thank you

 

foreach($_SESSION['post_data_array'] AS $seat) {
     $rowId = substr($seat, 0, 1);
     $columnId = substr($seat, 1);
      echo $rowId . $columnId . ", "; 
}

$sql125 = "INSERT INTO booked_seats(booking_id, row_id, column_id) values ('$book_id', '$rowId', '$columnId')";
$result125 = mysql_query($sql125);
if ($result125)
	{
		echo "worked";
	}
else
	{
		echo "didnt work";
	}			

[PaulRyan]

Place the SQL statement inside of the Foreach loop.

 

Regards, PaulRyan.

[Pikachu2000]

Running a query in a loop is resource intensive and should be avoided whenever possible. Build the query string in a loop, then execute one query.

[jcbones]

Try something like: (Pik's suggestion)

foreach($_SESSION['post_data_array'] AS $seat) {
     $rowId = substr($seat, 0, 1);
     $columnId = substr($seat, 1);
      echo $rowId . $columnId . ", "; 
  $sql[] = "('$book_id', '$rowId', '$columnId')";
}

$sql125 = "INSERT INTO booked_seats(booking_id, row_id, column_id) values " . implode(',',$sql);