foreach loop problem

vzwhaley

I am creating a restaurant directory and have two tables, one named Restaurants and another named RestaurantsCuisine. I have created an array of Cuisine ID values that I store in a field called Cuisines in the Restaurants table. I then explode the Cuisine ID values and am trying to check multiple checkboxes in an edit script for the restaurant. The Cuisine IDs in the array from the Restaurants table should match with ID fields from the RestaurantsCuisine table.

I cannot get the foreach loop to work correctly. It will check one of the checkboxes, but not all of the checkboxes that need to be checked. I have tested the foreach* statement to ensure that it is pulling in each Cuisine ID and it is successful, but I just cannot get the loop to work correctly. Any help would be appreciated.

<?
$sql = "SELECT * FROM Restaurants WHERE ID = '4' ";
	$Recordset = mysql_query($sql);
	$RS = mysql_fetch_assoc($Recordset);

$sql1 = "SELECT * FROM RestaurantsCuisine ORDER BY CuisineType ASC";
$Recordset1 = mysql_query($sql1);


$Cuisine = $RS['Cuisine'];
$CuisineListS = explode("|", trim($Cuisine));

while ($row_Recordset1 = mysql_fetch_array($Recordset1)) {
?>

<input name="Cuisine[]" type="checkbox" value="<?php echo $row_Recordset1['ID']; ?>"<?php 
foreach ($CuisineListS as $CuisineList2) {
	if($CuisineList2 == $row_Recordset1['ID']) {
           echo " CHECKED";
	}
	}
?>

<?php echo $row_Recordset1['CuisineType']; ?><br>
<? } ?>

leatherback

better would be to work with a matching table which stores the cuisines for the different resaurants:

match:
[res_nr][cui_nr]

$sql = "select * from restaurants
left join match on restaurant.ID = res_nr
left join RestaurantCuisine on cui_nr = restaurantCuisine.id";

However, if you insist on using this:

$sql = "SELECT * FROM Restaurants WHERE ID = '4' ";
	$Recordset = mysql_query($sql);
	$RS = mysql_fetch_assoc($Recordset);

$sql1 = "SELECT * FROM RestaurantsCuisine ORDER BY CuisineType ASC";
$Recordset1 = mysql_query($sql1);

$Cuisine = $RS['Cuisine'];
$CuisineListS = explode("|", trim($Cuisine));

while ($row_Recordset1 = mysql_fetch_array($Recordset1)) 
  {
  $ch = "";
  if(array_key_exists($row_Recordset1['ID'], $CuisineListS)
    {
	$ch = "checked";
	}
  echo "<input name=\"Cuisine[]\" ".$ch." type=\"checkbox\" value=\"".$row_Recordset1['ID']."\">
       ".$row_Recordset1['CuisineType']."<br />
  }

bpat1434

How about using [man]in_array/man to see if the ID of the record is in the $CuisineListS array.... if it is, echo "checked"....

if(in_array($CuisineListS, $row_Recordset1['ID'])) echo 'checked';

leatherback

bpat1434 wrote:
How about using [man]in_array/man to see if the ID of the record is in the $CuisineListS array.... if it is, echo "checked"....
if(in_array($CuisineListS, $row_Recordset1['ID'])) echo 'checked';

BPat: Absolutely right: Here the key does not link to the value. I usually have $key and $value linked.

Replace array_key_exists() with in_array() in my code

vzwhaley

Thanks to all of you for your suggestions, but for some reason, in_array nor array_key_exists is working in this matter. I have tried all of the above pieces of suggested code and none of them work. I am going to attempt to solve the problem with the SQL JOIN suggestion, but does anyone else have any other ideas of how to accomplish this? Thanks again for all of your help.

bpat1434

Sorry about that. PHP can't keep its parameters straight. so switch the parameters around and it should work. I was searching the wrong way:

if(in_array($row_Recordset1['ID'], $CuisineListS)) echo 'checked';

vzwhaley

It will select only one of the checkboxes, not all of the checkboxes that match an ID number. It is not looping correctly through all of the IDs in the array. Any other suggestions? Thanks again for the help.