REPOSITORY OVERVIEW

Live repository statistics

★ 87Stars

⑂ 37Forks

◯ 6Open issues

◉ 87Watchers

README preview

PHP-MySQL-Sessions

This is a native solution to easily store PHP session data in a MySQL database.

Overview

Session variables contain data that is saved for a specific user by associating the user with a unique identity. Typically, PHP would store session variables in a local file system on the server by default. While this may be acceptable to many people who are running small to moderate PHP applications, some larger applications that require load balancing would need to be run on multiple servers with a load balancer. In such cases, each server running PHP would need a way to ensure that sessions continue to work properly. One common way to achieve this is to override where PHP opens, reads, writes, and destroys the session variables so that it can perform these operations on a table inside of a MySQL database. When this is performed, the web application can gain advantages such as session management, session logging, and session interactions.

Installation

This solution can be easily integrated with your existing PHP code that uses PHP sessions. Simply perform the following steps:

Upload the files in this repository to your Apache server running PHP. You can store these files inside any resource folder of your desire. It is not recommended that these files be located in the root directory since it contains some sensitive database information.
Create a new MySQL database if you do not already have an existing one. Note down your MySQL credentials. Go to PHPMyAdmin or your database manager and run the following command:
```
CREATE TABLE sessions
(
	id varchar(32) NOT NULL,
	access int(10) unsigned,
	data text,
	PRIMARY KEY (id)
);
```

Edit the file database.class.php and change the following variables to your existing database.

define("DB_HOST", "localhost");
define("DB_USER", "yourusername");
define("DB_PASS", "1234567890");
define("DB_NAME", "yourdbname");

Make sure PHP has sufficient privileges and make sure that your MySQL server accepts connections if separate from your localhost.

Usage

An example script called example.php has been provided for your convenience. This contains all the basic functionality you would need for storing, retrieving, and destroying a session. One thing to note is that you do not have to call session_start() on your code as that is already taken care of inside the mysql.sessions.php class.

Declarations (include these on the top of your PHP):

include("database.class.php");	//Include MySQL database class
include("mysql.sessions.php");	//Include PHP MySQL sessions
$session = new Session();	//Start a new PHP MySQL session

Storing in a session variable:

//Store variable as usual
$_SESSION['user'] = "johnsmith@example.com";

Retrieving session variable:

//Show stored user
echo $_SESSION['user'];

Unset and Destroy (use these for signing out a user):

//Clear session data (only data column)
session_unset();
//Destroy the entire session
session_destroy();

Troubleshooting

If for some reason your code does not work, you can add the following lines to the top of your PHP script to show the errors:

error_reporting(E_ALL);
ini_set('display_errors', '1');

In addition, use PHPMyAdmin or your database manager to check your sessions table to see if the table has been altered in any way. For example, the table should populate as more session variables are being added.

ALGORITHMICALLY RELATED

Similar Open-Source Projects

Selected from shared topics, language and repository description—not editorial ratings.

ambiversive /

asg

★ 21

This is a content management system that merges concepts from multiplayer games, operating systems, wikis, link aggregators, feed readers, and more! Features: * OOP/MySQL/PHP/HTML/CSS/JS/Jquery/scrollTo+LocalScroll/Ace editor/Notifier.js * Documents organized in tree hierarchy, each document can act as directory * Every edit of a document saves a new revision with the old document * Chat integrated (chat notifies of cms events, uses long polling) * Aspect oriented (aspects can be toggled with commands or in sets- a user's aspect can be refreshed from the server by setting an aspect_preference variable to 2 (0 means off, 1 means on, 2 means needs refresh) * Command line (defaults to chat input, commands begin with forward slash) * Bots (Bot commands can be added as easily as adding a document in the appropriate place, bots can execute code. Bots respond to users they are focused on, when active.) * User-selectable stylesheets + individual css rules (styles are editable within the CMS, individual style rules are applied after loading style, added with /set body background black) * Easy to add new commands (/addcom) (commands are stored in CMS as javascript and loaded at runtime) * All aspects and commands are listed with /help * Aspects are remembered between sessions (ie: looks the way you left it) * All aspects, documents, commands, and users have access levels * Uses Ace editor for editing documents * DB info stored in database/config.php - run the .sql then login with admin/admin * Integrated link aggregator with full cache (fetches link with wget) * Integrated RSS feed parser and db of over 200 feeds * One aspect is called the 'metabrowser' which is an iframe that loads a URL on command (usage: /bload http://reddit.com or /meta) .. the url is also remembered between sessions. * There is an interesting JS function called 'simcom' which simulates a user typing into the command line- works for both commands and chat messages. Usage: asgConfig.simcom('chat message or command!')

Active repository

PHPNo license

⑂ 4 forks◯ 1 issuesUpdated Mar 28, 2026

View details View on GitHub ↗

PHP-MySQL-Sessions

Live repository statistics

README preview

PHP-MySQL-Sessions

Overview

Installation

Usage

Troubleshooting

Similar Open-Source Projects

asg

OBE-Based-Result-Management-System

cpanel_CPSP

AutoParts-Store

courier-management-system-php-mysql

PHP-MySQL-Sessions