INSERT

<html>
<title>Pendaftaran User</title>
<center><h1>Pendaftaran Pengguna</h1></center>
<center>
<table border=2>
<form method=post>


<tr>
   <td><br>Username : </td>
   <td><input type=text name=user></br></td>
</tr>
<tr>
   <td><br>Password : </td>
   <td><input type=password name=pass></br></td>
</tr>
<tr>
   <td><br>Name : </td>
   <td><input type=text name=adminame></br></td>
</tr>
<tr>
   <td><br>Email : </td>
   <td><input type=text name=email></br></td>
</tr>
<tr>
<td colspan=2 align=center><input type=submit value='Submit'></td>
</tr>
</form>
</center>
<?php


$username = $_POST['user'];
$pass = $_POST['pass'];
$name = $_POST['adminame'];
$email = $_POST['email'];
/*

Server : Localhost
User : user_webadmin
Password : sekolah123
DB Name : web_admin
Table Name : webadmin

*/

$masuk = mysql_connect("localhost","user_webadmin","sekolah123");

//Memastikan Masuk Ke DB

if(!$masuk) {
     die ('Kesalahan :'.mysql_error());
     }

//Pilih DB

if(!empty($_POST['user']) &&($_POST['pass']) && ($_POST['adminame']) && ($_POST['email'])) {


mysql_select_db("web_admin",$masuk);

//Jalankan SQL Query
//Table Name : web_admin
//id (INT)
//username,password,adminame,email (VARCHAR)

$query = mysql_query("SELECT * FROM webadmin WHERE username = '{$username}'");
$result = mysql_num_rows($query);

if($result != 0) {

mysql_query("INSERT INTO webadmin(username,password,adminame,email)VALUES('{$username}','{$pass}','{$name}','{$email}')");

}


//Tutup MYSql
mysql_close($masuk);

}

?>