PHP - How To Gather Data From A Checkbox Form

i want to  insert only whats checked to db:)

but everything get posted

for now i came upwith a for loop but thats for inserting all data not only  whats checked any one know a  good way to do  this?

Hi. I want to put data from these checkboxes (example):
Jan (value = jan)
Chris (value = chris)
Tom (value = 50)
Jon (unchecked)
Put janchris50 to the database after finding correct row with user ID, which is user_id for this example.

Then, the user goes to another page and he should see this:
Jan (checked)
Chris (checked)
Tom (checked)
Jon (unchecked)
In other words - page should get the information from the database and check the checkboxes that appears to be checked in the database.

By the way, it should rewrite the row each time, as the user can modify it.

Thanks.

I have a form on our website that a user can fill out for custom product.  I want the form data to be 1) stored into a mysql database AND after storing said data, 2) email the same data to our sales department.

1)  The form data DOES get stored into mysql database (except for the first two fields, for some weird reason)

2) I added a "mail" section to the php file that stores the data into the database, but it is not working correctly.  I have stripped the email portion down to sending just one of the fields in the "message" to make it easier for troubleshooting

I have included here, both the form section of the html file, and the formdata.php file that processes the data for your  analysis.  I am relatively new to php so there are going to be some issues with security, but I can work on those after I get the store & email process to work correctly.  Please review my code and see if anyone can be of assistance.  I looked through the forums and couldn't find another issue that was the same as mine.  If I just overlooked, please tell me the thread post #.  Thanks

THE FORM WHICH COLLECTS THE DATA
*******************************
<form method=POST action=formdata.php>

                 
  <table width="640" border=0 align="center">
    <tr>
      <td align=right><b>First Name</b></td>
      <td><input type=text name=FName size=25></td>
      <td><div align="right"><b>Telephone</b></div></td>
      <td><input type=text name=Tel size=25></td>
    </tr>
    <tr>
      <td align=right><b>Last Name</b></td>
      <td><input type=text name=LName size=25></td>
      <td><div align="right"><b>Fax</b></div></td>
      <td><input type=text name=Fax size=25></td>
    </tr>
    <tr>
      <td align=right><b>Title</b></td>
      <td><input type=text name=Title size=25></td>
      <td><div align="right"><b>Email</b></div></td>
      <td><input type=text name=Email size=50></td>
    </tr>
    <tr>
      <td align=right><b>Company</b></td>
      <td><input type=text name=Comp size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Address</b></td>
      <td><input type=text name=Addr size=25></td>
      <td><div align="right"><b>Estimated Annual Volume</b></div></td>
      <td><input type=text name=EAV size=25></td>
    </tr>
    <tr>
      <td align=right><b>City</b></td>
      <td><input type=text name=City size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>State/Province</b></td>
      <td><input type=text name=SProv size=25></td>
      <td><div align="right"><b>Application</b></div></td>
      <td><input type=text name=Appl size=25></td>
    </tr>
    <tr>
      <td align=right><b>Country</b></td>
      <td><input type=text name=Ctry size=25></td>
      <td><div align="right"><b>Type of System</b></div></td>
      <td><input type=text name=Syst size=25></td>
    </tr>
    <tr>
      <td align=right><b>Zip/Postal Code</b></td>
      <td><input type=text name=ZPC size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td><div align="right"><strong><font color="#FFFF00" face="Arial, Helvetica, sans-serif">COIL
          DESIGN</font></strong></div></td>
      <td><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong>PARAMETERS</strong></font></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Primary Resistance (ohms)</b></td>
      <td><input type=text name=Pres size=25></td>
      <td><div align="right"><b>Primary Inductance (mH)</b></div></td>
      <td><input type=text name=Pind size=25></td>
    </tr>
    <tr>
      <td align=right><b>Secondary Resistance (ohms)</b></td>
      <td><input type=text name=Sres size=25></td>
      <td><div align="right"><b>Secondary Inductance (H)</b></div></td>
      <td><input type=text name=Sind size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Peak Operating Current (Amps)</b></td>
      <td><input type=text name=POC size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Output Energy (mJ)</b></td>
      <td><input type=text name=Egy size=25></td>
      <td><div align="right"><b>Output Voltage (kV)</b></div></td>
      <td><input type=text name=Volt size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b># HV Towers per Coil</b></td>
      <td><input type=text name=TPC size=25></td>
      <td><div align="right"><b># of Coils per Package</b></div></td>
      <td><input type=text name=CPP size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th colspan=4><b>Please enter any additional information he </b></th>
    </tr>
    <tr>
      <th colspan=4><textarea name=Mess cols=50 rows=10 id="Message"></textarea></th>
    </tr>
  </table>
  </dl>
  <div align="center">
    <p>
      <input type=hidden name=BodyTag value="&lt;body  bgcolor=&quot;#484589&quot; text=&quot;#FFFFFF&quot; link=&quot;#FFFF00&quot; alink=&quot;#FFFFFF&quot; vlink=&quot;#FF7F00&quot;&gt;">
      <input type=hidden name=FA value=SendMail>
    </p>
    <p><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong>PLEASE MAKE SURE ALL
      INFORMATION<br>
      IS CORRECT BEFORE SUBMITTING</strong></font></p>
    <p>
      <input type=submit value="Submit Form">
    </p>
  </div>
