Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // cara input multipel data ke database
- /** insert multipel data **/
- // file multipel-insert-kategori.php
- <?php
- include "koneksi.php";
- echo "<form action=\"tambah.php\" method=\"post\"><table>
- <tr>
- <th>No.</th>
- <th>Nama Kategori</th>
- <th>Slug</th>
- </tr>";
- $jml_data = 10;
- for($i=1;$i<=$jml_data;$i++){
- echo "<tr>
- <td align=\"center\">$i.</td>
- <td><input type=\"text\" name=\"nama_kategori[]\" /></td>
- <td><input type=\"text\" name=\"slug[]\" /></td>
- </tr>";
- }
- echo "</table><input type=\"submit\" name=\"simpan\" value=\"Simpan Perubahan\" /></form>";
- ?>
- // file tambah.php
- <?php
- include "koneksi.php";
- if(isset($_POST['simpan'])){
- // loop data
- foreach($_POST['nama_kategori'] as $index=>$nama_kategori){
- $slug = $_POST['slug'][$index];
- if(trim($nama_kategori)!="" && trim($slug)!="") // validasi inputan tidak kosong
- echo("INSERT into kategori(nama_kategori,slug) VALUES('$nama_kategori','$slug')<br />");
- }
- echo "<script>history.back()</script>";
- }
- ?>
- /** update multipel data **/
- // file tampildata.php
- <?php
- echo "<form action=\"simpan.php\" method=\"post\">
- <table>
- <tr>
- <th>No.</th>
- <th>Nama Kategori</th>
- <th>Slug</th>
- <th>Hapus</th>
- </tr>";
- $no = 1;
- $sql = mysql_query("SELECT * from kategori order by nama_kategori");
- while($data = mysql_fetch_array($sql)){
- echo "<tr>
- <td align=\"center\">$no.<input type=\"hidden\" name=\"id[]\" value=\"$data[idkategori]\" /></td>
- <td><input type=\"text\" name=\"nama_kategori[]\" size=\"40\" value=\"$data[nama_kategori]\" /></td>
- <td><input type=\"text\" name=\"slug[]\" size=\"40\" value=\"$data[slug]\" /></td>
- <td align=\"center\"><input type=\"text\" name=\"hapus[]\" size=\"40\" value=\"1\" /></td>
- </tr>";
- }
- echo "</table><p><input type=\"submit\" name=\"simpan\" value=\"Simpan Perubahan \" /></p></form>";
- ?>
- // file simpan.php
- <?php
- include "koneksi.php";
- if(isset($_POST['simpan'])){
- // loop data
- foreach($_POST['id'] as $index=>$idkategori){
- $nama_kategori= $_POST['nama_kategori'][$index];
- $slug = $_POST['slug'][$index];
- $hapus= $_POST['hapus'][$index];
- // update
- mysql_query("UPDATE kategori set nama_kategori='$nama_kategori', slug='$slug' where idkategori='$idkategori'");
- // hapus data
- if($hapus)
- mysql_query("DELETE from kategori where idkategori='$idkategori'");
- }
- echo "<script>history.back()</script>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment