arijulianto

PHP Insert ke 2 database

Jan 2nd, 2014
232
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.40 KB | None | 0 0
  1. /** untuk kasusnya, pada sampel ini dibutuhkan 4 file **/
  2.  
  3. // file koneksi1.php
  4. <?php
  5. $c = mysql_connect("localhost","root","") or die("Tidak bisa konek ke mysql");
  6. $o = mysql_select_db("mydb1",$c) or die("Tidak bisa membuka database 1");
  7. ?>
  8.  
  9. // file koneksi2.php
  10. <?php
  11. $c = mysql_connect("localhost","root","") or die("Tidak bisa konek ke mysql");
  12. $o = mysql_select_db("mydb2",$c) or die("Tidak bisa membuka database 2");
  13. ?>
  14.  
  15. // file input.html
  16. <!DOCTYPE html>
  17. <head>
  18. <title>Register</title>
  19. </head>
  20. <body>
  21. <h1>Form Registrasi</h1>
  22. <form action="register.php" method="post">
  23. Nama: <input type="text" name="nama" size="30" placeholder="Nama Lengkap" /><br />
  24. Gender: <label><input type="radio" name="gender" value="L" /> Pria</label> <label><input type="radio" name="gender" value="P" /> Wanita</label><br />
  25. Tgl Lahir: <input type="text" name="tgl_lahir" size="20" placeholder="dd/mm/yyyy" /><br />
  26. Kota: <input type="text" name="kota" size="30" placeholder="Kota" /><br />
  27. Username: <input type="text" name="username" size="30" placeholder="username" /><br />
  28. Password: <input type="password" name="password" size="30" placeholder="Password" /><br />
  29. Email: <input type="text" name="email" size="30" placeholder="[email protected]" /><br />
  30. Website/Blog: <input type="text" name="url" size="30" placeholder="http://" /> *optional<br />
  31. <input type="submit" name="simpan" value=" REGISTER " />
  32. </form>
  33.  
  34.  
  35. // file register.php
  36. <?php
  37. include "koneksi1.php";
  38. if(isset($_POST['simpan'])){
  39. $nama = mysql_real_escape_string($_POST['nama']);
  40. $gender= $_POST['gender'];
  41. $tgl_lahir= preg_replace("/(\d{2})\/(\d{2})\/(\d{4})/","$3-$2-$1",$_POST['tgl_lahir']);
  42. $kota = mysql_real_escape_string($_POST['kota']);
  43. $username= mysql_real_escape_string($_POST['username']);
  44. $password= md5($_POST['password']);
  45. $email= mysql_real_escape_string($_POST['email']);
  46. $url= mysql_real_escape_string($_POST['url']);
  47.  
  48. if($nama && $gender && $tgl_lahir && $kota && $username && $password && $email){
  49. $simpan = mysql_query("INSERT into tblLogin(username,password,email,nama) VALUES('$username','$password','$email','$nama')");
  50. if($simpan){
  51. include "koneksi2.php";
  52. $simpan2 = mysql_query("INSERT into tblUser(username,nama,email,kota,url) VALUES('$username','$nama','$email','$kota','$url')");
  53. if($simpan2) echo "Registrasi berhasil...";
  54. }
  55. }else{
  56. echo "<p class=\"warning\">Maaf... harap isi form secara lengkap!!</p>";
  57. }
  58. }
  59. ?>
Advertisement
Add Comment
Please, Sign In to add comment