| |
|
Modul care iti arata cati vizitatori ai in PHP
|
| Author |
Message |
FrozenDesigns
Designer incepator
Posts: 220
Group: Registered
Joined: Feb 2008
Status:
Online
Reputation: 0
Lei: 898.79
|
Modul care iti arata cati vizitatori ai in PHP
creeam un tabel in mysql
CREATE TABLE `counter` ( `counter` INT( 20 ) NOT NULL );
INSERT INTO counter VALUES (0);
si modulul:
<?php
// Connects to your Database
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
//Adds one to the counter
mysql_query("UPDATE counter SET counter = counter + 1");
//Retreives the current count
$count = mysql_fetch_row(mysql_query("SELECT counter FROM counter"));
//Displays the count on your site
print "$count[0]";
?>
My portofolio
|
|
| 02-28-2008 12:05 AM |
|
|
Spartakus
Designer
Posts: 381
Group: Registered
Joined: Dec 2007
Status:
Offline
Reputation: 1
Lei: 599.83
|
RE: Modul care iti arata cati vizitatori ai in PHP
fb tutorialul .CRED ca o sa il folosesc in viitor
http://www.cscomunity.info - Un site pt gameri
|
|
| 02-28-2008 12:19 AM |
|
|
Scorillo
Ucenic
Posts: 156
Group: Registered
Joined: Feb 2008
Status:
Offline
Reputation: 0
Lei: 673.36
|
RE: Modul care iti arata cati vizitatori ai in PHP
din cate imi dau eu seama, scriptul ala ar afisa cate refresh-uri ai pe o pagina, nu userii online.
Varianta B
in MySQL database:
CREATE TABLE `useronline` (
ﾃつ ﾃつ `id` int(10) NOT NULL auto_increment,
ﾃつ ﾃつ `ip` varchar(15) NOT NULL default '',
ﾃつ ﾃつ `timestamp` varchar(15) NOT NULL default '',
ﾃつ ﾃつ PRIMARY KEY (`id`),
ﾃつ ﾃつ UNIQUE KEY `id`(`id`)
)
In pagina unde vrei sa afisezi utilizatorii online, bagi codul asta:
include_once ("usersOnline.class.php");
$visitors_online = new usersOnline();
if (count($visitors_online->error) == 0) {
if ($visitors_online->count_users() == 1) {
echo "Este " . $visitors_online->count_users() . " vizitator online";
}
else {
echo "Sunt " . $visitors_online->count_users() . " vizitatori online";
}
}
else {
echo "<b>Erori:</b><br /><ul>\r\n";
for ($i = 0; $i < count($visitors_online->error); $i ++ ) {
echo "<li>" . $visitors_online->error[$i] . "</li>\r\n";
}
echo "</ul>\r\n";
}
Si acum continutul fisierului usersOnline.class.php
$host = ""; // serverul MySQL
$user = ""; // MySQL username
$pass = ""; // MySQL password
$db = ""; // numele bazei de date MySQL
$conn = mysql_connect("$host", "$user", "$pass") or die ("Nu merje sa ma conectez la baza de date.");
mysql_select_db("$db", $conn);
class usersOnline {
var $timeout = 600;
var $count = 0;
var $error;
var $i = 0;
function usersOnline () {
$this->timestamp = time();
$this->ip = $this->ipCheck();
$this->new_user();
$this->delete_user();
$this->count_users();
}
function ipCheck() {
if (getenv('HTTP_CLIENT_IP')) {
$ip = getenv('HTTP_CLIENT_IP');
}
elseif (getenv('HTTP_X_FORWARDED_FOR')) {
$ip = getenv('HTTP_X_FORWARDED_FOR');
}
elseif (getenv('HTTP_X_FORWARDED')) {
$ip = getenv('HTTP_X_FORWARDED');
}
elseif (getenv('HTTP_FORWARDED_FOR')) {
$ip = getenv('HTTP_FORWARDED_FOR');
}
elseif (getenv('HTTP_FORWARDED')) {
$ip = getenv('HTTP_FORWARDED');
}
else {
$ip = $_SERVER['REMOTE_ADDR'];
}
return $ip;
}
function new_user() {
$insert = mysql_query ("INSERT INTO useronline(timestamp, ip) VALUES ('$this->timestamp', '$this->ip')");
if (!$insert) {
$this->error[$this->i] = "Rateu la inregistrare unui nou vizitator\r\n";
$this->i ++;
}
}
function delete_user() {
$delete = mysql_query ("DELETE FROM useronline WHERE timestamp < ($this->timestamp - $this->timeout)");
if (!$delete) {
$this->error[$this->i] = "Rateu la stergerea vizitatorului";
$this->i ++;
}
}
function count_users() {
if (count($this->error) == 0) {
$count = mysql_num_rows ( mysql_query("SELECT DISTINCT ip FROM useronline"));
return $count;
}
}
}
incearca instrumente SEO gratuite si vezi unde ma aberez sau cica dau lectii Photoshop.
|
|
| 02-28-2008 07:36 AM |
|
|
FrozenDesigns
Designer incepator
Posts: 220
Group: Registered
Joined: Feb 2008
Status:
Online
Reputation: 0
Lei: 898.79
|
RE: Modul care iti arata cati vizitatori ai in PHP
mi se pare si asta destul de bunisor da sar putea sa aiba vreo cateva greseli
My portofolio
This post was last modified: 02-28-2008 07:47 AM by dojo.
|
|
| 02-28-2008 07:44 AM |
|
|
Scorillo
Ucenic
Posts: 156
Group: Registered
Joined: Feb 2008
Status:
Offline
Reputation: 0
Lei: 673.36
|
|
| 02-28-2008 12:40 PM |
|
|
Aurel63
Aproape expert
Posts: 889
Group: Registered
Joined: Dec 2007
Status:
Offline
Reputation: 4
Lei: 4015.02
|
RE: Modul care iti arata cati vizitatori ai in PHP
In concluzie: la ce poate fi folosit?
Eu ma uit pe statistic awstats din cpanle, trafic.ro mai rar, si inca un counter, statcounter, de unde obtin statistici in detaliu.
Am auzit ca exista un scipt f msto de monitorizare, urchin parca, da e pe lovele, si recomandat inspecial celor ce vand efectiv online, magazinelor virtuale.
Pentru noi, muritorii de rand, cred ca sunt ok si astea free.
Mark Twain - "N-am lasat niciodata scoala sa-mi afecteze educatia."
Mark Twain - "Cel mai bun mod de a te inveseli este sa incerci sa inveselesti pe altcineva."
|
|
| 02-28-2008 06:02 PM |
|
|
Scorillo
Ucenic
Posts: 156
Group: Registered
Joined: Feb 2008
Status:
Offline
Reputation: 0
Lei: 673.36
|
|
| 02-28-2008 06:50 PM |
|
|
Aurel63
Aproape expert
Posts: 889
Group: Registered
Joined: Dec 2007
Status:
Offline
Reputation: 4
Lei: 4015.02
|
RE: Modul care iti arata cati vizitatori ai in PHP
Mark Twain - "N-am lasat niciodata scoala sa-mi afecteze educatia."
Mark Twain - "Cel mai bun mod de a te inveseli este sa incerci sa inveselesti pe altcineva."
This post was last modified: 02-28-2008 07:31 PM by Aurel63.
|
|
| 02-28-2008 07:29 PM |
|
|
|
|
 |
|
 |
|
|
