- Forums
- Snippets
- How To Encode Ip Address In Mysql Database With Php
This Page Contains information about How To Encode Ip Address In Mysql Database With Php By wallpaperama in category Snippets with 1 Replies. [1373], Last Updated: Tue Feb 07, 2023
wallpaperama
Thu Aug 02, 2007
1 Comments
2063 Visits
if you want to insert user information like the user's ip address, but don't want to put the dots in the ip address, there is a better way. like many forums websited, for example, phpbb, they encode the ip address of the poster, so they use this fucnctions to encode and decode, its an effecient way to manage information in your database.
here and example:
CODE:
function encode_ip($dotquad_ip){
$ip_sep = explode('.', $dotquad_ip);
return sprintf('%02x%02x%02x%02x', $ip_sep[0], $ip_sep[1], $ip_sep[2], $ip_sep[3]);
}
function decode_ip($int_ip){
$hexipbang = explode('.', chunk_split($int_ip, 2, '.'));
return hexdec($hexipbang[0]). '.' . hexdec($hexipbang[1]) . '.' . hexdec($hexipbang[2]) . '.' . hexdec($hexipbang[3]);
}