2. PHPRunner General questions
  3. add multiple records at once into one table
This topic is locked

add multiple records at once into one table

 		6/1/2018 4:06:00 PM
PHPRunner General questions
soluxbrasil author

I need a hint of how to add multiple records at once into one table. Example: I made a loan at the bank and would like to add the installments at one time, ie I made a loan of 24,000 and I want to add 24 installments of 1,000. Have you ever used anything like it?
jadachDevClub member 6/1/2018

I have done similar with the help of a stored procedure executed after recor added.
soluxbrasil author 6/1/2018



I have done similar with the help of a stored procedure executed after recor added.


Could you give me a tip or see your example?
admin 6/1/2018

Just to give you an idea how you can do this in your event code:

for($i = 0; $i < 24; ++$i) {

$data = array();

$data["account"] = $account;

$data["amount"] = "1000";

DB::Insert("installments", $data );

}