# web developers enter

**URL:** <https://forums.speedlife.net/t/web-developers-enter/52701>\
**Category:** NYSpeed Off Topic\
**Created:** [August 5, 2008, 6:43am UTC](https://forums.speedlife.net/t/web-developers-enter/52701 "2008-08-05T06:43:40Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![DrDoS](https://avatars.discourse-cdn.com/v4/letter/d/ccd318/32.png) [@DrDoS](https://forums.speedlife.net/u/DrDoS)\
**Post date:** [August 5, 2008, 7:01am UTC](https://forums.speedlife.net/t/web-developers-enter/52701/10 "2008-08-05T07:01:18Z")

</div>

try this

mysql

```auto

 CREATE TABLE `myVisitors`.`myVisits` (
`ip` BIGINT NOT NULL ,
`visits` INT UNSIGNED NOT NULL ,
`visitTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
UNIQUE (
`ip`
)
) ENGINE = MEMORY 

```

php

```auto
&lt;?php
	$dbHost = 'localhost';	// database host
	$dbName = 'myVisitors';	// database name
	$dbUN	= 'dbUN'; // database user name
	$dbPW	= 'dbPW'; // database password
	$ip = ip2long($_SERVER['REMOTE_ADDR']);		
	$dbcon = mysql_pconnect($dbHost,$dbUN,$dbPW)
	$sql = 'INSERT INTO ' . $dbName . '.myVisits SET ip=\'' . $ip . '\' ON DUPLICATE KEY visits=visits+1;';
	$DBQ	= mysql_query($sql);
	echo (!$DBQ) ? "Error with adding IP. &lt;br/&gt; Error:" . mysql_error() : "Added IP";
	mysql_close();
?&gt;

```

---

_[View the full topic](https://forums.speedlife.net/t/web-developers-enter/52701)._