help to INSERT values of checkboxes
Posted: Wed Dec 02, 2009 11:17 am
hi to all, i am making a enquiry form using php, insertion in mysql database is successful, but i dont know to insert the values of checkboxes, i have create a field in table named as "box" to insert the values of checkboxes in form of array
please edit my query of INSERT to insert the values of checkboxes.
html enquiry form and php file are following.
---------------------------------------------------------------------------
<form action="query.php" method="post">
<table cellpadding="3" cellspacing="3">
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3">
<strong>Query Form</strong>
</td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td>Name:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="Name" id="Name" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Email:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="email" id="email" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Company:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="company" id="company" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Country:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="country" id="country" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Telephone:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="tel" id="tel" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Fax:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="fax" id="fax" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Mobile:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="mob" id="mob" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr valign="top">
<td>Contact via:</td><td> </td>
<td>
<INPUT TYPE="checkbox" name="box[]"/>Email
<INPUT TYPE="checkbox" name="box[]"/>Fax
<INPUT TYPE="checkbox" name="box[]"/>Mobile
<INPUT TYPE="checkbox" name="box[]"/>Telephone
</td>
</tr>
<tr valign="top">
<td>Query Detail:</td><td> </td>
<td>
<TEXTAREA NAME="query" id="query" COLS=40 ROWS=10></TEXTAREA>
</td>
</tr>
<tr valign="top" align="center">
<td colspan="3">
<input type="submit" name="" value="Submit Query"/>
</td>
</tr>
<tr valign="top">
<td colspan="3"> </td>
</tr>
</table>
</form>
---------------------------------------------------------------------------
This is php file
---------------------------------------------------------------------------
<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("oscobizz_test", $con);
$sql="INSERT INTO query(name, email, company, country, tel, fax, mob, query)
VALUES
('$_POST[name]','$_POST[email]','$_POST[company]','$_POST[country]','$_POST[tel]','$_POST[fax]','$_POST[mob]','$_POST[query]')";
mysql_query($sql);
echo "Thanks for submit Query: we will contact you soon.";
mysql_close($con);
?>
please edit my query of INSERT to insert the values of checkboxes.
html enquiry form and php file are following.
---------------------------------------------------------------------------
<form action="query.php" method="post">
<table cellpadding="3" cellspacing="3">
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3">
<strong>Query Form</strong>
</td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td>Name:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="Name" id="Name" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Email:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="email" id="email" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Company:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="company" id="company" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Country:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="country" id="country" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Telephone:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="tel" id="tel" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Fax:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="fax" id="fax" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Mobile:</td><td> </td>
<td>
<INPUT TYPE="text" NAME="mob" id="mob" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr valign="top">
<td>Contact via:</td><td> </td>
<td>
<INPUT TYPE="checkbox" name="box[]"/>Email
<INPUT TYPE="checkbox" name="box[]"/>Fax
<INPUT TYPE="checkbox" name="box[]"/>Mobile
<INPUT TYPE="checkbox" name="box[]"/>Telephone
</td>
</tr>
<tr valign="top">
<td>Query Detail:</td><td> </td>
<td>
<TEXTAREA NAME="query" id="query" COLS=40 ROWS=10></TEXTAREA>
</td>
</tr>
<tr valign="top" align="center">
<td colspan="3">
<input type="submit" name="" value="Submit Query"/>
</td>
</tr>
<tr valign="top">
<td colspan="3"> </td>
</tr>
</table>
</form>
---------------------------------------------------------------------------
This is php file
---------------------------------------------------------------------------
<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("oscobizz_test", $con);
$sql="INSERT INTO query(name, email, company, country, tel, fax, mob, query)
VALUES
('$_POST[name]','$_POST[email]','$_POST[company]','$_POST[country]','$_POST[tel]','$_POST[fax]','$_POST[mob]','$_POST[query]')";
mysql_query($sql);
echo "Thanks for submit Query: we will contact you soon.";
mysql_close($con);
?>