Setting a Variable Value Based on Value of Array Element

[ccorbett]

Hello All --

I am currently using an open source piece of calendar software. This software inserts calendar entries into MYSQL based on an array of room id values like so:

foreach ( $rooms as $room_id ) {

insert into calendar_entrues values ... 

} 

I want to change the value of a variable within the foreach loop if one of the $rooms array elements equals a certain number. This variable would then be used as part of my insert.

For example, I tried something like this:

foreach ( $rooms as $room_id ) {

if ($rooms == "22") {
$hidden = 1;
}
else {
$hidden = 0
}

insert into calendar_entries values ($hidden...)

} 

This code chugs right past my if statement and inputs 0 for each $hidden even when my $rooms = 22 is present.

So I'm thinking I'm looking for the correct syntax to check if each array element equals a certain value. If it is, then set $hidden to one value, if not, set it to something else.

Can anyone help me out?

Thanks in advance!

-- Chris

[spiderling]

You should be checking it against $room_id. The $rooms variable is the array.

foreach ( $rooms as $room_id ) {
  if ($room_id == 22) {
    $hidden = 1;
  }
  else {
    $hidden = 0;
  }
  insert into calendar_entries values ($hidden...)
} 

[ccorbett]

Thanks spiderling.... I'm now trying something like what you provided and its not quite working:

foreach ( $rooms as $room_id ) {

if (isset($_GET["full"])) {

$hidden = 0;

if ($room_id == 3) {
$hidden = 1;
}
if ($room_id == 5) {
$hidden = 1;
}

}
INSERT into....
} 

$rooms is an array that contains three values: 3, 5 and 22 and $[get("full"}] is set. I want $hidden set to 0 if $room_id equals 3 or 5. I just ran this and all three entries were entered into my DB with $hidden = 0.

Any other thoughts?

Thanks!

[spiderling]

Use var_dump to check if $room_id is being seen as a string or int.

foreach ( $rooms as $room_id ) {
var_dump($room_id);
print '<BR>';
  if (isset($_GET["full"])) {
    $hidden = 0;
    if ($room_id == 3 || $room_id == 5) {
      $hidden = 1;
    }
  }
  INSERT into....
} 

[ccorbett]

I did that and here is the output:

string(1) "3" 
string(1) "5" 
string(2) "22"

I tried to read them in as strings and that did not seem to work either...

[spiderling]

I added

print 'room id: '.$room_id.', hidden: '.$hidden.'<BR>'; 

where the INSERT is and had the following result. I had the same results whether the array values were passed as strings or integers.

room id: 3, hidden: 1
room id: 5, hidden: 1
room id: 22, hidden: 0

Do you have the same results?

[ccorbett]

I did, yes, at that particular point. HOwever, I ended up having additional foreach loops within the outer one that I did not account for. These inner ones is where the INSERTS actually take place and they did not see the change to my $hidden variable.

Once I made that adjustment, it looks to be working great.

Thanks spiderling!