PHP Classes

PHP MySQLi Session Handler: Store sessions in a database using MySQLi

Recommend this page to a friend!
  Info   View files Example   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 681 This week: 1All time: 4,766 This week: 571Up
Version License PHP version Categories
dbsh 1.0.0BSD License5PHP 5, Databases, User Management
Description 

Author

This class is a session handler that store sessions in a database using the MySQLi.

It can register as a session handler with functions to open, close, read, write, destroy and garbage collect sessions.

The main class uses another class that stores and retrieves session records from a given MySQL database table using the MySQLi extension.

Picture of Mohammad Mostafa Shahreki
Name: Mohammad Mostafa ... <contact>
Classes: 6 packages by
Country: Iran Iran
Age: 41
All time rank: 8978 in Iran Iran
Week rank: 103 Up3 in Iran Iran Up

Recommendations

Assign and lookup sessions
Sessions class or equivalent

Example

<?php
function AutoLoad($class) {
    require_once
'class.' . $class . '.php';
}
spl_autoload_register('AutoLoad');
$dbsh = new DBSessionHandler();
?>
<!doctype html>
<html>
<head>
<title>Database Session Handler</title>
<meta charset="utf-8" />
</head>
<body>
<?php
echo '<p>There are ' . $dbsh->onlineCount() . ' user(s) online.</p>' . PHP_EOL;
echo
'Online users: <br />' . PHP_EOL;
foreach(
$dbsh->onlineUsers() as $user) {
    echo
$user . '<br />' . PHP_EOL;
}
?>
</body>
</html>


  Files folder image Files  
File Role Description
Plain text file class.DB.php Class Database Wrapper Class
Plain text file class.DBSessionHandler.php Class Database Session Handler Class
Accessible without login Plain text file index.php Example Example Script

 Version Control Unique User Downloads Download Rankings  
 0%
Total:681
This week:1
All time:4,766
This week:571Up
User Comments (1)
Excellent, the most necessary!
6 years ago (Sergey)
70%StarStarStarStar