{"id":816,"date":"2022-08-30T15:07:39","date_gmt":"2022-08-30T15:07:39","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/09\/php-codeigniter-error-call-to-undefined-method-ci_db_mysql_driverresult-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:07:39","modified_gmt":"2022-08-30T15:07:39","slug":"php-codeigniter-error-call-to-undefined-method-ci_db_mysql_driverresult-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/php-codeigniter-error-call-to-undefined-method-ci_db_mysql_driverresult-collection-of-common-programming-errors\/","title":{"rendered":"PHP Codeigniter error: call to undefined method ci_db_mysql_driver::result()-Collection of common programming errors"},"content":{"rendered":"

I was trying to create an xml response using codeigniter. The following error gets thrown when i run the code.<\/p>\n

This page contains the following errors:<\/em><\/p>\n

 0)\n            {\n                foreach ($query->result() as $row){\n                    echo ''.$row->title.'';\n                }\n            }\n        }\n        echo '';\n    }\n}\n?>\n<\/code><\/pre>\n
    \n
  1. \n
    Your code here is wrong:<\/p>\n
      $this->db->where('email_id', $email);\n            $this->db->limit(1);\n            $query = $this->db->from('lp_user_master');\n            $this->get();\n<\/code><\/pre>\n
    Should be, instead:<\/p>\n
      $this->db->where('email_id', $email);\n  $this->db->from('lp_user_master'); \n  $this->db->limit(1);\n  $query = $this->db->get();\n<\/code><\/pre>\n
    Now you can call $query->result()<\/code>, because the result resource is there after you actually get the table results<\/p>\n<\/li>\n<\/ol>\n
    Originally posted 2013-11-09 22:47:14. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    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: 0) { foreach ($query->result() as $row){ echo ”.$row->title.”; } } } echo ”; } } ?> 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-816","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=816"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/816\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}