how to delete a specific row in codeigniter

Question

I am new in codeigniter In my view page I am showing the data  from database in a table where I have two anchor tags for update and delete  I want to delete a specific row from database through id   my view page is    lt  php foreach  query as  row     gt    lt tr gt    lt td gt  lt  php echo  row- gt name    gt  lt  td gt     lt td gt  lt  php echo  row- gt testi    gt  lt  td gt     lt td gt  lt  php echo anchor  textarea delete row    DELETE    id   row- gt id       gt  lt  td gt     lt td gt  lt a href   ajax-modal2  data-id  delete    role  button  class  Delete  data-toggle  modal  onClick  confirm delete    gt  lt i class  icon-trash  gt  lt  i gt  lt  a gt  lt  td gt     lt  tr gt    lt  php     gt   lt  table gt    my controller page is  function delete row          this- gt load- gt model  mod1        this- gt mod1- gt row delete       redirect   SERVER  HTTP REFERER           and my model page is   function row delete               this- gt db- gt where  id    id          this- gt db- gt delete  testimonials           I want to delete the row by catching the respective id  Please dont be harsh  thank you

User · Answer

a simple way   in view pass the id value     lt td gt  lt  php echo anchor  textarea delete row id    row- gt id   DELETE    id   row- gt id       gt  lt  td gt    in controller receive the id     id    this- gt input- gt get  id     this- gt load- gt model  mod1     this- gt mod1- gt row delete  id     in model get the passed args    function row delete  id      Actually  you should use the ajax to POST the id value to controller and delete the row  not the GET

User · Answer

It will come in the url so you can get it by two ways  Fist one   lt td gt  lt  php echo anchor  textarea delete row    DELETE    id   row- gt id       gt  lt  td gt   id    this- gt input- gt get  id      2nd one    id    this- gt uri- gt segment 3     But in the second method you have to count the no  of segments in the url that on which no  your id come  2 3 4 etc  then you have to pass  then in the

User · Answer

multiple delete not working    function delete selection               id array   array             selection    this- gt input- gt post  selection   TRUE            id array   explode       selection            foreach   id array as  item               if   item                           DELETE ROW                  this- gt db- gt where  entry id    item                    this- gt db- gt delete  helpline entry                endif          endforeach

User · Answer

My controller     public function delete category       Created a controller class                          this- gt load- gt model  Managecat      Load model Managecat here            id  this- gt input- gt get  id            get the requested in a variable           sql del  this- gt Managecat- gt deleteRecord  id     send the parameter  id in Managecat  there I have created a function name deleteRecord           if  sql del                    data  success      Category Have been deleted Successfully        success message goes here                       My Model   public function deleteRecord  id          this- gt db- gt where  cat id    id        del  this- gt db- gt delete  category           return  del

User · Answer

You are using an  id variable in your model  but your are plucking it from nowhere  You need to pass the  id variable from your controller to your model    Controller  Lets pass the  id to the model via a parameter of the row delete   method   function delete row         this- gt load- gt model  mod1           Pass the  id to the row delete   method     this- gt mod1- gt row delete  id        redirect   SERVER  HTTP REFERER           Model  Add the  id to the Model methods parameters   function row delete  id        this- gt db- gt where  id    id       this- gt db- gt delete  testimonials         The problem now is that your passing the  id variable from your controller  but it s not declared anywhere in your controller

[php] how to delete a specific row in codeigniter?

Examples related to php

Examples related to codeigniter