/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

-1 vote188 views2 answers
On update cascade
SQL
1 vote189 views3 answers
Union SQL
SQL
1 vote216 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote201 views1 answer
Query by column for substring sql
SQL
0 vote231 views5 answers
How to make trigger in phpmyadmin
SQL
3 votes215 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote200 views1 answer
Find most frequent value in SQL column
SQL
21 votes210 views4 answers
Add column mssql
SQL
3 votes196 views2 answers
Plsql print
SQL
2 votes234 views1 answer
Datefromparts mssql
SQL