[php] session avec une bdd

session avec une bdd [php] - Programmation

Marsh Posté le 11-08-2001 à 21:46:07    

Salut les gens.
 
Voilà, je dois être neuneu :na: , mais j'arrive pas à adapter ca pour une bdd (c'est fait pour gerer les session avec des fichiers texte apparemment).
 
Je sais pas pourquoi mais j'ai comme un bloquage.  
 
Si quelqu'un(e) pouvait m'aider... :jap:  
 
 

Code :
  1. <?
  3. function open ($save_path, $session_name)
  4. {
  5. global $sess_save_path, $sess_session_name;
  6. $sess_save_path = $save_path;
  7. $sess_session_name = $session_name;
  8. return(TRUE);
  9. }
  11. function close()
  12. {
  13.   return(TRUE);
  14. }
  16. function read ($id)
  17. {
  18. global $sess_save_path, $sess_session_name;
  19. $sess_file = "$sess_save_path/sess_$id";
  20. if ($fp = @fopen($sess_file, "r" ))
  21. {
  22.  $sess_data = fread($fp, filesize($sess_file));
  23.  return($sess_data);
  24. }
  25. else
  26. {
  27.  return("" );
  28. }
  29. }
  31. function write ($id, $sess_data)
  32. {
  33. global $sess_save_path, $sess_session_name;
  34. $sess_file = "$sess_save_path/sess_$id";
  35. if ($fp = @fopen($sess_file, "w" ))
  36. {
  37.  return(fwrite($fp, $sess_data));
  38. }
  39. else
  40. {
  41.  return(FALSE);
  42. }
  43. }
  45. function destroy ($id)
  46. {
  47. global $sess_save_path, $sess_session_name;
  48. $sess_file = "$sess_save_path/sess_$id";
  49. return(@unlink($sess_file));
  50. }
  52. /***************************************************
  53. * ATTENTION - Vous devez implémenter une routine  *
  54. * d'entretien des sessions ici.                   *
  55. ***************************************************/
  57. function gc ($maxlifetime)
  58. {
  59. return TRUE;
  60. }
  62. session_set_save_handler ("open", "close", "read", "write", "destroy", "gc" );
  63. session_start();
  64. // utilisez vos sessions normalement
  65. ?>


 
 
je suis neuneu ! n'est-ce pas ?


---------------
oui oui
Reply

Marsh Posté le 11-08-2001 à 21:46:07   

Reply

Marsh Posté le 11-08-2001 à 22:14:58    

yo j'ai fini par trouver un truc.
 
Si ca interesse quelqu'un(e) :
 
 
http://phpbuilder.com/columns/ying20000602.php3
 

