[RESOLVED] Help with array and form

mpar612

I am sorry for the long pieces of code. I have to pieces of code and sort of want to merge them. I want to accomplish two things.

1) For each item that is in the $_SESSION['order'] array and in the "items" database table, I need to create an input field with a value like in the second piece of code posted below (about 20 lines down).

2) For each item that is in the array and not in the "items" database table, I need to create a hidden field like in the first piece of code below.

I have tried many different foreach() loops and I am having difficulty getting this to work the right way. Any guidance would be greatly appreciated.

Thanks in advance.

if(!empty($_SESSION['order'])) {
	foreach($_SESSION['order'] as $key => $value) {
		echo "<input type=\"hidden\" name=\"$key\" value=\"$value\" />";
	}
}

$itemsSql = "SELECT * FROM items WHERE menu = '$categoryMenu' AND category = '$category'";
$itemsRows = $db->getAll($itemsSql);

echo "<table border=\"0\" width=\"541\" id=\"table1\">
<tr>
<td colspan=\"3\" height=\"34\" valign=\"top\"><b>
<font face=\"Times New Roman\" color=\"#990000\">$category:</font></b></td>
</tr>";

if(!empty($_SESSION['order'])) {
foreach($_SESSION['order'] as $key => $value) {
	echo "<input type=\"hidden\" name=\"$key\" value=\"$value\" />";
										}
									}

foreach ($itemsRows as $itemsRow) {

$itemId = $itemsRow['itemId'];
$itemName = $itemsRow['itemName'];
$temperature = $itemsRow['temperature'];
$itemDescription = $itemsRow['itemDescription'];
$price = $itemsRow['price'];

echo "<tr>
<td width=\"24\" valign=\"top\" align=\"center\"><input type=\"text\" size=\"3\" name=\"$itemId\" value=\"$value\"></td>
<td width=\"421\" valign=\"top\">
<span style=\"font-family: Times New Roman\">
<font size=\"2\" color=\"#3F1F08\">$itemName</font></span></td>";

if($itemDescription != ""){
echo "<td width=\"421\" valign=\"top\">
<span style=\"font-family: Times New Roman\">
<font size=\"2\" color=\"#3F1F08\">$itemDescription</font></span></td>";
										}

echo "<td width=\"82\" align=\"right\" valign=\"top\">
<font face=\"Times New Roman\" size=\"2\" color=\"#3F1F08\">$$price</font></td>
</tr>";
	}

echo "</table>";							
}

dagon

what does it do vs what you want it to do? hard to debug without knowing the input or output

mpar612

Thanks for the response!

I am building a simple shopping cart. There are multiple order forms on the site. I am using sessions. I want values to be remembered when the user moves from form to form.

If the user comes back to a form that they previously filled out in the same session I want the quantity field of each item to be populated with the information they previously entered, which is being passed from page to page in an array. When the user goes to a different form I want all of the values that they entered in previous forms to show up as hidden form fields.

The problem I am having is when the user goes to a form that they previously filled out. My code effectively prints out all of the hidden form fields with the information that they previously entered. However, if the user returns to a form that they previously filled out then there are duplicate input fields with the same name, one for the actual form on the page and then an additional input field that is hidden from the users previous visit to that page.

Please let me know if you need further clarification.

mpar612

I have been working on this for most of my day and I think I have narrowed it down. I have a problem with my syntax that I am having difficulty working out.

I am selecting several rows in a database. Some of the values of these rows may or may not match values that are in the $_SESSION['order'] array. I need to print a hidden input field for each of the values in the array that do not match any results from the database.

My code below does this, but it prints out duplicate hidden input fields. I think it is printing out hidden input fields for each of the values in the array for every value returned from the database that does not match a value in the array.

Any thoughts on how to make this work? Any direction would be greatly appreciated. Thank you.

$itemsSql = "SELECT * FROM items WHERE menu = '$categoryMenu' AND category = '$category'";
$itemsRows = $db->getAll($itemsSql);

foreach ($itemsRows as $itemsRow) {

$itemId = $itemsRow['itemId'];

if(!empty($_SESSION['order'])) {
	foreach($_SESSION['order'] as $key => $value) {
		if($itemId != $key) {
			echo "<input type=\"hidden\" name=\"$key\" value=\"$value\" />";
		}
	}
}
}

mpar612

I figured it out. I posted the code below in case anyone else ever has the issue.

foreach ($_SESSION['order'] as $key => $value) {
								$found = false;

foreach ($itemsRows as $itemsRow) {
	if ($itemsRow['itemId'] == $key) {
		$found = true;
		break;
	}
}

    if (!$found) {
     echo "<input type=\"hidden\" name=\"$key\" value=\"$value\" />";
}
}