获取数据表的计数从另一个表CakePHP中
问题描述:
我试图让表的使用cakephp3另一个表计数,但我必须得到一个错误获取数据表的计数从另一个表CakePHP中
Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AS Transactions__COUNT() FROM transactions Transactions LEFT JOIN transactio' at line 1
我不知道这有什么错我的代码!
这里是我的控制器:
$data = $this->Transactions->find(
'all',
array(
'fields' => array('COUNT(*)'),
'group' => array('transactions_type_id'),
'contain' => array('TransactionsTypes')
) );
,这里是我的CTP:
<?php
foreach ($data as $transactionsType) {
?>
<li>
<p class="clearfix"><i class="icon-radio-checked text-info"></i><b><?php echo $transactionsType['title'] ?> </b><span>210</span>
</p>
<div class="progress progress-md">
<div class="progress-bar progress-bar-info" role="progressbar" aria-valuenow="8" aria-valuemin="0" aria-valuemax="100" style="width: 8%"><span class="sr-only">10% Complete (success)</span>
</div>
</div>
</li>
<?php }
?>
答
你只可以使用count()
功能。
$count=TableRegistry::get('Transactions')
->find()
->contain('TransactionsTypes')
->group('Transactions.transactions_type_id')
->count();
感谢您的重播,我都试过,但这个给我这个错误 警告(2):为的foreach()[APP /模板\网页\ home.ctp,线109] –
的提供了无效的参数错误在这一行: foreach($ count as $ transactionsType){ –
也我已经尝试var_dump($ count),并给我, int(1) –