Updating records codeigniter

Question

I am trying to update a table where id of the row is entered and title is selected through a dropdown list  but I have two problems  Firstly Im not sure how to pass the data to the model  and the second problem is actually updating the table using active record   controller class  class Update extends CI Controller    public function   construct             parent    construct               this- gt load- gt model  addmodel               this- gt load- gt helper  form       public function index          this- gt load- gt view  updview        public function updtitle               data   array       id    gt   this- gt input- gt post  id         title    gt   this- gt input- gt post  title             data1  data      data        data1  data      this- gt updmodel- gt upddata  data        this- gt load- gt view  updview    data1          gt    model class  class Updmodel extends CI Model      model constructor function function   construct         parent    construct       call parent constructor      this- gt load- gt database       public function upddata  data          this- gt db- gt where  emp no    data  id          this- gt db- gt update  title    data  title          return         gt    view                              Update employee title   lt form action  http   localhost ecwm604 index php update updtitle  method  POST  gt      employee id            lt input type text name  id  gt  lt br   gt      change title to            lt select name  title  gt               lt option value  Assistant Engineer  gt Assistant Engineer lt  option gt               lt option value  Engineer  gt Engineer lt  option gt               lt option value  Senior Engineer  gt Senior Engineer lt  option gt               lt option value  Senior Staff  gt Senior Staff lt  option gt               lt option value  Staff  gt Staff lt  option gt            lt  select gt  lt br   gt       lt input type  submit  value  submit   gt       lt br   gt   lt  php     print r  data         echo  data  title      gt    lt  body gt   lt  html gt

User · Answer

In codeigniter doc if you update specific field just do this   data   array       yourfieldname    gt  value       name    gt   name       date    gt   date      this- gt db- gt where  yourfieldname   yourfieldvalue    this- gt db- gt update  yourtablename    data

User · Answer

In your Controller  public function updtitle              data   array           table name    gt   your table name to update      pass the real table name          id    gt   this- gt input- gt post  id             title    gt   this- gt input- gt post  title                this- gt load- gt model  Updmodel       load the model first     if  this- gt Updmodel- gt upddata  data      call the method from the model                  update successful           else                  update not successful            In Your Model  public function upddata  data        extract  data        this- gt db- gt where  emp no    id        this- gt db- gt update  table name  array  title    gt   title        return true      The active record query is similar to   update  table name set title   title  where emp no  id

User · Answer

How to update in codeignitor   whenever you want to update same status with multiple rows you use where in insteam of where or if you want to change only single record can use where   below is my code   conditionArray   array 1  3  4  6    this- gt db- gt where in  ip id    conditionArray    this- gt db- gt update  this- gt table  array  status    gt   active       its working perfect

User · Answer

In your controller write this     public function update title              data   array                  table id    gt   this- gt input- gt post  table id             table title    gt   this- gt input- gt post  table title                  this- gt load- gt model  your model       First load the model     if  this- gt your model- gt update title  data      call the method from the controller                  update successful              else                  update not successful               While in your model     public function update title  data        this- gt db- gt set  table title   data  title             - gt where  table id   data  table id            - gt update  your table        This will works fine

[php] Updating records codeigniter

Examples related to php

Examples related to database

Examples related to codeigniter

Examples related to sql-update