Check Boxs

[Lamez]

How do I handle checkboxes in PHP?

 

Say I select 3 boxs out of 4, how do I get it to display those three checkboxs?

 

here is my php code I have so far: (does not work)

 

<?php
if(isset($_POST['Submit']))

{

    for ($i=0; $i<count($_POST['checkbox']);$i++) {

       echo "<br />value $i = ".$_POST['checkbox'][$i];

    }

}
?>

 

here is my html

<?php
include ("../../style/include/session.php");
include ("../../style/include/cons/head_2.php");
print '<div class="box"><h2>Select Paid</h2>';
if($session->isAdmin()){
?>
<form action="pay_do.php" method="post">

<table width="100%" border="0">
  <tr>
    <td width="419"><strong>First Name </strong></td>
    <td width="487"><strong>Last Name </strong></td>
    <td width="257"><strong>Paid (username) </strong></td>
  </tr>
  <? $qr=mysql_query("select * from users order by first");
while ($rs=mysql_fetch_assoc($qr)) { ?>
  <tr>
    <td><? echo $rs['first'];?></td>
    <td><? echo $rs['last'];?></td>
    <td><input type="checkbox" name="checkbox[]"  value="<?=$rs['username'] ?>" /> (<? echo $rs['username']; ?>)</td>
    <?
} 
?>
  </tr>
</table>

<br />
<input name="submit" type="submit" value="Mark Paid"  />
</form>

<?php
}else{
header("Location: ../../index.php");
}
print '</div>';
include ("../../style/include/cons/foot.php");
?>

 

-Thanks!

[mikefrederick]

a little improvement on what i wrote earlier, what are you trying to do now still put the checked boxes into the database?

[Lamez]

lol ya.

 

If I could just learn how to handle checkboxes then I think I can get the rest

[tibberous]

Do a print_r($_POST) and see what you are getting. It's like no one traces anything anymore.

[Lamez]

when I select a few boxes I  get this

 

Array ( [checkbox] => Array ( [0] => GoogleBot [1] => admin ) [submit] => Mark Paid )

[mikefrederick]

<?php

if(isset($_POST['Submit']))

 

{

 

    $boxes=$_POST['checkbox'];

 

 

 

for ($i=0; $i<count($boxes);$i++) {

mysql_query("insert into paid (user) values ('$boxes')");

    }

 

}

?>

[Northern Flame]

just do foreach()

[Lamez]

mike that loop did not work,

 

how would I use the foreach?

[Lamez]

like this?

 

<?php
$arr = print_r($_POST);
foreach ($arr as &$value) {
mysql_query("insert into paid (user) values ('$value')");
}
?>

[mikefrederick]

Yeah that actually made no sense. Had nothing to do with $i.

 

$boxes=$_POST['checkbox'];

 

 

$i=0;

while ($i<=count($boxes)) {

mysql_query("insert into paid (user) values ('$boxes[$i]')");

$i++;

    }

 

 

I think you can do that. Or else foreach

 

[Lamez]

yah it works!

[Lamez]

now how do I remove the users that I did not select? If I did not select user1, but I selected user2 it inserts a blank for user1 and adds the value for user2?

 

I have this so far:

<?php
include ("../../style/include/session.php");
include ("../../style/include/cons/head_2.php");
print '<div class="box">';
if($session->isAdmin()){

if(isset($_POST['Submit'])){
$boxes=$_POST['checkbox'];
if (empty($boxes)) {
//somthing
}

$i=0;
while ($i<=count($boxes)) {
mysql_query("insert into paid (user) values ('$boxes[$i]')");
$i++;
    }
echo "<h2>Processed</h2>";
echo "Selected users have been processed";
}else{
echo "<h2>Error!</h2>";
echo 'No data to process<br><a href="paid.php">Select Paid/Non-Paid</a>';
  }
}else{
header("Location: ../../index.php");
}
print '</div>';
include ("../../style/include/cons/foot.php");
?>

[mikefrederick]

