[Resolved] [Resolved] [Resolved] [Resolved] Persistent cookies.

alexboyer

Hello all,

I have a question about persistent cookies. I understand that session cookies are stored on the server and are deleted when the session ends (either by logout scripts or by physically closing the browser window).

Here's what I need help with. I want users to be able to click a button for a website setting and then when they come back after a week, the cookie on their computer gets detected and the setting gets put in place.

Sort of like how UPS does with their "Do you want to start here next time you visit" thing.
http://ups.com/?cookie=us_en_home&setCookie=yes
By clicking the link, you are setting a client-side cookie that won't just disappear when you leave.
Any help would be great!

Thanks in advance,

mrhappiness

http://www.php.net/setcookie

hth

alexboyer

Ok, that helps a little bit. But I still don't understand how cookies relay the variable information to the page. For instance I know how to set and call $_SESSION['var'] correctly. I've made pages that use session variables. But whenever I use setcookie(), nothing happens.... On top of that, I don't know which variables to set, nor do I know how to call them back when the user visits the page.

I'll continue to review the link you gave me.

Thanks!

alexboyer

Alright, I think I'm getting closer.... However, I get this error:
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 5 in /home/httpd/vhosts/xxxxxxxxx.com/httpdocs/contest/contest_results.php on line 41

When I try to run this:

if($_COOKIE['authuser'])
{
	mysql_connect(localhost,$username,$password);
	@mysql_select_db($database) or die( "Unable to select database");
	$authuser=$_COOKIE['authuser'];
	$cookiequery="SELECT * FROM passwords WHERE authuser='$authuser'";
	$cookres=mysql_query($cookiequery);
	$cookrow=mysql_fetch_row($cookres);
	$cookpass=mysql_result($cookres,0,"authpass");
	$authpass=$cookpass;
}

I've already set up the database connection variables in an external file and I've already set the $_COOKIE['authuser'] variable. I can also retrieve $COOKIE['authuser'] and it echos correctly. It may be related to the fact that I've already connected to the table once

dnast

Try changing

$cookrow=mysql_fetch_row($cookres);
$cookpass=mysql_result($cookres,0,"authpass");

$cookrow=mysql_fetch_array($cookres);
$cookpass=$cookrow['authpass'];

mysql_result doesn't work like you'd think after using mysql_fetch_* and some other mysql functions.

alexboyer

Ok, thanks. I actually had it working (sort of) before I changed it to what you suggested. Now I'm working on testing again. Here's an oddity I've been noticing. I've calculated the expiration time of the cookie out for 1 month using time()60602430. What's weird is that it will work for a while... I even echoed out every variable I'm using and they come through just fine. I can even close the browser window and open it back up and still be logged in. But every so often, I'll bring up the URL again and I will have been logged out.... So anyway, yeah. That's strange to me... It works sometimes and not others. We'll see if your change fixed that.

alexboyer

Ok, here's the entire page.... What's happening is when the person logs in, the session variables are carried over... But the cookie variables aren't created until after I click something else.

I think it's because

if($COOKIE['authuser'])
{
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$authuser=$COOKIE['authuser'];
$cookiequery="SELECT * FROM passwords WHERE authuser='$authuser'";
$cookres=mysql_query($cookiequery);
$cookrow=mysql_fetch_array($cookres);
$cookpass=$cookrow['authpass'];
$authpass=$cookpass;
echo "Authuser: $authuser<br>Cookiequery: $cookiequery<br>Cookres: $cookres<br>Cookrow: $cookrow<br>Cookpass: $cookpass<br>Authpass: $authpass<br>";
}

needs to be somewhere else, but I'm not sure where to put it. I would like it so the cookie is created as soon as the person logs in with the correct login/password combo. Also, I want the page to check for the cookie and automatically log them in after it finds the cookie.

<?php
session_start();
$time= time()+60*60*24*30;
setcookie("authuser", $_SESSION['authuser'], $time);
if($_POST["authuser"]) 
{ 
  $authuser=$_POST["authuser"]; 
  $authpass=$_POST["authpass"];   

} 
elseif($_SESSION["authuser"]) 
{ 
  $authuser=$_SESSION["authuser"]; 
  $authpass=$_SESSION["authpass"]; 
}
/*$authuser=$_POST['authuser'];
$authpass=$_POST['authpass'];
*/
include("dbinfo.inc.php");
$submit=$_GET['submit'];
$sort=$_GET['sort'];
$order=$_GET['order'];
if(!$order){
$order="ASC";
}
if(!$sort){
$sort="firstname";
}
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
if($_COOKIE['authuser'])
{
	mysql_connect(localhost,$username,$password);
	@mysql_select_db($database) or die( "Unable to select database");
	$authuser=$_COOKIE['authuser'];
	$cookiequery="SELECT * FROM passwords WHERE authuser='$authuser'";
	$cookres=mysql_query($cookiequery);
	$cookrow=mysql_fetch_array($cookres); 
	$cookpass=$cookrow['authpass'];
	$authpass=$cookpass;
	echo "Authuser: $authuser<br>Cookiequery: $cookiequery<br>Cookres: $cookres<br>Cookrow: $cookrow<br>Cookpass: $cookpass<br>Authpass: $authpass<br>";
}
$_SESSION['authuser']=$authuser;
$_SESSION['authpass']=$authpass;
$query="SELECT * FROM contest ORDER BY $sort $order";
$result=mysql_query($query);
$num=mysql_numrows($result);
$querypass="SELECT * FROM passwords WHERE authuser='$authuser' AND authpass='$authpass'";
$resultpass=mysql_query($querypass);
$numpass=mysql_num_rows($resultpass);
mysql_close();
?>

