Php fetch data from two tables

Question

I have to edit a form where it contains datas form two tables. one is master and another user. first the data is saved in user table and with that id the remaining datas get saved in master table. Below is my edit code.What should i do to fetch the data and edit it.

     public function edit() {
    $id = $this->request->params['pass'][0];
    $this->Master->id = $id;
    if( $this->Master->exists()){
        if( $this->request->is( 'post' ) || $this->request->is( 'put' ) ){
            if( $this->Master->save( $this->request->data ) ){
                $this->redirect(array('action' => 'index'));
            }
            else { 
                $this->Session->setFlash('Unable to edit row. Please, try again');
            } 
        }
        else { 
          $this->request->data = $this->Master->read();
        }
    } 
}

Could somebody help pls..

why you fetching the data. With user table id you can edit user fields. match user id and user_id in master table. if same then get master table id and edit master fields. This is what i understood. if i am wrong pls explain more your question. — Monty Khanna
– Monty Khanna, Commented Jan 12, 2016 at 5:35
If you got your answer what you need then i am posting my command in answer. pls confirm me — Monty Khanna
– Monty Khanna, Commented Jan 12, 2016 at 5:38

arilia · Accepted Answer · 2016-01-12 10:06:55Z

1

Update your code by :

$this->request->data = $this->Master->read(null, $id);

$this->set('masterArr',$this->Master->find('all',array('conditions' =>
array('Master.id ' => $id))));

edited Jan 12, 2016 at 10:06

arilia

9,3982 gold badges24 silver badges47 bronze badges

answered Jan 12, 2016 at 5:52

Monty Khanna

1,1207 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Php fetch data from two tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related