< php /* Jbots PS.Sessions (Persistent Server Side) ( requires : mysql, php sessions, client side cookies) This is the 1st script for sessions. It needs to be included before new variables are registered in the $data[] array, and MUST NOT have any ouput, or be included after output has been sent to the browser or headers will fail to post. */ //define constants $timenow = time(); $exp_time = ($timenow + 864000); //864000 = 10 days; $hostname = "mysql.pdx.solidnet.net"; //MySQL DB IP Address $mydb_name = "sessions_mrv"; //name of MySQL Database $mydb_user = "millerrv"; //name of MySQL DB Username $mydb_pass = "thx1138"; //DB user password unset($update); //db connection if (!($link = mysql_connect ($hostname, $mydb_user, $mydb_pass))) { exit("

Error connecting to database during session lookup"); } // clean up old sessions $delete_query = "DELETE FROM sessions WHERE session_uts < '$timenow'"; if (!($result = mysql_db_query($mydb_name, $delete_query))) { die ("

A database error has occurred. Unable to clean up sessions"); } //if cookie shows session resume it if (isset($_COOKIE[sid])) { $this_cookie = ereg_replace ("[[:space:]]", "", $_COOKIE[sid]); $this_cookie = ereg_replace ("[[:punct:]]", "", $this_cookie); //read in stored session data $query = "SELECT session_data FROM sessions WHERE session_id = '$this_cookie'"; $result = mysql_db_query($mydb_name, $query); while ($row = mysql_fetch_array($result)){ $session_data = base64_decode($row['session_data']); session_id($_COOKIE[sid]); session_start(); header("Cache-control: private"); //IE 6 Fix session_register ("data"); session_decode($session_data); setcookie("sid","$this_cookie","$exp_time","/",""); $update = 1; } } else { //session not active, create new session session_start(); header("Cache-control: private"); //IE 6 Fix session_register ("data"); $sessionid = session_id(); setcookie("sid","$sessionid","$exp_time","/",""); $update = 0; } //cookie still valid, but no session in DB. create new session if ($update != 1) { session_start(); header("Cache-control: private"); //IE 6 Fix session_register ("data"); $sessionid = session_id(); setcookie("sid","$sessionid","$exp_time","/",""); $update = 0; } ?>
Warning: session_encode() [function.session-encode]: Cannot encode non-existent session. in /www/htroots/m/millerrvinsurance.com/htdocs/products/rv/snowmobile/session_post.php on line 9

Warning: mysql_db_query() [function.mysql-db-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /www/htroots/m/millerrvinsurance.com/htdocs/products/rv/snowmobile/session_post.php on line 19

Warning: mysql_db_query() [function.mysql-db-query]: A link to the server could not be established in /www/htroots/m/millerrvinsurance.com/htdocs/products/rv/snowmobile/session_post.php on line 19

Error connecting to database during session lookup"); } // clean up old sessions $delete_query = "DELETE FROM sessions WHERE session_uts < '$timenow'"; if (!($result = mysql_db_query($mydb_name, $delete_query))) { die ("

Session failure has occurred. Please contact the administrator.