Advanced Search

php db sessions

/ Published in: PHP
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. // DB Managed Sessions using PHP and MySQL.
  2. // Written by: Greg Donald <[email protected]>
  3. // $Id: session.php 6 2005-12-26 01:22:57Z destiney $
  4.  
  5. // MySQL database connection parameters:
  6. $GLOBALS[ 'dbhost' ] = 'localhost';
  7. $GLOBALS[ 'dbuser' ] = 'root';
  8. $GLOBALS[ 'dbpasswd' ] = 'changeme';
  9. $GLOBALS[ 'dbname' ] = 'dbsessions';
  10.  
  11. // Session lifetime
  12. $GLOBALS[ 'online_expire' ] = 900;
  13.  
  14. // Default sessions table:
  15. $GLOBALS[ 'tb_sessions' ] = 'sessions';
  16.  
  17. // Use transparent sessions:
  18. ini_set( 'session.use_trans_sid', 1 );
  19.  
  20.  
  21. ///////////////////////////////////////////////////////////////////////
  22. // Below here should not require any changes
  23.  
  24. error_reporting( E_ALL );
  25.  
  26. $GLOBALS[ 'sdbh' ] = '';
  27.  
  28. function sess_open( $save_path, $session_name )
  29. {
  30.   if (! $GLOBALS[ 'sdbh' ] = mysql_pconnect( $GLOBALS[ 'dbhost' ],
  31.                                              $GLOBALS[ 'dbuser' ],
  32.                                              $GLOBALS[ 'dbpasswd' ] ) ){
  33.     die( mysql_error() );
  34.   }
  35.  
  36.   if( !mysql_select_db( $GLOBALS[ 'dbname' ], $GLOBALS[ 'sdbh' ] ) )
  37.   {
  38.     die( mysql_error() );
  39.   }
  40.  
  41.   return true;
  42. }
  43.  
  44. function sess_close()
  45. {
  46.   return mysql_close( $GLOBALS[ 'sdbh' ] );
  47. }
  48.  
  49. function sess_read( $key )
  50. {
  51.   $key = mysql_real_escape_string( $key );
  52.  
  53.   $sql = "
  54.     SELECT `data`
  55.     FROM `" . $GLOBALS[ 'tb_sessions' ] . "`
  56.     WHERE `id` = '$key'
  57.     AND `expire` > UNIX_TIMESTAMP()
  58.   ";
  59.  
  60.   $query = mysql_query( $sql ) or die( mysql_error() );
  61.  
  62.   if( mysql_num_rows( $query ) )
  63.   {
  64.     return mysql_result( $query, 0, 'data' );
  65.   }
  66.  
  67.   return '';
  68. }
  69.  
  70. function sess_write( $key, $val )
  71. {
  72.   $key = mysql_real_escape_string( $key );
  73.   $value = mysql_real_escape_string( $val );
  74.  
  75.   $sql = "
  76.     REPLACE INTO `" . $GLOBALS[ 'tb_sessions' ] . "` (
  77.       `id`,
  78.       `data`,
  79.       `expire`
  80.     ) VALUES (
  81.       '$key',
  82.       '$value',
  83.       UNIX_TIMESTAMP() + " . $GLOBALS[ 'online_expire' ] . "
  84.     )
  85.   ";
  86.  
  87.   return mysql_query( $sql ) or die( mysql_error() );
  88. }
  89.  
  90. function sess_destroy( $key )
  91. {
  92.   $key = mysql_real_escape_string( $key );
  93.  
  94.   $sql = "
  95.     DELETE FROM `" . $GLOBALS[ 'tb_sessions' ] . "`
  96.     WHERE `id` = '$key'
  97.   ";
  98.  
  99.   return mysql_query( $sql ) or die( mysql_error() );
  100. }
  101.  
  102. function sess_gc()
  103. {
  104.   $sql = "
  105.     DELETE FROM `" . $GLOBALS[ 'tb_sessions' ] . "`
  106.     WHERE `expire` < UNIX_TIMESTAMP() - " . $GLOBALS[ 'online_expire' ] . "
  107.   ";
  108.  
  109.   $query = mysql_query( $sql ) or die( mysql_error() );
  110.  
  111.   return mysql_affected_rows();
  112. }
  113.  
  114. session_set_save_handler( 'sess_open',
  115.                           'sess_close',
  116.                           'sess_read',
  117.                           'sess_write',
  118.                           'sess_destroy',
  119.                           'sess_gc' );
  120.  
  121. session_start();
  122.  
  123. $sn = session_name();
  124. $sid = session_id();

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.