Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $email=$_POST['email'];
- $password=$_POST['password'];
- $nama=$_POST['nama'];
- $jk=$_POST['jk'];
- $tempatlahir=$_POST['tempatlahir'];
- $tanggallahir=$_POST['tanggallahir'];
- $alamat=$_POST['alamat'];
- $kelurahan=$_POST['kelurahan'];
- $kecamatan=$_POST['kecamatan'];
- $kota=$_POST['kota'];
- $provinsi=$_POST['provinsi'];
- $hp=$_POST['hp'];
- $jp=$_POST['jp'];
- $kritik=$_POST['kritik'];
- if(!empty($email)|| !empty($password) || !empty($nama)|| !empty($jk)|| !empty($tempatlahir)|| !empty($tanggallahir)|| !empty($alamat)|| !empty($kelurahan)|| !empty($kecamatan)|| !empty($kota) || !empty($provinsi)|| !empty($hp)|| !empty($jp)|| !empty($kritikp)){
- $host="localhost";
- $dbUsername="root";
- $dbpassword="";
- $dbname="elefanaweb";
- $conn = new mysqli($host, $dbUsername, $dbpassword, $dbname);
- if(mysqli_connect_error()){
- die('Connect error ( '. mysqli_connect_errno().')'. mysqli_connect_error());
- }else {
- $SELECT = "SELECT email from daftar where email = ? limit 1";
- $INSERT = "INSERT into daftar(email, password, nama,jk,tempatlahir,tanggallahir, alamat,kelurahan,kecamatan,
- kota, provinsi,hp, jenisperwatan, kritik)values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
- $stmt=$conn->prepare($SELECT);
- $stmt->bind_param('s', $email);
- $stmt->execute();
- $stmt->bind_result($email);
- $stmt->store_result();
- $rnum=$stmt->num_rows;
- if($rnum==0){
- $stmt->close();
- $stmt=$conn->prepare($INSERT);
- $stmt->bind_param('ssscsdbssssicb', $email, $password, $nama, $jk, $tempatlahir, $tanggallahir, $alamat, $kelurahan,
- $kecamatan, $kota, $provinsi,$hp, $jp, $kritik);
- $stmt->execute;
- echo 'data berhasil dimasukkan';
- }else{
- echo 'email sudah digunakan';
- }
- $stmt -> close();
- $conn->close();
- }
- }
- else {
- echo "form data harus diisi";
- die();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement