是否将SQL查询转换为yii2？

Question

到目前为止，我一直在使用yii2中的SQL查询，它在本地工作得很好，但是一旦我将它部署到服务器上，就会显示

​

​

我已经尝试将它更改为yii query，因为它是下面的正确实现

$query = $connection->createCommand("SELECT a.name_of_flight, a.time_of_flight, (a.no_of_passenger - b.cnt) as avail, a.no_of_passenger FROM flight_schedule a LEFT JOIN (SELECT flight_time, COUNT(id) AS cnt FROM book_eticket WHERE flight_date='$date' AND company_name = '$comp_name' GROUP BY flight_time) b ON a.id = b.flight_time")->queryAll();

至

$query = (new \yii\db\Query());

$query
    ->select('a.name_of_flight, a.time_of_flight, (a.no_of_passenger - b.cnt) as avail, a.no_of_passenger')
    ->from('flight_schedule a')
    ->leftJoin('flight_time', ('COUNT(id) AS cnt FROM book_eticket'))
    ->where(array('and', 'flight_date=2016-6-29', 'company_name = Team5'))
    ->groupBy(['flight_time b','ON a.id = b.flight_time']);

$command = $query->createCommand();
$query = $command->queryAll();

但我得到一个错误：

​

​

有人能帮我找出问题所在吗？提前感谢

Answer 1

第一个屏幕显示的是访问问题。第二-像date和team这样的操作数不是字符串。这是错误的。你能引用他们的话吗？