PHP:搜索数组相似数据库“;如%key%”;


PHP : Search array similar DB " like %key% "

我有一个数组,格式如下:

countries(
    [0] = Array
        (
            [0] = 1
            [1] = USA

        )
    [1] = Array
        (
            [0] = 93
            [1] = Afghanistan
        )
    [2] = Array
        (
            [0] = 358
            [1] = Finland
        )

)

=======

[0] country code
[1] country name

我想搜索这个数组来获得这个号码属于哪个国家。。

示例:358545454554,我如何搜索数组以获得哪个国家,在这种情况下=芬兰请考虑性能,所以我想要最快的

要匹配第一个数字,请将这些数字的子字符串与您的结果进行比较:(演示)

<?php
$search = '358545454554';
$countries = [[1, 'USA'], [93, 'Afghanistan'], [358, 'Finland']];
$country = null;
foreach ($countries as $c) {
  if (substr($search, 0, strlen($c[0])) == $c[0]) {
    $country = $c[1];
    break;
  }
}
echo ($country === null) ? 'No country found!' : $country;
if (strpos($string, $word) === FALSE) {
   ... not found ...
}

请注意,strpos区分大小写,如果要进行不区分大小写的搜索,请改用stripos()

还要注意===,强制进行严格的相等性测试。如果"needle"字符串位于"haystack"的开头,则strpos可以返回有效的0。通过强制检查一个实际的布尔值false(又名0),您可以消除这个false positive

您可以使用array_filter进行此操作。第一种变体在国家ID的任何位置搜索数字,因此3581545454554与美国和芬兰匹配,第二种变体使用正则表达式仅过滤以相同数字开头的ID。

$data = array(
    array(1, 'USA'),
    array(93, 'Afghanistan'),
    array(358,'Finland')
);
$term = '358545454554';
// in case you want to match it anywhere in the term string...
$result = array_filter($data, function($elem) use($term) {
    return (strpos((string) $term,(string) $elem[0]) !==false ) ? true : false;
});
var_dump($result);
// in case you want to match only from start
$result = array_filter($data, function($elem) use($term) {
    return preg_match('/^'.$elem[0].'/',$term);
});
var_dump($result);
$countries =  array(
    array('1','USA'),
    array('93','Afghanistan'),
    array('358','Finland'),
    array('3','India')
);
$input_code = '358545454554';
$searched = array();
foreach($countries as $country) {
    if (strpos($input_code, $country[0]) !== FALSE) 
        $searched[] = $country[1];
}
print_r($searched);

请访问此处(演示)。