How to insert a user's ip into MySql?

[janhouse00]

1)Hi please take a look at this:

test.php

<?
$ip = $REMOTE_ADDR;
print("$ip");

?>

It works,right?Okay, what if I want to track a user's ip and insert it into
MySql database. I did try the following way:

<?
.....
.....
$ip = $REMOTE_ADDR;
.....
$query="insert into mytable values('$ip')";
..
?>

But, it failed to perform what I wanted. I don't know why.My question is:
Is there anyway to do the trick for me, or could anyone please help me to
figure out why?Any solution?

2)What's the difference between a webportal and a community?In my confusion,
I thought both of them are almost the same, they are equiped with forum,guest book,
membership registration....

3)I saw there is one kind of variables in MySQL called timestamp, so what does
it mean?Recording the current time while data is being inserted?And, how do I
use it?

Thank you very much,

Regards,
none
[e-mail]

[gyoung]

What error message did you get, if any?

i. Does your table only have one column? If not, you need to specify the column name.

ii. Strings withing single quotes are treated literally.

iii. Char/Varchar columns require quoted data.

Try something like:

$query="insert into mytable ('mycolumn')values('" . $ip . "');

You should also ensure that your query is correct (ie Print($query)😉.

Timestamps are the "number of seconds since the Unix Epoch" (some time in 1970).

[Anon]

not in mysql, mysql actually stores the date inside the field, not the number of seconds, to transfer that into php readable timestamps, use

SELECT UNIX_TIMESTAMP(time) as time FROM table

[intenz]

Do the following:

<?
$ip = $REMOTE_ADDR;
$query = mysql_query("INSERT INTO mytable (ip) VALUES ('$ip')";
?>