checkbox

[hidjra]

hi guys,

can anyone help me with this, it has nothing to do with vbulletin.

i want to write/pull some info to/from the database, and show the values in checkboxes, for example;

when a user signs up, he/she checks his interests in a form with checkboxes, this form puts the values into a database table, seperated with a space. And afterwards the user should have the possibility to change this info.

How do i make a form that puts multiple values in one table, seperated with a space?
And afterwards; how do i make a form that pulls the info from the database, en checks the checkbox if values are found in the table?

does this make any sense?? :cross-eyed:

Hidjra

[hidjra]

i tried this, but this only works when a user checks just one of the checkboxes :knockedout:

PHP Code:


$haalartiest = mysql_query("select artiestid,naam,synoniem,land,genre from club_artiest WHERE artiestid ='$artiestid'");
$array = $DB_site->fetch_array($haalartiest);


if ($array[genre] == "0") {
    $genre0 = "checked";
  } elseif ($array[genre] == "1") {
    $genre1 = "checked";
  } elseif ($array[genre] == "2") {
    $genre2 = "checked";
  } elseif ($array[genre] == "3") {
    $genre3 = "checked";
  } elseif ($array[genre] == "4") {
    $genre4 = "checked";
  } elseif ($array[genre] == "5") {
    $genre5 = "checked";
  } elseif ($array[genre] == "6") {
    $genre6 = "checked";
  } elseif ($array[genre] == "7") {
    $genre7 = "checked";
  } elseif ($array[genre] == "8") {
    $genre8 = "checked";
  } 


PHP Code:

<input type=\"checkbox\" name=\"genre\" value=\"1\" $genre1>
<input type=\"checkbox\" name=\"genre\" value=\"2\" $genre2>
<input type=\"checkbox\" name=\"genre\" value=\"3\" $genre3>
<input type=\"checkbox\" name=\"genre\" value=\"4\" $genre4>
<input type=\"checkbox\" name=\"genre\" value=\"5\" $genre5>
<input type=\"checkbox\" name=\"genre\" value=\"6\" $genre6>
<input type=\"checkbox\" name=\"genre\" value=\"7\" $genre7>
<input type=\"checkbox\" name=\"genre\" value=\"8\" $genre8> 


so what's wrong with this picture

hidjra

[Sparkz]

The checkboxes need to have unique names, for starters...

[hidjra]

ok, i gave the checkboxes a unique name, and i succeeded in writing the value to the table, seperated with a space

PHP Code:

<input type="checkbox\" name=\"genre[]\" value=\"1\" $genre1>
<input type=\"checkbox\" name=\"genre[]\" value=\"2\" $genre2>
<input type=\"checkbox\" name=\"genre[]\" value=\"3\" $genre3>
<input type=\"checkbox\" name=\"genre[]\" value=\"4\" $genre4>
<input type=\"checkbox\" name=\"genre[]\" value=\"5\" $genre5>
<input type=\"checkbox\" name=\"genre[]\" value=\"6\" $genre6>
<input type=\"checkbox\" name=\"genre[]\" value=\"7\" $genre7>
<input type=\"checkbox\" name=\"genre[]\" value=\"8\" $genre8> 


PHP Code:

$genres = implode($genre, " ");
    mysql_query("insert into club_artiest (naam, synoniem, land, genre) values ('$naam', '$synoniem', '$land' , '$genres')"); 


but what do i have to change in here to display the checkboxes as checked when editing an entry ?

PHP Code:

if ($array[genre] == "0") {
    $genre0 = "checked";
  } elseif ($array[genre] == "1") {
    $genre1 = "checked";
  } elseif ($array[genre] == "2") {
    $genre2 = "checked";
  } elseif ($array[genre] == "3") {
    $genre3 = "checked";
  } elseif ($array[genre] == "4") {
    $genre4 = "checked";
  } elseif ($array[genre] == "5") {
    $genre5 = "checked";
  } elseif ($array[genre] == "6") {
    $genre6 = "checked";
  } elseif ($array[genre] == "7") {
    $genre7 = "checked";
  } elseif ($array[genre] == "8") {
    $genre8 = "checked";
  } 


[hidjra]

nobody?? hello guys :speechless: help needed

Hidjra