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("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; } } function filterarr($str) { $str = filter_input(INPUT_POST , $str, FILTER_DEFAULT , FILTER_REQUIRE_ARRAY ); return $str; } $tanggal = date('Y-m-d'); $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 */;
|