Code :
  1. <?
  2. /* ------------------------------------------------------------------------
  3. * session_mysql.php
  4. * ------------------------------------------------------------------------
  5. * PHP4 MySQL Session Handler
  6. * Version 1.00
  7. * by Ying Zhang (ying@zippydesign.com)
  8. * Last Modified: May 21 2000
  9. *
  10. * ------------------------------------------------------------------------
  11. * TERMS OF USAGE:
  12. * ------------------------------------------------------------------------
  13. * You are free to use this library in any way you want, no warranties are
  14. * expressed or implied.  This works for me, but I don't guarantee that it
  15. * works for you, USE AT YOUR OWN RISK.
  16. *
  17. * While not required to do so, I would appreciate it if you would retain
  18. * this header information.  If you make any modifications or improvements,
  19. * please send them via email to Ying Zhang <ying@zippydesign.com>.
  20. *
  21. * ------------------------------------------------------------------------
  22. * DESCRIPTION:
  23. * ------------------------------------------------------------------------
  24. * This library tells the PHP4 session handler to write to a MySQL database
  25. * instead of creating individual files for each session.
  26. *
  27. * Create a new database in MySQL called "sessions" like so:
  28. *
  29. * CREATE TABLE sessions (
  30. *      sesskey char(32) not null,
  31. *      expiry int(11) unsigned not null,
  32. *      value text not null,
  33. *      PRIMARY KEY (sesskey)
  34. * );
  35. *
  36. * ------------------------------------------------------------------------
  37. * INSTALLATION:
  38. * ------------------------------------------------------------------------
  39. * Make sure you have MySQL support compiled into PHP4.  Then copy this
  40. * script to a directory that is accessible by the rest of your PHP
  41. * scripts.
  42. *
  43. * ------------------------------------------------------------------------
  44. * USAGE:
  45. * ------------------------------------------------------------------------
  46. * Include this file in your scripts before you call session_start(), you
  47. * don't have to do anything special after that.
  48. */
  50. $SESS_DBHOST = "localhost";   /* database server hostname */
  51. $SESS_DBNAME = "sessions";    /* database name */
  52. $SESS_DBUSER = "phpsession";   /* database user */
  53. $SESS_DBPASS = "phpsession";   /* database password */
  56. $SESS_DBH = "";
  57. $SESS_LIFE = get_cfg_var("session.gc_maxlifetime" );
  59. function sess_open($save_path, $session_name) {
  60. global $SESS_DBHOST, $SESS_DBNAME, $SESS_DBUSER, $SESS_DBPASS, $SESS_DBH;
  62. if (! $SESS_DBH = mysql_pconnect($SESS_DBHOST, $SESS_DBUSER, $SESS_DBPASS)) {
  63.  echo "<li>Can't connect to $SESS_DBHOST as $SESS_DBUSER";
  64.  echo "<li>MySQL Error: ", mysql_error();
  65.  die;
  66. }
  68. if (! mysql_select_db($SESS_DBNAME, $SESS_DBH)) {
  69.  echo "<li>Unable to select database $SESS_DBNAME";
  70.  die;
  71. }
  73. return true;
  74. }
  76. function sess_close() {
  77. return true;
  78. }
  80. function sess_read($key) {
  81. global $SESS_DBH, $SESS_LIFE;
  83. $qry = "SELECT value FROM sessions WHERE sesskey = '$key' AND expiry > " . time();
  84. $qid = mysql_query($qry, $SESS_DBH);
  86. if (list($value) = mysql_fetch_row($qid)) {
  87.  return $value;
  88. }
  90. return false;
  91. }
  93. function sess_write($key, $val) {
  94. global $SESS_DBH, $SESS_LIFE;
  96. $expiry = time() + $SESS_LIFE;
  97. $value = addslashes($val);
  99. $qry = "INSERT INTO sessions VALUES ('$key', $expiry, '$value')";
  100. $qid = mysql_query($qry, $SESS_DBH);
  102. if (! $qid) {
  103.  $qry = "UPDATE sessions SET expiry = $expiry, value = '$value' WHERE sesskey = '$key' AND expiry > " . time();
  104.  $qid = mysql_query($qry, $SESS_DBH);
  105. }
  107. return $qid;
  108. }
  110. function sess_destroy($key) {
  111. global $SESS_DBH;
  113. $qry = "DELETE FROM sessions WHERE sesskey = '$key'";
  114. $qid = mysql_query($qry, $SESS_DBH);
  116. return $qid;
  117. }
  119. function sess_gc($maxlifetime) {
  120. global $SESS_DBH;
  122. $qry = "DELETE FROM sessions WHERE expiry < " . time();
  123. $qid = mysql_query($qry, $SESS_DBH);
  125. return mysql_affected_rows($SESS_DBH);
  126. }
  128. session_set_save_handler(
  129. "sess_open",
  130. "sess_close",
  131. "sess_read",
  132. "sess_write",
  133. "sess_destroy",
  134. "sess_gc" );
  135. ?>

 

[edtdd]--Message édité par art_dupond--[/edtdd]


---------------
oui oui
Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed