Welcome Guest, Not a member yet? Register   Sign In
two database insert operations in one function using $this->db->insert()

Hi all

How can I perform two insert operations to two tables in a function ?
I tried following code

$this->subproduct  = $name;
        $this->status = 1;
        $this->db->insert('subproduct', $this);
        $insert_id = $this->db->insert_id();

        $this->subp_id = 2;
        $this->prd_id = $insert_id;
        $this->db->insert('product_subproduct', $this);

I am getting following error

Quote:A Database Error Occurred
Error Number: 1054

Unknown column 'subproduct' in 'field list'

INSERT INTO `product_subproduct` (`subproduct`, `status`, `subp_id`, `prd_id`) VALUES ('xxx', 1, 2, 19)

How can I reset values in $this after first insertion ?


You shouldn't really be using the current object to insert into the database, it would probably be better to use another variable. That way you can use two different ones for the inserts, for example

$data['subproduct']  = $name;
$data['status'] = 1;
$this->db->insert('subproduct', $data);
$insert_id = $this->db->insert_id();

$other_data['subp_id'] = 2;
$other_data['prd_id'] = $insert_id;
$this->db->insert('product_subproduct', $other_data);

You could use anything else instead of $data and $other_data

[eluser]saidai jagan[/eluser]
Yes this is Clean Smile

Thanks guys

Theme © iAndrew 2016 - Forum software by © MyBB