Remember Me code

NZ_Kiwis

I have a login script which on one page uses a forum with two text boxes for the username and password. I want to add a check box which will ask if the user want's to be rememberd....

can i and if so how do i add something like this to my code???

this is the code which starts the session

<?php
	session_start();

// dBase file
include "dbConfig.php";

if ($redirect == "") {
$redirect = "http://www.site.com";
} 





if ($_GET["op"] == "login")
	{
	if (!$_POST["username"] || !$_POST["password"])
		{
		Header("Location: error.php");
		}

	// Create query 

$q = "SELECT * FROM `members` "			."WHERE `username`='".$_POST["username"]."' "
			."AND `password`='".$_POST["password"]."' "
			." LIMIT 1";
		// Run query
		$r = mysql_query($q);

	if ( $obj = @mysql_fetch_object($r) )
		{
		// Login O.K., create session variables
		$_SESSION["valid_id"] = $obj->id;
		$_SESSION["valid_user"] = $_POST["username"];
		$_SESSION["valid_time"] = time();




		// Redirect to member page
require("../includes/currentdatetime.php"); 
$result6 = mysql_query ("SELECT * FROM members where username = '" . $_SESSION["valid_user"] . "';");
$row6 = mysql_fetch_array($result6);


$pre = $row6[lastlogin_stamp];

$total = $row6[login_times] + 1;
$result3 = mysql_query ("UPDATE members set login_times = '$total', prelogin_stamp = ' $pre' WHERE username = '" . $_SESSION ["valid_user"] . "';") or die("INSERT error: ".mysql_error());


$result = mysql_query ("UPDATE members set last_log_date = '$date', last_log_time = '$time', lastlogin_stamp = '$nowtime' WHERE username = '" . $_SESSION["valid_user"] . "';") or die("INSERT error: ".mysql_error());





		Header("Location: $redirect");
		}
	else
		{
		// Login not successful
		Header("Location: error.php");
		}
	}
else
	{
	Header("Location: error.php");
	}
?>

halojoy

hey

in login page, which you have not shown to us
can be a box where people can mark if want to be remember,
to avoid need to login next time

when this user submit his login, $user $pass and $remember (1 or 0)
these data are usually stored in a COOKIE, along with some other data
this is about the only way to do remember me
so need not login

Otherwise script will not know who is this visitor
unless you use IP-address (REMOTE_ADDR) as identification

I do not use cookies much
sometimes I use IP-address, for script to remember myself

to not need to login ( I have a static IPnumber, that is unique)

here is my most frequently used website, for time being
which uses my IP-number ( have not paid for any domain name )

http://213.100.118.115/wiki/index.php

####################################

when i go surfing, like here at www.phpbuilder.com
I need not login at all
(I can use REMEMBER ME, because I am the only one using my computer
have no wife or children, that can pretend to be me, and post in my name)

this is because this forums php script (phpB😎 has stored a COOKIE
in my Computers harddrive Cookie folder/file

each time I come here, php script is looking for this cookie
get my user-id and remember me variable ( 1 or 0)
and set me as login
and get my settings, username, email and whatever
from my user-id user data record stored in database

Basically you will have to do somthing like that
to remember you visitors and make it easy for them

Register Username and Password at halojoy's wiki

Your login will last 24 hours, if I remember this wiki script correctly
but of course I could change cookie lifetime to a week,

by just change a number of seconds in php script (or even 30 days)

/halojoy - is not using cookies, so you will often have to login at his website
..... but using some downloaded php scripts, that reads cookie and
..... userdata stored in flat-text-files (same as simple halojoy's users database)

🙂

LoganK

Halojoy, is your WIKI built with flat-file too?