Methods for writing session data to the database in php
- Create database 'session ';
Create a table structure:
- Create table 'session '(id CHAR (30) not null, 'user' CHAR (30), data CHAR (3000), parmiry by ('id '));
Save the session file session_start.php:
- $ Con = mysql_connection ("127.0.0.1", "user", "pass ");
- Mysql_select_db ("session ");
- Function open ($ save_path, $ session_name)
- {
- Return (true );
- }
- Function close ()
- {
- Return (true );
- }
- Function read ($ id)
- {
- If ($ result = mysql_query ("SELECT * FROM session WHERE id = '$ ID '"))
- {
- If ($ row = mysql_felth_row ($ result ))
- {Return $ row ["data"];}
- }
- Else
- {
- Return "";
- }
- }
- Function write ($ id, $ sess_data)
- {
- If ($ result = mysql_query ("UPDATE session SET data = '$ sess_data' WHERE id = '$ ID '"))
- {
- Return true;
- }
- Else
- {
- Return false;
- }
- }
- Function destroy ($ id)
- {
- If ($ result = mysql_query ("DELETE * FROM session WHERE id = '$ ID '"))
- {
- Return true;
- }
- Else
- {
- Return false;
- }
- }
- /*************************************** ******
- * WARNING-You will need to implement some *
- * Sort of garbage collection routine here .*
- **************************************** *****/
- Function gc ($ maxlifetime)
- {
- Return true;
- }
- Session_set_save_handler ("open", "close", "read", "write", "destroy", "gc ");
- Session_start ();
- // Proceed to use sessions normally
- ?>
Usage: on the page where you need to save the session to the database, introduce the file session_user_start.php. Note that this file must be in the first line of the file. |