将IPV6和IPV4存储在MySql中并读取 [英] Store IPV6 and IPV4 in MySql and also read it

问题描述

我有一个php网站.我想为每个用户存储一个最后的IP.我希望它适用于IPV4和IPV6用户.知道如何吗?

I have a php site. I want to store an last ip for each user. I want it to work for both IPV4 and IPV6 users. Any idea how?

推荐答案

使用 inet_pton() ，然后使用另一种解决方案是在数据库中存储IP字符串，而不进行任何转换. VARCHAR(39)字段将完成此任务，因为最高/最长的IPv6是ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff

Another solution would be storing the IP string without any transformations in the DB. A VARCHAR(39) field will do the job as the highest/longest IPv6 is ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff

这篇关于将IPV6和IPV4存储在MySql中并读取的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！