PHP - Checkbox Validation On Click

hallo everybody, i have column in my guestbook table mysql database names vis. i want make it possible for user to make theier comments invisible. if user checked yes, the comment will be viewd. if he did not checked, the comment will not be viewed. in my visibility.php the user can later change the value from yes to no or from no to yes. i do not know how to make this possible in update.php file. thank you very much for your help. Rafal   here is my code which not work in visibility.php

<form action="update.php" method="post">
<input type="hidden" name="inp_id" value="<?php echo  $row[id) ?>">
visible: <input type="checkbox" name="inp_vis" <?php if ($row[vis] == "yes") { echo "value='yes' checked"; } else { echo "value='no'"; } ?>>
<br>
<input type="submit" value="Save">
</form>

Edited by rafal, 25 September 2014 - 08:54 AM.

function get_checked($variable, $status){
	
	if($variable == $status){
		return 'checked="checked"';
	}else{
		return '';
	}
} 

<input type=\"checkbox\" name=\"emailNewsletter\" value=\"Yes\" ".get_checked($emailNewsletter, 'Yes').">
<input type=\"checkbox\" name=\"emailInbox\" value=\"Yes\" ".get_checked($emailInbox, 'Yes').">

$emailNewsletter = isset($_POST['emailNewsletter']) ? filter_input(INPUT_POST, 'emailNewsletter') : 'No';
$emailInbox = isset($_POST['emailInbox']) ? filter_input(INPUT_POST, 'emailInbox') : 'No';

If no submit button clicked display mysql information $userInfo['emailInbox'] instead of 'NO' . How to do that?      

I'm having a problem on how to get the values of those that are checked in my table.. so that i can insert them in my database. Someone help get those values pls.

Heres my code

Code: [Select]
<?php
$host="localhost"; 
$username="root"; 
$password="";
$db_name="dbprof";
$tbl_name="teacher"; 

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
echo '<form name="formupload" method="post" action="val3.php">';
echo "<table border=\"5\" >";
echo "<tr><th>List of Instructor</th>";
    if(mysql_num_rows($result)) 
    { 
    while($row = mysql_fetch_assoc($result)) 
    { 
echo "<tr><td>";
    echo "<input type='checkbox' name='list' 'value='" .$row['fullname']. "'> " .$row['fullname']. "<br/></td>"; 
    echo "</tr>";
   } 

}
    else {
    echo "<tr><td>No one to Approve</td></tr>";  
    } 
echo '<input type="image" src="images/reject.png" name="test" width="170" height="35" border="0" value="reject">';
echo '</form>';


?>

I dont know what to put in my val3.php'
so that it can the values of the Checked data. thanks for those who can help.

 :confused:Hi I have a problem with check box in jquery directory tree... I can't get value from it !!! :S
The value of $file show's as "array" in the echo"$files";  not as the real value of the file that is show'n in the directory tree.
Can someone help mee with this ?


<input type='checkbox' name='del[]' id='del' value='$file'/><a href=\"".$path.$file."\"><img src='slike_izgled/file.png'> $file</a>

