phalcon count统计

最新推荐文章于 2021-03-23 14:30:19 发布

转载最新推荐文章于 2021-03-23 14:30:19 发布 · 498 阅读

本文介绍了在数据库中使用单表和多表进行记录计数的方法。通过PHP代码示例展示了如何统计不同条件下的机器人数量及系统合同警告的数量。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

单表count:

//How many robots are there?
$number = Robots::count();
echo "There are ", $number, "\n";

//How many mechanical robots are there?
$number = Robots::count("type='mechanical'");
echo "There are ", $number, " mechanical robots\n"

多表count:

$result = $this->modelsManager->createBuilder()
->columns("SysContractWarn.con_warn_id")
->from("SysCustomer")
->join("SysContract","SysCustomer.cus_id = SysContract.cus_id")
->join("SysContractWarn","SysContract.con_id = SysContractWarn.con_id")
->where($where." AND SysCustomer.serv_status = 0 AND SysContractWarn.rmk_del = 0",array("manId"=>$man->man_id))
->getQuery()
->execute()
->count();