IP numbers and datestamp

TobiasM

requiring the ip numbers and timestamp from users submitting a form on my webpage.
do I create a query ?: similar
$query = "insert into testform (testform, tstamp) values ('date', NOW());
and what field name/type is best to use.
I have been searching the net for ideas but still am confused.

Thanks !

coditoergosum

What exactly are you trying to do? Are you trying to log visits to a certain page?

You can get the ip address of a user by calling the environment variable $REMOTE_ADDR.

As far as the type of field to use in your database to store the info, you can use either varchar or text... for the date, you can use a timestamp field.

TobiasM

Thks coditoergosum

where do i place $REMOTE_ADDR?
in here ?$query = "insert into testform(firstname, etc
or
before?

coditoergosum

Well, I don't know. You're going to have to answer my questions before I can answer yours. What exactly are you trying to do?

TobiasM

I require IP no's so I can follow what advertising link users have come from by checking my webstats AND I need the date when form was submitted.

coditoergosum

Sounds like you're probably wanting to get the HTTP_REFERER rather than the IP address of the user. You're still not supplying very much info... if you want more help, be more detailed.

This page should be useful: http://www.php.net/manual/en/reserved.variables.php

TobiasM

Here are some details...
?php
$ref = $HTTP_REFERER;
$sql_hostname = "localhost";
$sql_username = "xxx";
$sql_password = "xxx";
$sql_database = "exx";
$exp = $_POST["pw"];

MYSQL_CONNECT($sql_hostname,$sql_username,$sql_password) or DIE("Unable to connect to database");
@MYSQL_SELECT_DB("$sql_database") or DIE("Unable to select database");
$query = "insert into presform(name,email,telephone,country,state,consultant,refcode,newtime,comments)
values
('$date','$name','$email','$telephone','$country','$state','$consultant','$refcode','$newtime','$comments')";
$result = mysql_query($query);

?>
I need to include in my mysql form, the users host ip (so I can track what advertising medium they have come from) plus the timestamp so I know the date the form was submitted.
Confused as the date is not part of the html form - what query do I run and where do I put it after POST? do I include it within the form values?
Where do I run the environment (host/IP) string?
Thanks for link. Hope this has provided you with more details.

tgotchi

I believe this article could help you.

http://www.ip2location.com/articles/article2.htm

http://www.ip2location.com