/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

2 votes119 views1 answer
Find all triggers in database
SQL
1 vote121 views1 answer
Postgres check for foreign key
SQL
5 votes106 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote114 views1 answer
Postgresql delete type
SQL
0 vote172 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
1 vote110 views1 answer
How to start with sql
SQL
9 votes109 views3 answers
Mysql get last id
SQL
3 votes76 views1 answer
Postgresql where current year
SQL
2 votes116 views1 answer
Laravel sql String
SQL
1 vote112 views1 answer
Add time to date sql
SQL