Query from model to Controller

Question

I'm learning the whole MVC type of programming. I have a MySQl Query inside a model like so:

<?php
class BlogModel extends BaseModel { 

    public static function dbBlog() {
        $db         = new Database(true);
        $entries    = $db->matrix('cms_m1_blog_ml');
        $this->set('data_blog', $entries);
    }
}

This script worked when I had it in the controller. the view looks like this:

<?php

foreach($data_blog as $blog)
 { 
     echo "<ul>"; 
     echo "<li class='name'>Name:".$blog['title'] . "</li>"; 
     echo "<li class='content'>Content:".$blog['content'] . "</li>";
     echo "</ul>"; 
 }

How do I pass the data from the model to the controller? I ave tried all sorts of things but nothing was in the right direction. I use a custom framework build by my employee but it is based on CakePHP.

If you aim to lean MVC from CakePHP, then you are simply doing it wrong. — tereško, May 06 '13 at 13:36
[Read this](http://stackoverflow.com/a/16356866/727208). I already answered that same question few days ago. — tereško, May 06 '13 at 14:01

score 0 · Answer 1 · answered May 06 '13 at 13:16

0

Use something like this

$this->set('data_blog', BlogModel::dbBlog());

answered May 06 '13 at 13:16

Nisanth Kumar

5,667
8
33
43

Stefano Sanfilippo · Answer 2 · 2013-05-06T13:23:45.920

Give the controller a reference to the model. If the model is a static class, simply add a static variable to the controller class, else pass the correct model object as a parameter to the class constructor and store it in a property of the object. Like this:

class BlogModel extends BaseModel { 
    private $db;
    private $entries;

    public static function dbBlog() {
        $db         = new Database(true);
        $entries    = $db->matrix('cms_m1_blog_ml');
    }

    // Add getters here 
}

class BlogController {
    // Get mymodel somehow and store it

    public function doStuff() {
         $this->mymodel.getDB();
    }
}

score 0 · Answer 3 · answered May 06 '13 at 14:10

0

Found the anwser :)

Controller:

    public function blog(){
        $this->set('data_blog', BlogModel::dbBlog());
    }

    public function index() {
    }
}

Model:

    public static function dbBlog() {
        $db         = new Database(true);
        $entries    = $db->matrix('cms_m1_blog_ml');
        return $entries;
    }
}

So the problem was in the model, I just needed to return the entries and use the set in the controller.

answered May 06 '13 at 14:10

Aduro

47
2
7

Are you sure you're using CakePHP? This really doesn't look like CakePHP at all? – thaJeztah May 06 '13 at 21:03

Query from model to Controller

3 Answers3