CodeIgniter SQL query error handling

Question

At this moment i access my posts like this

http://localhost/post/174565/

and everything works fine, but when i am trying to access them like this

http://localhost/post/1745s65/

i am getting error

Error Number: 1054
Unknown column '1745s65' in 'where clause'
SELECT * FROM posts WHERE id = 1745s65;
Filename: D:\Localhost\Apache\htdocs\code\system\database\DB_driver.php
Line Number: 330

i understand why it is there, but how to handle it? For example my users don't need to see SQL query, and i want to show them 404 page instead of this block.

for what you need it? post is not about debuging sql query, but handling errors :) — Littlebobbydroptables
– Littlebobbydroptables, Commented Mar 30, 2013 at 23:42
to see the way that you parse the query. Normally, if you used active record correctly you should not see the above error. — Vassilis Barzokas
– Vassilis Barzokas, Commented Mar 30, 2013 at 23:43

Filippo oretti · Accepted Answer · 2013-03-31 01:38:19Z

2

use execptions:

try{
       //here what you need to do with script
         } catch (Exception $e) {
            var_dump($e->getMessage());
            show_404();
              }

i think you can try also to put :

$database['db_debug'] = FALSE; in config/database.php if you want to remove database errors from being shown

answered Mar 31, 2013 at 1:38

Filippo oretti

50k96 gold badges230 silver badges351 bronze badges

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

Comments

lighter · Accepted Answer · 2015-06-30 03:34:47Z

1

Try this code:

public function getPostData($iPostId) {
    $sqlQuery = $this->db->get_where('posts', array('id' => $iPostId));
    $aResult = $sqlQuery->result();

    if (empty($aResult)) {
        show_404();
    }
    else {
        return $aResult[0];
    }
}

edited Jun 30, 2015 at 3:34

lighter

2,8243 gold badges43 silver badges61 bronze badges

answered Mar 30, 2013 at 23:52

Vassilis Barzokas

3,2822 gold badges29 silver badges42 bronze badges

1 Comment

Littlebobbydroptables Over a year ago

Magic method! Works just perfectly.

enapupe · Accepted Answer · 2013-03-30 23:23:53Z

0

You need to validate user input to prevent this issues. Anyhow, Codeigniter has two preset environments: development and prodution. Check your root index.php for more information.

answered Mar 30, 2013 at 23:23

enapupe

17.2k3 gold badges34 silver badges45 bronze badges

1 Comment

Littlebobbydroptables Over a year ago

I thought about checking is_numeric and if SQL result !empty, thought there are some built-in functions :) Production environment changes nothing in this situation

Collectives™ on Stack Overflow

CodeIgniter SQL query error handling

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related