PHP - Handling Multiple Checkboxes Checkboxes?

Hey All,

I tried seraching, but I'm not sure what exactly to search for. Here's what I need to do, and any push in the right direction would be great:

I have a PHP form, with the Following:

Text Box: Student ID
Checkboxes for Activities

What I need to do is somehow loop through and make a new row for each activity. Example, if I entered Student ID 105 and Activities are Basketball, Baseball, and Chess Team, I need three different rows in the database each listing the individual activity and the student ID.

Any suggestions? I know how to do this if it was one entry (radio buttons) but want to be able to enter multiple rows at a time. Thanks!

hello.
can (or rather how can) i put multiple checkboxes in to 1 db column?

so, can i do this in 1 table:

id - tick box id
1  - 1,2,3
2  - 4,5,6
3  - 7,8,9

and then relate that table to another table

tick box id   -   name
1                -   name1
2                -   name2
3                -   name3
etc..


if so,
what format would i use in the db?  varchar, enum or set  (1,2,3 or '1','2','3')
and
how would i echo them out with the names from the second table?

thanks

hello all,

im wondering if it is possible to have multiple check boxes that get created based on the number of rows in a table (one representing each row) Code: [Select]
<input type='checkbox' name='approve[$tid]' value='ON'>
and then have a submit button at the bottom of the page that will find all of the checkboxes (it could be 1, or 100) and submit it to my form handling page.

thanks

Hi all, iv been trying to compile a script that will allow users to select multiple checkboxs that will filter results from db..but to no avail.  I have my data stored in mysql and have the queries saved seperatley. i.e. price = 0-500, 500-1000.etc.

What im trying to achieve is to allow users to select a checkbox that will execute that particular query and also more importantly allow them to select 'multiple' checkboxes that will filter the results accordingly.  I have never attempted to code this before although I am aware that it might involve arrays.  If someone could give me a nudge in the right direction that would be great :-)

I know how to pull data from sql table and limit down the results,

what i wanted to do is pull data from a sql table 'finished' and list data that has paid='0'

this is then limited to show the amount of rows set by variable 'maxPay'

here is my list what im pulling atm;
    <h2>Payment </h2>
    <?php 
if($userType[user_type]==28){
$queryPay = mysql_query("SELECT * FROM finished WHERE paid='0'&&method!='FALSE'&&method!='credit';") or die(mysql_error());

$queryAdmin = mysql_query("SELECT maxPay FROM `admin`;") or die(mysql_error());

$row = mysql_num_rows($queryPay);
//echo $row."row<br />";
$rowsArray = mysql_fetch_assoc($queryAdmin);
$rows = $rowsArray[maxPay];
//echo $rows."rows<br />";

if($rows>$row){
$r=$row;
}
else{
$r=$rows;
}
$s=0;
while($s<$r){
if($_POST[complete]==TRUE){
mysql_query("UPDATE `finished` SET `paid`='$_POST[paid]' WHERE `auctionID`='$_POST[aid]';");
$_POST[complete] = FALSE;

}
$s++;
}

$t=0;
while($t<$r){
$queryuser = mysql_query("SELECT * FROM finished WHERE paid='0'&&method!='FALSE'&&method!='credit';") or die(mysql_error());

$user = mysql_result($queryuser, $t, "username");
//echo $user;
$item = mysql_result($queryuser, $t, "itemName");
//echo $item;
$value = mysql_result($queryuser, $t, "marketPrice");
//echo $value;
$method = mysql_result($queryuser, $t, "method");
//echo $method;
$id = mysql_result($queryuser, $t, "auctionID");
//echo $id;



//echo $method;
if($method=='isk'){
?>
<FORM method="post" action="pay.php">
<input type="hidden" name=complete value="TRUE" />
<input type="hidden" name=paid value="YES" />
<input type="hidden" name=username value="<? echo $user; ?>" />
<input type="hidden" name=aid value="<? echo $id; ?>" />
<input type="submit" value="Paid" /><?
echo $user." won a ".$item." he selected to receive ".$value."ISK.";

echo "<br />";
?></FORM><?
}
elseif($method=='ship'){
?>
<FORM method="post" action="pay.php">
<input type="hidden" name=complete value="TRUE" />
<input type="hidden" name=paid value="YES" />
<input type="hidden" name=username value="<? echo $user; ?>" />
<input type="hidden" name=aid value="<? echo $id; ?>" />
<input type="submit" value="Paid" /><?
echo $user." won a ".$item." he selected to receive the ship.";

echo "<br />";
?></FORM><?
}
else{

}
$t++;
}

}
else{
echo "You are not an Admin.";
}
?>

