Codeigniter foreign key constraint check

Question

Let me first explain the table structure:

+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| id        | int(11)      | NO   | PRI | NULL    | auto_increment |
| firstname | varchar(255) | NO   |     | NULL    |                |
| name      | varchar(255) | NO   |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+

The id field is referenced from another table through a foreign key.

Say I have a function in my model like this:

public function delete_user($id) {
    return $this->db->delete('users', array('id' => $id));
}

When this user is referenced from the other table, it should throw an error. The "bad" thing is, that Codeigniter actually shows that error on a full page:

Error Number: 1451

Cannot delete or update a parent row: a foreign key constraint fails (`testing`.`users_link`, CONSTRAINT `users_link_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`))

DELETE FROM `users` WHERE `id` = '1'

Is there a way to make the delete_user function return FALSE instead of showing the error? I'd like to notify the user that they have to do something else first. I tried using transactions and returning the transaction_status, but that still throws the error.

Found the answer myself: $db['default']['db_debug'] = FALSE; and the errors are not displayed anymore so I can show my custom error messages :) — EsTeGe
– EsTeGe, Commented May 5, 2012 at 15:49

Kishan · Accepted Answer · 2019-07-03 08:43:24Z

8

in config folder database.php file find the line

$db['default']['db_debug']

and set it to FALSE. This will prevent Codeigniter from printing the error on the screen.

Also in the delete function you can check:

if ($this->db->_error_number() == 1451)

If you need to do something special when this happens.

edited Jul 3, 2019 at 8:43

Kishan

1,21014 silver badges26 bronze badges

answered May 6, 2012 at 9:17

Dan F.

1,37316 silver badges23 bronze badges

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

2 Comments

CodeGodie Over a year ago

Remeber that in Codeigniter 3.0 (CI3), this is now $errors = $this->db->error();

Matt Swanson Over a year ago

If you're looking for the $db['default']['db_debug'] line, it is located in /application/config/database.php if using default environment.

Mohsin Mujawar · Accepted Answer · 2019-09-07 13:51:17Z

0

I use it in this way Codeigniter 3.0

Model

/*
 * function to delete user
 */
function delete_user($id)
{
            if ( ! $this->db->delete('users', array('id' => $id)))
            {
                            return $this->db->error();
            }
    return FALSE;
}

Controller

$fk_check = $this->User_model->delete_user($id);

if($fk_check) {
// Unable to delete record
// $fk_check is an array containing $fk_check['code'] & $fk_check['message']
exit();
}

// Here your record has been deleted

answered Sep 7, 2019 at 13:51

Mohsin Mujawar

1641 silver badge7 bronze badges

Collectives™ on Stack Overflow

Codeigniter foreign key constraint check

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related