Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /** untuk kasusnya, pada sampel ini dibutuhkan 4 file **/
- // file koneksi1.php
- <?php
- $c = mysql_connect("localhost","root","") or die("Tidak bisa konek ke mysql");
- $o = mysql_select_db("mydb1",$c) or die("Tidak bisa membuka database 1");
- ?>
- // file koneksi2.php
- <?php
- $c = mysql_connect("localhost","root","") or die("Tidak bisa konek ke mysql");
- $o = mysql_select_db("mydb2",$c) or die("Tidak bisa membuka database 2");
- ?>
- // file input.html
- <!DOCTYPE html>
- <head>
- <title>Register</title>
- </head>
- <body>
- <h1>Form Registrasi</h1>
- <form action="register.php" method="post">
- Nama: <input type="text" name="nama" size="30" placeholder="Nama Lengkap" /><br />
- Gender: <label><input type="radio" name="gender" value="L" /> Pria</label> <label><input type="radio" name="gender" value="P" /> Wanita</label><br />
- Tgl Lahir: <input type="text" name="tgl_lahir" size="20" placeholder="dd/mm/yyyy" /><br />
- Kota: <input type="text" name="kota" size="30" placeholder="Kota" /><br />
- Username: <input type="text" name="username" size="30" placeholder="username" /><br />
- Password: <input type="password" name="password" size="30" placeholder="Password" /><br />
- Email: <input type="text" name="email" size="30" placeholder="[email protected]" /><br />
- Website/Blog: <input type="text" name="url" size="30" placeholder="http://" /> *optional<br />
- <input type="submit" name="simpan" value=" REGISTER " />
- </form>
- // file register.php
- <?php
- include "koneksi1.php";
- if(isset($_POST['simpan'])){
- $nama = mysql_real_escape_string($_POST['nama']);
- $gender= $_POST['gender'];
- $tgl_lahir= preg_replace("/(\d{2})\/(\d{2})\/(\d{4})/","$3-$2-$1",$_POST['tgl_lahir']);
- $kota = mysql_real_escape_string($_POST['kota']);
- $username= mysql_real_escape_string($_POST['username']);
- $password= md5($_POST['password']);
- $email= mysql_real_escape_string($_POST['email']);
- $url= mysql_real_escape_string($_POST['url']);
- if($nama && $gender && $tgl_lahir && $kota && $username && $password && $email){
- $simpan = mysql_query("INSERT into tblLogin(username,password,email,nama) VALUES('$username','$password','$email','$nama')");
- if($simpan){
- include "koneksi2.php";
- $simpan2 = mysql_query("INSERT into tblUser(username,nama,email,kota,url) VALUES('$username','$nama','$email','$kota','$url')");
- if($simpan2) echo "Registrasi berhasil...";
- }
- }else{
- echo "<p class=\"warning\">Maaf... harap isi form secara lengkap!!</p>";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment