Page 1 of 1

help to INSERT values of checkboxes

Posted: Wed Dec 02, 2009 11:17 am
by mianmajidali
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">&nbsp;</td>
</tr>
<tr>
<td colspan="3">
<strong>Query Form</strong>
</td>
</tr>
<tr>
<td colspan="3">&nbsp;</td>
</tr>
<tr>
<td>Name:</td><td>&nbsp;</td>
<td>
<INPUT TYPE="text" NAME="Name" id="Name" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Email:</td><td>&nbsp;</td>
<td>
<INPUT TYPE="text" NAME="email" id="email" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Company:</td><td>&nbsp;</td>
<td>
<INPUT TYPE="text" NAME="company" id="company" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Country:</td><td>&nbsp;</td>
<td>
<INPUT TYPE="text" NAME="country" id="country" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Telephone:</td><td>&nbsp;</td>
<td>
<INPUT TYPE="text" NAME="tel" id="tel" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Fax:</td><td>&nbsp;</td>
<td>
<INPUT TYPE="text" NAME="fax" id="fax" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr>
<td>Mobile:</td><td>&nbsp;</td>
<td>
<INPUT TYPE="text" NAME="mob" id="mob" SIZE="30" MAXLENGTH="40"/>
</td>
</tr>
<tr valign="top">
<td>Contact via:</td><td>&nbsp;</td>
<td>
<INPUT TYPE="checkbox" name="box[]"/>Email
&nbsp;&nbsp;&nbsp;
<INPUT TYPE="checkbox" name="box[]"/>Fax
&nbsp;&nbsp;&nbsp;
<INPUT TYPE="checkbox" name="box[]"/>Mobile
&nbsp;&nbsp;&nbsp;
<INPUT TYPE="checkbox" name="box[]"/>Telephone

</td>
</tr>
<tr valign="top">
<td>Query Detail:</td><td>&nbsp;</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">&nbsp;</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);


?>

Re: help to INSERT values of checkboxes

Posted: Wed Dec 02, 2009 12:31 pm
by yacahuma

Code: Select all

 
$valToSave =  implode(',',$_POST['box']);
 
also change your html like

<input type='checkbox' name='box[]' value='John'>

Re: Please reset my INSER query

Posted: Wed Dec 02, 2009 1:02 pm
by mianmajidali
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]');