$boxes=$_POST['checkbox'];

 

 

$i=0;

while ($i<=count($boxes)) {

if($boxes[$i]=='on') {

mysql_query("insert into paid (user) values ('$boxes[$i]')");

}

$i++;

    }

 

[Lamez]

now it does not insert anything into the DB

[mikefrederick]

oh yeah, usually by default the value is 'on' when checked but you set the value.

[Lamez]

well how do I set the value?

 

like this?

 

<input type="checkbox" name="checkbox[]"  value="<?=$rs['username'] ?>" />

 

so then I need to change this line:

 

if($boxes[$i]=='on') {

 

to this

 

if($boxes[$i]==$rs['username') {

 

?

[mikefrederick]

<input type="checkbox" name="checkbox[]" onclick="if(this.value=='on') {  this.value='<?=$rs['username'] ?>'; } if(this.value=='<?=$rs['username'] ?>') { this.value=''; }" />

 

 

 

try changing your input field to that and then the other thing to this:

 

$boxes=$_POST['checkbox'];

 

 

$i=0;

while ($i<=count($boxes)) {

if($boxes[$i]!=='') {

mysql_query("insert into paid (user) values ('$boxes[$i]')");

}

$i++;

    }

[Lamez]

now it just inserts a blank row

[mikefrederick]

did you put the exclamation point before the equals signs?

[Lamez]

sure did, I just copied and pasted

 

paid.php

<?php
include ("../../style/include/session.php");
include ("../../style/include/cons/head_2.php");
print '<div class="box"><h2>Select Paid</h2>';
if($session->isAdmin()){
?>
<form action="pay_do.php" method="post">

<table width="100%" border="0">
  <tr>
    <td width="419"><strong>First Name </strong></td>
    <td width="487"><strong>Last Name </strong></td>
    <td width="257"><strong>Paid (username) </strong></td>
  </tr>
  <? $qr=mysql_query("select * from users order by first");
while ($rs=mysql_fetch_assoc($qr)) { ?>
  <tr>
    <td><? echo $rs['first'];?></td>
    <td><? echo $rs['last'];?></td>
    <td><input type="checkbox" name="checkbox[]" onclick="if(this.value=='on') {  this.value='<?=$rs['username'] ?>'; } if(this.value=='<?=$rs['username'] ?>') { this.value=''; }" /> (<? echo $rs['username']; ?>)</td>
    <?
} 
?>
  </tr>
</table>



<br />
<input name="Submit" type="Submit" value="Mark Paid"  />
</form>

<?php
}else{
header("Location: ../../index.php");
}
print '</div>';
include ("../../style/include/cons/foot.php");
?>

 

pay_do.php:

<?php
include ("../../style/include/session.php");
include ("../../style/include/cons/head_2.php");
print '<div class="box">';
if($session->isAdmin()){

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


$i=0;
while ($i<=count($boxes)) {
if($boxes[$i]!=='') {
mysql_query("insert into paid (user) values ('$boxes[$i]')");
}
$i++;
    }
echo "<h2>Processed</h2>";
echo "Selected users have been processed";
}else{
echo "<h2>Error!</h2>";
echo 'No data to process<br><a href="paid.php">Select Paid/Non-Paid</a>';
  }
}else{
header("Location: ../../index.php");
}
print '</div>';
include ("../../style/include/cons/foot.php");
?>

[mikefrederick]

<input type="checkbox" name="checkbox[]" onclick="if(this.checked) {  this.value='<?=$rs['username'] ?>'; } else {  this.value=''; }" />

[mikefrederick]

Sorry, dumb.

 

 

<input type="checkbox" name="checkbox[]" onchange="if(this.checked) {  this.value='<?=$rs['username'] ?>'; } else {  this.value=''; }" />

[Lamez]

it still adds a blank row, along with the selected user.

 

That is ok I can live with that.

[mikefrederick]

well, you just have to find out what the value of the checkboxes you dont want is and then set the part of the php that says !=='' to !=='value' and then youre good