How to automatically send a flag

Question

Here is the HTML / JavaScript:

<form method = "post" style="display: inline;" name="thisform<?php echo $employee->id; ?>"> <input type="hidden" name="user" value="<?php echo $employee->id; ?>" /> <input type="hidden" name="auto" value="<?php echo $employee->stay_live; ?>" /> <h3><input type="checkbox" name="stay_live" onclick="document.forms.thisform<?php echo $employee->id; ?>.submit();" <?php if ($employee->stay_live == '1') { echo "checked"; } ?> title="Click to Stay Live Every Day" />&nbsp;<?php echo $employee->name; ?> </form> 

Here is the PHP :

 <?php if(isset($_POST['stay_live'])) { $user=$_POST['user']; $auto=$_POST['auto']; if ($auto == 1) { $sql = "UPDATE users SET stay_live = 0 WHERE id = '{$user}';"; } if ($auto != 1) { $sql = "UPDATE users SET stay_live = 1 WHERE id = '{$user}';"; } mysqli_query($dbconnection, $sql); } ?> 

If you see onclick code on the form, it will automatically submit the form and do the PHP POST . However, onclick only works if the checkbox NOT installed. If it is installed, the screen refreshes as if it were doing something, but the POST was never sent.

So, we summarize; everything works as expected when the box is unchecked and needs to be checked. But for UNSET to do this, the server function is never called. Can anyone understand why?

Note: this is test code, so please, no comments on SQL injection

Answer 1

Flag values ​​are not sent when they are not $_POST["stay_live"] , so $_POST["stay_live"] not set.

 <?php if (isset($_POST["user"])) // type="hidden" will be sent regardless of checkbox { if (isset($_POST["stay_alive"])) echo "Checkbox checked"; else echo "Checkbox not checked"; } ?> 

Answer 2

Using jQuery, I would do the following: you need to create a file with the functions you want to execute. This file will receive via POST or GET

In your onclick attribute, just add an if for your action variable if (the item is checked) action = unchecked --- else action = check

- jQuery function

 function cBoxSubmit($employId, $action){ // call it in your onclick attribute. $.post("submitFunction.php",{action: $action, employId: $employId, ...},function(data){ // Parameters: URL file, variables which will receive, call back function if(data){ // On Success or in your case if checked // add some code if needed } else{ // If unchecked // add some code if needed } } } 

NOTE: echo == return in your php file ... This is how you return data to the callback function in your jQuery function