Learn how to store persistent PHP session data in a SQL server and create an auto-login system that recognizes returning users.
- [Voiceover] Hi, I'm David Powers. Welcome to Managing PHP Persistent Sessions. In this course I'll show you how to store session data in a MySQL or MariaDB database and how to log in returning users automatically. We'll begin with an overview of how PHP handles sessions and stores session data in plain text files on the web server. Then we'll set up a database to store session data more securely. I'll show you how to define a class to open and close sessions, read and write session variables to the database, destroy sessions and garbage collect out-of-date records.
By default, sessions expire as soon as the browser is closed, but the highlight of this course is an auto-login system that uses a randomly generated single use token that recognizes returning users and preserves their data between visits, even on different computers. I hope you'll find this a useful and challenging project. So join me in Managing PHP Persistent Sessions.
- Configuring sessions
- Inspecting how session data is stored
- Implementing persistent sessions
- Creating a SQL database to store session data
- Implementing the PHP SessionHandlerInterface
- Writing session data
- Closing and destroying sessions
- Creating an auto-login system with persistent sessions
- Creating persistent logins
- Checking out visitor credentials
- Authenticating users
- Logging out users selectively
Skill Level Intermediate
PHP: Accessing Databases with PDO and MySQLiwith David Powers3h 47m Intermediate
1. Sessions and Security
2. Preparing the Database
Connecting to the database5m 49s
3. Storing Session Data in MySQL
4. Creating an Autologin System
5. Testing the Autologin System
Final thoughts3m 9s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.