Re: 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@afan.net] >> 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 >> >> >