cakephp read and display from more than one related table

Posted by z22 on Stack Overflow See other posts from Stack Overflow or by z22
Published on 2012-11-03T12:13:59Z Indexed on 2012/11/03 17:02 UTC
Read the original article Hit count: 252

I have 2 tables Users and Artists.

User:
id
name
password
city_id
state_id
country_id

Artist:
id
user_id
description

I wish to create add and edit form(single form acts as add and edit). But on click of edit link, I wish to fill in the form fields from user as well as artist table. How do i do that? Below is my controller code:

public function artist_register() {
        $this->country_list();
        if ($this->request->is('post')) {
            $this->request->data['User']['group_id'] = 2;
            if ($this->{$this->modelClass}->saveAll($this->request->data)) {
                $this->redirect(array('controller' => 'Users', 'action' => 'login'));
            }
        }
        $this->render('artist_update');
    }

    public function artist_update($id) {
        $artist = $this->{$this->modelClass}->findByuser_id($id);
        $artist_id = $artist[$this->modelClass]['id'];

        if($this->request->is('get')) {
            $this->request->data = $this->{$this->modelClass}->read(null, $artist_id);
            $this->request->data = $this->{$this->modelClass}->User->read(null, $id);
        } else {
            if($this->{$this->modelClass}->save($this->request->data)) {
                $this->Session->setFlash('Your Profile has been updated');
                $this->redirect(array('action' => 'index'));
            }
        }
    }

The code doesnt work. how do i solve it?

© Stack Overflow or respective owner

Related posts about php

Related posts about cakephp