repopulating checkboxes question

[porco]

Ok where am I going wrong here? I have a set of checkboxes called interests. This is repopulating from a mysql table, and as it is now it will echo the result only if it is a single checkbox ticked.

How do I get it to output if multiple checkboxes are ticked?

The second question is regarding putting the tick into the checkbox that are being returned from the table. Say if the user has previously selected government and opinion as subjects they are interested in. I need a tick inside the boxes.

If anyone has any ideas it would be greatly appreciated. Code snippet below....

$interests = array('technology','enterprise','research','government','people','lifestyle','opinion');
foreach($interests as $interestsinput)
{
if($interestsinput == $myrow['interests'])
{
echo ">".$myrow['interests']."</br>";
echo "checked";
}
}

[porco]

Ok I changed it a fraction and its picking up the multiple amounts of which boxes are ticked.

CODE

$interests = array('technology','enterprise','research','government','people','lifestyle','opinion');
foreach($myrow as $interestsinput)
{
if($interestsinput == $myrow['interests'])
{
echo ">".$myrow['interests']."</br>";

}
}
$question = $myrow['question'];
$answer = $myrow['answer'];

Now all it is I suppose is somehow saying check this box in the form. The syntax escapes me, I keep getting parse errors every way I try to write it...

[marky2coats]

Ok,

I went through many different ways of doing this before I came to this one that I use all the time now.

I create a function called check like this:

function check($key,$value,$return) {
if ($key == $value)
return $return;
}

So when I need to add a tick to check box or select something in a drop down list, i can use this funciton to return either "selected" or "checked". Example.

<input type=checkbox value="Yes" <?=check("Yes",$db_value,"checked")?> >

Simple and realy neat.

hope this helps

[porco]

Cool I will keep that one. It looks a lot better than what I ended up with here lol. I spent all day in another forum working it through with someone. If you're curious check out www.phpfreaks.com and go to the Newbies Forum. My name there is porco1 so its not hard to find the thread about checkboxes. About 3 pages long 🙂.

YOurs does look a lot more eloquent, and its handy having a function in the bag.

Ciao

[porco]

Ok say then I wanted to repopulate the correct select in this list below. I place the function at the top of the page and then what would I write for a select..... I just want to understand the function properly.

echo "<p>State<select class=\"state\" name=\"state\">\n";
echo "<option selected value=\"Queensland\">Queensland</option>\n";
echo "<option value=\"New South Wales\">New South Wales</option>\n";
echo "<option value=\"Victoria\">Victoria</option>\n";
echo "<option value=\"South Australia\">South Australia</option>\n";
echo "<option value=\"Western Australia\">Western Australia</option>\n";
echo "<option value=\"Northern Territory\">Northern Territory</option>\n";
echo "<option value=\"ACT\">A.C.T.</option>\n";
echo "<option value=\"Tasmania\">Tasmania</option>\n";
echo "</select></p>\n";

[marky2coats]

Ok,

echo "<p>State<select class=\"state\" name=\"state\">\n";
echo "<option value=\"Queensland\" <?=check("Queensland",$_POST["state"],"selected")?> >Queensland</option>\n";

echo "<option value=\"New South Wales\" <?=check("New South Wales",$_POST["state"],"selected")?> >New South Wales</option>\n";

You get the drift?. So it basically checks each option with whatever has been posted by the form if they match then it returns "selected" making the box automatically highlight the posted option

Mark.

[porco]

Yes that is a lot easier. The other way I had a couple of nested while loops and an if statement to maintain. Thanks. This will be a very useful tool.

It is really hard to find good information about repopulating checkboxes and selects for some reason.

In your debt

Ciao

Porco

[marky2coats]

Sorry this isnt quite right it should be:

echo "<p>State<select class=\"state\" name=\"state\">\n";
echo "<option value=\"Queensland\" ".check("Queensland",$_POST["state"],"selected") ." >Queensland</option>\n";

echo "<option value=\"New South Wales\" ".check("New South Wales",$_POST["state"],"selected"). " >New South Wales</option>\n";

Mark.

[porco]

Thanx

[marky2coats]

No problems. I had the same problem but im forever trying to refine code so that it can be as simple as possible!!

Mark.

[porco]

I cut and pasted to get the code 100% but it doesn't repopulate the state select list.

[marky2coats]

What do you mean by repopulate? Do you mean loading a select box with data from a database?

Mark.

[porco]

Yes, it is a change profile form with the information loaded from the database table for members. So they can change their details and reenter it. It all works fine except the 2 selects don't display the proper values - they show the default ie Queensland.

So I want to repopulate the select with the returned database state data, for instance.

MMmmm penny drops,,,, $_POST was in your reply.. I must be very tired at 1am.... 🆒

[marky2coats]

lol .. get some sleep!. Yeah u need to replace that $_POST with the value from the DB 🙂

Mark.

[porco]

ciao and thanx
🆒