if(isset($_POST['filedel'])) {                           
      $id = $_POST[del];
      $count = count($id);                        
      for ($i=0; $i<$count; $i++){                                             
      $files = $_POST['del'];      
                     
      echo"$files.$count";
               }
         
         
         
                        
   
         
            

I am having issue creating a checkbox that uses a onClick() js method.  I believe this might be due to the fact that I am echoing the html but if any one could help id appreciate it. 



 echo "<tr><td>WrkComp</td><td><input type='checkbox'" ?>
<script>onClick="show()" </script> 
<? "name='WrkComp[]' value='DEP' '.$checked.' '.$Disabled.'/></td>";

I have been having a bit of difficultly understanding how to submit a single checkbox values for a list of names and saving it in a MySQL database.

The way it is meant to work is that a list of names from a table (Table1) is produced on the screen through a query. I have a checkbox that appears beside each individual name and if I tick the box I want it to save the value '1' to the database, otherwise the value remains as zero. When I tick the necessary boxes I wish to save it to another table (Table2, it is separate from Table1). The name and value needs to be saved to it.

The problems that arises is how do I save the checkbox value for each individual name? Will I need to use a checkbox array or can I treat each name as independent? Hopefully you understand what I mean. 

hello,
i have table that store p_id , p_name , p_visible.
in my form code i put this :

$sql = "select * from pages";
$rslt = connect($sql);

   print "<form name='links' method='GET' action='checks/check_links.php'>";

   while ($links = mysql_fetch_array($rslt)) {
      print "<input type='checkbox' name='pagename' value='1'>$links[p_name]<br>";
   }
   
   print "<input type='submit' value='update'></form>";


my question is....
how to pass the query string that hold:

1. if checkbox checked, then pass value 1 to my sql query
2. i have to define witch value has need to go to the right p_name


please help.

Hi,

so i have a problem. I'm using a script to enable and disable checkboxes, and i'm id-ing them fetching values from a database:

while($data = mysqli_fetch_array($sql))
{
  if ($count % 5 == 0) {
    echo '</tr><tr>';
    $count = 0;
  }
  echo '<td><input name="subject_level[]" class="subject_a" disabled="disabled" type="checkbox" id="subject_level_'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
  echo '<label for="subject_level_'.$data['subject_level_id'].'" class="subject_1">'.$data['subject_name'].'</label></td>';
  $count++; //Increment the count
}

The names of the checkboxes come out fine, just that, is there any way to retrieve the values of the checkboxes into an array of some sort so that i could build a search query later?

if($_POST(subject_level)) or if($_POST(subject_level[]))  doesn't return true. does it make sense? im new to php so please forgive my ignorance. Help appreciated. Thanks!

I am retrieving data from mysql and printing this as a table. Now I want to print this as a checkbox. But not sure how to?

<?php
mysql_connect("localhost", "root", "")or die("cannot connect");
mysql_select_db("Examination")or die("cannot select DB");

$sql=mysql_query("SELECT * FROM question")
or die(mysql_error());

Print "<table border cellpadding=5>";
 while($info = mysql_fetch_array( $sql ))
 {
Print "<th>Question:</th> <td>".$info['Que_Question'] . "</td> ";
Print "<th>Choice1:</th> <td>".$info['Que_Choice1'] . "</td> ";
Print "<th>Choice2:</th> <td>".$info['Que_Choice2'] . "</td> ";
Print "<th>Choice3:</th> <td>".$info['Que_Choice3'] . "</td> ";
Print "<th>Choice4:</th> <td>".$info['Que_Choice4'] . "</td> ";



 }
 Print "</table>";
 ?>

How do I post the values that are in a while loop and add them to mysql table?


<form action="Test_Completed.php" method="post">
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>

Hello again,

I have a form that has several options to select features of a computer (vga, dvi, ethernet, modem, zip, etc.) through checkboxes. In the database, it is stored as a 0/1 (false/true). What I am working on is an edit form to make changes if necessary, but I am having trouble populating the checkboxes that are marked as true already.

Code: [Select]
while($cmp = $_SESSION['DB']->fetch_array($cmpQ)){
$chkbxs = array('vga', 'ps2', 'usb', 'firewire', 'ethernet', 'cddvd', 'fdd', 'zip', 'dvi', 'serial', 'sound', 'wireless', 'modem', 'smartm');
foreach ($chkbxs as $value) {
$check="";
if ($cmp[$value] == 1) {
$check = "checked";
echo ''.$value.' <br/>';
}
...more code, form below
This does it it should. I have an entry with vga, firewire, smartm, and zip selected, and $value returns that properly.

In the form, this is how I have it set up.
Code: [Select]
echo '<input type="checkbox" name="hardware[]" value="vga" '.$check.'>';
Right now, every checkbox is selected, meaning that for some reason, $cmp[$value] == 1 is affecting all checkboxes in the form, even though it is only returning the 4 that are marked as selected when I echo $value.

Am I missing something minor or am I going about this the wrong way?

Hey,

I have checkbox and with these I am setting an exam. I want the questions to contain numbers. So for each question a number would be displayed. So far I am Only getting the question and the choices to display.


<html>

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

$Value22 = mysql_real_escape_string(trim($_POST['myselects'])); 

$_SESSION['myselect23'] = $Value22;

//echo $_SESSION['myselect23'];
?>
<body>
<form action="Staff_Menu.php" method="post">
<?php

include '../Database/previous_q.php';

 while($info = mysql_fetch_array( $sql ))
 {
 
echo "{$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";


 }


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

 </body>
 
 </html>

I am wondering how to keep a checkbox checked?

I have the folllowing code and it is outputting the correct info, but when i tick checkbox, and then click box "SAVE Days and Recipes Chosen" the checkbox doesn't get set.

<?php
for($i = 0; $i < $rows; $i++) {
?>
<tr>
<?php
    for($j = 0; $j < $columns; $j++) {
            echo "<TD><font color='8678E9'>" . $data[$i + ($j * $rows)] . "</font></TD>\n"; ?>
            <td><input type='checkbox' name=$R1 <?php  if($R1=="checked"){$R1=="checked"; echo $R1;}
                                                        elseif($R1=="unchecked"){$R1=="unchecked"; echo $R1;} ?>                                                                                                 
            <td><?php echo"<TD><font color='3923D6'><font size=4>" . $data2[$i + ($j * $rows)] . "</TD>\n"; ?></font></td>
                <?php echo"<TD align='center'><font color='3923D6'><font size=4>" . $data4[$i + ($j * $rows)] . "</TD>\n"; ?></font></td>
                <?php echo"<TD align='center'><font color='3923D6'><font size=4>" . $data5[$i + ($j * $rows)] . "</TD>\n"; ?></font></td>
            <td align="centre"><input type="checkbox" name="ch1[]" method="POST" value=<?php echo $data3[$i + ($j * $rows)]?>,1 >M<br>           
                <input type="checkbox" name="ch1[]" value=<?php echo $data3[$i + ($j * $rows)]?>,2 method="POST">Tu<br>
                <input type="checkbox" name="ch1[]" value=<?php echo $data3[$i + ($j * $rows)]?>,3 method="POST">W<br>
                <input type="checkbox" name="ch4[]" <?php if (!isset($ch4)){$Value='unchecked'; echo $Value;} elseif(isset($ch4)){$Value='checked'; echo $Value;}?> value=<?php echo $data3[$i + ($j * $rows)]?>,4 method="POST">Th<br></td>
            <td align="centre"><input type="checkbox" name="ch1[]" value=<?php echo $data3[$i + ($j * $rows)]?>,5 method="POST">F<br>
                <input type="checkbox" name="ch1[]" value=<?php echo $data3[$i + ($j * $rows)]?>,6 method="POST">Sa<br>
                <input type="checkbox" name="ch1[]" value=<?php echo $data3[$i + ($j * $rows)]?>,7 method="POST">Su<br></td>     
                <?php echo"<TD><font color='3923D6'><font size=4>" . $data6[$i + ($j * $rows)] . "</TD>\n"; ?></font></td>
            <td style='font-weight: bold; text-align: left;'><font color='8678E9'>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</font></td>
                <?php
    }
    echo "</TR>\n";
}
echo "</TABLE>\n";
echo "<br>";
                       

It is the following part that i cuurently  need help with

            <td><input type='checkbox' name=$R1 <?php  if($R1=="checked"){$R1=="checked"; echo $R1;}
                                                        elseif($R1=="unchecked"){$R1=="unchecked"; echo $R1;} ?>         

I haven't looked at the other checkbox part of

            <td align="centre"><input type="checkbox" name="ch1[]" method="POST" value=<?php echo $data3[$i + ($j * $rows)]?>,1 >M<br>           
                <input type="checkbox" name="ch1[]" value=<?php echo $data3[$i + ($j * $rows)]?>,2 method="POST">Tu<br>
                <input type="checkbox" name="ch1[]" value=<?php echo $data3[$i + ($j * $rows)]?>,3 method="POST">W<br>
                <input type="checkbox" name="ch4[]" <?php if (!isset($ch4)){$Value='unchecked'; echo $Value;} elseif(isset($ch4)){$Value='checked'; echo $Value;}?> value=<?php echo $data3[$i + ($j * $rows)]?>,4 method="POST">Th<br></td>
            <td align="centre"><input type="checkbox" name="ch1[]" value=<?php echo $data3[$i + ($j * $rows)]?>,5 method="POST">F<br>
                <input type="checkbox" name="ch1[]" value=<?php echo $data3[$i + ($j * $rows)]?>,6 method="POST">Sa<br>
                <input type="checkbox" name="ch1[]" value=<?php echo $data3[$i + ($j * $rows)]?>,7 method="POST">Su<br></td>     


Appreciate any suggestions

I have this.

<input name="delete[]" type="checkbox" id="delete" value="1" />

What I want to is get the value from this which is the "1"
AND
Get the id which would be "delete"

I can get the value but i cant seem to get the id

This is what I have been using

foreach($_REQUEST['delete'] as $index=>$val){
echo $index;
echo $val;
}


echo $index just gives me the num of array I am on and the $val gives the actually value. Can anyone help me out with getting the id or how I can specify a id.

THanks

Hi All,

I'm very new to PHP so please bear with me.

I have created a form with 3 fields. One field is a multi select / checkbox with the name 'tenCode'. How do I get all of the values selected from this box and add them to my database?

My submission code (submit.php)

Code: [Select]
<?php
$con = mysql_connect("localhost","dbname","dbpassword");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("dbname", $con);

$sql="INSERT INTO tablename (tenFirst,tenPhone,tenID)
VALUES
('$_POST[tenFirst]','$_POST[tenPhone]','$_POST[tenID]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
  
echo "Adding Ten. The page will refresh in 5 seconds.";
echo "<meta http-equiv='Refresh' content='5; URL=nextpage.php'/>";

mysql_close($con)
?>

Thanks
dvent