Advertisement
H4nk

Multi Input Form

Sep 21st, 2012
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.97 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en">
  3.   <head>
  4.     <meta charset="utf-8">
  5.     <title>title</title>
  6.     <link rel="stylesheet" href="style.css">
  7.     <script type="text/javascript" src="jquery-1.8.1.js"></script>
  8.   </head>
  9.   <body>
  10.   <form id="id_form" action="<?php $_SERVER['PHP_SELF']?>" method="post">
  11.         <table>
  12.             <tr>
  13.             <td><input type="button" name="add_btn" value="Add" id="add_btn"></td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td>
  14.         </tr>
  15. <script> $(document).ready(function() {
  16.             var count = 0;
  17.  
  18.             $("#add_btn").click(function(){
  19.                     count += 1;
  20.                 $('#container').append(
  21.                              '<tr class="records">'
  22.                          + '<td ><div id="'+count+'">' + count + '</div></td>'
  23.                          + '<td><select <option value="">Select...</option>  <option value="M">Male</option>  <option value="F">Female</option>  id="jk_' + count + '" name="jk_' + count + '" type="text"></select></td>'
  24.                          + '<td><input id="nama_depan_' + count + '" name="nama_depan_' + count + '" type="text"></td>'
  25.                          + '<td><input id="nama_belakang_' + count + '" name="nama_belakang_' + count + '" type="text"></td>'
  26.                          + '<td><a class="remove_item" href="#" >Hapus</a>'
  27.                          + '<input id="rows_' + count + '" name="rows[]" value="'+ count +'" type="hidden"></td></tr>'
  28.                     );
  29.                 });
  30.  
  31.                 $(".remove_item").live('click', function (ev) {
  32.                 if (ev.type == 'click') {
  33.                 $(this).parents(".records").fadeOut();
  34.                         $(this).parents(".records").remove();
  35.             }
  36.             });
  37.         });
  38. </script>
  39.             <tr>
  40.                 <td>No</td><td>Jenis Kelamin</td><td>Nama Depan</td><td>Nama Belakang</td><td>&nbsp;</td>
  41.             </tr>
  42.             <tbody id="container">
  43.         </tbody>
  44.         <tr>
  45.             <td><input type="submit" name=submit value="Save"></td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td>
  46.           </tr>
  47.         </table>
  48.  
  49.     </form>
  50. <?php
  51.     if(isset($_POST['submit'])){
  52.       $connection = mysql_connect("localhost","root","") or die(mysql_error());
  53.       mysql_select_db("biodata") or die(mysql_error());
  54.             foreach ($_POST['rows'] as $key => $count ){
  55.                 $jk = $_POST['jk_'.$count];
  56.                 $nama_depan = $_POST['nama_depan_'.$count];
  57.                 $nama_belakang = $_POST['nama_belakang_'.$count];
  58.                 $query_2 = "INSERT INTO biodata (jk,nama_depan,nama_belakang)VALUES ('$jk','$nama_depan','$nama_belakang')";
  59.  
  60.                 mysql_query($query_2) or die(mysql_error());
  61.             }
  62.  
  63.            echo '<script type="text/javascript">alert("Saved Success !");</script>';
  64.  
  65.         mysql_close($connection);
  66.  
  67.     }else{
  68. echo '<script type="text/javascript">alert("Failed");</script>';
  69.     }
  70. ?>
  71.   </body>
  72. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement