help to INSERT values of checkboxes

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
mianmajidali
Forum Commoner
Posts: 30
Joined: Tue Dec 01, 2009 8:05 pm

help to INSERT values of checkboxes

Post 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);


?>
User avatar
yacahuma
Forum Regular
Posts: 870
Joined: Sun Jul 01, 2007 7:11 am

Re: help to INSERT values of checkboxes

Post by yacahuma »

Code: Select all

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

<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

Post 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]');
Post Reply