View file lospaciprian/muzica/online.php

<?php

include("config.php");
session_start();
$session=session_id();
$time=time();
$time_check=$time-3600;

$host=$host_baza;
$username=$user_baza;
$password=$parola_baza;
$db_name=$nume_baza;
$tbl_name="user_online";

mysql_connect("$host", "$username", "$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name WHERE session='$session'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($count=="0") {
$sql1="INSERT INTO $tbl_name(session, time)VALUES('$session', '$time')";
$result1=mysql_query($sql1);
}else{
$sql2="UPDATE $tbl_name SET time='$time' WHERE session='$session'";
$result2=mysql_query($sql2); }
$sql3="SELECT * FROM $tbl_name";
$result3=mysql_query($sql3);
$count_user_online=mysql_num_rows($result3);
echo "- Useri Online: $count_user_online<br/>";
$sql4="DELETE FROM $tbl_name WHERE time<$time_check";
$result4=mysql_query($sql4);

?>