Re: [PHP] including parenthesis, space and dashes in a phone number

It's ok to store it this way, but it could be a little PITA when search.
E.g., you store (123) 456-7890 and somebody search for 123-456-7890? Right?

-afan



Daevid Vincent wrote:
The kind of opposite of this, is what I use, in that it ADDs the () and -

if ((strlen($phone)) <= 14) $phone =
preg_replace("/[^0-9]*([0-9]{3})[^0-9]*([0-9]{3})[^0-9]*([0-9]{4}).*/",
"(\\1) \\2-\\3", $phone);

-----Original Message-----
From: afan pasalic [mailto:afan@xxxxxxxx]
Sent: Friday, November 30, 2007 5:45 AM
To: php-general
Subject: [PHP] excluding parenthesis, space and dashes from
phone number

hi,
I store phone number in mysql as integer, e.g. (123) 456-7890
is stored
as 1234567890.
though, in search form they usually type in a phone number with
parenthesis/space/dashes. I have to extract numbers before I search
through mysql.

currently, I use eregi_replace() function, several times, to
do the job:
eregi_replace(' ', '', $phone);
eregi_replace('(', '', $phone);
eregi_replace(')', '', $phone);
eregi_replace('-', '', $phone);
and it works fine.

but, is there any better way? more "fancy"? :)

thanks for any help.

-afan

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



.

Relevant Pages