[SOLVED] is_numeric Function

[ballouta]

Hi

I am trying to validate a phone number just to make sure that the users are writing numbers not letters. I am using this line of code:

 

<?php
if (!is_numeric ($phone))
echo "Error";
else
echo "OK";
?>

 

I noticed that if i insert +123456, the code continues and insert in the database this number: 2147483647

this field is called phone in my DB and of length 25

 

what's the problem and where?

 

Thank you

[GingerRobot]

The is_numeric function will allow signed numbers. It'll also allow decimal and exponential parts. If you want to ensure the string only contains decimal digits, use the ctype_digit function.

 

As for why it's been inserted as 2^32-1; i'm not overly sure. Evidently there's some sort of overflow going on somewhere. What type is the field? Do you do anything else to $phone before it's inserted?

[ballouta]

thank you, i just read the ctype_digit function manual.

 

The phone number in my database is of type int(25)

 

the main problem is clear now.

 

Is it possible to allow the user to write only the sign (+) before the phone number, i mean is there a built in fucntion that validates the phone number and allows the + sign before it? or this requires a reg? If yes what type should the phone field be in the DB?

 

Thank you

[.josh]

$num = '+12345';
if (preg_match('~^\+?[0-9]+$~',$num)) 
  // valid
else
  // not valid

[ToonMariner]

perhaps you might want to cater for a varchar instead?

[jxrd]

Yeah, if it's an int and the first digit is a 0 it removes it. Or so I think.

[ballouta]

Thank you all

 

the reg. exp works prefect