Cati vizitatori sunt Online

Pagini: 1

Moderat de sNk

Iulyan
Moderator
Postari: 50

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();

?>

Pagini: 1

Mergi la