Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once("konek.php");
- if ((isset($_POST['submit']))&&($_POST['submit']=='simpan')){
- $sql = "select * from keluarga where no_anggota='".$_POST['no_anggota']."'";
- $result = mysql_query($sql) or die (mysql_error());
- $num_rows = mysql_num_rows($result);
- if($num_rows>0){
- echo"<script>alter('N_Anggota yang di masukan sudah ada');</script>";
- echo"<script>location='simpan.php';</script>";
- exit();
- }
- $sql = "insert into keluarga(no_anggota, nama, alamat) values ('".$_POST['no_anggota']."','".$_POST['nama']."','".$_POST['alamat']."')";
- $result = mysql_query($sql) or die (mysql_error());
- if($result){
- echo"<script>alter('Data sudah terisimpan');</script>";
- echo"<script>location=='keluarga.php';</script>";
- }
- }
- ?>
- <html>
- <head>
- <title>Insert anggota</title>
- <script type="text/javascript">
- function cek_data()
- {
- if(form1.no_anggota.value=="")
- {
- alert("No Anggota tidak boleh kosong");
- form1.no_anggota.focus()
- return false
- }
- if(form1.nama.value=="")
- {
- alert("Nama tidak boleh kosong");
- form1.nama.focus()
- return false
- }
- if(form1.alamat.valus=="")
- {
- alert("Alamat tidak boleh kosong");
- form1.alamat.focus()
- return false
- }
- return true;
- //false ==> buat apaan ya?
- }
- </script>
- </head>
- <body>
- <h2>Menambah keluarga</h2>
- <hr>
- <form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" onSubmit="return cek_data()">
- <table width="100%" border="0">
- <tr>
- <td width="19%">no_anggota</td>
- <td width="81%"><label>
- <input name="no_anggota" type="text" size="8" maxlength="8">
- </label></td>
- </tr>
- <tr>
- <td>nama</td>
- <td><label>
- <input name="nama" type="text" size="30" maxlength="30">
- </label></td>
- </tr>
- <tr>
- <td>alamat</td>
- <td><label>
- <input name="alamat" type="text" size="50" maxlength="50">
- </label></td>
- </tr>
- <td> </td>
- <td><label>
- <input type="submit" name="submit" value="Simpan">
- <input type="reset" name="reset" value="Reset">
- </label></td>
- </tr>
- </label>
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement