[PHP] Member Count Script -Free Host,Free Hosting,Web Hosting,Free Web Hosting,Domain,Domain Name,Domain Name Forum,Web Hosting Forum- Website Design Forum

07-18-2005, 17:59

admans

Senior Member

Join Date: Jul 2005

Posts: 248

Trader Rating: (0)

Points: 22 (Donate)
5 F$/Referral Refer Friends

[PHP] Member Count Script

Description:
When a user goes on a certain page or multiple pages, it adds a record to the MySQL database with their IP, date and time they went on the page and the month. Implimented into the admin panel is a search so you can search for users at certain times or with a certain Ip address.

Step 1:
Create a MySql database called count. Then insert the following into the mysql database to get you table:

PHP Code:


			
 CREATE TABLE `guests` (

  `ip` varchar(30) NOT NULL default '',

  `date` varchar(30) NOT NULL default '',

  `time` varchar(30) NOT NULL default '',

  `month` varchar(30) NOT NULL default ''

)

Step 2:
Make a file called config.php and put the following into it editing all the variables that need changing.

config.php

PHP Code:


			
<?

// Edit varibles below

$host="localhost";  // mySQL database host

$username="";       // mySQL database username

$password="";       // mySQL database password

$database="count";  // mySQL database name

$table="guests";    // mySQL database table

// Do not edit below this line

$time=date("h:i A");

$date=date("j M Y");

$month=date("F");

$ip="$REMOTE_ADDR";

?>

Step 3:
Add the following script to the page that you want the members to be counted from (your hopepage or splash page)

index.php

PHP Code:


			
<?

include ('config.php');

mysql_connect($host,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO $table (ip, time, date, month) VALUES ('$ip','$time','$date','$month')";

mysql_query($query);

mysql_close();

?>

Step 4:
Create a folder called something along the lines of admin. Password protect this folder to stop intruders getting guest information. In the admin folder, add another config.php (Step 2).
Insert this page:

admin/index.php

PHP Code:


			
 <option value="date">Date (e.g. 1 Jan 2005)

</select>

&nbsp;

<input type="text" name="search">

&nbsp;

<input type="submit" value="Search"></form>&nbsp<a href="index.php">VIEW ALL</a>

</fieldset>

<br><br>

<?php

include ('config.php');

mysql_connect($host,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM $table";

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<br>We have had $num visitors.<br><br>";

echo "<table border='1' bordercolor='#CCCCCC' cellpadding='2' cellspacing='0' width='95%'>

<tr>

<td width='25%' align='center'>IP</td>

<td width='25%' align='center'>Date</td>

<td width='25%' align='center'>Time</td>

<td width='25%' align='center'>Month</td>

</tr>";

$i=0;

while ($i < $num) {

$ip=mysql_result($result,$i,"ip");

$date=mysql_result($result,$i,"date");

$time=mysql_result($result,$i,"time");

$month=mysql_result($result,$i,"month");

echo "<tr>

<td align='center'>$ip</td>

<td align='center'>$date</td>

<td align='center'>$time</td>

<td align='center'>$month</td>

</tr>";

$i++;

}

?>

Step 5:
This is the final stage where we add the search:

PHP Code:


			
 <fieldset>

<legend>Search</legend>

<form action="search.php" method="POST">

<select name="topic">

<option value="month">Month (e.g June)

<option value="ip">IP Address (e.g. xx.xx.xxx.xxx)

<option value="time">Time (e.g. 01:09 AM)

<option value="date">Date (e.g. 1 Jan 2005)

</select>

&nbsp;

<input type="text" name="search">

&nbsp;

<input type="submit" value="Search"></form>&nbsp<a href="index.php">VIEW ALL</a>

</fieldset>

<br><br>

<?php

include ('config.php');

$search=$_POST['search'];

$topic=$_POST['topic'];

mysql_connect($host,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM $table WHERE $topic LIKE '%$search%'";

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

if ($num == 1)

$match="&nbsp;";

else

$match="es";

echo "<br>You searched $search in $topic. We have found $num match$match<br><br>";

echo "<table border='1' bordercolor='#CCCCCC' cellpadding='2' cellspacing='0' width='95%'>

<tr>

<td width='25%' align='center'>IP</td>

<td width='25%' align='center'>Date</td>

<td width='25%' align='center'>Time</td>

<td width='25%' align='center'>Month</td>

</tr>";

$i=0;

while ($i < $num) {

$ip=mysql_result($result,$i,"ip");

$date=mysql_result($result,$i,"date");

$time=mysql_result($result,$i,"time");

$month=mysql_result($result,$i,"month");

echo "<tr>

<td align='center'>$ip</td>

<td align='center'>$date</td>

<td align='center'>$time</td>

<td align='center'>$month</td>

</tr>";

$i++;

}

?>

And you are done! This tut took me a while to write :P Hope you enjoy it. Any comments or suggestion please feel free to post them here!

__________________

http://img76.imageshack.us/img76/6450/sc2but4ng.gif | http://img495.imageshack.us/img495/...ogorwtan0je.gif | <a href="http://webtools.sc2.info"><img src="http://img129.imageshack.us/img129/8682/sc2webtan7ju.gif" border="1" width="100" alt="Free Webtools for all" /></a> | <a href="http://www.indexrated.com"><img src="http://img398.imageshack.us/img398/4813/listed1pb.gif" border="1" width="100" alt="Index Rated Directory - Rating Quality Sites" /></a>

Get all Games,Apps and Wallpapers Nokia, Samsung and Sony Erricson!!

07-19-2005, 07:06

xyris

Senior Member

Join Date: Jul 2005

Posts: 104

Trader Rating: (0)

Points: 0 (Donate)
5 F$/Referral Refer Friends

Re: [PHP] Member Count Script

thx for the code

08-31-2005, 16:44

commes

Senior Member

Join Date: Aug 2005

Location: Regina, Sask, Canada

Posts: 295

Trader Rating: (1)

Points: 76 (Donate)
5 F$/Referral Refer Friends

Re: [PHP] Member Count Script

nice doe, although i dont think ill use it, since i got a forum already, which comes with it

10-05-2005, 07:21

unknowngiver

Junior Member

Join Date: Jun 2005

Posts: 24

Trader Rating: (0)

Points: 4 (Donate)
5 F$/Referral Refer Friends

Re: [PHP] Member Count Script

Great work man
thanks for shairing

10-05-2005, 12:16

italks

Member

Join Date: Oct 2005

Posts: 51

Trader Rating: (0)

Points: 0 (Donate)
5 F$/Referral Refer Friends

Re: [PHP] Member Count Script

Its good for customer management.So thanks a lot for the detailed script.Will try it out before manking any further comments.

__________________
█ INCRIPT TECHNOLOGIES - webhosting India
█ iTALKS FORUMS - Designing & Hosting Community

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode