PHP TUTORIALS Create Login Page with DataBase-PhpMyAdmin-Mysql
FULL DETAILS..
Program Name :- htmllogin.html
<html>
<head>
<body bgcolor="">
<font>
<center><h1>Login</h1></center>
</font>
<form action="login.php" method="POST">
Username:<input type="text" name="uname">
Password:<input type="password" name="pass"><br>
<input type="submit" value="login" name="submit">
</form>
</body>
</head>
</html>
Program Name:- login.php
<?php
require ('sql_connect.php');
if (isset($_POST['submit'])){
$username=mysql_escape_string($_POST['uname']);
$password=mysql_escape_string($_POST['pass']);
if (!$_POST['uname'] | !$_POST['pass'])
{
echo ("<SCRIPT LANGUAGE='JavaScript'>
window.alert('You did not complete all of the required fields')
window.location.href='htmlogin.html'
</SCRIPT>");
exit();
}
$sql= mysql_query("SELECT * FROM `login_users` WHERE `username` = '$username' AND `password` = '$password'");
if(mysql_num_rows($sql) > 0)
{
echo ("<SCRIPT LANGUAGE='JavaScript'>
window.alert('Login Succesfully!.')
window.location.href='htmllogin.html'
</SCRIPT>");
exit();
}
else{
echo ("<SCRIPT LANGUAGE='JavaScript'>
window.alert('Wrong username password combination.Please re-enter.')
window.location.href='htmllogin.html'
</SCRIPT>");
exit();
}
}
else{
}
?>
Program Name:- sql_connect.php
<?php
mysql_connect("localhost", "root", "") or die("mysql connection is failure.");
mysql_select_db("login") or die("Database does not exists.");
?>
CODING FOR GET METHOD WITH EXAMPLE PROGRAM SESSON-2
Program name:- htmlget1.php
<html>
<head>
<body>
<h1><center>GET METHOD</center></h1>
<form action="get1.php" method="get">
Name:<input type="text" name="name">
Email:<input type="text" name="email">
<input type="submit" value="submit">
</body>
</head>
</html>
get1.php
Welcome<?php echo $_GET["name"];?>
Your Email Address is: <?php echo $_GET["email"];?>
