Codeigniter - Passing the value of column to the column of another table

Question

I getting Unknown column 'Array' in 'field list' error

i like to do is what ever random numeric inserted to invoice column i should pass it to the column transaction_num of another table.

MY CONTROLLER

$order = array(
           'date' => $date,
           'customer_id' => $cust_id,
           'invoice' => random_string('numeric', 6)
           );
    $ord_id = $this->PaymentModel->insert_order($order);

    $invoice = $this->PaymentModel->get_invoice($ord_id);

$order_detail = array(
        'transaction_num' => $invoice,

//there is other data to be inserted here i just removed it coz this column is the only problem
                );
$this->PaymentModel->insert_order_detail($order_detail);

MY PAYMENT MODEL

public function get_invoice($ord_id){

        $query = $this->db->select('invoice')->from('orders')->where('serial', $ord_id)->get(); 
        return $query->result_array();


}
public function insert_order_detail($order_detail) {
    $this->db->insert('order_detail', $order_detail);

}

@FastSnail ive tried to change my code now based on what is given code below now ive getting this errror http://prnt.sc/bzcpzd — rinru, Jul 30 '16 at 05:11

mokNathal · Accepted Answer · 2016-07-30T05:09:29.557

0

just change

public function get_invoice($ord_id){

        $query = $this->db->select('invoice')->from('orders')->where('serial', $ord_id)->get(); 
        return $query->result_array();


}

to

   public function get_invoice($ord_id){

            $this->db->where('serial', $ord_id);
            $query = $this->db->get('invoice')->row_array(); 
            return $query['invoice'];


    }

/////////////////////////////or//////////////////////

I am assuming you are doing above functionality in same function.So, you can just store

$invoice=random_string('numeric', 6);

and supply this to both tables

edited Jul 30 '16 at 05:09

answered Jul 30 '16 at 05:05

mokNathal

533
1
6
20

that is other issue please see http://stackoverflow.com/q/8028957/3239572 – mokNathal Jul 30 '16 at 05:11
remove space before – mokNathal Jul 30 '16 at 05:13
what you mean remove space before ' – rinru Jul 30 '16 at 05:17
if there is whitespace before – mokNathal Jul 30 '16 at 05:20
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/118686/discussion-between-moknathal-and-edgar-ong). – mokNathal Jul 30 '16 at 05:20
ive already firxed the problem. based on the link you give to men a while ago. i have plenty of echo that's why. btw thanks again for the help – rinru Jul 30 '16 at 05:29

Codeigniter - Passing the value of column to the column of another table

1 Answers1