and pay.php:
<?php 

header('Location: /admin.php');

include "connect.php";
echo $_POST[aid];
if($_POST[complete]==TRUE){
$tempID = (($_POST[aid])+1);
mysql_query("UPDATE `finished` SET `paid`='$_POST[paid]' WHERE `auctionID`='$tempID';") or die(mysql_error());
$_POST[complete] = FALSE;
}
?>

at the moment i am listing all my data, and processing it using pay.php, each dataset has a "paid" button, i want to change this to using a checkbox at end of each data row, and a submit button at the bottom. this way i can select which rows to update and tick the checkbox, then click submit and those rows will then be updated the value '0' in db to a value of 'YES'.

hope i explained myself clearly enough for some help.

im a relative php noob still in training. 

Hey all..

I have been messing around with some code with a form that has checkboxes on them, and the option of selecting more than one checkbox to submit to the database.  However, I keep getting the error," Warning: Invalid argument supplied for foreach() in (mydirectory)".

I have followed many tutorials and I don't see anything I am doing differently that they are, so I'm sure this is a simple fix, of something I am overlooking, or I am just horrible at this (new person).

Here is the snippet of the HTML code for the checkboxes.
Code: [Select]
<label>
  <input type="checkbox" name="project_list[]" value="chat"/>
  Chat Project (age 18+ requirement)</label>
<br />
<label>
  <input type="checkbox" name="project_list[]" value="forums"/>
  Forums Project (age 18+ requirement)</label>
<br />
<label>
  <input type="checkbox" name="project_list[]" value="content"/>
  Content/Editorial Project (postcasts, blogging, etc.)</label>
<br />
<label>
  <input type="checkbox" name="project_list[]" value="technology"  />
  Technology Project</label>
<br />
<label>
  <input type="checkbox" name="project_list[]" value="marketing"/>
  Marketing, Promotions and Publicity</label>
<br />
<label>
  <input type="checkbox" name="project_list[]" value="designartwork"/>
  Design and Artwork</label>
Here is the PHP code that I am using to do this.
Code: [Select]
include 'db.php';

mysql_select_db('skylers_training');

if($_POST['submit'])

