[RESOLVED] How do I record an ip address from a form submition?

[Wales]

<?php
$ip = getenv('REMOTE_ADDR');

$query = "INSERT INTO mytable (ip)
VALUES ('$ip')";

?>

My ip field: ip INT(10) UNSIGNED NOT NULL,

I pretty much have the above setup. When the users submit the form it submits everything but all I get for the ip field in mytable are the the numbers 1270

Also for INT(10)...isn't 10 suppose to hold the most 10 characters? Mine is holding only 4 even if I go the database and add more characters. I'm probably wrong though.

[bradmasterx]

insert this code for table you need 15 characters xxx.xxx.xxx.xxx

CREATE TABLE `my_table` (
`ip` VARCHAR( 15 ) NOT NULL 
) ENGINE = innodb;

<?php 

$cxn = mysqli_connect("Host", "User", "Pass", "DB");

$ip = getenv('REMOTE_ADDR'); 

$query = "INSERT INTO `my_table` (ip) 
VALUES ('$ip')"; 

$result = mysqli_query($cxn, $query);

?>

You should have you connection made, i used mysqli you can edit to mysql.
Hope this helped. 🙂

[Wales]

does this work with myisam too because I tried it and it don't seem so. I'm adding the field to my current table.

[bradgrafelman]

It'll work with any table type. The reason the INT column wouldn't work is because an IP isn't a numeric value.

Are you sure you dropped the INT column and added a VARCHAR(15) column?

[Wales]

I did and it didn't work the first time. I must of messed up somewhere. Anyways got it working now thanks a lot. Thought it was because of the numbers, but guess not because it has .