<title>pendaftaran</title>
<?php
 require_once("koneksi.php");
 $username = $_POST['username'];
 $pass = md5($_POST['password']);
 $sql ="select username from user where username = '$username'";

 $query =$db->query($sql);
 if($query->num_rows !=0) {
    echo "<div align='center'> username terdaftar<a herf='daftar.php'>back</a></div>";
 } else {
    if(!$username || !$pass){
    echo "<div align='center'> masih ada data yang kosong <a herf='dafta.php'>back</a></div>";
 }else{
    $data ="insert into user values (null,'$username','$pass')";
    $simpan = $db->query($data);
    if ($simpan){
        echo "<div align='center'> pendaftaran sukses,silakan <a herf='login.php'>login</a></div>";
    } else {
        echo "<div align='center'> gagal proses </div> ";
    }
 }
 }
?>