/PHP/How to insert ip address in mysql using php

How to insert ip address in mysql using php

-- `ip_address` int(4) unsigned NOT NULL
INSERT INTO my_table (`ip_address`) VALUES (INET_ATON("127.0.0.1"));
SELECT INET_NTOA(ip_address) as ip FROM my_table;
-- php
<?php
var_dump(ip2long('123.63.153.253'));	-- 2067765757
var_dump(long2ip(2067765757));			-- "123.63.153.253"
?>

Source: onlinewebtutorblog.com

How to insert ip address in mysql using php

-- `ip_address` int(4) unsigned NOT NULL
INSERT INTO my_table (`ip_address`) VALUES (INET_ATON("127.0.0.1"));
SELECT INET_NTOA(ip_address) as ip FROM my_table;
-- php
<?php
$ipaddress = $_SERVER['REMOTE_ADDR'];  
var_dump(ip2long('123.63.153.253'));	-- 2067765757
var_dump(long2ip(2067765757));			-- "123.63.153.253"
?>

Similar codes

2 votes299 views3 answers
Laravel subdays
PHP
0 vote278 views1 answer
Php mysql query multiple where
PHP
0 vote270 views1 answer
Laravel get all old input
PHP
0 vote308 views1 answer
Add variables to line in laravel notification
PHP Laravel
102 votes319 views6 answers
Push element in array php
PHP
4 votes281 views1 answer
TRANSACTON LARAVEL QUERY BUILDER
PHP Laravel
15 votes280 views10 answers
Hello world
PHP
0 vote242 views1 answer
Wordpress Simple Membership button name
PHP
9 votes248 views3 answers
Php append line to file
PHP
3 votes256 views1 answer
Php grab year from date
PHP