/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

0 vote120 views3 answers
Add ACF to single.php
PHP
0 vote372 views2 answers
Search post by post title in wordpres
PHP
0 vote161 views1 answer
Laravel Customizing Missing Model Behavior
PHP Laravel
9 votes136 views1 answer
Laravel 6 link storage with public
PHP Laravel
1 vote116 views2 answers
Php key value array to string
PHP
0 vote122 views1 answer
How to display the site tagline in wordpress
PHP
0 vote121 views3 answers
Transfer file using file_get_content
PHP
0 vote139 views1 answer
Yajra laravel datatables rawcolumn
PHP Laravel
1 vote123 views2 answers
Wordpress get option value
PHP Wordpress
2 votes118 views3 answers
Laravel env production
PHP