insert ip address in mysql
Solutions on MaxInterview for insert ip address in mysql by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "insert ip address in mysql"
Christian
28 Jul 2019
1-- `ip_address` int(4) unsigned NOT NULL
2INSERT INTO my_table (`ip_address`) VALUES (INET_ATON("127.0.0.1"));
3SELECT INET_NTOA(ip_address) as ip FROM my_table;
4-- php
5$ipaddress = $_SERVER['REMOTE_ADDR'];
6var_dump(ip2long('123.63.153.253')); -- 2067765757
7var_dump(long2ip(2067765757)); -- "123.63.153.253"similar questions
insert into auto increment mysqlmysql add to numbermysql ip addressmysql ip address data typeinsert mysql ifile nto databasehow to change the auto increment in existing table mysqlauto increment mysqlmysql store ip addresshow to find ip address of mysql database serverhow to insert ip address in mysql using phpadd auto increment column to existing table mysql your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful