Guru Online: Create Login Page Using PHP

Entries (RSS)
Comments (RSS)

Create Login Page Using PHP

Labels: PHP Script |

Overview
In this tutorial create 3 files

main_login.php
checklogin.php
login_success.php

Step

Create table "members" in database "test".
Create file main_login.php.
Create file checklogin.php.
Create file login_success.php.
Create file logout.php

Create table "members"

Create file main_login.php

Create file checklogin.php

<br /><?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="members"; // Table name  // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB");  // username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword'];  // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword);  $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql);  // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row  if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("myusername"); session_register("mypassword"); header("location:login_success.php"); } else { echo "Wrong Username or Password"; } ?><br />

Create file login_success.php

Logout.php

For PHP5 User - checklogin.php

<br /><?php ob_start(); $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="members"; // Table name  // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB");  // Define $myusername and $mypassword $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword'];  // To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword);  $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql);  // Mysql_num_row is counting table row $count=mysql_num_rows($result); // If result matched $myusername and $mypassword, table row must be 1 row  if($count==1){ // Register $myusername, $mypassword and redirect to file "login_success.php" session_register("myusername"); session_register("mypassword"); header("location:login_success.php"); } else { echo "Wrong Username or Password"; }  ob_end_flush(); ?><br />

Encrypting Password - Make your Login More Secure

0 comments:

Subscribe to: Post Comments (Atom)