Cati vizitatori sunt On

Introducere

In acest tutorial va voi arata cum puteti obtine si afisa nr. vizitatorilor care sunt online pe site.



Cuprins

Pasul 1

Creeaza o baza de date numita "test".



Pasul 2

Creeaza un tabel numit "useri_online" in baza de date care ai creat-o mai devreme.

Code:

CREATE TABLE `useri_online` (

`session` char(100) NOT NULL default '',

`time` int(11) NOT NULL default '0'

) TYPE=MyISAM;


Pasul 3

Creeaza un fisier numit useri_online.php in care vei adauga urmatorul cod cu un editor de texte(ex. wordpad):

Code:

session_start();

$session=session_id();

$time=time();

$time_check=$time-600;



$host="localhost"; // host

$username=""; // username mysql

$password=""; // parola mysql

$db_name="test"; // nume baza de date

$tbl_name="useri_online"; // nume tabel baza de date



mysql_connect("$host", "$username", "$password")or die("Nu ma pot
conecta la baza de date,informatii gresite sau baza de date moarta!");

mysql_select_db("$db_name");



$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 ";



$sql4="DELETE FROM $tbl_name WHERE time<$time_check";

$result4=mysql_query($sql4);



mysql_close();

?>