{
$project_lists = $_POST['project_list'];

foreach($project_lists as $list); //This is the line the code is getting the error on.


And the section of the INSERT MYSQL CODE for this part.
Code: [Select]
$reginsert = mysql_query("INSERT INTO  ... // the rest of the code (that works fine) follows this.

'$list' // This is the line that is supposed to send data from the checklists to the database.




When I submit the form, in addition to the error, nothing is submitted to the database table for the list (everything else works fine).

Any insight into this, would be appreciated.

Thanks!

Hi guys,

I am struggling with a form containing multiple checkboxes with corresponding textboxes.
Eg.: there are 5 checkboxes (XS, S, M, L, XL) and 5 textboxes (with values 3,4,5,6,8) that correspond to the checkboxes.
I give all the checkboxes the name 'size[]' and the textboxes the name 'price[]'.
The aim is to have my script set a boolean to true and update the corresponding price if the checkbox is selected.
Unfortunately it does not work this way: checkboxes are only put in the array when they are selected, meaning that if I select only checkbox S and L, the array length is 2 only, but array length price is always 5, so size[1] does not correspond to price[1] necessarily.

There probably is a better way to achieve what I need. Could anyone point me in the right direction?

edit: BTW the number of items is dynamic: sometimes there will also be XXL or some items will be missing and I also need to set the price for items where the checkbox is not checked.

Can someone please help? I am simply trying to email process a form with checkboxes and then redirect to a thank you page.  It works fine as long as at least one checkbox is checked. It breaks if no checkboxes are checked using the implode function to list the "interests". I'm getting this error (and no redirect to my thank you page): Warning: implode() [function.implode]: Invalid arguments passed...

<?php
if (isset($_REQUEST['submit']))
{
   $email = $_REQUEST['email'];
   $firstName = $_REQUEST['firstName'];
   $lastName = $_REQUEST['lastName'];
   $address = $_REQUEST['address'];
   $city = $_REQUEST['city'];
   $state = $_REQUEST['state'];
   $zipcode = $_REQUEST['zipcode'];
   $homePhone = $_REQUEST['homePhone'];
   $cellPhone = $_REQUEST['cellPhone'];
   $interest = $_REQUEST['interest'];
   $imploded_interest = implode(',',$interest);
   $comments = $_REQUEST['comments'];
   $to  = 'myemailhere@yahoo.com';
   $subject = 'Volunteer Signup';
   $message = "
   <html>
   <head>
   <title>Volunteer Signup</title>
   </head>
   <body>
      <p>Hello,<br/>A visitor has submitted the following information from the volunteer page:</p>
      <p><b>$firstName $lastName</b><br/>
      $address<br/>
      $city, $state $zipcode<br/><br/>
      Home Phone: $homePhone<br/>
      Cell Phone: $cellPhone<br/>
      Email: <strong>$email</strong><br/><br/>
      I would like to help in the following ways:<br/>
      $imploded_interest
      </p><br/>
      <p>$firstName would also like share the following comments:<br/>
      <q><i>$comments</i></q>
      </p>
      </body>
      </html>
      ";
   $headers  = 'MIME-Version: 1.0' . "\r\n";
   $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
   $headers .= 'From: Volunteer Signup <myemailhere@yahoo.com>' . "\r\n";
   mail($to, $subject, $message, $headers);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Volunteer</title>
</head>
<body>
            <form id="VolunteerForm" method="post" action="thankyou.php">
                 <table>
                           <tr>
                               <td style="width:150px;">Email Address:</td>
                                <td><input name="email" type="text" id="email" /></td>
                                <td style="width:320px;" class="padtr"><strong>Ways I can help:</strong></td>
                           </tr>
                                 <tr>
                               <td>First Name:</td>
                                <td><input name="firstName" type="text" id="firstName" /></td>
                                <td class="padtr"><input name="interest[]" value="yard-sign" type="checkbox"/>
                        Put a yard sign in my yard</td>
                            </tr>
                            <tr>
                               <td>Last Name:</td>
                                <td><input name="lastName" type="text" id="lastName" /></td>
                                <td class="padtr"><input name="interest[]" value="fundraiser-at-home" type="checkbox" />
                        Host a fundraiser at my home</td>
                            </tr>
                            <tr>
                               <td>Address:</td>
                                <td><input name="address" type="text" id="address" /></td>
                                <td class="padtr"><input name="interest[]" value="phone-calls" type="checkbox" />
                                Make phone calls to friends and family</td>
                            </tr>
                            <tr>
                               <td>City:</td>
                                <td><input name="city" type="text" id="city" /></td>
                                <td class="padtr"><input name="interest[]" value="mailings" type="checkbox" />
                                Help with mailings</td>
                            </tr>
                            <tr>
                               <td>State:</td>
                                <td><input name="state" type="text" id="state" /></td>
                                <td class="padtr"><input name="interest[]" value="doors-literature" type="checkbox" />
                                  Help knock on doors and distribute literature</td>
                            </tr>
                            <tr>
                               <td>Zip Code:</td>
                                <td><input name="zipcode" type="text" id="zipcode" /></td>
                                <td class="padtr"><input name="interest[]" value="donate" type="checkbox" />
                                  Make a donation</td>
                            </tr>
                            <tr>
                               <td>Home Phone:</td>
                                <td><input name="homePhone" type="text" id="homephone" /></td>
                                <td class="padtr"><input name="interest[]" value="endorsement" type="checkbox" />
                                Use my name as an endorsement</td>
                            </tr>
                            <tr>
                               <td>Cell Phone:</td>
                                <td><input name="cellPhone" type="text" id="cellphone" /></td>
                                <td class="padtr"><input name="interest[]" value="newsletter" type="checkbox" />
                                Sign up for our newsletter</td>
                            </tr>
                            <tr>
                              <td>Comments:</td>
                       <td><textarea name="comments" id="comments" rows="5" cols="17"></textarea></td>
                              <td>&nbsp;</td>
                            </tr>
                            <tr>
                           <td>&nbsp;</td>
                           <td>&nbsp;</td>
                                <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="submit" id="submit" value="Submit Now" />&nbsp; <input type="reset" name="reset" id="reset" value="Clear Form" /></td>
                            </tr>
                        </table>
                        </form>
</body>
</html>

Hi, I want to build into my html table that populates my database table to have a column for checkboxes with a delete button that takes the user to another page to confirm the deletion by outputting a message: Are you sure you want to delete ____, followed by a for loop to see how many checked records to get its ID in order to get its appropriate name. So I have a submit button with name attribute of "delete0" and the values of the input type of checkbox is $row['ID'], for some reason, I get the notice: "Notice: Undefined index: modifyArray in C:\display.php" and modifyArray is the name I give to the checkbox attribute (please see this in my display.php below)

Here is my display.php
Code: [Select]
<table border="border">
        <!--NB: checkbox form for multiple delete/update/insert-->
       <form method="post" action="">
           <input type='submit' value='DELETE' name='delete0' />
           
<?php
    session_start();
    require 'bellSessionDisconnect.inc';
    require 'bellConnect.inc.php';

   $result=mysql_query("SELECT ID, Image, Name, Manufacturer, Price, Description, SimSupport FROM bellProducts");
    //phpinfo(); 

    //NB: print table headings
    if(mysql_num_rows($result))//if there is at least one entry in bellProducts, make a table
    {
        //$counter+=1;
        print "<table border='border'>";
        print "<tr>
        <th>ID</th>
        <th>Select entries to modifiy</th> 
        <th>Image</th>
        <th>Name</th>
        <th>Manufacturer</th>
        <th>Price</th>
        <th>Description</th>
        <th>SimSupport</th>
        <th colspan='2' align='center'>Modify</th>
           </tr>";

        //NB: now output each row of records
        while($row=mysql_fetch_assoc($result))
        {
            //extract($row);
            
                print
                "<tr align='center'>
                    <td>$row[ID]</td>
                    <td><input type='checkbox' name='modifyArray[]' value='$row[ID]' /></td>
                    <td>";
                    if(!empty($row['Image']))
                    {
                        $curImage=$row['Image'];
                    }
                    else if(empty($row['Image']))
                    {
                        $curImage='fileUploadIcon.jpg';
                        //$title="please upload item image";
                    }
                       print "<img src=$curImage width='70px' height='90px' />
                    </td>
                    <td> $row[Name] </td>
                    <td> $row[Manufacturer] </td>
                    <td> $$row[Price]</td>
                    <td align='left'>$row[Description]</td>
                    <td>$row[SimSupport]</td>
                    <td><a href='bellUploadForm.php?ID=$row[ID]'>UPLOAD IMAGE</a></td>
                    <td><a href='bellUpdateForm.php?ID=$row[ID]'>UPDATE</a></td>
                  </tr>";
            //}//END INNER IF
        }//END WHILE
             
  }//END BIG IF

?>

<?php           
    if(array_key_exists('delete0', $_POST))
    {
        $modifyArray=$_POST["modifyArray"];
        if(!empty($modifyArray))
        {
            header("Location: http://localhost/bellDeleteForm.php");
            exit();
        }
    }

?>
        </form>
           
</table>
   


I will worry about redirecting to bellDeleteForm.php to confirm the records the user wants to delete after I get this going, please help!!! thanks

Hi,
I am having difficulty deleting rows in my table using check boxes. I have all the check boxes displaying for each row and a delete button below the table. However when i click on the delete button it isnt deleting the checked rows, i have displayed the code below that i am using;

Code: [Select]
<?php 
  



$result = mysql_query("SELECT * FROM contact ORDER BY msg_id ASC");

echo "<table border='1'>
<tr>
<th>Delete</th>
<th>Message ID</th>
<th>Name</th>
<th>Email</th>
<th>Message</th>

</tr>";

while($row = mysql_fetch_array($result))
  {
  ?>
   <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo $row['del_id']; ?>"></td>
   <?php
  echo "<td>" . $row['msg_id'] . "</td>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "<td>" . $row['msg'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
?>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>


<?php
// Check if delete button active, start this 
if(isset($_GET['delete'])) {

for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM contact WHERE id=".$_GET['del_id'];
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php 
if($result){

}
}
mysql_close();
?>
Please help
Thank you

guys,

I have looked on google for this and apparently noone is doing it.  I have 4 checkboxes and I want to send mail indicating which boxes were checked.  the only code I've found is PHP that captures the *status* of the boxes, such as "on" or "off".  I want to capture the names of the actual checkbox elements.  Here is the code I'm currently testing (which just prints out "on" or "off" to indicate which boxes are checked):

if(isset($_POST['checkboxes'])) {
	foreach($_POST['checkboxes'] as $selected){
		echo $selected . "</br>";
	}
} else {
    echo "No Desired Contact Time Specified.";
}

if I check all 4 boxes for instance, I get this:

on
on
on
on

any way to get the names?  thanks!

Hello all,

i have a table that displays data from mysql, now i want to update multiple rows from that table with checkboxes, the value will basically just switch from 'new' to 'done' so far i have this:

Code: [Select]
<tbody>
                                        <tr class="first">
        </tr>
<?php
$ticketde=0;
while ($ticketde < $numpscde) {

$f1pscde=mysql_result($ticketresultde,$ticketde,"id");
$f2pscde=mysql_result($ticketresultde,$ticketde,"ticket");
$f4pscde=mysql_result($ticketresultde,$ticketde,"date");
$f5pscde=mysql_result($ticketresultde,$ticketde,"ip");
$f6pscde=mysql_result($ticketresultde,$ticketde,"done");

$setdone = ($f6pscde["done"] == 'n') ? "<a href=\"donepsc.php?id=".$f1pscde."\"><img src=\"ico_new.gif\" alt=\"new\" /></a>" : $f6pscde["done"];

if(isset($_POST['setdone'])){$checkbox = $_POST['checkbox'];

$id = "('" . implode( "','", $checkbox ) . "');" ;
$sql = "UPDATE ticket
        SET done='done'
        WHERE id='$f1pscde'";
$result = mysql_query($sql) or die(mysql_error());
}

?>

<tr class="first">
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f1pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f2pscde; ?></font></td>

<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $f5pscde; ?></font></td>
<td class="tc"><font face="Arial, Helvetica, sans-serif"><?php echo $setdone; ?></font></td>
<td class="tc"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $f1pscde['id']; ?>"></td>


</tr>


<?php
$ticketde++;
}
?>
</tbody>
</table>
                                    <center><input type="submit" name="setdone" id="setdone" value="Set selected  to done" class="button"/>   
                                 -     <input type="submit" name="exporttxt" id="exporttxt" value="Export selected to .txt" class="button"/>
                                    </center>
                                   
</fieldset>
</form>
                           
I found that checkbox code sample on some other site and tried to implement it, i don't really know where to go from here, as it's a total mess to me now, any help would be greatly appreciated.

hey i am using a MySql database and i need to create a dynamic HTML table with one of its columns as checkboxes.so i have to create multiple checkboxes.but these checkbox values are to be stored in a mysql table and then later retrieved when form reloads.and depending on previous state when form was submitted, the newly created checkboxes have to be checked in the same manner.so how do i store multiple checkbox values in my table and also how do i retrieve them?
please help.

I'm very new to php. I'm still learning slowly.
I'm currently doing a page where im showing all my patient records but there's checkboxes to tick and select a particular patient and go to next page.php to see the details of their history.

Here is my codings
<?php

include ("includes/db.php");

?>

<table width="455"  align="center" height="129" border="0" cellpadding="0" cellspacing="1">
<tr>
<td width="453"><form name="form1" method="post" action="patienthistory.php">
<table width="900" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>

<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF" width="100"><strong>Patient ID</strong></td>
<td align="center" bgcolor="#FFFFFF" width="200"><strong>Patient Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Patient I/C</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Patient Mobile</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Patient Address</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>City</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>State</strong></td>

</tr>


<?php
$sql = "SELECT patient_id, patient_name, patient_ic, patient_mobile, patient_add, patient_city, patient_state FROM patient_healthcare ORDER by patient_id ASC";
$result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR);
while(list($patient_id,$patient_name,$patient_ic,$patient_mobile,$patient_add,$patient_city,$patient_state)=mysql_fetch_row($result)){
    $checked="$patient_id" ;
    echo '<tr><td><input name="checkbox[]" type="checkbox" value="'.$patient_id.'" '.$checked.'/></td><td>'.$patient_id.'</td><td>'.$patient_name.'</td><td>'.$patient_ic.'</td><td>'.$patient_mobile.'</td><td>'.$patient_add.'</td><td>'.$patient_city.'</td><td>'.$patient_state.'</td></tr>'."\n";
}
?>

When i tick one boxes and press Select. The next page.php shows all the records. I just want a particular record show not all. Need help.
Help is appreciated.

for example i have a form like this
Code: [Select]
<form name="input" action="page2.php" method="post">

<table cellpadding="20" width="100%">
<!-- BEGIN query -->


<tr>
<td>
<img src="../eImages/{IMAGE}.jpg" style="width:200px;height:200px;" />

                                                   </td>
   <td>

{EVENTTYPE}</br>
{DPLACE} </br>
{NAME}</br>
{SPEAKERS}</br>
{LOC}</br>
{STREET}</br>
{TIME} </br>
</td>

<td>
<input type="checkbox" name="eventlist">

</td>
</tr>
<!-- END query -->

</table>
<input type="submit" value="Submit" />
</form>
this is all dynamically loaded each time from a database so it could have several trs of this formal
my goal is to only select 3 of them and then submit the form
this is will make a checkbox for each one including all the details
but the problem is that the checkboxes will all have the same name as oneanother
is there a way to increment the checkbox name value each time it goes through the while loop in the database?
thanks