How to handle query errors in CodeIgniter3?

Question

I'm in the process of migrating a CI2 project to CI3.

One thing I am having difficulties with is handling errors on db queries. Could someone please tell me the correct way to do this? I cannot seem to find the answer in the docs or previous SO questions.

Basically, if the query results in a sql error, I want to return false. At the moment, it seems that error() returns an array and so is always returning true regardless of whether there is an error or not meaning my method always returns false.

function get_post()
{
    $post = //some db call to get a post

    if ( $this->db->error() )
    {
        return false;
    }
    else
    {
        return $post
    }
}

TimBrownlaw · Accepted Answer · 2017-06-30 11:42:55Z

2

Handling Errors

$this->db->error();

If you need to get the last error that has occurred, the error() method will return an array containing its code and message.

Here’s a quick example:

if ( ! $this->db->simple_query('SELECT `example_field` FROM `example_table`')) {
    $error = $this->db->error(); // Has keys 'code' and 'message'
}

1 : Changes in config/database.php

'db_debug' => FALSE,

2:

function get_post() {

    $post = //some db call to get a post

    $error = $this->db->error();

    if ( ! empty($error['code'])) {
        return FALSE;
    } else {
        return $post;
    }
}

edited Jun 30, 2017 at 11:42

TimBrownlaw

5,5373 gold badges27 silver badges29 bronze badges

answered Jun 30, 2017 at 11:27

Mukesh Kurmi

363 bronze badges

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

Collectives™ on Stack Overflow

How to handle query errors in CodeIgniter3?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related