I ran into a problem with a transaction in Laravel.
When I want to create a dynamic database.
It seems that my transaction is closed automatically.
try {
DB::beginTransaction();
do something ...
Schema::createDatabase($database);
DB::commit();
} catch (Exception $e) {
DB::rollBack();
}
Even in this way:
try {
DB::transaction(function () {
do something ...
Schema::createDatabase($database);
}
} catch (Exception $e) {
//
}
And also like this :
DB::statement("CREATE DATABASE IF NOT EXISTS `{$database}` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;");
Can you guide me?