Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <title>title</title>
- <link rel="stylesheet" href="style.css">
- <script type="text/javascript" src="jquery-1.8.1.js"></script>
- </head>
- <body>
- <form id="id_form" action="<?php $_SERVER['PHP_SELF']?>" method="post">
- <table>
- <tr>
- <td><input type="button" name="add_btn" value="Add" id="add_btn"></td><td> </td><td> </td><td> </td>
- </tr>
- <script> $(document).ready(function() {
- var count = 0;
- $("#add_btn").click(function(){
- count += 1;
- $('#container').append(
- '<tr class="records">'
- + '<td ><div id="'+count+'">' + count + '</div></td>'
- + '<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>'
- + '<td><input id="nama_depan_' + count + '" name="nama_depan_' + count + '" type="text"></td>'
- + '<td><input id="nama_belakang_' + count + '" name="nama_belakang_' + count + '" type="text"></td>'
- + '<td><a class="remove_item" href="#" >Hapus</a>'
- + '<input id="rows_' + count + '" name="rows[]" value="'+ count +'" type="hidden"></td></tr>'
- );
- });
- $(".remove_item").live('click', function (ev) {
- if (ev.type == 'click') {
- $(this).parents(".records").fadeOut();
- $(this).parents(".records").remove();
- }
- });
- });
- </script>
- <tr>
- <td>No</td><td>Jenis Kelamin</td><td>Nama Depan</td><td>Nama Belakang</td><td> </td>
- </tr>
- <tbody id="container">
- </tbody>
- <tr>
- <td><input type="submit" name=submit value="Save"></td><td> </td><td> </td><td> </td>
- </tr>
- </table>
- </form>
- <?php
- if(isset($_POST['submit'])){
- $connection = mysql_connect("localhost","root","") or die(mysql_error());
- mysql_select_db("biodata") or die(mysql_error());
- foreach ($_POST['rows'] as $key => $count ){
- $jk = $_POST['jk_'.$count];
- $nama_depan = $_POST['nama_depan_'.$count];
- $nama_belakang = $_POST['nama_belakang_'.$count];
- $query_2 = "INSERT INTO biodata (jk,nama_depan,nama_belakang)VALUES ('$jk','$nama_depan','$nama_belakang')";
- mysql_query($query_2) or die(mysql_error());
- }
- echo '<script type="text/javascript">alert("Saved Success !");</script>';
- mysql_close($connection);
- }else{
- echo '<script type="text/javascript">alert("Failed");</script>';
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement