/SQL/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

0 vote326 views1 answer
Clone table structure mysql
SQL
11 votes367 views6 answers
Distinct sql
SQL
5 votes360 views4 answers
Change auto increment mysql
SQL
0 vote346 views1 answer
Login phpmyadmin without password
SQL
1 vote445 views1 answer
Sql and
SQL
3 votes348 views1 answer
Mysql load sql from file
SQL
2 votes355 views4 answers
Mysql select into new table
SQL
3 votes358 views2 answers
Mysql config user password
SQL
0 vote376 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote402 views1 answer
How to get button for every record from mysql
SQL