-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathfunctions.php
32 lines (26 loc) · 1.17 KB
/
functions.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<?php
function users_online() {
if(isset($_GET['onlineusers'])) {
global $connection;
if(!$connection) {
session_start();
include("includes/db.php");
$session = session_id();
$time = time();
$time_out_in_seconds = 5;
$time_out = $time - $time_out_in_seconds;
$query = "SELECT * FROM users_online WHERE session = '$session' ";
$send_query = mysqli_query($connection, $query);
confirmQuery($send_query);
$count = mysqli_num_rows($send_query);
if($count == NULL) { // new user online
mysqli_query($connection, "INSERT INTO users_online(session, time) VALUES('$session', '$time')");
} else { // extend current logged-in user session
mysqli_query($connection, "UPDATE users_online SET time = '$time' WHERE session = '$session'");
}
$user_online_query = mysqli_query($connection, "SELECT * FROM users_online WHERE time > '$time_out' ");
echo mysqli_num_rows($user_online_query);
}
} // end GET onlineusers
}
users_online();