Beranda · Tips Trick · Film · Lagu · PHP · Tutorial Umum · jQuery · Otomotive
» » PHP - Script Untuk Melihat User Online

PHP - Script Untuk Melihat User Online

Jika anda sedang mendevelope web aplikasi tentu anda ingin tahu berapa yang online di web anda.
Berikut saya kasih tutorial Script Untuk Melihat User Online

Creating table

Pertama membuat database dan tabel
    

  1. 
CREATE TABLE `online_users` (

    

    2. 

  2. 
`session_id` CHAR(150) NOT NULL,

    

    3. 

  3. 
`last_activity` INT(11) NOT NULL DEFAULT '0'

    

    4. 

  4. 
);
    

    5.

Creating php file

Langkah selanjutnya ialah membuat dan menggunakan 'SA_USERSONLINE' Class!
SA_USERSONLINE class:
    

  1. 
<?php 
    
/*


    

    2. 

  2. 
 * Author : D

    

    3. 

  3. 
 * Website: http://database.net

    

    4. 

  4. 
 */
    

    5. 

  5. 
class SA_USERSONLINE

    

    6. 

  6. 
{

    

    7. 

  7. 
protected $DB_HOST = DB_HOST;

    

    8. 

  8. 
protected $DB_NAME = DB_NAME;

    

    9. 

  9. 
protected $DB_USER = DB_USER;

    

    10. 

  10. 
protected $DB_PWD = DB_PWD;

    

    11. 

  11. 
protected $session_id = null;

    

    12. 

  12. 
protected $time = null;

    

    13. 

  13. 
protected $timeout = 15;

    

    14. 

  14. 
protected $link = null;

    

    15. 

  15. 
protected $stmt = null;

    

    16. 

  16. 
function __construct ()

    

    17. 

  17. 
{

    

    18. 

  18. 
session_start();

    

    19. 

  19. 
$this->session_id = session_id();

    

    20. 

  20. 
$this->time = time();

    

    21. 

  21. 
$this->link = mysqli_connect($this->DB_HOST, $this->DB_USER, 

    

    22. 

  22. 
$this->DB_PWD, $this->DB_NAME);

    

    23. 

  23. 
}

    

    24. 

  24. 
 

    

    25. 

  25. 
/**

    

    26. 

  26. 
     * Gets current online users

    

    27. 

  27. 
     */

    

    28. 

  28. 
function get_online_users ()

    

    29. 

  29. 
{

    

    30. 

  30. 
$this->delete_update_onlineusers();

    

    31. 

  31. 
$this->insert_onlineusers();

    

    32. 

  32. 
$this->stmt = mysqli_query($this->link, 

    

    33. 

  33. 
'SELECT session_id FROM online_users');

    

    34. 

  34. 
return mysqli_num_rows($this->stmt);

    

    35. 

  35. 
}

    

    36. 

  36. 
 

    

    37. 

  37. 
private function already_registred ()

    

    38. 

  38. 
{

    

    39. 

  39. 
$this->stmt = mysqli_query($this->link, 

    

    40. 

  40. 
"SELECT session_id FROM online_users WHERE session_id='$this->session_id'");

    

    41. 

  41. 
if (! $this->stmt || mysqli_num_rows($this->stmt) <= 0)

    

    42. 

  42. 
return false;

    

    43. 

  43. 
return true;

    

    44. 

  44. 
}

    

    45. 

  45. 
 

    

    46. 

  46. 
private function insert_onlineusers ()

    

    47. 

  47. 
{

    

    48. 

  48. 
if (! $this->already_registred()) {

    

    49. 

  49. 
mysqli_query($this->link, 

    

    50. 

  50. 
"INSERT INTO online_users VALUES('$this->session_id',$this->time)");

    

    51. 

  51. 
}

    

    52. 

  52. 
}

    

    53. 

  53. 
 

    

    54. 

  54. 
private function delete_update_onlineusers ()

    

    55. 

  55. 
{

    

    56. 

  56. 
$timeout = $this->time - ($this->timeout * 60);

    

    57. 

  57. 
mysqli_query($this->link, 

    

    58. 

  58. 
"DELETE FROM online_users WHERE last_activity<=$timeout");

    

    59. 

  59. 
mysqli_query($this->link, 

    

    60. 

  60. 
"UPDATE online_users SET last_activity=$this->time WHERE session_id='$this->session_id'");

    

    61. 

  61. 
}

    

    62. 

  62. 
 

    

    63. 

  63. 
/**

    

    64. 

  64. 
     * Set timeout in minutes.

    

    65. 

  65. 
     * 

    

    66. 

  66. 
     * @param int $timeout      

    

    67. 

  67. 
     */

    

    68. 

  68. 
function set_timeout ($timeout)

    

    69. 

  69. 
{

    

    70. 

  70. 
$this->timeout = ((int) $timeout);

    

    71. 

  71. 
}

    

    72. 

  72. 
}

    

    73. 

  73. 
 

    

    74. 

  74. 
?>

    

    75.
Example usage:
    

  1. 
$usersOnline = new SA_USERSONLINE();

    

    2. 

  2. 
echo 'Online users: ', $usersOnline->get_online_users();
    

    3.
Juga, anda bisa customize session timeout(dalam menit):
$usersOnline->set_timeout(15);


Selamat mencoba..

Artikel keren lainnya:

Ditulis oleh pada tanggal Thursday, July 24, 2014

Belum ada tanggapan untuk "PHP - Script Untuk Melihat User Online"

Post a Comment