Inserting checkbox values

Question

hey i have registration form that has checkboxes along with other fields. i cant insert the selected checkbox values into the data base. i have made one field in the database for storing all checked values. this is the code for checkbox part in the form:

<pre><input type="checkbox" name="expertise[]" value="Websites,IT and Software"> Websites, IT and Software   <input type="checkbox" name="expertise[]" value="Writing and Content"> Writing and Content </pre>
<pre><input type="checkbox" name="expertise[]" value="Design and Media"> Design and Media            <input type="checkbox" name="expertise[]" value="Data entry and Admin"> Data entry and Admin </pre>
<pre><input type="checkbox" name="expertise[]" value="Engineering and Skills"> Engineering and Science     <input type="checkbox" name="expertise[]" value="Seles and Marketing"> Sales and Marketing </pre>
<pre><input type="checkbox" name="expertise[]" value="Business and Accounting"> Business and Accounting     <input type="checkbox" name="expertise[]" value="Others"> Others </pre>

and this is the corresponding php code for inserting data

$checkusername=mysql_query("SELECT * FROM freelancer WHERE fusername='{$_POST['username']}'");

if (mysql_num_rows($checkusername)==1)
{
  echo "username already exist";
}
else
{
  $query = "insert into freelancer(ffname,flname,fgender,femail,fusername,fpwd,fphone,fadd,facc,facc_name,fbank_details,fcity,fcountry,fexpertise,fprofile,fskills,fhourly_rate,fresume) values

  ('".$_POST['first_name']."','".$_POST['last_name']."','".$_POST['gender']."','".$_POST['email']."','".$_POST['username']."','".$_POST['password']."','".$_POST['phone']."','".$_POST['address']."','".$_POST['acc_num']."','".$_POST['acc_name']."','".$_POST['bank']."','".$_POST['city']."','".$_POST['country']."','".implode(',',$_POST['expertise'])."','".$_POST['profile']."','".$_POST['skills']."','".$_POST['rate']."','".$_POST['resume']."')";

  $result =

  ($query) or die (mysql_error());

this code inserts data for all fields but the checkbox value field remains empty???

Answer 1

You've defined in HTML an array via "[]" (expertise[]) and in PHP you use value $_POST['expertise']. I suggest using:

 <input type="checkbox" name="expertise" value="Design and Media" /> Design and Media   

EDIT:

Try use var_dump($_POST['expertise']) to view the content of variable $_POST['expertise']. The function often helps a lot.

Answer 2

In this expertise contains array, so use this

$exp = $_POST["expertise"];
$fulexp = implode(",", $exp);
// echo $fulexp;

It will give the correct results of all checkbox valu

Answer 3

But $_POST["expertise"]; is only going to return the last checked box checked by the user if you change the checkbox name from expertise[].