Use variables in Model

Question

Use variables in Model

Navigation

#1 by (1 votes)
#2 by (0 votes)
#3 by (0 votes)

0

Well, I have the following function in my Model:

public function get_learning_category_list() {
     $categorias = $this->db->select('t1.id, t1.title, t1.metadata, t1.meta_title, t1.description, t1.meta_description, t1.meta_spam, t1.url, t1.alt_img')
        ->from('learning_category t1')
        ->join('learning_rel_category t4', 't1.id = t4.category_id', 'left')
        ->join('learning t2', 't4.learning_id = t2.id', 'left')
        ->join('learning_rel_language t3', 't2.id = t3.learning_id', 'left')
        ->where('t3.language', $this->language)
        ->group_by('t1.id')
        ->get()->result_array();
    foreach($categorias as $c){
        $total = $this->db->select('count(learning_rel_language.learning_id) as total', false)
        ->from('learning')
        ->join('learning_rel_language', 'learning.id = learning_rel_language.learning_id', 'inner')
        ->join('learning_rel_category', 'learning.id = learning_rel_category.learning_id', 'inner')
        ->where('learning_rel_category.category_id', $c['id'])
        ->where('learning_rel_language.language', $this->language)
        ->group_by('learning_rel_language.language')->get()->first_row('array');

        $metadata = json_decode($c['metadata']);
        $tt = $c['title'];
        $url = $c['url'];
        if($this->language != 'pt_br'){
            $tt = $metadata->{$this->language};
            $tt_pt_br = $c['title'];
        }

        $return[] = array('url' => $url, 'title'=>$tt, 'id'=>$c['id'], 'total'=>$total['total'], 'title_pt_br'=>$tt_pt_br);

    }

    return $return; //$categorias;
}

Giving a print_r($this->learn->get_learning_category_list()); results in this value:

Array ( [0] => Array ( [url] => [title] => Cursos sobre como gerar leads qualificados [id] => 2 [total] => 6 [title_pt_br] => )

Beauty? But I need to use (in the same Model) these values, url title and etc. How can I do this?

Being more specific, I need to use here:

$category_format = (Aqui url title, ou seja : Cursos sobre como gerar leads qualificados ).'-cmdo-'.(Aqui o id, ou seja :2); .

php codeigniter

asked by anonymous 06.04.2015 / 15:36

3 answers

0

If your return is returning the values of the function you can use the same inside the view and give a print_r to see which values are returned inside the view, otherwise create a variable to store the return of the function and load the view passing same as $this->load->view('nome_view', $dados_funcao)

06.04.2015 / 15:45

0

It's not clear to me what the purpose of storing the return of this function back in your Model is.

However you can do this by creating a property in your Model class to store the data you are going to use.

<?php

class Meu_Model {

    protected $learning_category_list;

    // ...

    public function get_learning_category_list() {

         // ...

        $this->learning_category_list = $return;            

        return $return;
    }
}

So after running $this->learn->get_learning_category_list() , within your class you can use $this->learning_category_list .

Again, if you tell us more in detail why you want to do this in this way, make it clearer to suggest a better solution.

06.04.2015 / 15:54

Android sqlite - Return _id logged ListView only a value selected using Where condition Error configuring Doctrine + Zend

score 1 · Accepted Answer

I solved using:

 $categorias = $this->learn->get_learning_category_list();
    foreach($categorias as $cat){
        $cat = (object) $cat;
 if($cat->title != '') {
            $return = strtolower(url_title($cat->title)).'-cmdo-'.$cat->id;
        }else{
            $return = 'cursos-de-marketing-digital-online-'.$cat->id;
        }   
    return $return;