Update table data within Codeigniter Controller / MySQL

Question

I'm in a small pickle on this one. I'm using Codeigniter controller.

I need to update an Order status where "DATA HERE" is located in the code below.

Basically here is what i need to do locate the $orderid within a table called "orders" find the "status" and update it to the text "Paid".

$orderid = $id;

if($this->input->post("status")=="OK" && $this->input->post("step")=="Confirmation" && $this->input->post("orderhash")==$orderHashOrg)
    {
        // DATA HERE    
    }

Any help is greatly appreciated.

Here is my current code

$updateData=array("status"=>"Paid");

    if($this->input->post("status")=="OK" && $this->input->post("step")=="Confirmation" && $this->input->post("orderhash")==$orderHashOrg)
    {

        $d = $this->db->get('offers_orders');
        $this->db->select('status');
        $this->db->where('order_number', $id);

        $orderdata = $d->result_array();

        $this->db->update("offers_orders", $updateData);

    }

write your code first, we can help fix the bug

DevZer0
– DevZer0

2013-06-28 13:56:49 +00:00
Commented Jun 28, 2013 at 13:56 — DevZer0
– DevZer0, Commented Jun 28, 2013 at 13:56
Just updated... Thank you!

Jack Johnson
– Jack Johnson

2013-06-28 14:41:42 +00:00
Commented Jun 28, 2013 at 14:41 — Jack Johnson
– Jack Johnson, Commented Jun 28, 2013 at 14:41

Abhishek Kannan · Accepted Answer · 2013-06-28 14:46:05Z

6

Assuming you have established your database connection.

 $orderid = $id;

if($this->input->post("status")=="OK" && $this->input->post("step")=="Confirmation" && $this->input->post("orderhash")==$orderHashOrg)
{

$updateData=array("status"=>"Paid");

$this->db->where("orderid",$orderid);
$this->db->update("orders",$updateData);    
}

answered Jun 28, 2013 at 14:46

Abhishek Kannan

9981 gold badge8 silver badges16 bronze badges

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

Comments

DEarTh · Accepted Answer · 2021-05-07 10:35:07Z

-2

function update ($data,$id){

    $this->db->where('user.id',intval($id));

    return $this->db->update('user', $data);

}

edited May 7, 2021 at 10:35

DEarTh

1,0051 gold badge8 silver badges20 bronze badges

answered Aug 24, 2016 at 9:06

Mrunmay Deswandikar

1

Collectives™ on Stack Overflow

Update table data within Codeigniter Controller / MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related