IP address storing in MySQL database using PHP [duplicate]

by

This tutorial might help you.

The most efficient way of saving IPv4 addresses is with an INT field (not VARCHAR as you might expect). You convert them using PHP’s ip2long and back using either MySQL’s INET_NTOA function or PHP’s long2ip function.

If you need to store IPv6, you’ll want to use a BINARY field instead and PHP’s inet_pton function.

More Related Contents:

  1. Using PHP data in MySQL [closed]
  2. which is better every user have a table or just a row [closed]
  3. I am seeing this error on submitting form Error: query was empty [closed]
  4. PHP – Change value y,n in database [closed]
  5. PDOException SQLSTATE[HY000] [2002] No such file or directory
  6. Many-to-many relationships examples
  7. Automated or regular backup of mysql data
  8. strange character encoding of stored data , old script is showing them fine new one doesn’t
  9. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  10. How to upload images into MySQL database using PHP code
  11. PDO mysql: How to know if insert was successful
  12. How to loop through a mysql result set
  13. MySQL check if a table exists without throwing an exception
  14. Maximum execution time in phpMyadmin
  15. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  16. Mechanisms for tracking DB schema changes [closed]
  17. Fetching single row, single column with PDO
  18. Mysql No connection could be made because the target machine actively refused it
  19. Replacing mysql_* functions with PDO and prepared statements
  20. Is there any way to check the performance of mysql Indexing
  21. phpmyadmin automatic logout time
  22. PHP – Secure member-only pages with a login system
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. Fatal error: Call to undefined function mysqli_result()
  25. Laravel nested relationships
  26. Selecting all fields except only one field in mysql [duplicate]
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. How do I save PHP session data to a database instead of in the file system?
  29. Auto Increment skipping numbers?
  30. How to get last inserted id from table MySQL [duplicate]

Leave a Comment