[RESOLVED] in_array warning help

focus310

Hello:

I'm trying to run my script and I'm receiving the following message:
Warning: in_array()[function.in-array]: Wrong datatype for second argument in />Activities.

This error is appearing in a form field where I have checkboxes. So this warning appears for all the choices.

This is what I have coded:
At the beginning of my script, I'm validating data and this is the code.

if ( isset ( $_POST['availability'] ) && is_array ( $_POST['availability'] ) ) { 
     $_SESSION['availability'] = mysql_real_escape_string(implode(', ',$_POST['availability']));  

   } else { 
     $errors[] = 'Availability is a required field, Please select at least one.'; 
   }

This is the code for the checkboxes. I'm only showing one choice in order to make the post short.

<input type=checkbox name=interests[] value="Activities"<?php echo ( isset ( $_SESSION['interests'] ) && in_array('Activities', $_SESSION['interests']) ? ' checked="checked"' : '' ); ?> />Activities<br>

Can someone help me out?
Thank you in advance.

shiggins

My first guess would be that until the form has been posted you won't have an "interests" array.

kilbey1

I think, like shiggins says, you need to check for the existence of the array with an if statement first.

focus310

Hi,

I believe the problem is with the "implode" I have set. I should really do the implode in my INSERT query.

My variables, availability and interests, are checkboxes. I need to store the information in a table.

First, I tested to see what would happen if I removed the implode. The script worked and inserted the data in the table. But, the result that is in the table does not show the choices that were made. Instead, it shows the "array".

So now, I need to convert my array into a string to store in the table. The data in this table is not going to be used for anything.

I'm trying to use the implode in my insert query but I'm receiving the following message:
Parse error: syntax error, unexpected ',' in C:\Inetpub\fullfocus\AngelHouse\testing.php on line 27.

This error message is coming from this section of code:

$query = "INSERT INTO test (available, interests)
           VALUES ('implode(",",$_SESSION[available])', 'implode(",",$_SESSION[interests]'))";		
      $result = mysql_query ($query) or die (mysql_error());

I know it has to do with my insert statement. I'm trying to research the proper way to write the implode but I'm not having much luck.

Any ideas what I'm doing wrong?

Weedpacket

Because you've messed up your quotes. (look at the syntax highlighting in your post)

Tell you what; instead of trying to pile everything into one statement, use some variables to spread it out a bit more.

Weedpacket

Because you've messed up your quotes. (look at the syntax highlighting in your post)

Tell you what; instead of trying to pile everything into one statement, use some variables to spread it out a bit more. In particular, you can't embed function calls inside string literals and expect PHP to notice them.

focus310

Hello:

I was able to solve the problem. Everything works great now.

bradgrafelman

In case others stumble upon this thread in the future, would you mind telling us what it is you did to solve it?

Also, don't forget to mark the thread resolved.

focus310

Hi,

I thought I marked this resolved.

First, here is the form field for the checkboxes.

<input type="checkbox" name="available[]" value="Weekday mornings"<?php echo ( isset ( $_SESSION['available'] ) && in_array('Weekday mornings', $_SESSION['available']) ? ' checked="checked"' : '' ); ?> />Weekday mornings<br>
<input type="checkbox" name="available[]" value="Weekend mornings"<?php echo ( isset ( $_SESSION['available'] )  && in_array('Weekend mornings', $_SESSION['available']) ? ' checked="checked"' : '' ); ?> />Weekend mornings<br>
<input type="checkbox" name="available[]" value="Weekday afternoons"<?php echo ( isset ( $_SESSION['available'] ) && in_array('Weekday afternoons', $_SESSION['available']) ? ' checked="checked"' : '' ); ?> />Weekday afternoons<br>
<input type="checkbox" name="available[]" value="Weekend afternoons"<?php echo ( isset ( $_SESSION['available'] ) && in_array('Weekend afternoons', $_SESSION['available']) ? ' checked="checked"' : '' ); ?> />Weekend afternoons<br>
<input type="checkbox" name="available[]" value="Weekday evenings"<?php echo ( isset ( $_SESSION['available'] ) && in_array('Weekday evenings', $_SESSION['available']) ? ' checked="checked"' : '' ); ?> />Weekday evenings<br>
<input type="checkbox" name="available[]" value="Weekend evenings"<?php echo ( isset ( $_SESSION['available'] ) && in_array('Weekend evenings', $_SESSION['available']) ? ' checked="checked"' : '' ); ?> />Weekend evenings<br>

Then, this is the part where I do the validation for the check boxes.



   if ( isset ( $_POST['available'] ) && is_array ( $_POST['available'] ) ) { 
     $_SESSION['available'] = $_POST['available'];   

   } else { 
     $errors[] = 'Please select at least one.'; 
   }

When the validation is completed and there are no errors, this is the code I used to handle the checkbox array.

$_SESSION['available1'] = implode(' , ', $_SESSION['available']);

Now, the array is converted into a string and I ran an insert statement and this achieved what I needed to achieve.