HTTPSession Question

php_person · January 3rd, 2010, 10:48 PM

It says on page 298 that I should be getting the same output every time I refresh the page, but the session id changes EVERY TIME. The only changes I made to the code is PgSQL to MySQL and switching _session_close_method() to public to get rid of the error. Any ideas what happened? Thanks in advanced!

php_person · January 4th, 2010, 10:55 AM

Never mind. I found out what was wrong. The $strUserAgent variable in the HTTPSession Class was in the wrong spot. The wrong version of the SQL in the __construct function:

PHP Code:


			
$stmt = "...AND ((now() - `created`) < '" . $strUserAgent . $this->session_lifespan . " seconds') AND `user_agent` = '" . "' AND..."

And now look at the right SQL:

PHP Code:


			
$stmt = "...AND ((now() - `created`) < '" . $this->session_lifespan . " seconds') AND `user_agent` = '" . $strUserAgent . "' AND..."

Notice how the ' . $strUserAgent' moved. Is was in the complete wrong area.

To Ed L.-T., Steven D. N., and/or Thomas M.: You should consider updating the Code for Download so this will work for future downloaders.

Thanks!

DMatt · March 1st, 2011, 05:45 PM

Quote:

Originally Posted by php_person

Never mind. I found out what was wrong. The $strUserAgent variable in the HTTPSession Class was in the wrong spot. The wrong version of the SQL in the __construct function:

PHP Code:


			
$stmt = "...AND ((now() - `created`) < '" . $strUserAgent . $this->session_lifespan . " seconds') AND `user_agent` = '" . "' AND..."

And now look at the right SQL:

PHP Code:


			
$stmt = "...AND ((now() - `created`) < '" . $this->session_lifespan . " seconds') AND `user_agent` = '" . $strUserAgent . "' AND..."

Notice how the ' . $strUserAgent' moved. Is was in the complete wrong area.

To Ed L.-T., Steven D. N., and/or Thomas M.: You should consider updating the Code for Download so this will work for future downloaders.

Thanks!

very useful! thanks!!! :-):-):-)

maximo · February 9th, 2012, 07:34 AM

Quote:

Originally Posted by php_person

Never mind. I found out what was wrong. The $strUserAgent variable in the HTTPSession Class was in the wrong spot. The wrong version of the SQL in the __construct function:

PHP Code:


			
$stmt = "...AND ((now() - `created`) < '" . $strUserAgent . $this->session_lifespan . " seconds') AND `user_agent` = '" . "' AND..."

And now look at the right SQL:

PHP Code:


			
$stmt = "...AND ((now() - `created`) < '" . $this->session_lifespan . " seconds') AND `user_agent` = '" . $strUserAgent . "' AND..."

Notice how the ' . $strUserAgent' moved. Is was in the complete wrong area.

To Ed L.-T., Steven D. N., and/or Thomas M.: You should consider updating the Code for Download so this will work for future downloaders.

Thanks! [:D]

I'd have wasted a lot more time if I hadn't found your post!! thanks again.