Which MySQL datatype to use for an IP address? [duplicate]

by

Since IPv4 addresses are 4 byte long, you could use an INT (UNSIGNED) that has exactly 4 bytes:

`ipv4` INT UNSIGNED

And INET_ATON and INET_NTOA to convert them:

INSERT INTO `table` (`ipv4`) VALUES (INET_ATON("127.0.0.1"));
SELECT INET_NTOA(`ipv4`) FROM `table`;

For IPv6 addresses you could use a BINARY instead:

`ipv6` BINARY(16)

And use PHP’s inet_pton and inet_ntop for conversion:

'INSERT INTO `table` (`ipv6`) VALUES ("'.mysqli_real_escape_string(inet_pton('2001:4860:a005::68')).'")'
'SELECT `ipv6` FROM `table`'
$ipv6 = inet_pton($row['ipv6']);

More Related Contents:

  1. MySQL integer field is returned as string in PHP
  2. Php date() Date and time is stuck [closed]
  3. mysqli or die, does it have to die?
  4. MySQL vs MySQLi when using PHP [closed]
  5. PHP/MySQL insert row then get ‘id’
  6. How do I set ORDER BY params using prepared PDO statement?
  7. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  8. How can I store and retrieve images from a MySQL database using PHP?
  9. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  10. PHP file cannot enter some part of code
  11. Laravel migration: unique key is too long, even if specified
  12. Laravel: PDOException: could not find driver
  13. Laravel Eloquent select all rows with max created_at
  14. IP Address of the machine in PHP gives ::1 but why?
  15. Advantages Of MySQLi over MySQL [closed]
  16. Grouping WHERE clauses in Codeigniter
  17. Using if(isset($_POST[‘submit’])) to not display echo when script is open is not working
  18. SELECT COUNT() vs mysql_num_rows();
  19. Store procedures in phpMyAdmin
  20. Unique IPs in a voting system
  21. Get MySQL database output via PHP to XML
  22. Storing time information: Timezone required?
  23. Finding free blocks of time in mysql and php?
  24. How to escape single-quote (apostrophe) in string using php
  25. adding 1 day to a DATETIME format value
  26. Query on a many-to-many relationship using Doctrine with Symfony2
  27. Best way to connect to MySQL with PHP securely [duplicate]
  28. mysqli persistent connection
  29. UTF-8 not working in HTML forms
  30. Using mysql concat() in WHERE clause?

Leave a Comment