<?php
$host=""; // nama host
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // nama database di DB.sql
$tbl_name=""; // nama table sql

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
?>
 <?php
$username = $_POST['username'];
$password = $_POST['password'];
if (empty($username)){
echo "<script>alert('Username belum diisi')</script>";
echo "<meta http-equiv='refresh' content='1 url=login.php'>";
}else if (empty($password)){
echo "<script>alert('Password belum diisi')</script>";
echo "<meta http-equiv='refresh' content='1 url=login.php'>";
}else{
session_start();
$login = mysql_query("select * from member where username='$username' and password='$password'");
$data=mysql_fetch_array($login);
if (mysql_num_rows($login) > 0){
    $_SESSION['username']=$data['username'];
header("location:login_berhasil.php");
}else{
echo "<script>alert('Username atau Password salah')</script>";
echo "<meta http-equiv='refresh' content='1 url=login.php'>";
}
}

?>