NYCPHP Meetup

NYPHP.org

[nycphp-talk] storing phone numbers in MySQL

Jeff Siegel jsiegel1 at optonline.net
Wed Mar 10 18:35:29 EST 2004


I believe that the storing of the phone numbers would fall under the 
"display agnostic" theory as noted in the PHundamentals article on 
storing and retrieving data. Besides, by storing just the numbers (as 
strings, of course) means you can display it using hyphens or with 
parens or whatever may be needed.

Jeff Siegel
----------------

David Mintz wrote:

> Jeez I'm awful sorry to disturb you again but... you do store them as
> string types, right? If they were actually numeric in the data layer (as
> opposed to the form input) and there were a leading zero somewhere it
> sounds like it could get ugly.
> 
> PS I am loving that QuickForm, oh yesssssss.
> 
> On Wed, 10 Mar 2004, Mitch Pirtle wrote:
> 
> 
>>David Mintz wrote:
>>
>>>Hey you in the back of the room, stop snoring.
>>>
>>>
>>
>>(snaps head up)  Hey who what the...  Oh.
>>
>>[...] By using PEAR's
>>HTML_QuickForm, it is pretty easy to ensure you are only getting numeric
>>data - and providing helpful messages too.
>>
> 
> 
> 
> ---
> David Mintz
> http://davidmintz.org/
> 
>         "Anybody else got a problem with Webistics?" -- Sopranos 24:17
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
> 




More information about the talk mailing list