Cakephp MySql Query with WHERE

Question

I have work function:

public function index()
    {
        $this->set('tables', $this->Table->find('all'));
    }

But how show only column WHERE owner = logged user?

How do you know if user is logged in? How do you authenticate user? — Michel
– Michel, Commented Jun 10, 2015 at 13:17
public $components = array( 'Session', 'Auth' => array( 'loginRedirect' => array( 'controller' => 'tables', 'action' => 'index' ), 'logoutRedirect' => array( 'controller' => 'tables', 'action' => 'index' ), 'authenticate' => array( 'Form' => array( 'passwordHasher' => 'Blowfish' ) ) ) ); — andrzej
– andrzej, Commented Jun 10, 2015 at 13:21
public function isAuthorized($user) { // Admin can access every action if (isset($user['role']) && $user['role'] === 'admin') { return true; } // Default deny return false; } — andrzej
– andrzej, Commented Jun 10, 2015 at 13:21
Then @drmonkeyninja answer should be correct. Have you tried it? — Michel
– Michel, Commented Jun 10, 2015 at 13:26

drmonkeyninja · Accepted Answer · 2015-06-10 16:38:29Z

1

You want to do something like this where $this->Session->read() returns the current authenticated user:-

$this->Table->find(
    'all',
    array(
        'conditions' => array('Table.user_id' => $this->Session->read("Auth.User.id"))
    )
);

answered Jun 10, 2015 at 13:06

drmonkeyninja

8,5404 gold badges35 silver badges59 bronze badges

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

4 Comments

Parse error: syntax error, unexpected T_DOUBLE_ARROW

Sorry, typo. Fixed the answer. Forgot to include array after the conditions index.

Undefined variable: tables and Invalid argument supplied for foreach()

You shouldnt use (deprecated) static access, better $this->Session->read().