Member Avatar for msolomon.ashish

Hello
iwant a script in php i describe my problem below

i checked all the checkbox and updated after updating i am getting values from enable field but when i checked randomly i am not getting updating i am getting different values to be checked

Here's the code

/* For connecting database 
      connect.php
*/
/*  database connection */ 
<?php

$con=mysqli_connect("localhost","root","","multiple");
if(mysqli_connect_errno())
{
echo "failed to connect".mysqli_connect_error();

}

?>
*/ 
<?php
error_reporting(E_ALL ^ E_NOTICE);
include_once("connect.php");

if(isset($_POST["submit"])) 
{
$usersCount = count($_POST["id"]);
for($i=0;$i<=$usersCount;$i++) {
$query1=mysqli_query($con,"UPDATE multiple set enable='".$_POST["id1"][$i]."' where id='".$_POST["id"][$i]."'");
if($query1)
{
echo "updated";
}
}
}


?>

<html>
<head>

</head>
<body>
<form action="index.php" method="post">
<?php
include_once("connect.php");
$retrieve=mysqli_query($con,"select * from multiple ORDER BY id ASC ");

while($row=mysqli_fetch_array($retrieve))
{

$id=$row["id"];
$enable=$row["enable"];
?>




<input type="checkbox" name="id1[]" id="id1[]"  value="enable" <?php   if($enable=="enable") { echo 'checked' ; }  ?> />

<input type="hidden" name="id[]"  id="id[]" value="<?php  echo $row["id"];  ?>" />
<?php  
echo $row["name"]; 

?>


<?php
}

?>
</br></br>
<input type="submit"   name="submit" id="submit" value="submit" />
</form>

</body>
</html>  
/*  sql dump file  */
-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Nov 08, 2014 at 05:23 PM
-- Server version: 5.6.16
-- PHP Version: 5.5.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `multiple`
--

-- --------------------------------------------------------

--
-- Table structure for table `multiple`
--

CREATE TABLE IF NOT EXISTS `multiple` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `enable` varchar(255) DEFAULT NULL,

  PRIMARY KEY (id)
) ;

--
-- Dumping data for table `multiple`
--

INSERT INTO `multiple` (`id`, `firstname`, `lastname`, `email`, `phone`, `enable`) VALUES
(3, 'ashish2', 'ashish2', 'ashish2', 'ashish2', 'enable'),
(4, 'ashish3', 'ashish2', 'ashish3', 'ashish2', 'enable'),
(5, 'anusha', 'anusha', 'anusha', 'anusha', ''),
(6, 'madiri', 'madiri', 'madiri', 'madiri', '');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  • 2 Contributors
  • 2 Replies
  • 4K Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by msolomon.ashish
Member Avatar for diafol

A problem with this setup is that only checked checkboxes are sent as post data, the unchecked ones are ignored so do not appear in the $_POST superglobal.

You can use the id value of the row in the checkbox itself - don't use a hidden input.

<input type="checkbox" name="id1[<?php  echo $row["id"];  ?>]" id="id_<?php  echo $row["id"];  ?>"  value="enable" <?php   if($enable=="enable") { echo 'checked' ; }  ?> />

Or

<input type="checkbox" name="id1[]" id="id_<?php  echo $row["id"];  ?>"  value="<?php  echo $row["id"]" <?php   if($enable=="enable") { echo 'checked' ; }  ?> />

The latter is probably easiest as you can then get all the ids (checked) from this:

$checkedArray = (array) $_POST['id1']; //will give an array of id values that are checked
if(!empty($checkArray))
{
    $str = implode(",",$checkedArray);
    //run update query -see below
}

BUT that will not tell you which ones were changed from 1 to 0. You can however cover this in your SQL. I strongly suggest that you do not store the word 'enable' in your DB but change it to tinyint type and have value 1 and 0 (1 equiv to checked and 0 unchecked). So this:

<?php   if($enable=="enable") { echo 'checked' ; }  ?>

Becomes:

<?php   if($enable==1) { echo 'checked' ; }  ?>

The update query could then look like something like this:

UPDATE multiple SET `enable` = IF(id IN ($str),1,0)

NOT TESTED

Member Avatar for msolomon.ashish

Hello It's not working for my form

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.