PHP mobile phone number location query code (API interface/mysql)

PHP mobile phone number location query code (API interface/mysql)_PHP tutorial

WBOY

Release： 2016-07-21 15:16:37

Original

1402 people have browsed it

First, we introduce using your own database to query multiple mobile phone numbers. It is still recommended that you have your own mobile phone number database. Under normal circumstances, if you only want to satisfy general inquiries, you do not need to purchase the professional version of the mobile phone number database, which will increase unnecessary costs. I provide you with an ACCESS database for free, which contains more than 170,000 pieces of data. The commonly used mobile phone number segments starting with 130-139, 150-159 and 180-189 are all in it. You can easily convert it into MYSQL or MYSQL with the help of database tools. Other versions of the database

The latest mobile phone number database download address: http://xiazai.jb51.net/201209/yuanma/phone-number-database-jb51.rar

PHP+MYSQL mobile phone number Attribution query implementation method

Through the above introduction, we already have our own MYSQL data table. The structure of this table is very simple: ID (serial number), code (area code), num (mobile phone number segment), cardtype (mobile phone card type), city (mobile phone number location). Note that this table stores a large amount of data. Appropriate index fields should be established based on your SQL query statement to improve query efficiency.

1) To obtain the location of the mobile phone number, we only need to determine the location of the mobile phone number segment. It is mainly implemented through the following functions, among which GetAlabNum, cn_substr, and str_replace are all string operation functions, and $dsql is a database operation class.

Copy code The code is as follows:

 
function GetTelphone($tel) 
{ 
global $city,$ dsql; 
if(isset($tel)) $tel = GetAlabNum(trim($tel));//The GetAlabNum function is used to replace full-width numbers and convert possible illegal mobile phone numbers into numbers; trim removes excess spaces . 
else return false; 
if(strlen($tel) < 7) return false; 
$tel = cn_substr($tel, 11);//Intercept 11 characters first to prevent multiple Mobile phone number
//if(!is_numeric($tel)) return false; 
if(cn_substr($tel, 1) == "0")//Determine whether the mobile phone number starts with 0, in this case It may be that the landline number starts with 0
{ 
if(cn_substr($tel, 2) == "01" || cn_substr($tel, 2) == "02") $tel = cn_substr($ tel, 3);//3-digit area code
else $tel = cn_substr($tel, 4); 
$row = $dsql->GetOne(" Select code,city as dd from `dede_tel` where code='$tel' group by code "); 
} 
else 
{ 
$tel = cn_substr($tel, 7); 
$row = $dsql->GetOne (" Select num,city as dd from `dede_tel` where num='$tel' "); 
} 
$city = $row['dd']; 
if($city) 
{ 
$city = str_replace("province", "-", $city); 
$city = str_replace("city", "", $city); 
$city = "< br />[".$city."]"; 
return $city; 
} 
} 

API implementation method, you don’t need your own database here but there are limitations.
Mainly use curl to implement, you need to enable PHP’s support for curl.

Copy code The code is as follows:

header(“Content-Type: text/html; charset=utf-8″);
if (isset($_GET['number'])) {
$url = 'http://webservice.webxml.com.cn/WebServices/MobileCodeWS.asmx/ getMobileCodeInfo';
$number = $_GET['number'];
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POST , true);
curl_setopt($ch, CURLOPT_POSTFIELDS, “mobileCode={$number}&userId=”);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$data = curl_exec($ch) ;
curl_close($ch);
$data = simplexml_load_string($data);
if (strpos($data, 'http://')) {
echo 'Mobile phone number format error !';
} else {
echo $data;
}
}
?>

Querying the mobile phone number ownership with php mysql will be much slower, after all, the data needs to be obtained through a third method.