Databases
StackOverflow2013
Postsdbo
PODetermining local / international phone numbers for the US
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODetermining local / international phone numbers for the US
    primarykey
    data
    text
    <p>You're probably thinking this has been asked a million times before but I think that my question is a little different. Most requests for phone number validation are used for validating user input. In my scenario I'm trying to validating incoming phone calls to a US mobile phone, and determine whether they're calling from another country or from within the US.</p> <p>My main problem is that I'm based in the UK and have no experience of US phone numbers.. I've read about the format of how to dial etc (both international and national) but my worry is that the phone numbers appear differently on the recipient's phone, and in a variety of formats.</p> <p>Here is the specification of what I'm trying to do.. </p> <ul> <li>Imagine you are based in the US and are receiving a call on your mobile phone</li> <li>Determine whether the call is from a US or another country</li> <li>In the UK calls can come appear in the local or international format, it should be able to determine if it's a US number or not</li> <li>I believe international calls can be displayed on your phone in the format 0044 or +44 (if you were calling from the UK to the US)</li> <li>If the call is from within the US is it a valid phone number?</li> <li>Strip out all non numerical characters and reformat to national format. For example, the UK number 01530 123123 would get reformatted to 01530123123</li> <li>Strip out all non numerical characters and reformat to international format. For example, the UK number 01530 123123 would get reformatted to 00441530123123</li> </ul> <p>I'm trying to write the code in PHP and avoid regular expressions. I'm thinking it could use substr() to break down parts of the number.</p> <p>Any thoughts on how to go about this, code snippets or example phone numbers? I'm really hoping someone from the US will be able to enlighten me on phone number formatting etc..</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKara
    1. USRichW
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODetermining local / international phone numbers for the US
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODetermining local / international phone numbers for the US
      1. USRichW
      1. VTBountyStart
    3. VO
      singulars
      1. PODetermining local / international phone numbers for the US
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload