CodeIgniter Forums
two database insert operations in one function using $this->db->insert() - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: two database insert operations in one function using $this->db->insert() (/thread-25592.html)



two database insert operations in one function using $this->db->insert() - El Forum - 12-17-2009

[eluser]core-coder[/eluser]
Hi all

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

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 ?


Thanks


two database insert operations in one function using $this->db->insert() - El Forum - 12-17-2009

[eluser]Cro_Crx[/eluser]
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

Code:
$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


two database insert operations in one function using $this->db->insert() - El Forum - 12-17-2009

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


two database insert operations in one function using $this->db->insert() - El Forum - 12-18-2009

[eluser]core-coder[/eluser]
Thanks guys