Wednesday 18 January 2012

login.php


<?php
// Inialize session
session_start();
// Include database connection settings
include('config.inc');
// Retrieve username and password from database according to user's input
$login = mysql_query("SELECT * FROM user WHERE (username = '" . mysql_real_escape_string($_POST['username']) . "') and (password = '" . mysql_real_escape_string(md5($_POST['password'])) . "')");
// Check username and password match
if (mysql_num_rows($login) == 1) {
// Set username session variable
$_SESSION['username'] = $_POST['username'];
// Jump to secured page
header('Location: securedpage.php');
}
else {
// Jump to login page
header('Location: index.php');
}
?>

simple registration form


for form :
<html>
<body>
<h1> Registration Form : </h1>
<form name="form1" action="register.php" method="post" />
Name :
   <input type="text" name="name" value=""/>

Address :
  <input type="text" name="address" value=""/>
  <input type="submit" name="submit" value="Register"/>
  </form>

</body>
</html>

register.php


?php
include("cls.php");
$obj= new connect();
$obj->connect();

$varname=$_POST['name'];
$varaddress=$_POST['address'];

$sqlinsert= "insert into reg(name,address)values('$varname','$varaddress')";
if(!mysql_query($sqlinsert))
{
echo "errro in querry".mysql_error();
}
else
{
echo"registration complete";
}
?>


cls.php



<?php
class connect
{
function connect()
{
$con = mysql_connect('localhost','root','');
if(!$con)
{
die("Error in database connection");
}
$sdb=mysql_select_db('db',$con);
if(!$sdb)
{
die("Erroe in database selection");
}

}
}
?>