saving simple checkbox boolean php

Question

Something basic but I don’t see why it doesn’t work I want to save the state of a checkbox in a database, type Boolean, if checked 1 else 0 here is my code:

<input type="checkbox" name="stok"  value="1"
  <?php if(isset($_POST['stok'])) echo "checked='checked'"; ?>
/>
<?php
    if (isset($_POST['stok']) && !empty($_POST['stok']) && $_POST['stok'] === 'on')               
        $stok = 1;  
    else 
        $stok = 0;      

    mysql_query ("update tab set etat_vendu=$stok where id=$big");
?>  

//this is my var $stok=$row['stok'];

$_POST['stok'] === 'on' should be $_POST['stok'] == '1', I can't see the value "on" — Okan Kocyigit
– Okan Kocyigit, Commented May 23, 2013 at 12:16

Matheno · Accepted Answer · 2013-05-23 12:49:38Z

2

This will work:

if(isset($_POST['stok'])){
    //$stok is checked and value = 1
    $stok = $_POST['stok'];
}
else{
    //$stok is nog checked and value=0
    $stok=0;
}

answered May 23, 2013 at 12:49

Matheno

4,2126 gold badges40 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

luna dev Over a year ago

Hi, I made the store in database but when I return to modify the product the stock checkbox is not check !!

weirdan · Accepted Answer · 2021-03-31 18:17:11Z

1

$stock = $_POST['stok'] ?? 0; // Null coalescing Since PHP7

edited Mar 31, 2021 at 18:17

weirdan

2,67725 silver badges28 bronze badges

answered Mar 31, 2021 at 7:46

Jorge Alfaro

111 bronze badge

Comments

nl-x · Accepted Answer · 2013-05-23 12:18:14Z

0

Try changing $_POST['stok'] === 'on' into $_POST['stok'] === '1' in your if.

answered May 23, 2013 at 12:18

nl-x

11.9k7 gold badges36 silver badges67 bronze badges

Comments

Edwin Lambregts · Accepted Answer · 2013-05-23 12:19:14Z

0

Your if-statement can be shorter, way shorter since you're already passing a value :)

if (isset($_POST['stok']))
    $stok = $_POST['stok']; // equals 1 since that's the given value
else
    $stok = 0;

Edit: don't forget to check your UPDATE() statement:

mysql_query("UPDATE tab SET etat_vendu='".$stok."' WHERE id='".$big."'");

Add data sanitation where necessary.

answered May 23, 2013 at 12:19

Edwin Lambregts

4086 silver badges22 bronze badges

1 Comment

Edwin Lambregts Over a year ago

What is the problem? Isn't the database updated or is the checkbox not checked while the value in the database is 1?

Matheno · Accepted Answer · 2013-05-23 13:24:11Z

0

I think I know what you want now

$result = mysqli_query($con,"SELECT etat_vendu FROM tab WHERE id=".$big);
    while($row = mysqli_fetch_array($result))
    {
        $stok = $row['etat_vendu'];
    }

And your checkbox

    <form action='index.php' method='post'>
<?php
    if($stok != 0){
    echo "<input type='checkbox' name='stok'  value='1' checked='checked'/>";
    }
    else{
    echo "<input type='checkbox' name='stok'  value='1'/>";
    }
?>
    <input type='submit' name='submit' value='submit'>
    </form>
<?php
            if(isset($_POST['stok'])){
                //$stok is checkend and value = 1
                $stok = $_POST['stok'];
            }
            else{
                $stok=0;
            }
?>

answered May 23, 2013 at 13:24

Matheno

4,2126 gold badges40 silver badges54 bronze badges

1 Comment

Matheno Over a year ago

No prob, glad I could help

mzedeler · Accepted Answer · 2015-12-27 00:24:30Z

0

As simple as that

if($fetch['proved'] === '1') {
   $p1 = 1;
   $p0 = 0;
} else {
   $p1 = 0;
   $p0 = 1;
}

<select name="proved">
  <option value="<?php echo $p0 ?>"><?php echo $p0 ?></option>
  <option selected value="<?php echo $p1 ?>"><?php echo $p1 ?></option>
</select>

edited Dec 27, 2015 at 0:24

mzedeler

4,3994 gold badges30 silver badges45 bronze badges

answered Dec 26, 2015 at 23:00

kooli

171 bronze badge

Collectives™ on Stack Overflow

saving simple checkbox boolean php

6 Answers 6

1 Comment

Comments

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related