The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
//GRAB PHP INFO
function ajax_update_status(value){
// Get all the form data
$.ajax({
type: "POST",
url: "ajax/online_status.php?s=" + value
});
}
onclick="ajax_update_status('invisible'); return false" data-status="status-invisible"
//GET THE USERS CURRENT ONLINE SESSION STATUS AND CHANGE IT IF NESSECARY
if(isset($_GET['s']) && !empty($_GET['s'])){
//THE VARIABLE IS SET
if($_GET['s'] == 'online'){
//SET THE SESSION VARIABLE TO ONLINE
$_SESSION["online_status"] ='online';
//CHANGE THE USERS DATABASE ENTRY
online_status($_SESSION["uid"], 'online', $datetime);
}elseif($_GET['s'] == 'away'){
//SET THE SESSION VARIABLE TO AWAY
$_SESSION["online_status"] = 'away';
//CHANGE THE USERS DATABASE ENTRY
online_status($_SESSION["uid"], 'away', $datetime);
}elseif($_GET['s'] == 'invisible'){
//SET THE SESSION VARIABLE TO INVISIBLE
$_SESSION["online_status"] = 'invisible';
//CHANGE THE USERS DATABASE ENTRY
online_status($_SESSION["uid"], 'invisible', $datetime);
}
}
the function of online status is
[code]//CHANGE THE USERS DATABASE ONLINE STATUS WHEN THE USER LOGS ON
function online_status($uid, $status, $date){
global $link;
$date_clean =mysqli_real_escape_string($link,str_replace(",","-",$date));
if($status==="online" || $status==="away" || $status==="invisible" || $status==="offline"){
$sql=" UPDATE bb_users SET online_status='".$status."', online_status_time='".$date_clean."' WHERE uid='".$uid."' LIMIT 1";
mysqli_query($link, $sql) or die;
}
}
my next questions would be...It's all in here:
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
http://php.net/manual/en/mysqli.quickstart.prepared-statements.php
Everything else is fine.