codeigniter update table row with new data array where

Question

I have a database record with a uniqueID/PrimaryKe (OrderNumber)

I want to update the record with new data for that same PrimaryKey, OrderNumber.

My Controller is:

 $data = array(
      'CustomerName' =>  $this->input->post('customer'),
      'CustomerAccountCode' =>  $this->input->post('accountcode'),
      'PeriodStart' =>  substr($this->input->post('period'), 0,10),
      'OrderUnitOfMeasure' =>  $this->input->post('buom'),
      'CreditLimit' =>  $this->input->post('creditlimit'),
      'BalanceBeforeOrder' =>  $this->input->post('currentbalance'),
      'BalanceAfterOrder' =>  $this->input->post('newbalance'),
      'OrderLines' =>  $this->input->post('orderlines'),
      'TotalCost' =>  $this->input->post('grandtotal'),
      'AverageDiscount' =>  $this->input->post('avediscount'),
      'TotalCubes' =>  $this->input->post('grandtotalcubes'),
      'TreatedCubes' =>  $this->input->post('grandtotaltreatedcubes'),
      'SpecialComments' =>  $this->input->post('specialcomments'),
      'CustomerReference' =>  $this->input->post('customerref'),
      'ordernumber' =>  $this->input->post('ordernumber')
      );

    $this->sales_model->update_order_data($data);

My model is:

function update_order_data($q){
    $this->db->where('CustomerOrderID', 'OrderNumber'); //ordernumber being post input ordernumber in array
    $query = $this->db->update('Customer_Order_Summary');
}

So what I want is :

update 'Customer_Order_Summary' 
set 'CustomerName'="$this->input->post('customer')",
set 'CustomerAccountCode'="$this->input->post('accountcode')",
//rest of set statements for each column and corresponding post
where 'CustomerOrderID'='OrderNumberInArray'//(post value)

This update statement is not working, any pointers would be appreciated.

Thanks as always,

Bhuvan Rikka · Accepted Answer · 2013-05-15 04:32:01Z

2

Remove 'ordernumber' from your $data array and pass it separately

$this->sales_model->update_order_data($this->input->post('ordernumber'),$data);‌

The query should be like

function update_order_data($key,$q){
 $this->db->where('CustomerOrderID', $key);
 $query = $this->db->update('Customer_Order_Summary',$q);
}

edited May 15, 2013 at 4:32

answered May 14, 2013 at 14:08

Bhuvan Rikka

2,7031 gold badge19 silver badges28 bronze badges

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

2 Comments

Smudger Over a year ago

Thanks again. okay, so progress definitely. problem is the $q['OrderNumber'] is my primary key and I am passing it as part of array $q. I then use it in the update statement set and the where so get error: Cannot update identity column 'CustomerOrderID'. How do I pass an array for the update columns and a variable for the where clause? Thanks.

Bhuvan Rikka Over a year ago

@Smudger Oops forgot abt that... Just remove the order number from your data array and pass two parameters to the model like $this->sales_model->update_order_data($this->input->post('ordernumber'),$data);.. Check the edited answer

Marko Aleksić · Accepted Answer · 2013-05-14 14:14:50Z

2

Try:

function update_order_data($q)
{
    $this->db->where('CustomerOrderID', $q['OrderNumber']);
    $this->db->update('Customer_Order_Summary',$q);
    return $this->db->affected_rows();
}

Note: Usually, in update functions, I have 2 arguments eg:

function update_something($pk,$data)
{
   $this->db->where('primary_key', $pk);
   $this->db->update('database_table',$data);
   return $this->db->affected_rows();
}

answered May 14, 2013 at 14:14

Marko Aleksić

1,5911 gold badge18 silver badges24 bronze badges

Collectives™ on Stack Overflow

codeigniter update table row with new data array where

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related