Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if (isset($_POST['submit'])) {
- //hitung jumlah form
- $jumlah = count($_POST['nama']);
- //buat variabel untuk menampung data
- $value = null;
- //lakukan looping pembacaan data
- for ($i = 0; $i < $jumlah; $i++) {
- if ($_POST['nama'][$i] != null && $_POST['umur'][$i] != null) {
- //masukkan data ke variabel $value
- $value .= ",('".$_POST['nama'][$i]."','".$_POST['umur'][$i]."')";
- }
- }
- //siapkan query
- $sql = "INSERT INTO `t_anggota` (`nama`, `umur`) VALUES ".trim($value, ',');
- //siapkan koneksi ke database
- $con = mysqli_connect('localhost', 'root', '', 'multi_insert');
- //eksekusi
- mysqli_query($con, $sql);
- }
- ?>
- <html>
- <head>
- <title>Multiple Insert</title>
- <style>
- form { margin-left: 40px; }
- input[type="submit"] {
- background: #001a67;
- padding: 10px 15px;
- margin-top: 10px;
- border-radius: 5px;
- border: none;
- color: #fff;
- font-size: 16px;
- margin-left: 28%;
- }
- input[type="text"],
- input[type="number"] {
- padding: 5px;
- font-size: 14px;
- border-radius: 5px;
- border: 1px solid #4d4d4d;
- outline: 0;
- }
- h3 {
- font-size: 30px;
- margin-left: 40px;
- }
- </style>
- </head>
- <body>
- <h3>Multiple Insert</h3>
- <br />
- <form action="" method="POST">
- <?php
- for ($i = 0; $i < 5; $i++) {
- echo '<label>Nama '.($i+1).' : </label><input type="text" name="nama[]" />';
- echo ' <label>umur '.($i+1).' :</label><input type="number" name="umur[]" /><br /><br />
- }
- ?>
- <input type="submit" name="submit" value="submit" />
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement