dannon

Oh, doing it whenever the user logs in is a good idea. Why didn't I think of it before? Thank you!!

Yea It's without the last = '$last', I forgot to add a comma when I was testing it. So is it possible to fix the cookie problem?

Yes I have tested it. The database contained the newer value. Edit:: I'm actually using this code. I have used the code at the top just for testing. $query = "INSERT INTO " . TABLE_REMEMBER . " (hash, user_id) VALUES ('$hash', $user_id) ON DUPLICATE KEY UPDATE hash = '$hash' last = '$last'"; $query = $this->db->query($query); setcookie(C_HASH, $hash, time() + $this->rememberMeTime, '/'); //stored for a year.

I have created a function which inserts a hash into a database and sets a cookie with the same hash. I call this function every time an user visit the site and has the hash cookie set. But when I keep refreshing the page very quickly the cookie hash value and the database hash value go out of sync. As if the function gets terminated in the middle of it processing. What can I do to fix this? I use this code to update the hash: public function updateHash($user_id, $hash) { $query = "INSERT INTO " . TABLE_REMEMBER . " (hash, user_id) VALUES ('$hash', $user_id) ON DUPLICATE KEY UPDATE hash = '$hash'"; $query = $this->db->query($query); if($query){ setcookie(C_HASH, $hash, time() + $this->rememberMeTime, '/'); //stored for a year. } } (I use PDO for my database stuff.) Also... Is there a way to make this query faster? It kind of slows down the generation of my website.

I have created a new topic.

If you are wondering.. I use this to check the hash: public function checkRememberMe($hash) { $sth = $this->db->prepare("SELECT user_id, time, hash FROM " . TABLE_REMEMBER . " WHERE hash = :hash "); $pass = array( ":hash" => $hash ); $sth->execute($pass); $rememberDetails = $sth->fetch(PDO::FETCH_ASSOC); if (!empty($rememberDetails)) { $hash2 = md5(crypt($this->misc->generateRandomString(32), rand())); $this->updateHash($rememberDetails['user_id'], $hash2); return $rememberDetails['user_id']; } else { $this->finishRemember = true; echo "Invalid remember me hash. Logging out."; echo C_HASH; $this->logout(); } return 0; }

I have ran into a problem. I have created a function to update the hash and sometimes it goes out of sync. I have also created a function to check the cookie hash against the database. I got this to update the hash: public function updateHash($user_id, $hash) { setcookie(C_HASH, $hash, time() + $this->rememberMeTime, '/'); //stored for a year. $query = "INSERT INTO " . TABLE_REMEMBER . " (hash, user_id) VALUES ('$hash', $user_id) ON DUPLICATE KEY UPDATE hash = '$hash''"; $this->db->exec($query); } and if I keep refreshing the page really quickly the cookie and the database hash goes out of sync. How can I fix this? I'm guessing that it stops the function in the middle of it being processed.

Thank you!

I have looked at Google's cookies and I have noticed that they don't have the PHPSESSID cookie. Is there some kind of reason for this? Or are they just not using php ? I was thinking about storing a hash in my mysql database with an user id and then get the ID, but if someone finds out someone's hash then they will be able to access their account. Also I have thought about storing and checking the IP aswell, but if the user is constantly moving locations then it will be a pain for the user.

Hi, I am working on a login form and I am trying to add a secure remember me feature as I don't really trust cookies because people can change those. So how can I create a secure remember me feature?

The query was working fine, sorry. Thank you for your help!

Nevermind.

I am trying to learn how to deal with lots of data.. so I have inserted over 4 million rows into a MySQL table with an unique and with random numbers. I want to use php to find out a rank of an unique row based on the number of votes they get. And when I retrieve the data from the MySQL database I obviously get the 'error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in ...' on line' error. This is the code that I use to get the error: $sth = $this->db->query("SELECT votes FROM list "); $this->toplistItems = $sth->fetchAll(PDO::FETCH_ASSOC); How can I deal with large amounts of data? And yes.. i know that I can increase the allocated memory.. but let's say that I can't. Thank you in advance. (Also posted on: http://www.phphelp.com/forum/index.php?topic=18402.0 )

Ahh! Ok. Thank you!

Nope.

Nope. ;( I have tried require before. Above the function gives me and it isn't working inside of the function.

Hi, I have a class: class Toplist { public function get_article($id) { $id = (int) $id; $articles = array(); $query = $db->sql_query("SELECT * FROM `toplist` WHERE `id` = '$id'"); $result = $db->sql_fetchrowset($query); return $articles; } } and I get the variable db is in ./models/config.php and it isn't working on the classToplist. I have a feeling that this happens because the config file is not a class. How can I fix this?

I have a frame on my website, but when I click on a hyperlink the page opens up on the frame, but I how can I make it so it will open on a new tab/window? (the hyperlinks will change all the time it will get it will get the page's url from a different site) (I gave no javascript experience, I just know that it can be done with javascrpit)

I want know how to make it to print out on my website

Hi I am making a highscores search page for my game, and I don't know how to make a rank For example I have 2 players in my database Player1 - xp is 50 attack level is 6 defense levels is 4 Player2 - xp is 55 attack level is 4 defense levels is 9 And for example i type in player2 it will show the attack level defense level and xp. I need to know how to find out how many tables down the player is? This is my connection thing : $skillsinfo = "SELECT * FROM skills where playerName = '$player'"; $skillsinfo2 = mysql_query($skillsinfo) or die ("Could not connect to players database."); $skillsinfo3 = mysql_fetch_array($skillsinfo2);