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);
?>
help to INSERT values of checkboxes
Moderator: General Moderators
-
mianmajidali
- Forum Commoner
- Posts: 30
- Joined: Tue Dec 01, 2009 8:05 pm
Re: help to INSERT values of checkboxes
Code: Select all
$valToSave = implode(',',$_POST['box']);
<input type='checkbox' name='box[]' value='John'>
-
mianmajidali
- Forum Commoner
- Posts: 30
- Joined: Tue Dec 01, 2009 8:05 pm
Re: Please reset my INSER query
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]');
VALUES
('$_POST[name]','$_POST[email]','$_POST[company]','$_POST[country]','$_POST[tel]','$_POST[fax]','$_POST[mob]','$_POST[query]');