Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I have two models "Ficha" and "Perigo":

class Ficha extends AppModel {

    var $primaryKey = 'id_ficha';

    public $validate = array(
        'nome_produto' => array(
            'rule' => 'notEmpty'
        ),
        'versao' => array(
            'rule' => 'notEmpty'
        ),
        'data_ficha' => array(
            'rule' => 'notEmpty'
        )
    );
}


    class Perigo extends AppModel {


    var $belongsTo = array(
        'Ficha' => array(
            'className'    => 'Ficha',
            'foreignKey'   => 'id_fichas'
        )
    );
}

As you can see they are "linked". Now, in the code i have a form for Ficha that the method "add()" of FichasController redirects to my Perigo Model:

add() (of FichaController)

    public function add() {
//pr($this->request->data); // to get the data from the form

    if ($this->request->is('post')) {
        $this->Ficha->create();
        if ($this->Ficha->save($this->request->data)) {
            $this->Session->setFlash('Your post has been saved.');
            //$last_id=$this->Ficha->getLastInsertID();
            //$this->redirect(array('action' => 'preencher_ficha'),$last_id);
            $this->redirect(array('controller'=>'perigos', 'action' => 'add'),$last_id);
        } else {
            $this->Session->setFlash('Unable to add your post.');
        }

    }
}

The redirection is made to a form that exists in PerigosController.

add.ctp (of Perigo)

echo $this->Form->create('Perigo');
echo $this->Form->input('class_subst', array('label' => 'Classificação da substância ou mistura:'));
echo $this->Form->input('simbolos_perigo', array('label' => 'Símbolos de Perigo:'));
echo $this->Form->input('frases_r', array('label' => 'Frases R:'));
echo $this->Form->end('Avançar');

add() (of PerigoController)

    public function add() {

    if ($this->request->is('post')) {
        $this->Perigo->create();
        if ($this->Perigo->save($this->request->data)) {
            $this->Session->setFlash('Your post has been saved.');
            $this->redirect(array('controller'=>'perigos', 'action' => 'index'));
        } else {
            $this->Session->setFlash('Unable to add your post.');
        }

    }
}

but there's something i don't know how to do it. Since the models are relational, and the same happens with the two tables on the database (the table perigos has a foreignkey that is the primary key of the table "fichas", how can i insert the data on table perigos in database? I mean, how can i get the key of the Ficha inserted in the first form and insert her in the foreign key of "perigos" when i submit this second form?

share|improve this question
your redirect link is wrong - the ID is not a second param but part of the array (or should be!). also dont mix "public" and "var". – mark Dec 11 '12 at 11:48
@mark thank you for the reply. but then, how should i pass it? 'foreignKey'=>'$last_id' in the array? – user1511579 Dec 11 '12 at 11:52
1  
$this->redirect(array('controller'=>'perigos', 'action' => 'add', $last_id)); – mark Dec 11 '12 at 11:57
not working mark. I did as you told me, but then, in the PerigosController when i try a pr($last_id) to see if is receving the var correctly, it gives me "undefined variable". – user1511579 Dec 11 '12 at 12:03

1 Answer

up vote 1 down vote accepted

As @mark says, your redirection is bad, it should include the id in the URL array:

$this->redirect(array('controller'=>'perigos', 'action' => 'add', $last_id));

Like this you are passing the parameter by URL. In the add action of your PerigosController you should have an $idFicha param at the method:

//PerigosController.php
public function add($idFicha){
    //here you can use $idFicha
    ...

    //when submiting the Perigos form, we add the foreign key.
    if($this->request->is('post')){

        //adding the foreign key to the Perigo's array to add in the DB.
        $this->request->data['Perigo']['ficha_id'] = $idFicha;

        if ($this->Ticket->save($this->request->data)) {
          //...
        }
    }
}

Data submitted by POST method in a form will be always contained in an array of this type: $this->request->data['Model_name']. In your case:

$this->request->data['Perigo']

Another way to do this, is using sessions if you prefer to hide the id value: http://book.cakephp.org/2.0/en/core-libraries/components/sessions.html#sessions

share|improve this answer
Working!! The redirection is like you said and it's already inserting correctly on db. Thanks a lot Steve! – user1511579 Dec 11 '12 at 12:13
Your wellcome. De nada :) – Alvaro Dec 11 '12 at 12:17
Ahah, you know portuguese? – user1511579 Dec 11 '12 at 12:20
Nah, Spanish :) – Alvaro Dec 11 '12 at 12:25
Ahahah, cool :P – user1511579 Dec 11 '12 at 12:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.