Array Help

jeffgman

I am trying to create a form where each line is pulled from a MySQL database with an column for ordered amount. Then when the user hits the submit button, it enters in that data into a new table of the MySQL database and sends an e-mail. I am just trying to create the first page so far. Here is what I have done so far:

  <FORM ACTION=\"misc_order_submit.php\" METHOD=POST>
  	<TABLE BORDER=\"0\">
		<TR>
			<TD width=\"200\"><center><b><u>Description</u></b></center></TD>
			<TD width=\"20\"><center><b><u>Min</u></b></center></TD>
			<TD width=\"20\"><center><b><u>Max</u></b></center></TD>
			<TD width=\"40\"><center><b><u>Pkge Qty</u></b></center></TD>
			<TD width=\"40\"><center><b><u>Order</u></b></center></TD>
		</TR>";
				while (($row=mysql_fetch_array($result))):
					$id=$row["id"];
					$sku=$row["sku"];
					$description=$row["description"];
					$vpc=$row["vpc"];
					$package_qty=$row["package_qty"];
					$location=$row["location"];
					$min=$row["min"];
					$max=$row["max"];
		<TR>
			<TD>";
			print $description;
			echo "</TD>
			<TD>";
			print $min;
			echo "</TD>
			<TD>";
			print $max;
			echo "</TD>
			<TD>";
			print $package_qty;
			echo "</TD>
			<TD><input name=\"order[$id]\" type=text></TD>
		</TR>";
			endwhile
	?>
	<TR>
		<TD colspan="5">&nbsp;&nbsp;<input type=submit></TD></TR>
	</TABLE>
	</FORM>

I imagine I am incorrect in how the array is working. How do I make sure that the ordered amount ($order) stays with the correct $id when I insert into the database?

Thanks for any help you can offer me.

Jeff

sarahk

there's a few ways but this would be consistent with your work so far:

<FORM ACTION=\"misc_order_submit.php\" METHOD=POST> 
<TABLE BORDER=\"0\"> 
<TR> 
<TD width=\"200\"><center><b><u>Description</u></b></center></TD> 
<TD width=\"20\"><center><b><u>Min</u></b></center></TD> 
<TD width=\"20\"><center><b><u>Max</u></b></center></TD> 
<TD width=\"40\"><center><b><u>Pkge Qty</u></b></center></TD> 
<TD width=\"40\"><center><b><u>Order</u></b></center></TD> 
</TR>
<?php
while ($row = mysql_fetch_array($result))
{
	$id=$row['id']; 
	$sku=$row['sku']; 
	$description=$row['description']; 
	$vpc=$row['vpc']; 
	$package_qty=$row['package_qty']; 
	$location=$row['location']; 
	$min=$row['min']; 
	$max=$row['max']; 
	echo "<TR> 
	<TD>{$description}</TD> 
	<TD>{$min}</TD> 
	<TD>{$max}</TD> 
	<TD><input name='amount[$id]' type='text' value='{$package_qty}'></TD>
	<TD><input name='order[$id]' type='text'></TD> 
	</TR>"; 
}
?> 
<TR> 
<TD colspan="5">  <input type=submit></TD></TR> 
</TABLE> 
</FORM>

jeffgman

Originally posted by sarahk
there's a few ways but this would be consistent with your work so far:

<?php
while ($row = mysql_fetch_array($result))
{
	$id=$row['id']; 
	$sku=$row['sku']; 
	$description=$row['description']; 
	$vpc=$row['vpc']; 
	$package_qty=$row['package_qty']; 
	$location=$row['location']; 
	$min=$row['min']; 
	$max=$row['max']; 
	echo "<TR> 
	<TD>{$description}</TD> 
	<TD>{$min}</TD> 
	<TD>{$max}</TD> 
	<TD><input name='amount[$id]' type='text' value='{$package_qty}'></TD>
	<TD><input name='order[$id]' type='text'></TD> 
	</TR>"; 
}
?>

[/B]

Okay, so I was pretty close myself. But, I don't want the <input name='amount[$id]' type='text' value='{$package_qty}'> line. Is it okay if I just do a <TD>{$package_qty}</TD> for that line also?

Now what would I do for the submit page? Would it look something like this:

count '$order[$id]"
for each $order[$id] {
INSERT INTO database_name where ROW is $id
}

Thanks for your help.

Jeff

p.s. May I also ask how come you removed my WHILE ... : and endwhile lines in favor of WHILE ... { }? I thought I read on www.php.net that the way I did was the prefered way. Was I reading something old?

sarahk

Originally posted by jeffgman

Now what would I do for the submit page? Would it look something like this:

count '$order[$id]"
for each $order[$id] {
INSERT INTO database_name where ROW is $id
}

drop the count, it's not doing anything
decide whether you are updating or inserting.

foreach($order as $id => $val)
{
  $sql = "insert into `table` (field1, field2) values ( $id, $val)";
//or
  $sql = "update `table` set field2 = '$val' where field1 = '$id'";
}

Originally posted by jeffgman
p.s. May I also ask how come you removed my WHILE ... : and endwhile lines in favor of WHILE ... { }? I thought I read on www.php.net that the way I did was the prefered way. Was I reading something old? [/B]

No, I'm probably out of date on that one, but I know mine works 🙂
http://nz.php.net/manual/en/control-structures.while.php

jeffgman

Originally posted by sarahk

foreach($order as $id => $val)
{
  $sql = "insert into `table` (field1, field2) values ( $id, $val)";
//or
  $sql = "update `table` set field2 = '$val' where field1 = '$id'";
}

One more question. What is "$val"? And where is that variable coming from? What does it equal?

Thanks for all of your help. It has definitely given me a place to go.

Jeff

sarahk

$val is whatever was entered in the text box on the form

jeffgman

Thank you for your help. It is greatly appreciated.