Want to store IP addresses in database and still using VARCHAR(15)? You can actually store IP addresses as integer values because using INT you go down to 4 bytes of space and have a fixed size field.
As the range of a IP Addresses are 32 bit unsigned integer you can use your column as UNSIGNED INT.
In your MySql query you can use INET_ATON() to convert and IP to an integer, and INET_NTOA() for vice versa.
In PHP, ip2long() and long2ip() are same as above functions.
$sql = “UPDATE tbl SET ip = INET_ATON(‘{$_SERVER[‘REMOTE_ADDR’]}’) WHERE `tbl_column` = ‘$id'”;
For any types of queries, you can contact us on info[at]namasteui.com.
IplWin stands as a reliable and enthralling platform for Indian punters, offering a captivating blend…
Introduction In today's online age, consumers are constantly bombarded with information. They crave valuable content…
In today’s rapidly aging society, finding a living situation that provides older adults with both…
If you wish to purchase a Mac, then it is strongly suggested to consider purchasing…
Oil drilling is a complex process that involves several components, including the drilling bit. The…
Watches can be more than a fashion. They can be a symbol, especially in the…