Login user using php & mysql
This code is not yet completed but it is usable.
<?php $user = $_POST['txtusername']; $pass = $_POST['txtpassword']; $login = $_POST['btnlogin']; $dbhost = "localhost"; $dbuser = "iicuser"; $dbpass ="123456"; $dbname = "iicdatabase"; $cnn = mysql_connect($dbhost,$dbuser,$dbpass); $sldb = mysql_select_db($dbname,$cnn); if(isset($login)){ if(!$user){ echo "Please Input Your Username"; } else{ $check_username = mysql_query("SELECT username FROM tbladmin WHERE username='".$user."'"); if(!mysql_num_rows($check_username)){ if(!$pass){ echo "Please Input Your Password"; } else{ $check_password = mysql_query("SELECT password FROM tbladmin WHERE password='".$pass."'"); if(mysql_num_rows($check_password) && mysql_num_rows($check_username)){ echo "Well Done"; } else{ echo "You might wrong username or password."; } } } } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Login with database</title> </head> <form action="#" method="post"> Username:<input type="text" name="txtusername" /><br /> Password:<input type="text" name="txtpassword" /><br /> <input type="submit" name="btnlogin" value="Login" /> </form> <body> </body> </html>