Posted by Marek Simon on 01/30/06 19:33

Marek Simon wrote:
> I have mysql database for internal computer evidence and I store IP as
> unsigned numeric value. It is very good for computing network ranges and
> so on. But PHP do not support unsigned integer. So when I store values
> to doatabase, I must convert it to string with sprintf. When reading it,
> I get a string value with 10-digit number, bigger than maxint. I need to
> convert it to signed int and work with it as a number (for making binary
> arithmetics). I have discovered no way how to do it. Intval() or (int)
> type conversion returns maxint. Converting it in mysql is anoying too,
> because mysql cant do signed 32-bit int type conversion, only 64 bit.
> Marek

I've just found something.
intVal(floatVal($num));

Marek

[Back to original message]