如何使用SELECT请求获取数据

Question

我正在尝试在我的数据库中显示运营商的统计数据。当我调用该函数但出现如下错误时：class: "Doctrine\DBAL\Exception\SyntaxErrorException"message: "An exception occurred while executing 'select count(cod_ser) TOTAL FROM public.tiers_datamart period =06-2019':↵↵SQLSTATE[42601]:我的代码是这样的：public function getTotalDatabyMonth($date, $type, $filtre) {        $em = $this->getDoctrine()->getManager('dbStat')->getConnection();        if($filtre == null) {            $restriction = "period =".$date;        }else {            $restriction = $type." = ".$filtre." AND period = ".$date;        }        $rawSql = "select count(".$type.") TOTAL FROM public.tiers_datamart ".$restriction;                $stmt = $em->prepare($rawSql);        $stmt->execute();           $result = $stmt->fetchAll();            return intval($result[0]['total']);    }    public function getTotalDatabyMonths($dates, $type, $filtre) {        $totalDatas = [];        foreach($dates as $date){            $total = $this->getTotalDatabyMonth($date, $type, $filtre);            array_push($totalDatas, $total);        }        return $totalDatas;    }我调用函数 'data'=> $this->getTotalDatabyMonths($dataFormats[1], "cod_ser", $restriction)我试图在方法中替换$filtreby但它返回相同的值 12 次。$restrictiongetTotalDatabyMonths()

Answer 1

$rawSql = "select count(".$type.") TOTAL FROM public.tiers_datamart WHERE ".$restriction;

添加 WHERE 就可以了。