Codeigniter: Simple echo of data from DB

Question

What is the best way to create my model so I can call it from my controller like this?

$this->model_model->function->dbname

I have the following model but its rubbish:

Model:

function systemName()
{

    $query = $this->db->query("SELECT cms_name FROM options");

    return $query->result();
}

Update:

function systemOptions($options)
{   
    $this->db->select($options);

    $query = $this->db->get('options');

    return $query->num_rows();
}

wallyk · Accepted Answer · 2012-06-12 04:40:22Z

2

Why would you want to? Why not call it like this?:

 $this->model_model->functionname('dbname');

A complete skeleton of a model is like this:

<?php
class Mymodel extends Model
{
    function get_some_entries($number_rows)
    {
            return $result = $this -> db -> query("SELECT id, name
                                            FROM tablename
                                            LIMIT $number_rows");
    }
}
?>

edited Jun 12, 2012 at 4:40

answered Jun 12, 2012 at 4:29

wallyk

58.1k17 gold badges92 silver badges155 bronze badges

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

3 Comments

Jess McKenzie Over a year ago

Thats better but I just get Array in my view.

wallyk Over a year ago

@JessMcKenzie: I updated it with a skeleton. Adapt as needed.

Jess McKenzie Over a year ago

I have updated my question but it just seems to give me the id why?

Jasonw · Accepted Answer · 2012-06-14 02:36:44Z

Best way? You can probably read on CodeIgniter general guide and alter to your situation. But the basic idea is that, you create the model class then load from your controller. Then just call the model function accordingly. For example,

class Custom_model extends CI_Model {


function __construct()
{
    parent::__construct();
}

function systemName()
{

    $query = $this->db->query("SELECT cms_name FROM options");
    return $query->result();
}

...
...

function systemOptions($options)
{   
    $this->db->select($options);

    $query = $this->db->get('options');

    return $query->num_rows();
}


}

<?php
class CustomController extends CI_Controller {

public function __construct()
{
    parent::__construct();       
    $this->load->model('custom_model', 'fubar');
}

public function index()
{
    $result = $this->fubar->systemName('dbname'); 
    print_r ($result);
}

}
?>

Collectives™ on Stack Overflow

Codeigniter: Simple echo of data from DB

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related