cakephp how to specify home and away team names in index.ctp and relationship in models

34 views Asked by At

Match and team has many to many relationship but it does not work if i put the associations. and how to get home and away team names from the team table instead of home_id and team_id. please help

MatchesController.php

class MatchesController extends AppController
{
    public $uses = array('Match','Team');
    public function index()
    {
        $matches=$this->Match->find("all");
        $this->set("matches",$matches);
    }

    public function add() 
    {
        if ($this->request->is('post')) 
        {
            $this->Match->create();
            if ($this->Match->save($this->request->data)) 
            {
                $this->Flash->success(__('Match Has Been Added'));
                return $this->redirect(array('action' => 'index'));
            }
            $this->Flash->error(__('Something Went Wrong.'));
        }
        $teams = $this->Team->find('list');
        $this->set('teams',$teams);
    }

index.ctp

<?php foreach($matches as $match) { ?>
    <tr>
        <td><?php echo $match['Match']['id']; ?></td>
        <td><?php echo $match['Match']['home_id']; ?></td>
        <td><?php echo $match['Match']['away_id']; ?></td>
        <td><?php echo $match['Match']['date']; ?></td>
        <!--    <td><?php// echo $match['Match']['time']; ?></td> -->
        <td><?php echo $match['Match']['location']; ?></td>
        <!--    <td><?php //echo $match['Match']['winner_id']; ?></td> -->
        <!--    <td><?php //echo $match['Match']['winner_id']; ?></td> -->
        <!--        <td><?php //echo $match['Match']['home_goals']; ?></td> -->
        <!--    <td><?php //echo $match['Match']['away_goals']; ?></td>-->
        <!--    <td><?php //echo $match['Match']['type']; ?></td> -->
        <td>
        <?php
        echo $this->Html->link('View', array('action'=>'view',$match['Match']['id']), array('class'=>'btn btn-primary'));
        echo $this->Html->link('Edit', array('action'=>'edit',$match['Match']['id']), array('class'=>'btn btn-success'));
        echo $this->Form->postLink('Delete', array('action'=>'delete',$match['Match']['id']),array('confirm'=>'Are You sure you want to delete Student', 'class'=>'btn btn-danger'));?>
        </td>
    </tr>
<?php } ?>

Match model

class Match extends AppModel {
}

Team Model

class Team extends AppModel {
}
0

There are 0 answers