RE: [PHP] including parenthesis, space and dashes in a phone number
- From: warren@xxxxxxxxxxxx ("Warren Vail")
- Date: Fri, 30 Nov 2007 13:11:11 -0800
Not to mention that syntax works in the US, but not large portions of the
rest of the world. (even with the 1 country code in front).
Warren vail
-----Original Message-----.
From: afan pasalic [mailto:afan@xxxxxxxx]
Sent: Friday, November 30, 2007 12:03 PM
To: Daevid Vincent
Cc: 'php-general'
Subject: 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
- Follow-Ups:
- Re: [PHP] including parenthesis, space and dashes in a phone number
- From: Jochem Maas
- Re: [PHP] including parenthesis, space and dashes in a phone number
- References:
- RE: [PHP] including parenthesis, space and dashes in a phone number
- From: "Daevid Vincent"
- Re: [PHP] including parenthesis, space and dashes in a phone number
- From: afan pasalic
- RE: [PHP] including parenthesis, space and dashes in a phone number
- Prev by Date: Re: [PHP] including parenthesis, space and dashes in a phone number
- Next by Date: Re: [PHP] including parenthesis, space and dashes in a phone number
- Previous by thread: Re: [PHP] including parenthesis, space and dashes in a phone number
- Next by thread: Re: [PHP] including parenthesis, space and dashes in a phone number
- Index(es):
Relevant Pages
|
|
