Bagaimana cara untuk Menyimpan banyak data dengan Checkbox

Dibuat 6 Tahun lalu | 2019-09-30 17:37:57 WIB,

Telah Dilihat 4589 Kali

Sultan Account

aswar munap Mengatakan : Sultan Account

Assalamualaikum Warahmatullahi Wabarakatuh...
 
Gan..mohon bantuannya..ane pengen menyimpan banyak data sekliagus dengan masing field dan checkbox..sesuai yang dilampiran...
 
ini code tuk di tablenya...
 
<td class="hidden-480"><?php echo $no; ?></td>
	<td><?php echo "<input type='text' class='col-xs-12' readonly id='form-field-1' name='detil[]' value='".$k['checklist_name']."'/>"; ?>
	<?php echo "<input type='hidden' class='col-xs-10 col-sm-10'  readonly id='form-field-1' name='id_detil[]' value='".$k['id_detil_ceklist']."'/>"; ?></td>
 
	<td><?php echo "<input type='text' class='col-xs-12'  id='form-field-3' name='qty[]' />"; ?></td>
	<td><?php echo "<select name='stas[]' class='col-xs-15 col-sm-15' class='chosen-select form-control'  >
												<option selected value='ada'>Ada</option>
												<option value='tidak'>Tidak</option>
					</select>"; ?></td>
 
	<td class="center"><?php echo "<input class='checkbox' type='checkbox'  name='baik[]' value='baik' />"; ?></td>
	<td class="center"><?php echo "<input class='checkbox' type='checkbox'  name='rusak[]' value='rusak' />"; ?></td>
	<td class="center"><?php echo "<input class='checkbox' type='checkbox'  name='bersih[]' value='bersih' />"; ?></td>
	<td class="center"><?php echo "<input class='checkbox' type='checkbox'  name='kotor[]' value='kotor'/>"; ?></td>
	<td class="center"><?php echo "<input type='text' class='col-xs-12 col-sm-12'  id='form-field-1' name='ket[]' />"; ?>
	<?php echo "<input type='hidden' class='col-xs-10 col-sm-10'  readonly id='form-field-1' name='unit[]' value='".$unit."'/>"; ?>
		<?php echo "<input type='hidden' class='col-xs-10 col-sm-10'  readonly id='form-field-1' name='unit1' value='".$unit."'/>"; ?></td>
 
dan ini tuk aksi simpan datanya..
 
 $num_input = count($_POST['id_detil']);
