PHP - When User Clicks Checkbox, It's Not Captured In Php Array

i have a form with multiple checkboxes, with the same name. so i put them in an array like this.

Code: [Select]
<input type='checkbox' name='test[]' value='' />
<input type='checkbox' name='test[]' value='' />
<input type='checkbox' name='test[]' value='' />
<input type='checkbox' name='test[]' value='' />
Now when i do print_r($_POST['test']; , it should display an array and if each checkbox has been ticked or not.  it just comes up blank.

Any idea?

Hi guys,

I need some help in my coding, I have submitted the form, and basically I should see the success msg, which is echo '<p>Your new account has been successfully created. You\'re now ready to <a href="login.php">log in</a>.</p>'. However it wasnt appearing, and when I look into my database, I couldnt find any record which I have registered, is there something amiss in my coding? Please help, Thanks


<?php
  require_once('123.php');

  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
  or die(mysql_error());

  if (isset($_POST['submit'])) {
    // Grab the profile data from the POST
    $name = $_POST['name'];
   $email = $_POST['email'];
    $password = $_POST['password'];
   $location = $_POST['location'];
   $dob = $_POST['dob'];
   $category = $_POST['category'];

        $query = "INSERT INTO practice_user (name, email, password, location, dob, category, join_date) " .
      "VALUES ('$name, $email', $password, $location, $dob, $category, NOW())";
        mysqli_query($dbc, $query)
      or die(mysql_error());

        // Confirm success with the user
        echo '<p>Your new account has been successfully created. You\'re now ready to <a href="login.php">log in</a>.</p>';

        mysqli_close($dbc);
   }
?>

I'm looking for (1) a code to analyze the current page and show main words of the text, and (2) capturing similar words from the internet.

Script:

<?php

// For example, the entries in the table.
$entry1 = "text1";
$entry2 = "text2";
$entry3 = "text3";

// For example, the ID numbers in the table.
$value1 = "140";
$value2 = "141";
$value3 = "142";

echo "<form method='POST' action='" . $_SERVER['PHP_SELF'] . "'>";
echo "<input type='checkbox' name='hashtag_modify_checkbox[]' value='" . $value1 . "' />";
echo "Modify";
echo "<input type='text' name='hashtag_name[]' value='" . $entry1 . "' />";

echo "<input type='checkbox' name='hashtag_modify_checkbox[]' value='" . $value2 . "' />";
echo "Modify";
echo "<input type='text' name='hashtag_name[]' value='" . $entry2 . "' />";

echo "<input type='checkbox' name='hashtag_modify_checkbox[]' value='" . $value3 . "' />";
echo "Modify";
echo "<input type='text' name='hashtag_name[]' value='" . $entry3 . "' />";

echo "<input type='submit' name='submit' />";
echo "</form>";


// Here, only store those hashtag names where the "modify" checkbox is checked.


?>

This is used for the admin panel.   It is a form where the input fields hold the text ("hashtags") already inside of them.   Basically, one would have to check the "modify checkbox" to modify a hashtag, then only the modified hashtags should get stored into an array.   How to have those hashtags stored in the array with the checked checkbox as the factor?   The suggestions are much appreciated.
Edited by glassfish, 23 October 2014 - 10:06 AM.

Hi. I have a form with a selection of checkboxes. I am trying to use an array to store the results in a single column of a mysql database. The problem is, instead of the values, it just stores 'array'.

Each checkbox is like so:

<input name="previous_diseases[]" value="Tuberculosis"/>

Here is my code:

Code: [Select]
<?php
try{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$database = new PDO('mysql:host=localhost;dbname=db', 'username', 'password', $pdo_options);
 
$execution=$database->prepare('INSERT INTO form(title, forename, surname, address_1, address_2, address_city, address_county, address_country, address_postcode, email, previous_diseases, hear) VALUES(:title, :forename, :surname, :address_1, :address_2, :address_city, :address_county, :address_country, :address_postcode, :email, :previous_diseases, :hear)'); 
$execution->execute(array('title' => $_POST['title'],
         'forename' => $_POST['forename'],
 'surname' => $_POST['surname'],
         'address_1' => $_POST['address_1'],
 'address_2' => $_POST['address_2'],
 'address_city' => $_POST['address_city'],
 'address_county' => $_POST['address_county'],
 'address_country' => $_POST['address_country'],
 'address_postcode' => $_POST['address_postcode'],
 'email' => $_POST['email'],
 'previous_diseases' => $_POST['previous_diseases'],
     'hear' => $_POST['hear']));
Can anyone please show me what I need to change to get the values inserted into the database.

Thank you

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

Hi all,

I have a set of checkboxes which I need to be able to send into a session, which can be picked up later but exploded (it could be a possible maximum 7 options, may be only be 1).

I've been experimenting with foreach, but I can't get that into a session to be able to reuse, only $_POST which can't be carried over different pages.  Also, once I have them inside a session, how do I print what's been selected (rather than having to pick out manually).  IE - so if six have been selected, it prints those six options, or if it's two then it prints just those two choices.

Thanks!

Jason

database.php ________________________________________________________________________________________   $res = pg_query ($conn, "SELECT artist, composer, genre, title, album, label, price, description FROM music");         echo "<table border='1'>";
        while($a = pg_fetch_array($res)){
            echo "<td>" . $a['1'] . "</td>";
            echo "<td>" . $a['2'] . "</td>";
            echo "<td>" . $a['3'] . "</td>";
            echo "<td>" . $a['4'] . "</td>";
            echo "<td>" . $a['5'] . "</td>";
            echo "<td>" . $a['6'] . "</td>";
            echo "<td>" . $a['7'] . "</td>";
            echo '<td><input type="checkbox" name="music[]" value="$ref"' . $row['0'] . $row['1'] . $row['2'] . $row['3'] . $row['4'] . $row['5'] . $row['6'] . $row['7'] . '"/></td>';
echo"</tr>";
      }
    echo "</table>\n";
?>   _____________________________________________________________________________- shoppingbasket.php _____________________________________________________________________________-   <form action="shoppingbasket.php" method="POST">
Send To Basket: <name="music">
<input type="submit" value="submit">
</form> cant get it to send data from database to this page shoppingbasket.php 

Problem: my checkbox array chkBrand[] is not saving data when I click the save button called cmdSave. Each checkbox specifies a brand connected to a model number. Multiple brands can be connected to each model number. (Don't ask, it's what the customer wants.)

So, if I check the checkbox in row 0 and row 3, only row 0 shows up. If I check the boxes in row 0, 1, 5, only rows 0, 1 show up in chkBrand and $newchkbrandarr.

First, my routine to see which button is checked is at the top of the php file. Here it is.

else if (isset($_POST['cmdSave'])) //Try to save items first.
    {
$newchkbrandarr=$_POST['chkBrand']; //Checkbox for each brand.
$oldchkbrandarr=$_SESSION['oldchkbrandarr'];
$olddata=$_SESSION['olddata']; //Non-brand Fields strung together.
$brandlist=$_SESSION['brandlist']; //List of brands displayed.

crPrintarr('chkBrand raw',$_POST['chkBrand']); //DEBUG. Prints array to screen.
//===At this point chkBrand[] contains: 1

//Turn nulls in checkboxes to zeros.
$cnt=count($newchkbrandarr);
for ($j=0; $j<$cnt; $j++)
{
$newchkbrandarr[$j]=$newchkbrandarr[$j]+0;
} //for j

//Make sure that at least one brand is checked.
$cnt=count($newchkbrandarr);
crPrintarr('newchkbrandarr',$newchkbrandarr); //DEBUG
//===At this point, $newchkbrandarr contains: 1, 0

$s='Elements in newchkbrandarr cnt='.$cnt;
$s.=', count brandlist='.count($brandlist);
crDebug($s); //DEBUG
$cnt2=0;
$cnt=count($newchkbrandarr); //Find number of elements.
for ($j=0; $j<$cnt; $j++)
{
$cnt2=$cnt2+$newchkbrandarr[$j]+0;
//$s='arrpos '.$j.': newchkbrandarr='.($newchkbrandarr[$j]+0).', cnt2='.$cnt2;
//crDebug($s); //DEBUG
} # for j


Here is my code to construct the array of checkboxes, one per table row. Each checkbox has its array position explicitly defined as $x. $x starts at zero, and is incremented by 1 for each table row (each check box).


    $x=0;
    while ($row = mysqli_fetch_array($result)) 
     {
$br=trim($row['brand']); //Brand name to display
$brandvar=$br;
$brandlist[]=$br; //Save every found brand for later.
//First find if brand is checked on table "brands". 
        $query2 = "SELECT brand ".
        "FROM brands ".
        "WHERE ".
        "(partid=".$partidvar.") ".
        "AND (brand='".$br."') ".
        "ORDER BY brand ".
        ";";
        $cntchk=crqryCount($query2,false); //If $cntchk>0 then brand is checked.
        //$s="Is brand stored already? <br/>$query2";
        //crDebug($s); //DEBUG
        
        $query2 = "SELECT brand ".
        "FROM zzbrands ".
        "WHERE (brand='".$br."') ".
        "AND (prodnameoverride=1) ".
        "ORDER BY brand ".
        ";";
$override=crqryCount($query2,false); //Can this brand override product name?

$s="\n";
     $s.='<tr><td>'.
         '<input type="text" value="'.$br.'" id="txtBrand[]" name="txtBrand[]" '.
         'size="20" readonly class="mydisabled" />';
     $s.='<td align="center">';
     $s.='<input type="checkbox" name="chkBrand['.$x.']" '.
         'id="chkBrand['.$x.']" value="1" ';
     if ($cntchk>0)
     {
     $s.='checked="checked" ';
     $oldchkbrandarr[$x]=1;
     }
     else {
     $oldchkbrandarr[$x]=0;
     }
     $s.='/>';


Any ideas what I might be missing?

Hello,

I have been spending over 6 hours trying to square this away and I have looked at some tutorials from PHPFreaks... Maybe I'm missing something.

Basically I rebuilding the form from bottom up and I thought some check boxes would be easier for some part of the form instead of drop-down menu.

Basically this form is submitting query to MySQL:

article_add.php (Basically has the form)
article_insert.php (Basically insert the data to MySQL)

Here is one part of the form where the check box is located:

Here is article_add.php

<form action="article_insert.php" method="post">
<-- 
OTHER INPUT BOXES
-->
<div class="inputfieldtb"><label for="news_cat">News Categories:</label>
    <?
echo "<table>";
echo "<tr>";

$counter = 1;
                            while ($nc = mysql_fetch_array($news_cats)) {
$ncat_id = $nc['ncat_id'];
$ncat_name = $nc['ncat_label'];

echo "<td><div><input type=\"checkbox\" name=\"category[]\" value=\"$ncat_id\" ''/>$ncat_name</div></td>\n";

if (($counter % 4) == 0) {
echo "</tr><tr>";
}
$counter ++;
}
echo "</tr></table>";
                            echo "<br />";
?>
    </div>
<-- 
MORE FORMS
-->
</form>



Here is article_insert.php



// CONNECT TO DATABASE
include("../mods/connect.php");

<--- 
OTHER DATA INSERT IN MYSQL
-->

$news_cat = mysql_real_escape_string(implode(',', $_POST['category'])); // <-- Checkbox Data

<--- 
MORE DATA INSERT IN MYSQL
-->

$query = "INSERT INTO news_articles VALUES ('<--- MORE CONTENT BEING INSERT INTO MYSQL -->,'$news_cat','$news_content',<--- MORE CONTENT BEING INSERT INTO MYSQL -->'')";
mysql_query($query) or die ('Error inserting new data into the data to the database: ' . mysql_error() . '');


The error I'm getting is "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','','3','0','','','')' at line 1";


So what am I doing wrong? 

Once I get this resolved, I would like to learn how to display the checkbox / updated the checkbox as well.

Thank you in advance for your time and your help with this problem.

Hi all,

Im creating a simple quiz where some of the questions are checkbox because there is more than one correct answer.  What I would like to be able to do, is run an if statement to check if, say for example, options 1 and 5 out of 6 have been selected, then award the point. However the point is only awarded is both options are selected.

Any suggestions?

Thank you in advance

Hi all,

I have been trying to figure this out for a few days already and can't seem to figure it out. I want to display a few images with a checkbox next to it so I can delete multiple images at once when I press the delete button.

My problem is that I can't seem to figure out how to check if the checkbox is checked. if I uncheck one of them and click the delete button it deletes one from the array but I don't know which one was unchecked. For example if I uncheck the second one the array shows:

Array
(
=> on [1] => on
)

but I don't know which of the three was unchecked?

Here is the code I have been testing with:

Code: [Select]
<?php
// if submit button is clicked
if(isset($_POST['submit'])) {
// do delete function();

}
// display deletethis[] array
if (isset($_POST['deletethis'])) {
echo "<pre>";
print_r ($_POST['deletethis']);
echo "</pre>";
}

$separate = array("http://funnypicturesimages.com/images/image/funny-dog-pictures.jpg", "http://1.bp.blogspot.com/-35wQMpYtNZc/TXWNx8y2xCI/AAAAAAAB_2o/9vZYNfWrGn8/s400/funny_demotivational_posters_01.jpg", "http://3.bp.blogspot.com/-TFnzZ8zFtgg/TXWNpodBkGI/AAAAAAAB_2Q/O_fOOSqFM6w/s400/funny_demotivational_posters_04.jpg");
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">';

// display each image from array
foreach ($separate as $value)
{
echo "<img src=".$value.">";
if ($_POST['deletethis'] = "on") {
$checked="checked";
} else {
$checked="";
}

if ($_POST['deletethis'] != "") {
echo "checked"; } else{ echo "unchecked"; }

// if checkbox currently checked display it checked else display unchecked
if ($checked == "checked") {
echo '<input type="checkbox" name="deletethis[]" checked="checked"/><br /><br />';
} else {
echo '<input type="checkbox" name="deletethis[]"/><br /><br />';
}

}
?>
<center><input type="submit" name="submit" value="Delete Checked"></center>
</form>

Hey basically i'm working on a multi checkbox way to delete messages stored in "crew_messages", i'm getting the error message "Unknown column 'Array' in 'where clause'" from the following code and i'm unsure as to why

Code: [Select]
if (isset($_POST["submit2"]) == "DELETE SELECTED") {
for($i=0;$i<count($_POST["chkColor"]);$i++) 
{ 
if(trim($_POST["chkColor"][$i]) != "") 
{ 
$rawr = $_POST['chkColor'];
$sql = "DELETE FROM crew_messages WHERE id = $rawr";
mysql_query($sql) or die(mysql_error());
} 
}  } 

the check box itself

Code: [Select]
<input type="checkbox" name="chkColor[]" value="27">
any clues? cheers

i have this code:
foreach($product_names as $product_row) { ?>
            <tr>
                <td >&nbsp;</td><td width='200px'><?php echo $product_row->getName(); ?></td>
                <td width='200px'><input type="checkbox" name="graphic[]" value="<?php echo  $product_row->getId();?>" /></td>
                <td width='200px'><input type="checkbox" name="text[]"    value="<?php echo  $product_row->getId();?>" /></td>
            </tr>
            <?php }         
            ?>
       </table>
        <table>
            <tr>
                <td>
                      <input type='hidden' name='submit' value='Submit'> 
                <?php
                    if ( (isset($graphic)) || (isset($text) ))
                    {
                       echo "checkboxes checked";
                      //show submit button
                    }
                    else
                    {
                        //hide submit botton and
                        echo "no boxes check";
                    }
                ?>
                </td>
            </tr>
        </table>
     
so if i want to loop through grapic[] with the code:
 line 36  $graphics_selected = $_POST['graphic'];
 line 37   foreach($graphics_selected as $val)
            {
                       if there is something in array(thus any checkbox is checked) enable submit button
else if no checkboxes are checked disable submit button
           }

i get errors:
Notice: Undefined index: graphic in /home/helloises/svn_wappool/apps/lpmanager/modules/doc/templates/productSuccess.php on line 36 Warning: Invalid argument supplied for foreach() in /home/helloises/svn_wappool/apps/lpmanager/modules/doc/templates/productSuccess.php on line 37

please help????

Hello,

I want to create an order form where people can order shirts with sizes and quantities.
So in 1 form you have a column where people can check the size and after that the quantities. (see below the form)
As result i want after pressing submit and selecting for example 3 shirts Large and 1 small:
S=1, M=0, L=3, XL=0, XXL=0

Code: [Select]
echo "<form method=\"post\" action=".$PHP_SELF.">
  <label>aantal
  <input name=\"textfield[]\" type=\"text\" size=\"4\" maxlength=\"3\">
  <input class=\"option2\" id=\"option2\" name=\"maat[]\" type=\"checkbox\" value=\"S\">S<br />
 
  <input name=\"textfield[]\" type=\"text\" size=\"4\" maxlength=\"3\">
  <input class=\"option2\" id=\"option2\" name=\"maat[]\" type=\"checkbox\" value=\"m\">m<br />
 
  <input name=\"textfield[]\" type=\"text\" size=\"4\" maxlength=\"3\">
  <input class=\"option2\" id=\"option2\" name=\"maat[]\" type=\"checkbox\" value=\"l\">l<br />
 
  <input name=\"textfield[]\" type=\"text\" size=\"4\" maxlength=\"3\">
  <input class=\"option2\" id=\"option2\" name=\"maat[]\" type=\"checkbox\" value=\"XL\">XL<br />
 
  <input name=\"textfield[]\" type=\"text\" size=\"4\" maxlength=\"3\">
  <input class=\"option2\" id=\"option2\" name=\"maat[]\" type=\"checkbox\" value=\"XXL\">XXL<br />
 
  </label>
<input type=submit value=Select></form>";
i hope you can help me with it.

thanks in regard!