Database
MySQL admin table columns id, username, passcode.
CREATE TABLE admin
(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(30) UNIQUE,
passcode VARCHAR(30)
);
(
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(30) UNIQUE,
passcode VARCHAR(30)
);
THURSDAY, SEPTEMBER 24, 2009
PHP Login Page Example.
This post for PHP beginnersLogin Page Example. I want to explain creating database, posting form values, storing the session value and destroy the session. It's is very useful and simple. Try live demowith Username : test Password :test
 Database MySQL admin table columns id, username, passcode.
CREATE TABLE admin
( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(30) UNIQUE, passcode VARCHAR(30) ); Config.php Database configuration file.
<?php
$mysql_hostname = "hostname";$mysql_user = "username"; $mysql_password = "password"; $mysql_database = "database"; $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Opps some thing went wrong"); mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");
?>
Login.php Contains PHP and HTML code.
>?php
include("config.php");session_start(); if($_SERVER["REQUEST_METHOD"] == "POST") {
// username and password sent from Form
$myusername=addslashes($_POST['username']); $mypassword=addslashes($_POST['password']); $sql="SELECT id FROM admin WHERE username='$myusername' and passcode='$mypassword'"; $result=mysql_query($sql); $row=mysql_fetch_array($result); $active=$row['active']; $count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){ session_register("myusername"); $_SESSION['login_user']=$myusername; header("location: welcome.php"); } else { $error="Your Login Name or Password is invalid"; } }
?>
<form action="" method="post">
<label>UserName :</label>
<input type="text" name="username"/><br />
<label>Password :</label>
<input type="password" name="password"/><br/>
<input type="submit" value=" Submit "/><br />
</form>
lock.php Session verification. If no session value page redirect to login.php
<?php
include('config.php');session_start(); $user_check=$_SESSION['login_user']; $ses_sql=mysql_query("select username from admin where username='$user_check' "); $row=mysql_fetch_array($ses_sql); $login_session=$row['username']; if(!isset($login_session)) { header("Location: login.php"); }
?>
welcome.php
<?php
include('lock.php');
?>
<body>
<h1>Welcome <?php echo $login_session; ?></h1>
</body>
logout.php SignOut Destroy the session value.
<?php
session_start();if(session_destroy()) { header("Location: login.php"); }
?>
|
0 comments:
Post a Comment