Well I found the solution. It can be done one by passing a closure function in with() as second index of array like Post::query() ->with([‘user’ => function ($query) { $query->select(‘id’, ‘username’); }]) ->get() It will only select id and username from other table. I hope this will help others. Remember that the primary key (id … Read more
Eloquent has a method for that (Laravel 4.*/5.*); Model::whereNotNull(‘sent_at’) Laravel 3: Model::where_not_null(‘sent_at’)
Never set a directory to 777. you should change directory ownership. so set your current user that you are logged in with as owner and the webserver user (www-data, apache, …) as the group. You can try this: sudo chown -R $USER:www-data storage sudo chown -R $USER:www-data bootstrap/cache then to set directory permission try this: … Read more
In case someone comes across this and is looking for these settings (like I was) You have to On the left hand side, click “+Add Product” and select “Facebook Login” (it was at the top for me) See the new settings available on the left hand side You will now have these OAuth settings on … Read more
You need to put SongsTableSeeder into file SongsTableSeeder.php in the same directory where you have your DatabaseSeeder.php file. And you need to run in your console: composer dump-autoload to generate new class map and then run: php artisan db:seed I’ve just tested it. It is working without a problem in Laravel 5
LARAVEL 5.5 AND UP Use the full form of the blade directive: @php $i = 1 @endphp LARAVEL 5.2 – 5.4 You can use the inline tags: @php ($i = 1) Or you can use it in a block statement: @php $i = 1 @endphp ADD A ‘DEFINE’ TAG If you want to use custom … Read more
You can use: Request::url() to obtain the current URL, here is an example: @if(Request::url() === ‘your url here’) // code @endif Laravel offers a method to find out, whether the URL matches a pattern or not if (Request::is(‘admin/*’)) { // code } Check the related documentation to obtain different request information: http://laravel.com/docs/requests#request-information
When using ->get() you cannot simply use any of the below: if (empty($result)) { } if (!$result) { } if ($result) { } Because if you dd($result); you’ll notice an instance of Illuminate\Support\Collection is always returned, even when there are no results. Essentially what you’re checking is $a = new stdClass; if ($a) { … … Read more
I thought I’d take a crack at answering my own question. What follows is just one way of solving the issues 1-3 in my original question. Disclaimer: I may not always use the right terms when describing patterns or techniques. Sorry for that. The Goals: Create a complete example of a basic controller for viewing … Read more
Tested versions (Updated) Version Tested (Yes/No) 4.2 No 5.x Yes (5.5) 6.x No 7.x No 8.x Yes (8.4) 9.x Yes (9.2) Define Connections Using .env >= 5.0 (or higher) In .env DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=database1 DB_USERNAME=root DB_PASSWORD=secret DB_CONNECTION_SECOND=mysql DB_HOST_SECOND=127.0.0.1 DB_PORT_SECOND=3306 DB_DATABASE_SECOND=database2 DB_USERNAME_SECOND=root DB_PASSWORD_SECOND=secret In config/database.php ‘mysql’ => [ ‘driver’ => env(‘DB_CONNECTION’), ‘host’ => env(‘DB_HOST’), ‘port’ … Read more