Keeping checkboxes checked after post... ??

[simplyrichard]

Can someone help me format these two codes together?

 

<?PHP
  $query="SELECT activities_id, activities_name FROM culvercareers.activities"; 
  $result = mysql_query ($query);
  while($nt=mysql_fetch_array($result))
  {
  //Array or records stored in 
  echo "<input type=checkbox name=activities value=$nt[activities_id]> $nt[activities_name] <br>";
}
  echo "</select>";
  ?>

 

(The above code pulls the activities from the database.) and ....

 

<?php if ($_POST['activities'] == $nt[activities_name]) { echo "checked"; } ?>

 

What I am trying to do is if an error happens, the checkboxes on my form are still checked....

[F1Fan]

What errors? Do you mean you want it to always be checked by default?

[simplyrichard]

No, after you hit submit on my form, it brings you back to the form to correct any errors but all checkboxes, and dropdowns are uncheacked or emtpy.

 

[F1Fan]

OK, I see. First of all, you need [] brackets after "activities" in your checkbox name, so it will be treated as an array. If you don't do that, you'll only get one value of all the checked values.

 

Then, you'll need to check that array for matching values. This should work:

 

<?php
  $activities = isset($_POST['activities'])?$_POST['activities']:array();
  $query="SELECT activities_id, activities_name FROM culvercareers.activities"; 
  $result = mysql_query ($query);
  while($nt=mysql_fetch_array($result))
  {
  //Array or records stored in 
  echo "<input type='checkbox' name='activities[]'".(in_array($nt['activities_id'],$activities)?" checked":"")." value='{$nt['activities_id']}'> {$nt['activities_name']} <br>";
}
?>

 

I also fixed a lot of your syntax. Be careful about that, because using incorrect syntax may work, but then something may go wrong down the road that will screw you up.

[aebstract]

Just check to see if $_POST['whatever'] is set, if it is then make your checkbox with 'checked' in it and if it isn't then make your normal checkbox.

[simplyrichard]

THanks a million that code worked perfect! I didnt write that bit of code sorry for the errors.

 

Richard

[simplyrichard]

F1Fan ,

Using your code above, it worked perfect. However now when I try to insert the selected activities into the database I get only "array" inserted. I assume I need to do something like this

 

$aoi = $activities['0'].$activities['1'].$activities['2'].$activities['3'];

 

That didnt work  nor did $aoi =

$_POST['activities'];

 

Can you help?

 

Richard

[F1Fan]

$_POST['activities'] is an array, so you can't just insert it into the DB like that. You'll have to use a foreach loop.

[simplyrichard]

Can you give me an example of how to call out each item in the array?

[F1Fan]

<?php
$activities = $_POST['activities'];
foreach ($activities as $activity){
  // run your insert queries here...
}
?>