Inserting Session

[treeleaf20]

Hello all,
I have everything set up on my site for people to login in and there variable goes into a session variable. I was wondering if anyone can show me how I could insert that variable into the databse along with a timestamp. That would be helpful but if someone could show me how to check to see if the person is already in the database and then update the timestamp and increment a times visted column by one that would be the greatest ever. I'm not sure if it can even be done. So please help me out...I would greatly appreciate it...thank you in advance.

[devinemke]

here is a very simplified example (not much error checking). you didn't mention which database you are using but i will assume you are using mySQL and that your data structure looks something like this:

table: users
user_id (int) PK
email (varchar)
password (varchar)
timestamp (timestamp)
times_visited (int)

this example also assumes your have already put email and password into the session that that you are already connected to the database:

$result = mysql_query("SELECT * FROM users WHERE email = '" . $_SESSION['email'] . "' AND password = '" . $_SESSION['password'] . "'");
if (mysql_num_rows($result))
{
	$row = mysql_fetch_assoc($result);
	$times_visited = $row['times_visited'] + 1;
	$result_update = mysql_query('UPDATE users SET times_visited = ' $times_visited);
	{
		if ($result_update) {echo 'you have now vistited ' . $times_visited . ' times';}
	}
}
else
{
	$result_insert = mysql_query('INSERT INTO users SET
	email = '" . $_SESSION['email'] . "',
	password = '" . $_SESSION['password'] . "',
	times_visited = 1");
	if ($result_insert) {echo 'your data has been entered in our database';}
}

note that you do not need to update the timestamp field, mySQL will do that for you automagically.

[treeleaf20]

I have this code:

[code=php]

$qry = "SELECT * FROM usage WHERE username_use = '" . $SESSION['username'] . "'";
$result = mysql_query($qry);
echo $qry;
$num_rows = mysql_num_rows($result);
if ($num_rows > 0)
{
$row = mysql_fetch_assoc($result);
$times_visited = $row['times_visited'] + 1;
$qry_update = "UPDATE usage SET times_visited = ' $times_visited' WHERE username_use = '$SESSION['username']'";
echo $qry_update;
$result_update = mysql_query($qry_update);
//{
// if ($result_update) {echo 'you have now vistited ' . $times_visited . ' times';}
//}
}
?>

---

[/code]

It is giving me and error on this line:

[code=php]

$num_rows = mysql_num_rows($result);
if ($num_rows > 0)
?>

---

[/code]

It says that it is an invalid argument...I'm not sure why this would be the case. Also does the update query look right to all of you as well?? Thanks for the help.

[devinemke]

it means that your query is failing. use [man]mysql_error[/man] to see what exactly what the error is.