How i can update sql record by checkbox in php?

Question

I'm new in PHP so I faced a problem, I got these rows in MySQL

+---+--------------+
|ID |  published   |
+---+--------------+
| 1 |    TRUE      |
| 2 |    FALSE     |
| 3 |    TRUE      |
+---+--------------+

For example, I want to update ID no. 2 into "TRUE" with a checkbox:

<?php 

$host="localhost";  
$username="root";  
$password="password"; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="chek_box_test"; // Table name 

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
?>

<?php 

$id = $_GET['id'];
$select = mysql_query("SELECT * FROM $tbl_name WHERE id = $id");
while($row = mysql_fetch_array($select)){
?>
<form method="post" action="checkbox_test.php?id=<?php echo $id; ?>">
<input type="checkbox" name="publish" <?php
if($row['publish'] == TRUE){
     echo "checked='checked'";
}
?>
/>
<input type='hidden' name='id' value="<?php echo $row['id']; ?>" />
<input type="submit" name="submit" value="Update"></form><?php } ?>

<?php 
if(isset($_POST['submit'])){
    echo $publish = ($_POST['publish'] == 1) ? TRUE : FALSE;
    $id=$_POST['id'];
    $query = mysql_query("UPDATE $tbl_name SET publish = '$publish' WHERE id =$id");
}
?>

My problem is if I check that PHP it only give me 'FALSE' value. I want that if I check and click submit it will give me "TRUE" or "FALSE".

Please help me to do this. Any useful advice will be appreciated.

What does your table field published actually hold? Tinyint (0|1), enum('yes','no') or enum('TRUE','FALSE'). You are mixing up true and yes. — colburton
– colburton, Commented Jun 23, 2014 at 11:33
oh sorry its a mistake` it was boolian number instaed of yes or no — Sifat080
– Sifat080, Commented Jun 23, 2014 at 14:03
There is no such thing as a boolean number in mysql. What is the datatype of this column? — colburton
– colburton, Commented Jun 23, 2014 at 14:05
Ok its tiny or enum. Pick one of them. Better if it is enum('TRUE','FALSE') — Sifat080
– Sifat080, Commented Jun 23, 2014 at 14:10
If it is tinyint 'yes' and 'no' are all mapped to 1, which is not what you want. — colburton
– colburton, Commented Jun 23, 2014 at 14:11

hellcode · Accepted Answer · 2014-06-24 11:49:55Z

1

The value of your input field is missing:

<input type="checkbox" name="publish" value="1" <?php
if($row['publish'] == 'yes'){
     echo "checked='checked'";
}
?>
/>

To solve the error 'Undefined index publish' you could change

echo $publish = ($_POST['publish'] == 1) ? TRUE : FALSE;

to:

$publish = FALSE;
if(isset($_POST['publish']) and $_POST['publish']==1) {
  $publish = TRUE;
}

edited Jun 24, 2014 at 11:49

answered Jun 23, 2014 at 11:32

hellcode

2,6881 gold badge19 silver badges22 bronze badges

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

1 Comment

Sifat080 Over a year ago

Its working. Its give me true value by check and uncheck. But 1 more problem have. Next time when i uncheck and click update button it show a error. And the error is 'Undefined index publish in my file name on line 34

user2078937 · Accepted Answer · 2014-06-23 11:34:58Z

0

Mention the value="TRUE"

   <input type="checkbox" name="publish"  <?php
   if($row['publish'] == 'yes'){
    echo "checked='checked' ";
    echo "value='TRUE'";
   }
   ?>
   />

answered Jun 23, 2014 at 11:34

user2078937

1 Comment

Sifat080 Over a year ago

plz see my question code one more time and First ans also

Collectives™ on Stack Overflow

How i can update sql record by checkbox in php?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related