Fatal error: Call to a member function result_array() on null in line

Question

I am getting fatal error any one can help me what is wrong with code.? please help.

public function index(){


                $t_name = $this->input->post('t_name');
                $row_id = $this->input->post('change_id');

                if($t_name == ''){
                    $t_name = 'table1';                 
                }
                if($row_id == '')
                {
                    $row_id = 1;
                    //Setup a database connection returning a single row value
                    $this->db->select("*");
                    $this->db->where("Q_Id", $row_id);
                    $query = $this->db->get('table1',1,0);

                    if($query->num_rows() > 0) {
                        $variable = $query->row("Q_Id");
                        $qu['res'] = $variable;

                    } else {

                    }
                }

                $this->load->view('admin/question_paper_alter' , $qu);
            }

view code. I want to print my row in this table field. any one can help me.

<?php foreach($res->result_array() as $row):?>
<tr>
    <td><?php echo $row['rrid']?></td>
                    <td><?php echo $row['name']?></td>
                </tr>
                <?php endforeach; ?>

what is $res? or do you mean $qu['res']->result_array()? — bansi
– bansi, Commented Mar 22, 2017 at 11:03
@bansi yes $res comes from controller $qu['res'] I am new to codeiniter so help me. — Mahi
– Mahi, Commented Mar 22, 2017 at 11:05
Have you tried this stackoverflow.com/questions/18347028/… — lazyme114
– lazyme114, Commented Mar 22, 2017 at 11:07
looks like you need $qu['res'] = $query;. I may be wrong (never worked with codeigniter) — bansi
– bansi, Commented Mar 22, 2017 at 11:12

webpic · Accepted Answer · 2017-03-22 11:17:16Z

1

write result_array(); in query itself.

$data= $this->db->get()->result_array();
$i=0;
foreach ($data as $row);
{
       echo $row[$i]->title;
       echo $row[$i]->name;
       $i++;
}

result_array returns result with array with stdobject

edited Mar 22, 2017 at 11:17

answered Mar 22, 2017 at 11:10

webpic

4431 gold badge10 silver badges23 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:17:18Z

0

Check https://www.codeigniter.com/userguide3/database/results.html

result_array() is a method of $query

$query = $this->db->query("YOUR QUERY");

foreach ($query->result_array() as $row)
{
        echo $row['title'];
        echo $row['name'];
        echo $row['body'];
}

try do something like Codeigniter result_array() returning one row

edited May 23, 2017 at 12:17

CommunityBot

11 silver badge

answered Mar 22, 2017 at 11:05

Maciej__

1491 silver badge7 bronze badges

3 Comments

Mahi Over a year ago

I do this same but not working. my $query is $res comes from controller.

Maciej__ Over a year ago

try $qu['res'] = $query;

Mahi Over a year ago

It give me error Parse error: syntax error, unexpected '=' when I try to use $qu['res']

Collectives™ on Stack Overflow

Fatal error: Call to a member function result_array() on null in line

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related