drimlen

querySQL

May 5th, 2012
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. <?php
  2. error_reporting(0);
  3. if($_POST["simpan"])
  4. {
  5. $conn = mysql_connect("127.0.0.1","jackhack","dancing01")or
  6. die(mysql_error()."Cannot connect to server");
  7.  
  8. $data = mysql_select_db("personalia", $conn)or
  9. die(mysql_error()."Cannot connect to database");
  10.  
  11.  
  12. $textnip = $_POST['NIP'];
  13. $textnama = $_POST['nama'];
  14. $kodedepartemen = $_POST['kode'];
  15. $tanggalLhr = $_POST['tahun']-$_POST['bulan']-$_POST['tanggal'];
  16. $textanak = $_POST['anak'];
  17.  
  18. $sql = "insert into karyawan (NIP, Kode_Dep, Nama, Tanggal_Lahir, Jumlah_Anak) values ('$textnip','$kodedepartemen', '$textnama', '$tanggalLhr' ,'$textanak')";
  19. $result = mysql_query($sql, $conn)or
  20. die(mysql_error()."An error occure in SQL query <br> Query: $sql");
  21. print("<table align=\"center\">");
  22. print("<tr bgcolor=\"#0099FF\">");
  23. print("<td align=\"center\">");
  24. print("<font face=\"verdana\" color=\"#CCEBFF\">Terima kasih $textnama data anda telah kami simpan</td>");
  25. print("</tr>");
  26. print("<tr bgcolor=\"#0099FF\">");
  27. print("<td align=\"center\">");
  28. print("<font face=\"verdana\" color=\"#CCEBFF\"><a href=\"insertPegawai.php\">Back</td>");
  29. print("</tr>");
  30. print("</table>");
  31.  
  32. }
  33. ?>
Advertisement
Add Comment
Please, Sign In to add comment