Automatically Log the IP Address of Site Visitor

How can i insert the IP Address of my users into a table automaticaly using the INSERT function.

 

definitely can, you need to use

$REMOTE_ADDR

PHP:

in order to collect the user ip address from certain php page.

 

You can get IP address in PHP as below..

$remote_ip = $_SERVER['REMOTE_ADDR']

and then you can use it in insert query to store in database

 

is this correct

 

Nope.
You are storing IP in date column which is wrong.

you should add a column in dle_search table "ip_address" and insert ip in that column..

something like this..

$remote_ip = $_SERVER['REMOTE_ADDR'];
mysql_query("INSERT IGNORE INTO dle_search (tag, ip_address) VALUES ('$story', $remote_ip)");

 

What should be the datatype of the ip column. I selected INT

 

keep data type as varchar - length 20. If you wish, you can store it as integer value as well but that needs conversion so better store it as it is in varchar field.

 

Thank you for the excellent help. This is the second time you are helping me. I do owe you something man. What can i do for you?

 

varchar(15) is enough for IPs

 

Which language use are using?

 

For crowded website. it will need large CPU performence