</form>
THE FILE THAT PROCESSES THE FORM DATA (formdata.php)
***********************************************
<?php
$con = mysql_connect("localhost","XXX","XXX");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("customform", $con);

$sql="INSERT INTO formdata (Fname, Lname, Title, Comp, Addr, City, SProv, Ctry, ZPC, Tel, Fax, Email, EAV, Appl, Syst, Pres, Pind, Sres, Sind, POC, Egy, Volt, TPC, CPP, Mess)
VALUES ('$_POST[Fname]','$_POST[Lname]','$_POST[Title]','$_POST[Comp]','$_POST[Addr]','$_POST[City]','$_POST[SProv]','$_POST[Ctry]','$_POST[ZPC]','$_POST[Tel]','$_POST[Fax]','$_POST[Email]','$_POST[EAV]','$_POST[Appl]','$_POST[Syst]','$_POST[Pres]','$_POST[Pind]','$_POST[Sres]','$_POST[Sind]','$_POST[POC]','$_POST[Egy]','$_POST[Volt]','$_POST[TPC]','$_POST[CPP]','$_POST[Mess]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Your Information Was Successfully Posted";

mysql_close($con);

$to = "recipient email address here"; 
$subject = "Custom Form"; 
$email = $_POST['Email'] ; 
$message = $_POST['Comp'] ; 
$headers = "From: $Email"; 
$sent = mail($to, $subject, $message, $headers) ; 
if($sent) 
{print "Your mail was sent successfully"; }
else 
{print "We encountered an error sending your mail"; }
?>

Hey

I have checkbox and when the user tick one or more box these should be stored as 0 or 1 but since its while loop, I am not sure how to work that out.

So far I have

<html>

<?php
session_start();
include '../Database/connection.php';

$Value24 = mysql_real_escape_string(trim($_POST['myselect'])); 

$_SESSION['smodule'] = $Value24;

?>
<body>
<form action="Test_Completed.php" method="post">
<?php

$query = mysql_query("
   SELECT *
FROM Test 
WHERE Tes_ID = '{$_SESSION['smodule']}'

");

while( $query1 = mysql_fetch_array($query) ) {
     echo "Test Name:  {$query1['Tes_Name']}";
}  

?>
<br>
<?php
$query = mysql_query("
   SELECT *
FROM User
WHERE Use_ID = '{$_SESSION['ssubject']}'

");

while( $query1 = mysql_fetch_array($query) ) {
     echo "User Name:  {$query1['Use_Name']}";
} 
?>

<br>
<?PHP

include '../Database/take_an_exam.php';
$intNumber = 1;
 while($info = mysql_fetch_array( $sql ))
 {
echo "$intNumber, {$info['Que_Question']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice1[]\" value=\"{$info['Que_Choice1']}\" /> ";
echo "{$info['Que_Choice1']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice2[]\" value=\"{$info['Que_Choice2']}\" /> ";
echo "{$info['Que_Choice2']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice3[]\" value=\"{$info['Que_Choice3']}\" /> ";
echo "{$info['Que_Choice3']} <br />\n";
echo "<input type=\"checkbox\" name=\"choice4[]\" value=\"{$info['Que_Choice4']}\" /> ";
echo "{$info['Que_Choice4']} <br />\n";

$intNumber++; 
 }


 ?>
 <input type="submit" value="submit"/>
 </body>
 
 </html>

 </body>
 
 </html>


<?PHP

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("Examination", $con);

//Get & clean value from POST data

$choice1 = mysql_real_escape_string(trim($_POST['choice1']));
$choice2 = mysql_real_escape_string(trim($_POST['choice2']));
$choice3 = mysql_real_escape_string(trim($_POST['choice3']));
$choice4 = mysql_real_escape_string(trim($_POST['choice4'])); 
$user = mysql_real_escape_string(trim($_SESSION['username1'])); 


//Create and run INSERT query
$query = "INSERT INTO Answer (`Ans_Answer1`, `Ans_Answer2`, `Ans_Answer3`, `Ans_Answer4`, `Que_ID`, `Use_ID`) 
          VALUES ('{$choice1}', '{$choice2}', '{$choice3}', '{$choice4}', '{$query1}', '{$user}')";
$result = mysql_query($query) or die (mysql_error());

$_SESSION['Ans_ID'] = mysql_insert_id();


 header("location:check.php");

?>

Hey phpFreaks, im having some troubles getting my script to work correctly and im also not sure if this issue is in the right section of the forum. but heres what i have going on.
I have a query result that displays a list of images with a checkbox and a couple buttons for edit and delete. everything works fine other than the checkbox stuff. I had it working when i was using a submit button, but i wanted to get rid of that button cuz it was only dealing with the checkboxes. so whats going on when using the checkboxes is that when checked or uncheck it would submit the form. It works to submit but its not submitting any data to the database.

heres what i got for code for this section of checkbox.
Code: [Select]
<?php
echo '<form method="post">';
if(isset($_POST['submit'])){
foreach($_POST['id'] as $id){
$value = (isset($_POST['location'][$id]) && $_POST['location'][$id]=="0" ? '0' : '1');
$insert = mysql_query("UPDATE items SET location='$value' WHERE id='$id'") or die('Insert Error: '.mysql_error());
}
}
     $result = mysql_query("SELECT * FROM items")
or die("Query Failed: ".mysql_error());
$counter = 0;
echo '<div class="specialcontainer">';
 while($row = mysql_fetch_array($result)){
list($id, $item_info, $item_img, $price, $sale, $location) = $row;
if($location == '0'){
$set_checked = 'checked="checked"';
}else{
$set_checked = '';
}
if($counter % 5==0) {
echo '</div>';
echo '<div class="specialcontainer">';
}
echo '<div class="special"><img src="../images/items/'.$item_img.'" width="130" /><br />'.$item_info.'<br />$'.$price.'<br />$'.$sale.'<br />Slide Show: <input type="checkbox" id='.$id.' value="0" name="location['.$id.']" '.$set_checked.'  onchange="this.form.submit()"/><br /><input type="button" value="Edit" name="edit" id="'.$id.'" onclick="window.location.href=\'specials.php?action=edit&id='.$id.'\'"><input type="button" value="Delete" name="Delete" id="'.$id.'" onclick="window.location.href=\'specials.php?action=delete&id='.$id.'\'"><input type="hidden" name="id[]" value='.$id.' /></div>';
$counter++;
 }
 echo '</div>';
 echo '</form>';
?>

I've been poking around online for about a day now trying to find a good way to do the following:

I have an "order" I'm reading in from a MySQL database (not completely relevant, but just fyi). And, for this order there are a number of "parts" (automotive parts) that have been ordered. For each part there is data pertaining to the quantity of parts that have been ordered and the number of parts that have been allocated (based on our inventory) and then a third column that has the number of parts still in that order that are still to be allocated at a future date.

Basically, I'm displaying this data in a form with each row having a checkbox to the far left. What I want to do is allow the user to check any number of check boxes. If a check box is checked the form should submit all of the input text boxes for that row (the user can update the quantities) that I talked about in the second paragraph for that "part" (each part is displayed in a row and has a checkbox).

Unfortunately, most of the examples I found for checkboxes in a form submit a specific value (like a number of a letter). I need the form to submit the values that are in the textboxes. So basically, I'm thinking I need the page to update a PHP object whenever the value of a textbox is changed and then when the user clicks a button it will send the php object for each checked row through GET or POST. But, how would I get it to onchange update a PHP object (the PHP object would need to be a 2-D array where the first index allows you to select the part and the second index allows you to select which quantity you will change). I'm thinking I would need to call a script from the onchange like: onchange="somePHPfunction(partNumberIndex, whichQuantityI'mChanging, currentValueOfThatQuantity)" but of course that would require me to embed some php inside the onchange call since the partNumberIndex and whichQuantity are PHP variables..

Any ideas on how to do this sort of thing?
Or any ideas on how to do this differently?
I'm trying to avoid javascript because it would place a javascript constraint on the users.
But, maybe there's no other way to do this sort of thing?

Any help would be greatly appreciated!

Hi,

having problems getting checkboxes to display all reuslts when a user selects more than one check box say in the category section and one in the location section - see page http://www.partyco.co.uk/event-and-party-venues/ - submit to see reults page:

I managed to get it to display reults if the user only seletc either a right or left column option OR one of each - BUT not when thet select multiple categories and one location - and ideas how to do this ? putting it into an array perhaps - but how - new to some of this....

here is the code for the reults page:
Code: [Select]
<?php
$location = $_POST[location];
$category = $_POST[category];
?>

<?php

$Link = mysql_connect("xxxxxxxxx", "xxxxxxxxx", "xxxxxxxx") or die(mysql_error());
mysql_select_db("xxxxxxxx") or die(mysql_error());

// selects db listings when location not given
if (empty($location)) {
$query = "SELECT * FROM venues WHERE category = '$category' order by title";
$result = mysql_query($query) or die(mysql_error());

// selects db listings when category not given
} elseif(empty($category)) {
$query = "SELECT * FROM venues WHERE location = '$location' order by title";
$result = mysql_query($query) or die(mysql_error());

// selects db listings when both given
}else {
$query = "SELECT * FROM venues WHERE category = '$category' and location = '$location' order by title";
$result = mysql_query($query) or die(mysql_error());
}

while($row = mysql_fetch_array($result)){
echo "<div class=\"resultsShort\" style=\"margin-bottom:10px;\">";
echo "<h2 id=\"resultsHeading\">";
echo $row['title'];
echo "</h2>";
echo "<p class\"resultspara\">". nl2br($row['description']). "</p>";
echo "<h4 style=\"margin:5px 0 0 0; padding:0;\">Contact details</h4>";
echo "<p class\"resultspara\">". nl2br($row['contact']). "</p>";
echo "<div style=\"float:left; width:124px; height:40px; margin:10px 15px 0 0;\">";
echo "<a href=\"/party-supplier-resources/email-supplier.php?title=". $row['title']. "&email=" . $row['email']. "&location=" . $row['location']. "&category=" . $row['category']. "\" title=\"contact this venue here\">";
echo "<img src=\"/images/email-supplier.jpg\" width=\"124\" align=\"right\" height=\"35\" alt=\"contact this supplier button\" border=\"0\" /></a>";
echo "</div>";
echo "</div>";
}


?>


<?php include("../include/shareLinks.php"); ?>


<div id="popupContact">
<a id="popupContactClose" title="close this window">close x</a>
<h1>Supplier Directory Enquiry Form</h1>
<?php include("../include/enquiryform.php"); ?>
</div>
<div id="backgroundPopup"></div>


<?php
mysql_close ($Link);
?>
Any help appreciated!

Aaron

MOD EDIT: [code] . . . [/code] BBCode tags added.

<script type="text/javascript">

i have this in a loop and a form
Code: [Select]
<input type='checkbox' name='$topic' value='No' />
on the page the form directs to.  How do i get each separate topic that has been checked?

This is related to how PHP processes checkboxes in a form. I have a checkbox in a form called chkNewpart:
    
    $s='<tr><td>Model: <td><input type="text" name="txtModelnum" id="txtModelnum" value="'.$row['modelnum'].'" size="20" maxlength=15 />';
    $s.=' New part? <input type="checkbox" name="chkNewpart" value="'.$newpartvar.'" ';
    $s.='checked="';
    if ($newpartvar==1)
     {
     $s.='checked';
     }
    
    $s.='" />';
    $s.='</tr>';


In my db, the field that holds this value is a tinyint, and the default is 1, which stands for true. So when I display the checkbox, if the value of the field is 1, then the box should be checked. That part works.

The problem I have is when I uncheck the box and save the checkbox to a php variable, and then the database field.
            
$newpartvar=$_POST['chkNewpart'];
...
            $query = "UPDATE parts SET modelnum='".$modelvar."', ".
            "prodcat='".$prodcatvar."', ".
            "prodname='".$prodnamevar."', ".
            "prodsubname='".$prodsubnamevar."', ".
            "newflag=";
            if ($newpartvar==1)
             {
             $query.="1"; //True
             }
            else {
             $query.="0"; //False
             }
            $query.=", ";
            $query.="updateuser='".$_SESSION['username']."', ".
            "updatedate=NOW() ".
            "WHERE partid=".$partidvar.";";

I get no errors but php doesn't seem to change the field value, when I look at it in PHP Admin.

How do I handle the values of checkboxes properly? I'd like 1 to be true and 0 to be false.

Hi:

Is this the correct way to do a memory form for a checkbox?

Code: [Select]
<input name="status[]" id="pending" value="<?=$_POST['pending'] ?>" type="checkbox"  />

Hi,

I am using check box group in my php form,
The user can choose multiple answers, if he choose 3 answers and the form is submitted only one answer is displayed in mysql

Code: [Select]
GetSQLValueString($_POST['father'], "text"),
any help please?
Thanks

Hey I'm a beginner at this and I was hoping the answer might be something simple.  I'll post the code if needed, but it might just be something simple.

I have a contact form with a php script to email me when a user enters information.  I have a checkbox for whether or not a user wants to receive our newsletter.

When a user fills in his/her information.  Clicks the checkbox to receive our newsletter, then clicks submit they are then taken to a thank you page and I receive an email with their info, etc.

When a user fills in his/her information. DOES NOT click the checkbox, then clicks submit, nothing on the screen changes, but I still receive the email with their info.

Why is this happening?  What am I missing with this checkbox? How do I get the thank you page to still display if they DO NOT click the checkbox?

Any thoughts would be appreciated.

if($x==""){ $x=1; } while($do=mysql_fetch_array($sql){ <form name='Form' action='posting.php' method='post'> <input type='checkbox' name='<?php print $x; ?>' value='<?php print $do[id]; ?>' /> <input type='submit' name='checked' value='checking'> $x++; }     When I click on the submit button, only one value of $x is sent to posting.php instead of multiple loop values in checkbox. Does anyone have a solution to it ?   Under Posting.php for ($x = 1; $x <= 20; $x++) {
$x=$_POST[$x]; echo "$x"; }
Edited by sungpeng, 16 October 2014 - 09:41 PM.

Why is it grouping the checked boxes instead of keeping them in order like area is?
if(isset($_POST['submit'])){
for($i=0; $i<10; $i++){
echo "<br />Ignore = [".$_POST['ignore'][$i]."]";

if($_POST['ignore'][$i]!="true")
echo ", Area = ".$_POST['area'][$i];
}
}
else
{
echo "<form method='post'><table>";
for($i=0; $i<10; $i++){
echo "
 <tr>
  <td><input type='checkbox' name='ignore[]' value='true' /></td>
  <td><input type='text' name='area[]' /></td>
 </tr>\n";
}
echo "
</table>
<input type='submit' name='submit' value='Submit' />
</form>";
}

Input:
Quote

Checked - ignored
Unchecked - a
Checked - ignored2
Unchecked - b
Checked - ignored3
Unchecked - c
Unchecked - d
Checked - ignored4
Unchecked - e
Checked - ignored5


Output:
Quote

Ignore = [true]
Ignore = [true]
Ignore = [true]
Ignore = [true]
Ignore = [true]
Ignore = [], Area = c
Ignore = [], Area = d
Ignore = [], Area = ignored4
Ignore = [], Area = e
Ignore = [], Area = ignored5