Note: first create the database project_cms .Then create the table…into it.
CREATE TABLE IF NOT EXISTS `tbl_login` (
`userid` int(11) NOT NULL auto_increment,
`username` varchar(50) NOT NULL,
`password` varchar(70) NOT NULL,
`email` varchar(100) NOT NULL,
`status` int(2) NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
<?php
session_start(); //session start
ob_start(); //object start
if(isset($_POST[‘submit’])){
include(‘config.php’);
$username =mysql_escape_real_string( $_POST[‘username’]);
$password = mysql_escape_real_string($_POST[‘password’]);
$sql= mysql_query(“select username,password from tbl_user where username= ‘”.$username.”‘ and password='”.$password.”‘ and status=1 “);
$result =mysql_num_rows($sql);
if($result >0) {
$_SESSION[‘username’] = $username;
session_register(‘username’);
header(‘location:index.php’);
ob_end_flush();
}else{
$ans = ‘Wrong Username or Password’;
}
}
?>
Just embed this Code at the top of index.php file: