Delete mysql records is not working in codeIgniter

Question

This is my controller function:

function delete_article($title){

    if ($this->session->userdata('User') && $this->session->userdata('User') == '[email protected]') {

        $this->load->model('Article', 'Article', TRUE);
        $this->Article->delete_article_db($title);

        redirect('admin/user_article');
    } else {
        redirect('');
    }
}

And this is my model function for deleting the database record:

 function delete_article_db($title) {
    $this->db->where('Title', $title);
    $this->db->delete('article');
}

When I run this code, nothing gets deleted. However, the code does not fire any errors or warnings.

This is my MySQL table structure:

CREATE TABLE IF NOT EXISTS `article` (
   `Name` text NOT NULL,
   `Email` text NOT NULL,
   `Phone` text NOT NULL,
   `Address` text NOT NULL,
   `Literature` text NOT NULL,
   `Title` text NOT NULL,
   `Submission_Name` text NOT NULL,
   `Additional_Name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

did you check that there's an article with this title? Did you check server logs? — Sal00m
– Sal00m, Commented Nov 26, 2013 at 17:52
Does it work with $this->db->delete('article', array('Title' => $title)); ? — user2629998
– user2629998, Commented Nov 26, 2013 at 17:53

Damien Pirsy · Accepted Answer · 2013-11-26 18:05:27Z

3

A bit of a wild guess, but looking at your controller method, and the variable names, I'm assuming you're passing the title via url, something like

http://example.com/admin/delete/Title to be deleted

Which leads me to think your query is not working because of encoding of the spaces in the url (or other characters) which won't match the not encoded spaces in your db.

Try with:

function delete_article_db($title) {
    $this->db->where('Title', rawurldecode($title) );
    $this->db->delete('article');
}

answered Nov 26, 2013 at 18:05

Damien Pirsy

25.5k8 gold badges72 silver badges77 bronze badges

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

2 Comments

Mohammed Sufian Over a year ago

PERFECT WORKS.. FOR ME NOW.. THANK YOU VERY MUCH SIR.. I AM SOLVING THIS FROM LAST 2 HOURS THANK YOU AGAIN SIR.. :)

Damien Pirsy Over a year ago

Glad it worked! :) As an advice: always var_dump() a variable when you're not sure about its content (like in where clause)

Collectives™ on Stack Overflow

Delete mysql records is not working in codeIgniter

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related