updating /changing a value in database using codeigniter

Question

Iam developing using codeIgniter and I have managed to simply post a id number and phone number into the a table named "offers" both fields are INT, however when i try update a phone number corresponding to a specific id I keep getting the following error

Unknown column 'mysubmit' in 'field list'

UPDATE offers SET phneNum = '078444', mysubmit = 'Submit Form' WHERE idNum = '12'

Filename: C:\xampp\htdocs\project\system\database\DB_driver.php

I have listed my controller , model and view below

newOffer/controller

     class newOffer extends CI_Controller {
  function addOffer() {
 //if the form is submitted           
  $this->load->view("check");
 $this->load->model("offer_model");
   if ($this->input->post('mysubmit')) {

       $this->offer_model->entry_insert();
            }

    }
   function updateOffer (){
    $this->load->view("check");
 $this->load->model("offer_model");
 if ($this->input->post('mysubmit')) {
    // $this->offer_model->upddata();
  $this->offer_model->upddata($this->input->post());
   }


  }
 }
 ?>

offer_model

  class offer_model extends CI_Model{
   public function entry_insert(){
     $data = array(
       'idNum' => $this->input->post('idNum'),
        'phneNum' => $this->input->post('phneNum'),

    );

   $this->db->insert('offers',$data);

}
 public function upddata($data) {
             $data=array();

         $idNum = $data['idNum'];
    $data=$this->input->post(); //get all post value to data array

    unset($data['idNum']); // unset unnecessary values 
   $this->db->where('idNum', $idNum)->update('offers' ,$data);
   return true;
}



}


 ?>

The view // Please enter details for your new offer

        <label for="ID Number">ID Number:  <span class="required">*</span></label>
        <input type="text" name="idNum" id="idNum" placeholder="Please enter ID   Number/>
        <label for="phone Number">Phone Number:</label>
       <input type="text" name="phneNum" id="phneNum   " placeholder="Please enter phone Number"/>

         <fieldset class="submit_field">
          <?php echo form_submit('mysubmit', 'Submit Form'); ?>
       </fieldset>

       </div><!-- end of form div -->
    ?>

schwarz · Accepted Answer · 2013-09-24 19:39:31Z

2

Your issue seems to be in your model function:

 public function upddata($data) {
         $data=array();

     $idNum = $data['idNum'];
$data=$this->input->post(); //get all post value to data array

unset($data['idNum']); // unset unnecessary values 
$this->db->where('idNum', $idNum)->update('offers' ,$data);
return true;
}

the second line, $data=array(); technically wipes the data from the passed in variable and creates a new blank array. So the third statement will return null for $idNum. Instead you can use the $data variable directly to construct your where clause.

public function upddata($data) {
//do necessary data validation here or in the controller.
 $idNum = $data['idNum'];
//not needed you already have the data in the $data var//$data=$this->input->post();
unset($data['idNum']); // unset unnecessary values 
$this->db->where('idNum', $idNum);
$this->db->update('offers' ,$data);
return true;
}

answered Sep 24, 2013 at 19:39

schwarz

3033 silver badges11 bronze badges

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

2 Comments

schwarz Over a year ago

Indeed I also forgot to mention that your table probably doesn't have the mysubmit column, you would need to unset this as well as per Bill Garrison's comment.

mickmackusa Over a year ago

The model layer should not be accessing $this->input->post(). The model should perform database processes while being totally ignorant of the source of its input data. It is the responsibility of the controller to collect all required data and pass that payload to the model.

Suvash sarker · Accepted Answer · 2013-09-24 19:54:09Z

0

public function upddata($data) {

             $idNum = $data['idNum'];

             $offers_data = array("phneNum" => $data['phneNum']);

             unset($data['idNum']); // unset unnecessary values 
             $this->db->where('idNum', $idNum)->update('offers' ,$offers_data );
             return true;
}

edited Sep 24, 2013 at 19:54

answered Sep 24, 2013 at 19:47

Suvash sarker

3,1451 gold badge21 silver badges23 bronze badges

4 Comments

Zidane Over a year ago

thanx a lots I adjust and put extract($data); at the beginning of the function and it works alright

Bill Garrison Over a year ago

I don't agree with this at ALL. The method is an update method. THIS confines the method to ONLY update the phone number. If he tries to update anything else it will not work. His problem (as i mentioned in my answer) is that he had the POST data from his submit input in the array.

Suvash sarker Over a year ago

he wanted to update only phone number.please see the form mention in question.

mickmackusa Over a year ago

For the record, CI's update() method can receive the WHERE clause data as an associative array in the method's 3rd parameter.

Bill Garrison · Accepted Answer · 2013-09-24 19:40:03Z

0

When a form is submitted the submit button is ALSO an input and gets sent along with the post. You then send it to the update method and so it is looking for the column "mysubmit" (the name of your submit input) to update to the value of your submit button.

You need to unset($data['mysubmit']) before sending it to the update method.

You also need to get rid of $data = array();. I assume that was there for debugging purposes.

answered Sep 24, 2013 at 19:40

Bill Garrison

2,2474 gold badges37 silver badges78 bronze badges

Collectives™ on Stack Overflow

updating /changing a value in database using codeigniter

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related