How can I convert db query result to array

Question

original I thought the $query is array object, since I can print these data to a list table like this. my controller code

$data['dates'] = $this->calendar_model->get_cal_eventDate();
$this->load->library('table');
$this->load->view('my_test', $data);

my view code

echo $this->table->generate($dates);

but when I changed my code to try to print $tbDataArr via foreach. It didn't work. How can I convert the $query result (eventDate field values) to array object.

function get_cal_eventDate() {
    $this->db->select('eventDate');
        $query = $this->db->get('tb_event_calendar');
        return $query;
}

$tbDataArr = $this->calendar_model->get_cal_eventDate();

foreach ($tbDataArr as $key => $value) {
    echo "Key: $key; Value: $value<br />\n";
}

var_dump($tbDataArr) - what is your output ?

hsz
– hsz

2011-04-04 12:35:17 +00:00
Commented Apr 4, 2011 at 12:35 — hsz
– hsz, Commented Apr 4, 2011 at 12:35
What is the current format of result returned?

Shakti Singh
– Shakti Singh

2011-04-04 12:35:31 +00:00
Commented Apr 4, 2011 at 12:35 — Shakti Singh
– Shakti Singh, Commented Apr 4, 2011 at 12:35

Nick Pyett · Accepted Answer · 2011-04-04 12:38:26Z

9

Are you using CodeIgniter? If you are you can do this

function get_cal_eventDate() {
    $this->db->select('eventDate');
    $query = $this->db->get('tb_event_calendar');
    $result = $query->result_array();
    return $result;
}

If not need more info about what your doing with your PHP.

answered Apr 4, 2011 at 12:38

Nick Pyett

3,4181 gold badge26 silver badges27 bronze badges

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

Comments

Kunta Kinte · Accepted Answer · 2011-12-17 15:32:32Z

4

Codeigniter, right?

Use the $query->result_array() method.

see more here:
http://codeigniter.com/user_guide/database/results.html

edited Dec 17, 2011 at 15:32

user212218

answered Apr 4, 2011 at 12:39

Kunta Kinte

512 bronze badges

Comments

Rafael Lima · Accepted Answer · 2018-05-04 04:12:13Z

0

    //Convert $query->result_array() to $query->result() after add new field in array

    $result = $query->result_array();
    for($i=0;$i<$query->num_rows();$i++){
        //insert new field in array (test_field with value 1)
        $result[$i]+=array('test_field'=>1);
        $result[$i] = (object)$result[$i];
    }
    return $result; //equivalent to return $query->result() without new field;

answered May 4, 2018 at 4:12

Rafael Lima

1

Collectives™ on Stack Overflow

How can I convert db query result to array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related