Members Zone

@NvenomJun 19.2011 — #well i cant really give you a step by step guide as im short on time but i can give you a general direction.

the way i would do it is have a seperate table for members although you can also just assign a 0, 1 and check that but sticking with the whole seperate table we will do it like this.

you will need a table called members in your DB with the coulmns

username -TEXT- and pass -TEXT-

memberlogin.php

[code=php]
  // First we connect to the database
 
 mysql_connect("127.0.0.1", "root", "pass") or die(mysql_error()); 
 
 mysql_select_db("database") or die(mysql_error()); 
 
 //than we check if there is a login cookie
 
 if(isset($_COOKIE['ID_my_site']))
 
 
 //if there is, it logs you in and directes you to the members page
 
 { 
 $username = $_COOKIE['my_site_member_Login']; 
 
  $pass = $_COOKIE['my_site_member_Pass'];
 
 
   $check = mysql_query("SELECT * FROM members WHERE username = '$username'")or die(mysql_error());
 
  while($info = mysql_fetch_array( $check )) 
 
   {
 
   if ($pass != $info['password']) 
 
   {
 
   }
 
   else
 
   {
 
   header("Location: memberonly.php");
 
 
 
   }
 
   }
 
 }
 
 
 //if the login form is submitted 
 
 if (isset($_POST['submit'])) { // if form has been submitted
 
 
 
 // makes sure they filled it in
 
  if(!$_POST['username'] | !$_POST['pass']) {
 
   die('You did not fill in a required field.');
 
  }
 
  // checks it against the database
 
 
 
  if (!get_magic_quotes_gpc()) {
 
   $_POST['email'] = addslashes($_POST['email']);
 
 
  }
 
  $check = mysql_query("SELECT * FROM members WHERE username = '".$_POST['username']."'")or die(mysql_error());
 
 
 
 
 //Gives error if user dosen't exist
 
 $check2 = mysql_num_rows($check);
 
 if ($check2 == 0) {
 
   die('That user does not exist in our database. <a href=register page if you want it.php>Click Here to Register</a>');
 
   }
 
 while($info = mysql_fetch_array( $check )) 
 
 {
 
  $_POST['pass'] = stripslashes($_POST['pass']);
 
  $info['password'] = stripslashes($info['password']);
 
  $_POST['pass'] = md5($_POST['pass']);
 
 //gives error if the password is wrong
 
  if ($_POST['pass'] != $info['password']) {
 
   die('Incorrect password, please try again.');
 
  }
 else 
 
 { 
 
 
 // if login is ok then we add a cookie 
 
   $_POST['username'] = stripslashes($_POST['username']); 
 
   $hour = time() + 50400;  //14 hours it expires
 
 setcookie(my_site_member_Login, $_POST['username'], $hour); 
 
 setcookie(my_site_member_Pass, $_POST['pass'], $hour);
 
 //then redirect them to the members area 
 
 header("Location: memberonly.php"); 
 } 
 
 } 
 
 } 
 
 else 
 
 { 
 
 
 
 // if they are not logged in 
 //We display the login page
 ?> 
 [/code]

[code=html]
 <body>
 <form action="<?php echo $_SERVER['PHP_SELF']?>" method="post"> 
 
  <tr><td align="Center">Username:</td><td></br> 
 
  <input type="text" name="username"> 
 
  </td></tr> </br>
 
  <tr><td align="Center">Password:</td><td></br>
 
  <input type="password" name="pass"> 
 
  </td></tr></br> 
 
  <tr><td colspan="2" align="Center"> </br>
 
  <input type="submit" name="submit" value="Login"> 
 
   </td></tr>
 </form>
 </body>
 [/code]

Than on your memberonly page we simply add this at the top or include it in external .php file so you can easly add it to all your member pages

memberonly.php

[code=php]
 <?php 
 
 // Connects to your Database 
 
 mysql_connect("127.0.0.1", "root", "pass") or die(mysql_error()); 
 
 mysql_select_db("data") or die(mysql_error()); 
 
 //checks cookies to make sure they are logged in 
 
 if(isset($_COOKIE['ID_my_site'])) 
 
 { 
 
  $username = $_COOKIE['my_site_member_Login']; 
 
  $pass = $_COOKIE['my_site_member_Pass']; 
 
   $check = mysql_query("SELECT * FROM members WHERE username = '$username'")or die(mysql_error()); 
 
  while($info = mysql_fetch_array( $check )) 
 
   { 
 
 
 
 //if the cookie has the wrong password, they are taken to the login page 
 
   if ($pass != $info['password']) 
 
   { 			header("Location: memberlogin.php"); 
 
   } 
 
 
 
 //otherwise they are shown the admin area (this just allows them to stay on the same page) 
 
  else 
 
   { 
 
 
   } 
 
   } 
 
   } 
 
 else 
 
 
 
 //if the cookie does not exist, they are taken to the login screen 
 
 { 
 
 header("Location: memberlogin.php"); 
 
 } 
 
 ?>
 
 [/code]

and than of course you finish of memberonly.php with what ever page content you want

Members Zone

2 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Members Zone

2 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #PHP _↴