Insert Multiple Records to One Table Error

[toad78]

How can I insert multiple rows of records to go to just the one table in a database? I understand I need to use 'foreach', so I created the below, but get the following error: Notice: Undefined index: office_date, office_ho in C:\htdocs\wvgymnastics\admin\info\office_info_insert.php on line 38

Warning: Invalid argument supplied for foreach() in C:\htdocs\wvgymnastics\admin\info\office_info_insert.php on line 38

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  foreach($_POST['office_date, office_ho'] as $s){
  $insertSQL = sprintf("INSERT INTO office (office_date, office_ho) VALUES (%s, %s)",
                       GetSQLValueString($_POST['office_date'], "text"),
                       GetSQLValueString($_POST['office_ho'], "text"));
 
  mysql_select_db($database_wvgsadmin, $wvgsadmin);
  $Result1 = mysql_query($insertSQL, $wvgsadmin) or die(mysql_error());
 
  $insertGoTo = "office_info_list.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
}

<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
<table align="center" class="center" id="striped">
<tr valign="baseline">
<td nowrap align="right">Date:</td>
<td><input type="text" name="office_date" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Hours:</td>
<td><input type="text" name="office_ho" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Date:</td>
<td><input type="text" name="office_date" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Hours:</td>
<td><input type="text" name="office_ho" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Date:</td>
<td><input type="text" name="office_date" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Hours:</td>
<td><input type="text" name="office_ho" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Date:</td>
<td><input type="text" name="office_date" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Hours:</td>
<td><input type="text" name="office_ho" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Date:</td>
<td><input type="text" name="office_date" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Hours:</td>
<td><input type="text" name="office_ho" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">&nbsp;</td>
<td><input type="submit" value="Insert record"></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>

Thank you!

[symbol.software]

Hi,

$_POST['office_date, office_ho']... your index is invalid..
can be either office_date or office_ho but not in the same time

[imaginethis]

foreach($_POST['office_date, office_ho'] as $s) is the problem. Your $_POST array doesn't have an index named office_date,office_ho. If you are looking to make an array using office_date and office_ho you can just do foreach(array($_POST['office_date'], $_POST['office_ho']) as $s)

[toad78]

Okay. What do you suggest?

[Cups]

simply do:

foreach($_POST['office_date'] as $s){

unless you have office_date's blank, but office_ho's with values ...

[symbol.software]

Okay. What do you suggest?

We help you with syntax.. you go with the logic part

[toad78]

I'll need both office_date and office_ho.

[imaginethis]

foreach(array($_POST['office_date'], $_POST['office_ho']) as $s) 

>.>

[toad78]

Thank you. I finally got it panned out, with your help!

I love this place!
toad78

[r937]

i don't do php so i'm not sure i understood your script correctly, but it appears that you are generating a series of INSERT statements like this --

INSERT INTO office (office_date, office_ho) VALUES ('2009-01-25', 123);
INSERT INTO office (office_date, office_ho) VALUES ('2009-01-26', 456);
INSERT INTO office (office_date, office_ho) VALUES ('2009-01-27', 937);

it is substantially more efficient if you generate just one single INSERT statement like this --

INSERT INTO office (office_date, office_ho) VALUES
('2009-01-25', 123)
, ('2009-01-26', 456)
, ('2009-01-27', 937);

you just need to tweak your loop a little (although i cannot tell you exactly how)