STEP BY STEP LOGIN AND REGISTRATION TUTORIAL IN PHP

STEP 1:  First we have to create database :

CREATE TABLE  `blog_login`.`user` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`username` VARCHAR( 200 ) NOT NULL ,
`password` VARCHAR( 200 ) NOT NULL
) ENGINE = MYISAM

STEP 2:  Create config.php file.

<?php
$host="localhost";
$user="root";
$password="";
$con=mysql_connect($host,$user,$password) or die("mysql_error()");
mysql_select_db("database_name",$con);
?>

STEP 3: Now create registration form.

register.php

<form action="thanks_register.php" method="post">

<label>Username</label>
<br />
<input type="text" name="username" /><br />
<label>Password</label><br />
<input type="password" name="password" /><br />

<input type="submit" name="submit" value="Register" />
</form>

STEP 4: Create thanks_register.php

<?php
include('config.php');
if(isset($_POST['submit'])=='Register')
{
$username=$_POST['username'];
$password=$_POST['password'];
$insert=mysql_query("INSERT INTO `user` (`id`, `username`, `password`) VALUES('','$username','$password')");

if($insert)
{
echo "Successfully Inserted";
}
else
{
echo "Not Inserted";
}
}
?>

STEP 5: Create login page.

login.php

<form action="thanks_login.php" method="post">

<label>Username</label>
<br />
<input type="text" name="username" /><br />
<label>Password</label><br />
<input type="password" name="password" /><br />

<input type="submit" name="submit" value="Register" />
</form>

STEP 6: Create thanks_login.php

<?php
include('config.php');
if(isset($_POST['submit'])=='Login')
{
$username=$_POST['username'];
$password=$_POST['password'];
$sql=mysql_query("select username,password from users where username='$username' and password='$password'");
if(mysql_num_rows($sql)>0)
{

header("Location:index.php");
}
else
{
echo "invalid login";


}
?>