Log In

Email:
Password:
Keep me logged in

Forgot Password

Email:




Social Media
     
CategoriesCSS (5)
jQuery (73)
PHP (30)
.htaccess (4)
Sponsored Links


Count Online Users
PHP
Demo | Browse Category | Thursday, December 1, 2011 by




PHP:
Make database for your users.
CREATE TABLE `your_database`.`users` (
`id` INT PRIMARY KEY AUTO_INCREMENT ,
`user` VARCHAR( 25 ) NOT NULL ,
`pass` VARCHAR( 25 ) ,
`status` VARCHAR( 10 ),
) ENGINE = MYISAM ;
count-online-users.php
<?php

mysql_connect("server", "username", "password");
$q = mysql_query("SELECT * FROM your_database.users WHERE status='online'");
$n = mysql_num_rows($q); //COUNTS USERS ONLINE

echo 'Count users: '.$n;
?>
index.php, where login and numbers of online users will be displayed.
<?php

session_start();
$session = $_SESSION['user'];
if($session)
{
echo '<b>'.$session.'</b>';
}
else
{
echo ' <table>
<tr><td align="right">Username:</td><td align="left"><input name="user"></td></tr>
<tr><td align="right">Password:</td><td align="left"><input name="pass" type="password"></td></tr>
</table>
<table width="250">
<tr><td align="left"></td><td align="right"><input name="submit" type="submit" value="Log In!"></td></tr>
</table><br>
}

?>
process.php is where the login info will be checked.
<?php

session_start();
$session = $_SESSION['user'];
$user = $_POST['user'];
$pass = $_POST['pass'];

if(!$session)
{
if($user&&$pass){
mysql_connect("server", "username", "password");
$q = mysql_query("SELECT * FROM your_database.users WHERE user='$user' AND pass='$pass'");
$n = mysql_num_rows($q);

if($n){
$_SESSION['user'] = $user;
mysql_query("UPDATE your_database.users SET status='online' WHERE user='$user'"); //SETS STATUS AS ONLINE
session_write_close();
}
else
{
$q = mysql_query("SELECT * FROM your_database.users WHERE user='$user'");
$r = mysql_num_rows($q);
if($r){
echo 'Wrong Password <a href="index.php">Go back</a>';
}
else
{
echo 'Email not found <a href="index.php">Go back</a>';
}
}
}
else
{
echo 'Enter both fields <a href="index.php">Go back</a>';
}
}
else
{
header("Location: index.php");
}

?>
logout.php
<?php

session_start();
$user = $_SESSION['user'];
if($user)
{
mysql_connect('server', 'username', 'password');
mysql_query("UPDATE yourdatabase.users SET status='offline' WHERE user='$user'");

//DESTROYS SESSION
$unset = time()-60*60*24*365*10;
session_unset();
setcookie("user", $user, $unset, "/", ".yourdomain.com");
session_destroy();
ob_start();
ob_end_flush();
}
header("Location: index.php");

?>
Views: 329 Likes: 2 Dislikes: 0






,.m
n

Saturday, May 12, 2012 at 4:39:04 PM
,.m
mm

Saturday, May 12, 2012 at 4:38:35 PM