Jochem Maas wrote:
> afan pasalic wrote:
>> 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.
2007. 11. 30, péntek keltezéssel 08.44-kor afan pasalic ezt írta:
> 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
afan pasalic wrote:
> 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_r
I suck at regex.. but found this a while ago. Supposedly it'll strip all
non-numeric characters, so I've used it for phone #'s and SSNs:
preg_replace ('/[^\d]+/s', '', $var)
-TG
- Original Message -
From: afan pasalic <[EMAIL PROTECTED]>
To: php-general
Date: Fri, 30 Nov 2007 08:44:
4 matches
Mail list logo