Get success confirmation while insert multiple rows using loop

Question

How can I get success confirmation while I am using loop to insert table rows in MySql database table?

My code is like below (I am using CodeIgniter):

foreach($bookids as $key=>$bookid)
{
    $this->db->query("INSERT INTO `book` (`invoice_id`,`item_id`,`quantity`,`price`) VALUES (`$invoice_id`,`$product_id`,`$product_quantitys[$key]`,`$product_prices[$key]`)");        
}

I would like to get confirmation after all rows inserted successfully.

Kumar V · Accepted Answer · 2014-01-13 08:03:59Z

6

You can use affected_rows() function to check data inserted( or updated) or not.

$actual_count = count($bookids); // array of book ids
$inserted_count = 0;

foreach($bookids as $key=>$bookid)
{
    $this->db->query("INSERT INTO `book` (`invoice_id`,`item_id`,`quantity`,`price`) VALUES (`$invoice_id`,`$product_id`,`$product_quantitys[$key]`,`$product_prices[$key]`)");        
    if($this->db->affected_rows()>0) // data inserted, so it will return 1
    {
      $inserted_count ++;
    }
}

if($actual_count  == $inserted_count )
{
  //throws success message to controller
}
else
{
   // throws error message with mismatch record count
}

answered Jan 13, 2014 at 8:03

Kumar V

8,8289 gold badges44 silver badges60 bronze badges

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

2 Comments

Foysal Vai Over a year ago

kumar_v, Thanks for solution.I would like to implement transaction here. How is it possible??

Kumar V Over a year ago

refer this tutorial: ellislab.com/codeigniter/user-guide/database/transactions.html

MSadura · Accepted Answer · 2014-01-13 08:08:23Z

1

$success = true;    

foreach($bookids as $key=>$bookid)
{
    if ($this->db->query("INSERT INTO `book` (`invoice_id`,`item_id`,`quantity`,`price`) VALUES         (`$invoice_id`,`$product_id`,`$product_quantitys[$key]`,`$product_prices[$key]`)"))
    {} else { $success = false}
}

if ($success){
   code on success...
}

Explanation: SImply if your query success do nothing, if one of queries will fail flag $success will be false and you will know that something went wrong

answered Jan 13, 2014 at 8:08

MSadura

1,04213 silver badges18 bronze badges

Collectives™ on Stack Overflow

Get success confirmation while insert multiple rows using loop

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