Inserting data into a table

RohitBarde

I want to insert a data in a table after an event has occurred. Do you have any related work on such cases for reference?

clarkwinkelmann

RohitBarde Listen for event. Use Eloquent models or Fluent query builder to do a query against the database. This will be pretty much the same as doing it in Laravel. Does that help ?

GradDev

hey clarkwinkelmann
I'm using this query-
DB::table('users_groups')->insert(array('user_id' => 1, 'group_id' => 5));

But I get the error-
Uncaught Error: Class 'Illuminate\Support\Facade\DB' not found in C:\xampp\htdocs\flarum\vendor\flagrow\flarum-ext-image-upload\bootstrap.php:11

The file DB.php exists in the Facade folder. So what could be the problem here?

clarkwinkelmann

GradDev façades are in the root PHP namespace. You probably are in your extension namespace when calling that code.

Try to put use DB; with your other listener imports or call the method like \DB::method()

luceos

Facades are like accessors, they facilitate easier access to specific ioc bindings. My recommendation is to just load the ioc binding, in this case use ConnectionInterface:

http://devdocs.io/laravel~5.5/api/5.5/illuminate/database/connectioninterface

MichaelBelgium

I believe u can create via the group model also (or vice-versa, via the user model)

Laravel docs