Thursday, September 10, 2009

Login System for your Web by PHP

Step-1:
Creating Mysql Table (databse name: "tarique"): form is name of mysql table.

CREATE TABLE `form` (
`name` VARCHAR( 50 ) NOT NULL ,
`age` INT( 20 ) NOT NULL ,
`E-mail` VARCHAR( 50 ) NOT NULL ,
`password` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM ;



Step-2:
Crating HTML Form file (File name "registration.html"): regtoweb.php is name of php file.



















Step-3:
Crating PHP file (File name "regtoweb.php"): Must save your file name as regtoweb.php. and "tarique" is the mysql database name.

$fname=$_POST["name"];
$fage=$_POST["age"];
$femail=$_POST["E-mail"];
$fpassword=$_POST["password"];
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("alhera", $con);

mysql_query("INSERT INTO form(`name`, `age`, `E-mail`, `password`) VALUES('$fname','$fage','$femail','$fpassword')");
echo "Your record successfully added";

mysql_select_db("alhera", $con);

$result = mysql_query("SELECT * FROM form");

echo "





";

while($row = mysql_fetch_array($result))
{
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
}
echo "
nameageE-mailpassword
" . $row['name'] . "" . $row['age'] . "" . $row['E-mail'] . "" . $row['password'] . "
";

mysql_close($con);
?>



By using this code you can make login system into your localhost.

No comments:

Post a Comment

Search This Blog

Followers