/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 votes153 views1 answer
Tsql copy table
SQL
-2 votes121 views2 answers
Union vs union all in sql
SQL
0 vote105 views2 answers
Many to many flask-sqlalchemy
SQL
23 votes111 views4 answers
How to show all users in mysql
SQL
20 votes107 views5 answers
Sql show tables
SQL
27 votes109 views5 answers
Add column in table
SQL
0 vote117 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote124 views1 answer
For row in sql database python loop
SQL
0 vote115 views1 answer
Multiple tricky query in sql server
SQL
0 vote105 views1 answer
Postgresql remove new line from string
SQL