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: 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