<?  if($numpass=="1"){ ?>

<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
</tr>
<tr>
<td valign="top"><br>
<div align="center" class="style1"><span class="style2">Current Contestant List</span><br>
<br>
</div></td>
</tr>
<tr>
<td valign="top">
<form name="form1" method="GET" action="contest_results.php">
<select name="sort" size="1">
<option value="">Select

<option value="firstname">First Name
<option value="lastname">Last Name
<option value="email">E-Mail
<option value="age">Age
<option value="entrydate">Date Entered
</select>
<input name="Submit" type="submit" class="redform" value="Order List">
</form>
<div align="center"><a href="logout.php">Logout</a></div>
</td>
</tr>
<tr>
<td valign="top">

<? echo " Sorting by $sort.&nbsp;&nbsp;<a href=\"contest_results.php?sort=$sort&order=ASC\" title=\"Sort ascending.\"><img src=\"../graphics/nav_buttons/up_cc0000.gif\" width=\"10\" height=\"10\" border=0></a>&nbsp;&nbsp;<a href=\"contest_results.php?sort=$sort&order=DESC\" title=\"Sort descending.\"><img src=\"../graphics/nav_buttons/down_cc0000.gif\" width=\"10\" height=\"10\" border=0></a>"?>

</td>
</tr>
<tr>
<td valign="bottom">
<img src="../graphics/bkgd/1px_333.gif" width="100%" height="5"></td>
</tr>
<td>
<table align="left" width="350" border="0" cellspacing="0" cellpadding="0">

<?
$i=0;
while ($i < $num) {
$name=mysql_result($result,$i,"firstname");
$namelast=mysql_result($result,$i,"lastname");
$address_1=mysql_result($result,$i,"address_1");
$city=mysql_result($result,$i,"city");
$state=mysql_result($result,$i,"state");
$country=mysql_result($result,$i,"country");
$phone=mysql_result($result,$i,"phone_number");
$email=mysql_result($result,$i,"email");
$zip=mysql_result($result,$i,"zip");
$age=mysql_result($result,$i,"age");
$comments=mysql_result($result,$i,"comments");
$entrydate=mysql_result($result,$i,"entrydate");
$id=mysql_result($result,$i,"ID");
?>

<?php echo "$name $namelast - ";
				if(!$age){
					echo "Did not give age information.<br>";
					}
				else{
					echo "$age years old.<br>";
					}
				echo "Entered $entrydate.<br><br>$address_1<br>$city, $state&nbsp;&nbsp;$zip<br>$phone<br><a href=\"mailto:$email\">$email</a>"?>

</td>
</tr>
<tr>
<td>

 <? echo"<div class=\"whitetiny\"><strong>Comments</strong></div>$comments" ?>

</td>
</tr>
</table></td>
</tr>
<tr>
<td>
<img src="../graphics/bkgd/1px_333.gif" width="100%" height="5"></td>
</tr>

<?
++$i;
} 
?>

</table>
</td>
</tr>
</table>
<br>

<? }
elseif(!$authuser || !$authpass){?>

<div align="right">Username</div></td>
<td><input name="authuser" type="text" id="authuser" size="23" maxlength="23"></td>
</tr>
<tr>
<td colspan="2"><img src="../graphics/bkgd/1px_trans.gif" width="100%" height="5"></td>
</tr>
<tr>
<td><div align="right">Password</div></td>
<td><input name="authpass" type="password" id="authpass" size="25" maxlength="25"></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input name="Submit" type="submit" class="redform" value="Submit">
<input name="Reset" type="reset" class="redform" value="Reset">
<img src="../graphics/bkgd/1px_trans.gif" width="100%" height="5"> </div></td>
</tr>
</table>
</form>

<? }
elseif($numpass=="0"){?>

<br><br><br>
<form name="form2" method="POST" action="contest_results.php">
<table width="350" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#666666">
<tr>
<td colspan="2">Something was entered incorrectly... </td>
</tr>
<tr>
<td width="50%"><div align="right">Username</div></td>
<td><input name="authuser" type="text" id="authuser" size="23" maxlength="23"></td>
</tr>
<tr>
<td colspan="2"><img src="../graphics/bkgd/1px_trans.gif" width="100%" height="5"></td>
</tr>
<tr>
<td><div align="right">Password</div></td>
<td><input name="authpass" type="password" id="authpass" size="25" maxlength="25"></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input name="Submit" type="submit" class="redform" value="Submit">
<input name="Reset" type="reset" class="redform" value="Reset">
<img src="../graphics/bkgd/1px_trans.gif" width="100%" height="5"> </div></td>
</tr>
</table>
</form>

<? }
else{?>

<br><br><br>
<form name="form2" method="POST" action="contest_results.php">
<table width="350" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#666666">
<tr>
<td width="50%" height="26"><div align="right">Username</div></td>
<td><input name="authuser" type="text" id="authuser" size="23" maxlength="23"></td>
</tr>
<tr>
<td colspan="2"><img src="../graphics/bkgd/1px_trans.gif" width="100%" height="5"></td>
</tr>
<tr>
<td><div align="right">Password</div></td>
<td><input name="authpass" type="password" id="authpass" size="25" maxlength="25"></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input name="Submit" type="submit" class="redform" value="Submit">
<input name="Reset" type="reset" class="redform" value="Reset">
<img src="../graphics/bkgd/1px_trans.gif" width="100%" height="5"> </div></td>
</tr>
</table>
</form>

<? }

 ?>