StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POStoring Sessions in a DB in PHP - keep getting mysql error
primarykey
Id
2962110
data
AcceptedAnswerId
2962146
AnswerCount
1
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2010-06-02T22:37:31.487
FavoriteCount
0
LastActivityDate
2010-06-02T22:46:22.697
LastEditDate
2010-06-02T22:46:22.697
LastEditorUserId
199261
OwnerUserId
199261
ParentId
0
PostTypeId
1
Score
0
ViewCount
670
LastEditorDisplayName
text
Body
I want to store all my sessions in a DB and have read up on this and implemented the following class: <pre><code><?php /** * This class handles users sessions and stores the session in the DB rather than in a file. This way stops any * shared host security problems that could potentially happen. */ class sessionHandler { /** * Initial constructor which takes the database object as a param, to do all the database stuff * @param object $db The datase object */ public function __construct ($db) { $this->db = $db; $this->setHandler(); } function setHandler() { session_set_save_handler(array(&$this, "open"), array(&$this, "close"), array(&$this, "read"), array(&$this, "write"), array(&$this, "destroy"), array(&$this, "clean") ); } /** * Initiate a database object if necessary */ function open() { $this->db->connect(); } /** * Write session id and data to the database * @param string $id The hashed 32 char session id, unique to a user * @param string $data Serialized session array from the unique session * @return id The newly inserted ID of the database */ function write($id, $data) { $access = time(); $dateAdded = date("Y-m-d G:i:s"); $this->db->wrapper->where(array("sessionId"=>$id)); $this->db->query($this->db->wrapper->delete(__CLASS__)); //fopen a file and store this in it that way we can debug $query = $this->db->wrapper->insert(__CLASS__, array("sessionId"=>$id,"dateAdded"=>$dateAdded,"sessionData"=>$data)); $this->db->query($query); return $this->db->insertId(); } /** * Retrieve the session data for a given session id * @param string $id The hashed 32 char session id, unique to a user * @return string The session data found for the given session id */ function read($id) { $id = $this->db->wrapper->escape($id); $row = $this->db->fetch(1, $this->db->wrapper->get_where(__CLASS__,array("sessionId"=>$id)), array(),false); if ($row) { return $row['data']; } return ""; } /** * Delete a session from the database by its unique session id * @param string $id The hashed 32 char session id, unique to a user * @return integer The number of deleted rows - should only ever be 1 */ function destroy($id) { $id = $this->db->wrapper->escape($id); $this->db->wrapper->where(array("sessionId"=>$id)); $this->db->query($this->db->wrapper->delete(__CLASS__)); return $this->db->affectedRows(); } /** * Garage collector which deletes old records in the database, delete sessions that have expired. This is * determined by the session.gc_maxlifetime variable in the php.ini * @param integer $max The maximum number of seconds allowed before a session is to be considered expired * @return integer The number of deleted rows */ function clean($max) { $old = time() - $max; $old = $this->db->wrapper->escape($old); $this->db->wrapper->where(array("access"=>$old), "<"); $this->db->query($this->db->wrapper->delete(__CLASS__)); return $this->db->affectedRows(); } /** * Close the database connection once a read / write has been complete */ function close() { $this->db->close(); } /** * End the current session and store session data. */ public function __destruct(){ session_write_close(); } } </code></pre> As you can see in my code, i pass the DB object into the class as a param. My bootstrap file is as follows: <pre><code> $db = mogDB::init(); $sh = new sessionHandler($db); session_start(); </code></pre> I have used a few of my own classes here so MogDB:init() basically creates a database connection with the right credentials. The wrapper stuff is basically so i dont have to type out sql query after sql query (me being a bit lazy i guess). But the problem i get is this in my php error log: <pre><code>08-Apr-2010 17:40:31] PHP Warning: mysql_insert_id(): 11 is not a valid MySQL-Link resource in /library/mysql.php on line 69 </code></pre> I have debugged this as much as i can and it seems that when it tries to write the session to the DB, it is failing. I have managed to save the query to a file and that imports fine into the database via phpmyadmin, so its not the query thats the problem. line 69 in mysql.php is as follows: <pre><code>68. public function insertId() { 69. return mysql_insert_id($this->id); 70. } </code></pre> Any help would be much appreciated Thanks
Tags
<php><mysql><database><session><resources>
Title
Storing Sessions in a DB in PHP - keep getting mysql error
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USphpNutt
UserOwnerUserId
1. USphpNutt
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.