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 "
name | age | password | |
---|---|---|---|
" . $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