Docstoc

3.Create a Basic Login Script in PHP

Document Sample
3.Create a Basic Login Script in PHP Powered By Docstoc
					           Create a Basic Login Script in PHP
Interested in creating your own forum page, blog, or even a shopping cart? A login area is the
first step. Here is how to create a script for it in PHP.

Steps
   1. 1

       Create the login database and table. For the purposes of the code examples below, we
       will assume the database name to be "test" and the table name to be "members". The
       database and table can be created through the control panel of your webhost. The
       "members" table will store the username and the passwords of all the people would be
       allowed access via this login script. The table should have a unique id field as the primary
       key, a username field, and a password field.

       Example:

       <form name="form1" method="post" action="checklogin.php">
       <strong>Member Login </strong>
       Username: <input name="myusername" type="text" id="myusername" />
       Password: <input name="mypassword" type="password" id="mypassword" />
       <input type="submit" name="Submit" value="Login" /></form>

   2. 2

       Create the login interface. This is an html page containing a form, two text boxes for
       the user name and password, and a submit button. As long as you have these elements,
       you may design the layout however you wish.

   3. 3

       Create the php script that will check the login input against the database. This script
       will connect to the database, send a query and retrieve the result, check to see if the
       username and password is correct and send you to the next page depending on the result
       of the comparison.

       Example (connecting to the database):

       <?php
       $host="localhost"; // Host name
       $username=""; // username
       $password=""; // password
       $db_name="test"; // Database name
       $tbl_name="members"; // Table name
  // Replace database connect functions depending on database you are
  using.
  mysql_connect("$host", "$username", "$password");
  mysql_select_db("$db_name");



  Example (submitting query and retrieving results):

  // username and password sent from form
  //NEVER Remove the mysql_real_escape_string. Else there could be anSql-
  Injection!
  $myusername=mysql_real_escape_string($_POST['myusername']);
  $mypassword=mysql_real_escape_string($_POST['mypassword']);

  $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and
  password='$mypassword'";
  $result=mysql_query($sql);



  Example (checking results):

  // Replace counting function based on database you are using.
  $count=mysql_num_rows($result);
  // If result matched $myusername and $mypassword, table row must be 1
  row



  Example (direct user based on result):

  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";
  }

4. 4

  Create the page that will display after login success. This script will start your session
  and display an html message of your choosing.

  Example:

  // Check if session is not registered , redirect back to main page.
  <?
  session_start();

  if(!session_is_registered(myusername)){
  header("location:main_login.php");
  }
  ?>

  <html>
  <body>
  Login Successful
  </body>
  </html>

5. 5

  Create logout script. This step is optional as sessions can time out. If you wish to create
  one, you will need a button or link to initiate the script and a message to confirm the
  success of logging out.

  Example:

  <?
  session_start();
  session_destroy();
  ?>

				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:7
posted:6/28/2012
language:English
pages:3