Best way to store IP in database?

by

Store the ip as a INT(11) UNSIGNED, then use the INET_ATON and INET_NTOA functions to store/retrieve the ip address.

Sample code:

INSERT table(ip) VALUES (INET_ATON('192.168.0.1')); /*ip = 3232235521*/
SELECT INET_NTOA(ip) As IPAddress FROM table; /*IPAddress = 192.168.0.1*/

More Related Contents:

  1. Laravel – only a zero is saved to the database
  2. storing user_id in session variable
  3. mysqli or die, does it have to die?
  4. Convert from MySQL datetime to another format with PHP
  5. MySQL vs MySQLi when using PHP [closed]
  6. PHP/MySQL insert row then get ‘id’
  7. How do I set ORDER BY params using prepared PDO statement?
  8. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  9. Passing an array to a query using a WHERE clause
  10. How can I store and retrieve images from a MySQL database using PHP?
  11. PHP/MySQL Insert null values
  12. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  13. PHP file cannot enter some part of code
  14. Laravel: PDOException: could not find driver
  15. Can you add an if statement in ORDER BY?
  16. PDO Connection Test
  17. Grouping WHERE clauses in Codeigniter
  18. Using if(isset($_POST[‘submit’])) to not display echo when script is open is not working
  19. MySQL (or PHP?) group results by field data
  20. SELECT COUNT() vs mysql_num_rows();
  21. Store procedures in phpMyAdmin
  22. Check if a row exists using old mysql_* API
  23. Unique IPs in a voting system
  24. MySQL get a random value between two values
  25. Get MySQL database output via PHP to XML
  26. php warning mysql_fetch_assoc
  27. Storing time information: Timezone required?
  28. Backup a mysql database and download as a file
  29. Is a BLOB converted using the current/default charset in MySQL?
  30. PHP/MySQL Pagination

Leave a Comment