Cant store ip as int in the database

Asked Mar 15 '17 at 14:30

Active Mar 15 '17 at 14:49

Viewed 33 times

I am trying to store an ip after i have used the function ip2long() but it won't INSERT anything when i use this function? if i change $ip = 10; it will store 10 as my ip in the database, but it won't store the number returned from the function.

I have tried to check if the returned value is a int with is_int() and it returns true.

The ip in the database is a int(39), so basically why won't it update my database?

PHP/SQL

$ip = ip2long($_SERVER['REMOTE_ADDR']);

$stmtt = $dbCon->prepare("INSERT INTO rating_users (imgId, rating, ip) VALUES (?, ?, ?)");
$stmtt->bind_param('iii', $imgValue, $voteValue, $ip);
$stmtt->execute();

edited Mar 15 '17 at 14:49

Funk Forty Niner

74,450
15
68
141

asked Mar 15 '17 at 14:30

Christian Lauridsen

Have you checked your error log if any errors are thrown? – M. Eriksson Mar 15 '17 at 14:31
1

Your answer is here => https://dev.mysql.com/doc/refman/5.7/en/integer-types.html being `unsigned INT` if it's not already that. What is the exact schema for it? – Funk Forty Niner Mar 15 '17 at 14:34
See also http://stackoverflow.com/questions/5842085/how-should-ip2long-converted-ips-be-stored-in-mysql – Funk Forty Niner Mar 15 '17 at 14:35
If your int field is signed you need to make it unsigned. – apokryfos Mar 15 '17 at 14:40
1

they come to ask, we answer... we stare and wait for answers on comments asking for clarification; and you are where, testing? having breakfast? gone to school? other? I swear, it's like pulling teeth; again. – Funk Forty Niner Mar 15 '17 at 14:41
@Fred-ii-, Cool Off ... looks like temperature at your place is really high :) – Rahul Mar 15 '17 at 14:42
Sorry i was making me a some food :) the problem was unsigned, i am very thankfull for the answer and help :) – Christian Lauridsen Mar 15 '17 at 14:42
@Rahul my eyes get tired faster now *lol* after all that "staring" for updates. – Funk Forty Niner Mar 15 '17 at 14:43
*"Sorry i was making me a some food"* - well, I wasn't far from the truth *lol!* *"having breakfast?"* - not bad huh? ;-) – Funk Forty Niner Mar 15 '17 at 14:44
lol i still wonder how it evolved this way tho xD but thanks for the great response and help :) – Christian Lauridsen Mar 15 '17 at 15:52

Cant store ip as int in the database

0 Answers0