现在我在where条件下手动给出id号,就像这样
where(['idsmsdata' => [1,6,7]]);
我的问题是:
$query1 = (new \yii\db\Query())->select(['number'])
->from('smsdata')
->where(['idsmsdata' => [1,6,7]]);
$command1 = $query1->createCommand();
$data1 = $command1->queryAll();
$vnumber = '';
foreach($data1 as $row1) {
$vnumber .= $row1['number'].',' ;
}
echo $vnumber;
我会在$vnumber中得到这样的输出:96xxxxxx,85xxxxxx,77xxxxxxx。id中对应的三个数字。
我希望查询是where id != 0,这样它就可以获取剩余的id。
发布于 2019-06-20 19:32:21
试试这个:-
$query1 = (new \yii\db\Query())->select(['number'])
->from('smsdata')
->where(['<>','idsmsdata', 0]);
$command1 = $query1->createCommand();
$data1 = $command1->queryAll();
$vnumber = '';
foreach($data1 as $row1) {
$vnumber .= $row1['number'].',' ;
}
echo $vnumber;
https://stackoverflow.com/questions/56684753
复制相似问题