Mysql storage PHPSession

The first configuration is as follows: change the files in sessionsave_handlerfiles to User in 1phpini, and restart Apache2 by default.

The first configuration is as follows:

1. change the files in session. save_handler = files to User in php. ini. restart Apache by default.

2. the name of the database created in this instance is php, username: root password: root.

The table structure of the database designed for this instance is as follows:

1. Create table mysession (
2. Session_key char (32) not null,
3. Session_data text,
4. Session_expiry int (11 ),
5. Primary key (session_key)
6. );

The first column indicates the session ID, the second column stores the data in the session, and the third column stores the validity period. The following is the key custom function implementation session_set_save_handler (......), the code is as follows:

User-define-session-inc.php

2. Function mysession_open ($ save_path, $ session_name)
3. {
4. @ Mysql_connect ("localhost", "root", "root") or die ("database server connection failed ");
5. @ Mysql_select_db ("php") or die ("The database does not exist or is unavailable ");
6. Return true;
7. }
8. Function mysession_close ()
9. {
10. Return true;
11. }
12. Function mysession_read ($ key)
13. {
14. @ Mysql_connect ("localhost", "root", "root") or die ("database server connection failed ");
15. @ Mysql_select_db ("php") or die ("The database does not exist or is unavailable ");
16. $ Expiry_time = time ();
17. $ Query = @ mysql_query ("select session_data from mysession where session_key = '$ key' and session_expiry> $ expiry_time") or die ("SQL statement execution failed ");
18. If ($ row = mysql_fetch_array ($ query ))
19. Return $ row ['session _ data'];
20. Else
21. Return false;
22. }
23. Function mysession_write ($ key, $ data)
24. {
25. @ Mysql_connect ("localhost", "root", "root") or die ("database server connection failed ");
26. @ Mysql_select_db ("php") or die ("The database does not exist or is unavailable ");
27. $ Expiry_time = time () + 1200;
28. $ Query = @ mysql_query ("select session_data from mysession where session_key = '$ key'") or die ("SQL statement execution failed ");
29. If (mysql_numrows ($ query) = 0)
30. {
31. $ Query = @ mysql_query ("insert into mysession values ('$ key',' $ data', $ expiry_time)") or die ("SQL statement execution failed ");
32. }
33. Else
34. {
35. $ Query = @ mysql_query ("update mysession set session_data = '$ data', session_expiry = $ expiry_time where session_key =' $ key '") or die ("SQL statement execution failed ");
36. }
37. Return $ query;
38. }
39. Function mysession_destroy ($ key)
40. {
41. @ Mysql_connect ("localhost", "root", "root") or die ("database server connection failed ");
42. @ Mysql_select_db ("php") or die ("The database does not exist or is unavailable ");
43. $ Query = @ mysql_query ("delete from mysession where session_key = '$ key '")
44. Or die ("SQL statement execution failed ");
45. Return $ query;
46. }
47. Function mysession_gc ($ expiry_time)
48. {
49. @ Mysql_connect ("localhost", "root", "root") or die ("database server connection failed ");
50. @ Mysql_select_db ("php") or die ("The database does not exist or is unavailable ");
51. $ Expiry_time = time ();
52. $ Query = @ mysql_query ("delete from mysession where session_expiry <$ expiry_time") or die ("SQL statement execution failed ");
53. Return $ query;
54. }
55. Session_set_save_handler ('mysession _ open', 'mysession _ close', 'mysession _ read', 'mysession _ write', 'mysession _ destroy ', 'mysession _ gc ');
56. ?>

The test code is as follows:

1. save. php

2. Include ('User-define-session-inc.php ');
3. Session_start ();
4. $ _ SESSION ['username'] = "Simon ";
5. $ _ SESSION ['password'] = "123456 ";
6. ?>

2. show. php

2. Include ('User-define-session-inc.php ');
3. Session_start ();
4. Echo "UserName:". $ _ SESSION ['username']."
5. ";
6. Echo "PassWord:". $ _ SESSION ['password']."
7. ";
8. ?>