Is there a 'insertAll' in Medoo?

[anta40]

Hi.

Just tried Medoo for my side project. It's very easy to setup and use 👍

I wonder if Medoo support mass insertion something like this:

$result = $database->insert('account', [
{
    'user_name' => 'foo',
    'email' => '[email protected]'},
{
    'user_name' => 'steve',
   'email' => '[email protected]'},
{
   'user_name' => 'john',
  'email' => '[email protected]}]);
]);

This way, I can know whether ALL data are succesfully inserted or not.

[patkon]

Hi, you can find the answer in the Documentation: Section Multi-Insertion:
https://medoo.in/api/insert

$database->insert("account", [
	[
		"user_name" => "foo",
		"email" => "[email protected]",
		"age" => 25,
		"city" => "New York",
		"lang [JSON]" => ["en", "fr", "jp", "cn"]
	],
	[
		"user_name" => "bar",
		"email" => "[email protected]",
		"age" => 14,
		"city" => "Hong Kong",
		"lang [JSON]" => ["en", "jp", "cn"]
	]
]);

// Returns the number of rows affected by the last SQL statement
echo $data->rowCount();