華府江山 http://203.72.56.8/phpBB3/ |
|
Login.php Example http://203.72.56.8/phpBB3/viewtopic.php?f=42&t=737 |
第 1 頁 (共 1 頁) |
發表人: | alex [ 2011年 11月 26日, 20:10 ] |
文章主題 : | Login.php Example |
Login.php Example ***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"); } ?> |
第 1 頁 (共 1 頁) | 所有顯示的時間為 UTC + 8 小時 |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |