eloquent
-
Use search terms in eloquent queries for Laravel
I needed to make an Eloquent query that could take search terms. The search terms are optional – no search term and the whole dataset is returned. In our particular data model the Users have one or many Associations. So the search term should check for user name, phone, email and association name. In the…
-
(PHP) Add column to table in Laravel
Create migration in console: [php] php artisan make:migration add_mycolumn_to_mytable [/php] Use Schema::table() to access existing table (instead of Schema::create() for creating new tables) [php] public function up() { Schema::table(‘mytable’, function($table) { $table->text(‘mycolumn’); }); } public function down() { Schema::table(‘mytable’, function($table) { $table->dropColumn(‘mycolumn’); }); } [/php] Then run migrations: [php] php artisan migrate [/php]
-
(PHP) Eloquent doodles for Laravel
[php] // Get model by primary key $myModel = MyModel::find($id); //Where can use short syntax for equal comparison. $myModels = MyModel::where(‘someAttribute’, ‘=’, ‘someValue’)->get(); $myModels = MyModel::where(‘someAttribute’, ‘someValue’)->get(); // Delete models $affectedRows = MyModel::where(‘someAttribute’, ‘someValue’)->delete(); // Select distinct $distincts = MyModel::distinct()->select(‘someAttribute’)->where(‘someAttribute’, ‘someValue’)->get(); // Select with Limit and offset $myModels = MyModel::limit(30)->get(); $myModels = MyModel::limit(30)->offset(30)->get(); [/php] Different…