I would like to make a timestamp column with a default value of CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP using the Laravel Schema Builder/Migrations. I have gone through the Laravel documentation several times, and I don’t see how I can make that the default for a timestamp column. The timestamps() function makes the defaults 0000-00-00 00:00 for … Read more
I am working on a project in Laravel where I am storing some settings in .env file setting like few parameters for testing purpose and few parameters are for live working so I was just checking that is there any way to comment in .env file of Laravel. Here is an example /* Test Settings … Read more
I would like to retrieve the last file inserted into my table. I know that the method first() exists and provides you with the first file in the table but I don’t know how to get the last insert. 19 Answers 19
lets say I have 7 columns in table, and I want to select only two of them, something like this SELECT `name`,`surname` FROM `table` WHERE `id` = ‘1’; In laravel eloquent model it may looks like this Table::where(‘id’, 1)->get(); but I guess this expression will select ALL columns where id equals 1, and I want … Read more
After the latest update of PHP Intelephense that I get today, the intelephense keep showing an error for an undefined symbol for my route (and other class too), there is no error like this before and it’s bothering me. Here is the error screenshot : And this is my code : Route::group([‘prefix’ => ‘user’, ‘namespace’ … Read more
Simple question, but the answer seems quite hard to come by. In Codeigniter, I could load the URL helper and then simply do echo base_url(); to get my site’s URL. Is there an equivalent in Laravel? 18 Answers 18
I duplicated a working laravel app and renamed it to use for another app. I deleted the vendor folder and run the following commands again: composer self-update composer-update npm install bower install I configured my routes and everything properly however now when I try to run my app in my browser I get the following … Read more
In Laravel, there appears to be a command for creating a migration, but not removing. Create migration command: php artisan migrate:make create_users_table If I want to delete the migration, can I just safely delete the corresponding migrations file within the database/migrations folder? Migrations file: 2013_05_31_220658_create_users_table 9 Answers 9
I’m trying to create foreign keys in Laravel however when I migrate my table using artisan i am thrown the following error: [Illuminate\Database\QueryException] SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL : alter table `priorities` add constraint priorities_user_id_foreign foreign key (`user_id`) references `users` (`id`)) My migration code is as so: priorities migration file … Read more
This question already has answers here: Laravel Eloquent: Ordering results of all() (12 answers) Closed 6 years ago. Simple question – how do I order by ‘id’ descending in Laravel 4. The relevant part of my controller looks like this: $posts = $this->post->all() As I understand you use this line: ->orderBy(‘id’, ‘DESC’); But how does … Read more
