I'm making a simple IP logger. I've tested the script, but the database doesn't seem to filling up. It could be a problem with the database format etc, details below. Otherwise, I must have made an newbie oversight in the PHP. Some fresh eyes would be greatly appreciated!

id: INT(10), unsigned, NN, primary key, auto_inc
page: VARCHAR(255), NN
logdate: VARCHAR(100), NN
ip: VARCHAR(100), NN


include 'ip_finder.php'; // IP finder script, returns the variable $IP
include 'config.php'; // Database details

$date = date("F j, Y, g:i a");

// echo $ref." ".$date." ".$IP." ".$agent;

$logger = "INSERT into doorbell ('page', 'logdate', 'ip', 'agent') VALUES ('$ref', '$date', '$IP', '$agent')";

if (!$logger){ 
	die('Could not connect: ' . mysql_error());
	} else {
		echo "1 record added";



Recommended Answers

$logger = "INSERT into doorbell (page, logdate, ip, agent) VALUES ('$ref', '$date', '$IP', '$agent')";
Jump to Post

All 3 Replies

Member Avatar
$logger = "INSERT into doorbell (page, logdate, ip, agent) VALUES ('$ref', '$date', '$IP', '$agent')";

hmmm. that seems to have done it... Although I swear I already tried without quotes...
some sort of devil magic going on..

Cheers mate!

Member Avatar

Ok, great, are we solved?

If so, click the link below 'Thread Solved' or whatever it says. Cheers.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.