//input data pendidikan
for ($i = 0; $i < $num_input; $i++) {
$id_detil = $_POST['id_detil'][$i];
$qty = $_POST['qty'][$i];
$stas = $_POST['stas'][$i];
$baik = $_POST['baik'][$i];
$rusak = $_POST['rusak'][$i];
$bersih = $_POST['bersih'][$i];
$kotor = $_POST['kotor'][$i];
$ket = $_POST['ket'][$i];
$tanggal = date('Y-m-d');
$unit = $_POST['unit'][$i];
 
 
    $query = "insert into checklist (check_list, qty,stat,baik,rusak,bersih,kotor,ket,tgl_cek,unit) 	
	values('$id_detil', '$qty', '$stas', '$baik', '$rusak','$bersihk','$kotor','$ket', '$tanggal', '$unit')";
mysql_query($query) or die(mysql_error());	
 
tapi kenapa error masuk ke databasenya ya gan...

Ada 1 File Kiriman :

1. Untitled90.png (19 KB)

Ada 3 Jawaban

Bukhori Muslim commented on 01 Okt 2019 13:36:17 Sultan Account

	Assalamualaikum,.. untuk atribut name buat gini coba gan semuanya : name='baik[$no]'

Munajat Ibnu
commented on 02 Okt 2019 14:15:26 Sultan Account

Assalamualaikum,.. sy coba ga ada masalah mas
<!DOCTYPE html>
<html>
<head>
	<title></title>
</head>
<body>
	<form action="" method="post">
		<table>
			<tr>
				<td>No</td>
				<td>Checklist</td>
				<td>QTY</td>
				<td>Status</td>
				<td>Baik</td>
				<td>Rusak</td>
				<td>Bersih</td>
				<td>Kotor</td>
				<td>Keterangan</td>
			</tr>
			<tr>
				<td>1</td>
				<td><input class='col-xs-12' id='form-field-1' name='detil[]' readonly type='text' value='test'> <input class='col-xs-10 col-sm-10' id='form-field-1' name='id_detil[]' readonly type='hidden' value='1'></td>
				<td><input class='col-xs-12' id='form-field-3' name='qty[]' type='text'></td>
				<td><select class='chosen-select form-control' name='stas[]'>
					<option selected value='ada'>Ada</option>
					<option value='tidak'>Tidak</option>
				</select></td>
				<td class="center"><input class='checkbox' name='baik[]' type='checkbox' value='baik'></td>
				<td class="center"><input class='checkbox' name='rusak[]' type='checkbox' value='rusak'></td>
				<td class="center"><input class='checkbox' name='bersih[]' type='checkbox' value='bersih'></td>
				<td class="center"><input class='checkbox' name='kotor[]' type='checkbox' value='kotor'></td>
				<td class="center"><input class='col-xs-12 col-sm-12' id='form-field-1' name='ket[]' type='text'> <input class='col-xs-10 col-sm-10' id='form-field-1' name='unit[]' readonly type='hidden' value='1'></td>
			</tr>
			<tr>
				<td>2</td>
				<td><input class='col-xs-12' id='form-field-1' name='detil[]' readonly type='text' value='test2'> <input class='col-xs-10 col-sm-10' id='form-field-1' name='id_detil[]' readonly type='hidden' value='2'></td>
				<td><input class='col-xs-12' id='form-field-3' name='qty[]' type='text'></td>
				<td><select class='chosen-select form-control' name='stas[]'>
					<option selected value='ada'>
						Ada
					</option>
					<option value='tidak'>
						Tidak
					</option>
				</select></td>
				<td class="center"><input class='checkbox' name='baik[]' type='checkbox' value='baik'></td>
				<td class="center"><input class='checkbox' name='rusak[]' type='checkbox' value='rusak'></td>
				<td class="center"><input class='checkbox' name='bersih[]' type='checkbox' value='bersih'></td>
				<td class="center"><input class='checkbox' name='kotor[]' type='checkbox' value='kotor'></td>
				<td class="center"><input class='col-xs-12 col-sm-12' id='form-field-1' name='ket[]' type='text'> <input class='col-xs-10 col-sm-10' id='form-field-1' name='unit[]' readonly type='hidden' value='2'></td>
			</tr>
			<tr>
				<td>2</td>
				<td><input class='col-xs-12' id='form-field-1' name='detil[]' readonly type='text' value='test3'> <input class='col-xs-10 col-sm-10' id='form-field-1' name='id_detil[]' readonly type='hidden' value='3'></td>
				<td><input class='col-xs-12' id='form-field-3' name='qty[]' type='text'></td>
				<td><select class='chosen-select form-control' name='stas[]'>
					<option selected value='ada'>
						Ada
					</option>
					<option value='tidak'>
						Tidak
					</option>
				</select></td>
				<td class="center"><input class='checkbox' name='baik[]' type='checkbox' value='baik'></td>
				<td class="center"><input class='checkbox' name='rusak[]' type='checkbox' value='rusak'></td>
				<td class="center"><input class='checkbox' name='bersih[]' type='checkbox' value='bersih'></td>
				<td class="center"><input class='checkbox' name='kotor[]' type='checkbox' value='kotor'></td>
				<td class="center"><input class='col-xs-12 col-sm-12' id='form-field-1' name='ket[]' type='text'> <input class='col-xs-10 col-sm-10' id='form-field-1' name='unit[]' readonly type='hidden' value='3'></td>
			</tr>
		</table><input type="submit" name="submit" value="kirim">
	</form>
</body>
</html>
<?php
if(isset($_POST['submit'])){
define("DBUSER","root");
define("DBPASS","");
define("DBNAME","test");
define("DBSERVER","localhost");
     $db = @new mysqli(DBSERVER,DBUSER,DBPASS,DBNAME);
 
    if ($db->connect_errno) {
        echo '<p>There was an error connecting to the database!</p>';
        if ($mysqliDebug) {
            echo $db->connect_error;
        }
        die();
    }
function filterarr($str) {
$str   = filter_input(INPUT_POST, $str, FILTER_DEFAULT, FILTER_REQUIRE_ARRAY);
return $str;
}
 
$tanggal = date('Y-m-d');
if(isset($_POST["id_detil"]) && is_array($_POST["id_detil"])){	
$count = count(filterarr('id_detil'));
for( $i=0; $i < $count; $i++ ){
	$id_detil = isset(filterarr('id_detil')[$i]) ? filterarr('id_detil')[$i] : null;
	$qty = isset(filterarr('qty')[$i]) ? filterarr('qty')[$i] : null;
	$stas = isset(filterarr('stas')[$i]) ? filterarr('stas')[$i] : null;
	$baik = isset(filterarr('baik')[$i]) ? filterarr('baik')[$i] : null;
	$rusak = isset(filterarr('rusak')[$i]) ? filterarr('rusak')[$i] : null;
	$bersih = isset(filterarr('bersih')[$i]) ? filterarr('bersih')[$i] : null;
	$kotor = isset(filterarr('kotor')[$i]) ? filterarr('kotor')[$i] : null;
	$ket = isset(filterarr('ket')[$i]) ? filterarr('ket')[$i] : null;
	$unit = isset(filterarr('unit')[$i]) ? filterarr('unit')[$i] : null;
$query = "insert into checklist (check_list, qty,stat,baik,rusak,bersih,kotor,ket,tgl_cek,unit) 	
	values('$id_detil', 
	'$qty', 
	'$stas', 
	'$baik', 
	'$rusak',
	'$bersih',
	'$kotor',
	'$ket', 
	'$tanggal', 
	'$unit')";
$sql = $db->query($query);
	}
}
if($sql){echo "ok";}else{echo "gagal";}
}
?>
 
databasenya
-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 02, 2019 at 09:13 AM
-- Server version: 10.1.36-MariaDB
-- PHP Version: 7.2.11
 
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;
 
--
-- Database: `test`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `checklist`
--
 
CREATE TABLE `checklist` (
  `id` int(5) NOT NULL,
  `check_list` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `stat` varchar(20) NOT NULL,
  `baik` varchar(20) NOT NULL,
  `rusak` varchar(20) NOT NULL,
  `bersih` varchar(20) NOT NULL,
  `kotor` varchar(20) NOT NULL,
  `ket` varchar(200) NOT NULL,
  `tgl_cek` date NOT NULL,
  `unit` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--
-- Dumping data for table `checklist`
--
 
INSERT INTO `checklist` (`id`, `check_list`, `qty`, `stat`, `baik`, `rusak`, `bersih`, `kotor`, `ket`, `tgl_cek`, `unit`) VALUES
(1, 1, 1, 'ada', 'baik', '', 'bersih', 'kotor', 'q', '2019-10-02', 0),
(2, 2, 2, 'ada', '', '', '', '', 'w', '2019-10-02', 0),
(3, 1, 0, 'ada', 'baik', 'rusak', 'bersih', 'kotor', '', '2019-10-02', 0),
(4, 2, 0, 'ada', '', '', '', '', '', '2019-10-02', 0),
(5, 1, 2, 'ada', 'baik', 'rusak', 'bersih', 'kotor', '', '2019-10-02', 0),
(6, 2, 1, 'ada', '', '', '', '', '', '2019-10-02', 0),
(7, 1, 0, 'ada', '', '', '', '', '', '2019-10-02', 0),
(8, 2, 0, 'ada', '', '', '', '', '', '2019-10-02', 0),
(9, 1, 0, 'ada', '', '', '', '', '', '2019-10-02', 0),
(10, 2, 0, 'ada', '', '', '', '', '', '2019-10-02', 0),
(11, 1, 12, 'ada', 'baik', 'rusak', 'bersih', 'kotor', '121', '2019-10-02', 1),
(12, 2, 3, 'ada', '', '', '', '', '1', '2019-10-02', 2),
(13, 3, 4, 'ada', '', '', '', '', '1', '2019-10-02', 3),
(14, 1, 0, 'ada', '', '', '', '', '', '2019-10-02', 1),
(15, 2, 0, 'ada', '', '', '', '', '', '2019-10-02', 2),
(16, 3, 0, 'ada', '', '', '', '', '', '2019-10-02', 3);
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `checklist`
--
ALTER TABLE `checklist`
  ADD PRIMARY KEY (`id`);
 
--
-- AUTO_INCREMENT for dumped tables
--
 
--
-- AUTO_INCREMENT for table `checklist`
--
ALTER TABLE `checklist`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
COMMIT;
 
/*!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 */;

aswar munap
commented on 02 Okt 2019 16:26:42 Sultan Account

Assalamualaikum,.. 
 
Masih salah bro Munajat Ibnu....
pas di submit, yang masuk itu..
padahal pilihannya...
1. Baik, Rusak
2. Rusak, Bersih
3. Bersih, Kotor
 
Tetapi tang masuk ke database seperti lampiran
 
Mohon pencerahannya bro....

Terdapat 1 File dilampirkan :

1. Untitled91.png (18 KB)

Maaf, Untuk Memberikan Komentar Anda Harus Login !!!

	BSI - Bank Syariah Indonesia (451)

	ROBBY PRIHANDAYA
	1043-5665-19


	Bank Muamalat (147)
	ROBBY PRIHANDAYA
	4220-0174-81

Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (69185 Members, 796 Products, 4718 Topic, 13114 Comments)

Bagaimana cara untuk Menyimpan banyak data dengan Checkbox

Ada 3 Jawaban

Projects Remote

Hot Questions

Tentang Kami

Jam Layanan

Knowledgebase