CakePHP在一个index.ctp中显示两个表的数据
CakePHP在一个index.ctp中显示两个表的数据
提问于 2014-05-09 14:21:11
我的companies/index.ctp中有以下代码：
<div class="companies index">
<h2><?php echo __('Company Details'); ?></h2>
<table cellpadding="0" cellspacing="0">
<tr>
<th><?php echo $this->Paginator->sort('Id'); ?></th>
<th><?php echo $this->Paginator->sort('Company Name'); ?></th>
<th><?php echo $this->Paginator->sort('ABN'); ?></th>
<th><?php echo "Billing Address"; ?>
<?php echo $this->Paginator->sort(''); ?>
<?php echo $this->Paginator->sort(''); ?>
<?php echo $this->Paginator->sort(''); ?>
<?php echo $this->Paginator->sort(''); ?></th>
<th><?php echo "Shipping Address"; ?>
<?php echo $this->Paginator->sort(''); ?>
<?php echo $this->Paginator->sort(''); ?>
<?php echo $this->Paginator->sort(''); ?>
<?php echo $this->Paginator->sort(''); ?></th>
<th><?php echo $this->Paginator->sort('Phone'); ?></th>
<th><?php echo $this->Paginator->sort('Email'); ?></th>
<th><?php echo $this->Paginator->sort('Fax'); ?></th>
<th><?php echo $this->Paginator->sort('Website'); ?></th>
<th><?php echo $this->Paginator->sort('Description'); ?></th>
<th><?php echo $this->Paginator->sort('License Number'); ?></th>
<th class="actions"><?php echo __(''); ?></th>
</tr>
<?php foreach ($companies as $company): ?>
<tr>
<td><?php echo h($company['Company']['id']); ?> </td>
<td><?php echo h($company['Company']['company_name']); ?> </td>
<td><?php echo h($company['Company']['ABN']); ?> </td>
<td><?php echo h($company['CompaniesBillingAddress']['company_street_address']); ?>
<?php echo h($company['CompaniesBillingAddress']['company_suburb']); ?>
<?php echo h($company['CompaniesBillingAddress']['company_state']); ?>
<?php echo h($company['CompaniesBillingAddress']['company_postcode']); ?> </td>
<td><?php echo h($company['Company']['company_street_address']); ?>
<?php echo h($company['Company']['company_suburb']); ?>
<?php echo h($company['Company']['company_state']); ?>
<?php echo h($company['Company']['company_postcode']); ?> </td>
<td><?php echo h($company['Company']['company_phone']); ?> </td>
<td><?php echo h($company['Company']['company_email']); ?> </td>
<td><?php echo h($company['Company']['company_fax']); ?> </td>
<td><?php echo h($company['Company']['company_website']); ?> </td>
<td><?php echo h($company['Company']['company_description']); ?> </td>
<td><?php echo h($company['Company']['license_number']); ?> </td>
<td class="actions">
<?php echo $this->Html->link(__('View'), array('action' => 'view', $company['Company']['id'])); ?>
</td>
</tr>
<?php endforeach; ?>
</table>companiesController：
公共数组= $components (‘分页器’)；
public function index() {
$this->Company->recursive = 0;
$this->set('companies', $this->Paginator->paginate());
}//一些代码}
companiesBillingAddressController
public $components = array('Paginator');
public function index() {
$this->CompaniesBillingAddress->recursive = 0;
$this->set('companiesBillingAddresses', $this->Paginator->paginate());
}}CompaniesBillingAddress表属于公司表。我希望companiesBillingAddress表中的数据显示在companies/index.ctp中。我一直收到一个错误，说“未定义的索引: CompaniesBillingAddress [APP\View\Companies\index.ctp，第36行”。有人能帮帮我吗？
回答 1
Stack Overflow用户
发布于 2014-05-09 16:57:52
$this->Company->recursive = 1;在您的companiesController中应该可以完成这项工作。在像“未定义索引”这样的情况下，在视图中调试数组是一种很好的方法。如果你没有找到你想要的数据，看看你的控制器。在这种情况下，错误是您禁用的递归。
此外，我不建议使用递归，而是使用containable behaviour。因此，将递归设置为0实际上是一个很好的方法。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/23557866
复制相关文章
相似问题
腾讯云开发者
