PHP Codeigniter error: call to undefined method ci_db_mysql_driver::result()

Question

I was trying to create an xml response using CodeIgniter. The following error gets thrown when I run the code.

This page contains the following errors:

error on line 1 at column 48: Extra content at the end of the document

Also:

Call to undefined method ci_db_mysql_driver::result()

<?php  
class Api extends CI_Controller{  
    
    function index()  
    {
        $this->load->helper('url', 'xml', 'security');
        echo '<em>oops! no parameters selected.</em>';
        
    }
    
    function authorize($email = 'blank', $password = 'blank')
    {
        header ("content-type: text/xml");
        echo '<?xml version="1.0" encoding="ISO-8859-1"?>';
        echo '<node>';
        
        if ($email == 'blank' AND $password == 'blank')
        {
                echo '<response>failed</response>';
        } 
        else 
        {
            $this->db->where('email_id', $email);
            $this->db->limit(1);
            $query = $this->db->from('lp_user_master');
            $this->get();
            $count = $this->db->count_all_results();
            
            if ($count > 0)
            {
                foreach ($query->result() as $row){
                    echo '<ip>'.$row->title.'</ip>';
                }
            }
        }
        echo '</node>';
    }
}
?>

Can you show the end result that is being parsed?

Pekka
– Pekka

2011-11-22 09:40:36 +00:00
Commented Nov 22, 2011 at 9:40 — Pekka
– Pekka, Commented Nov 22, 2011 at 9:40

always-a-learner · Accepted Answer · 2017-08-23 12:39:59Z

14

Your code here is wrong:

$this->db->where('email_id', $email);
$this->db->limit(1);
$query = $this->db->from('lp_user_master');
$this->get();

Should be, instead:

$this->db->where('email_id', $email);
$this->db->from('lp_user_master'); 
$this->db->limit(1);
$query = $this->db->get();

Now you can call $query->result(), because the result resource is there after you actually get the table results

edited Aug 23, 2017 at 12:39

always-a-learner

3,81410 gold badges48 silver badges89 bronze badges

answered Nov 22, 2011 at 9:49

Damien Pirsy

25.5k8 gold badges72 silver badges77 bronze badges

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

Comments

mickmackusa · Accepted Answer · 2025-11-25 09:37:19Z

The controller is not the layer where database interactions should take place; that's a job for the model layer.

You seem to be trying to select a single value from the first row of the query result; this is most elegantly achieved with row(). Assuming title is a non-nullable column, you don't need to count the rows; if the value returned from row() is null then you know there is no qualifying row.

get() executes the query built upto that point, then it reset the entire query builder cache. When you call count_all_results(), you have no FROM clause, only the SELECT clause that the method provides.

Controller

public function authorize(string $email = 'blank', string $password = 'blank')
{
    header ("content-type: text/xml");
    echo '<?xml version="1.0" encoding="ISO-8859-1"?>';
    echo '<node>';
        if ($email === 'blank' && $password === 'blank') {
            echo '<response>failed</response>';
        } else {
            $this->load->model('User_model', 'UserModel');
            $title = $this->UserModel->getUserTitle($email);
            printf('<ip>%s</ip>', $title ?? 'failed');
        }
    echo '</node>';
}

Model

public function getUserTitle(string $email): ?string
{
     return $this->db
         ->get_where('lp_user_master', ['email_id' => $email], 1)
         ->row('title');
}

Collectives™ on Stack Overflow

PHP Codeigniter error: call to undefined method ci_db_mysql_driver::result()

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related