Skip to content

Instantly share code, notes, and snippets.

@cpierce
Created January 12, 2015 15:15
Show Gist options
  • Save cpierce/e413a7e097d35c716b56 to your computer and use it in GitHub Desktop.
Save cpierce/e413a7e097d35c716b56 to your computer and use it in GitHub Desktop.
<?php
/* Model/Sponsor.php */
class Sponsor extends AppModel {
public $name = 'Sponsor';
public $useTable = 'Sponsors';
public $displayField = 'Sponsor';
public $primaryKey = 'SponsorID';
public $hasMany = array(
'SponsorDivision' => array(
'className' => 'SponsorDivision',
'foreignKey' => 'SponsorID',
'dependent' => 'true',
)
);
}
/* Model/SponsorDivision.php */
class SponsorDivision extends AppModel {
public $useTable = 'SponsorDivision';
public $primaryKey = 'SponsorDivisionID';
public $belongsTo = array(
'Sponsors' => array(
'className' => 'Sponsor',
'foreignKey' => 'SponsorID',
)
);
}
/* Controller/SponsorDivisionsController.php */
class SponsorDivisionsController extends AppController {
public function index() {
$this->SponsorDivision->Behaviors->load('Containable');
$this->set('sponsordivisions', $this->SponsorDivision->find('all', array(
'contain' => array(
'Sponsor',
),
'order' => array(
'SponsorDivision.SponsorDivision' => 'asc'),
),
));
}
}
/* View/SponsorDivisions/index.ctp */
<h1>Sponsors Listing</h1>
<table class="table table-striped table-condensed">
<tr>
<th>Sponsor</th>
<th>Sponsor Division</th>
</tr>
<?php foreach ($sponsordivisions as $division): ?>
<tr>
<td><?php echo $division['Sponsor']['Sponsor']; ?></td>
<td><?php echo $division['SponsorDivision']['SponsorDivision']; ?></td>
</tr>
<?php endforeach; ?>
<?php unset($division); ?>
</table>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment