php - 保存字符串的最后 10 位数字

Question

我目前正在使用 API 将用户的手机号码保存到数据库

public function save_user_phonebook_record($data)
{
    $mobile=str_replace('+','0',$data['mobile']);
    $mobile=str_replace(' ','',$mobile);
    $mobile=substr($mobile, -10);
    $params = array(':mobile' => $mobile, ':user_id' => $data['user_id']);
    $sql = "SELECT * FROM friends where mobile=:mobile AND user_id=:user_id";
    $stmt = parent::query($sql, $params);
    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) :
        $res=$row;
    endwhile;
    if(count($res)<1)
    {
        $sql = 'INSERT INTO friends (user_id, name, mobile) 
        VALUES(:user_id, :name, :mobile)';
        $params =(array(
            ':user_id' => $data['user_id'],
            ':name' => $data['name'],
            ':mobile' => $data['mobile']
        ));
        parent::query($sql, $params) or die(parent::$dbh->errorInfo());
    }
}

使用的API

$client->save_phonebook(array('key'=>$api_key, 'user_id'=>'25349', 'phonebook'=>json_encode(array(array('name'=>'XXXXX Jain',"mobile"=>"+919876543210"),array('name'=>'xxxxxx Verma',"mobile"=>"09876543210")))));

存储在移动表中的手机号码保存为+919812345678,09876543210，，尽管我已输入$mobile=substr($mobile, -10);仅保存号码的最后 10 位数字，但由于某种原因似乎不起作用

Answer 1

此处需要更改，将 $data['mobile'] 替换为 $mobile

$params =(array(
            ':user_id' => $data['user_id'],
            ':name' => $data['name'],
            ':mobile' => $mobile
        ));