laravel-4

How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?

by

Given it’s a raw expression, you should use DB::raw() to set CURRENT_TIMESTAMP as a default value for a column: $table->timestamp(‘created_at’)->default(DB::raw(‘CURRENT_TIMESTAMP’)); This works flawlessly on every database driver. As of Laravel 5.1.25 (see PR 10962 and commit 15c487fe) you can now use the new useCurrent() column modifier method to achieve the same default value for a … Read more

Migration: Cannot add foreign key constraint

by

Add it in two steps, and it’s good to make it unsigned too: public function up() { Schema::create(‘priorities’, function($table) { $table->increments(‘id’, true); $table->integer(‘user_id’)->unsigned(); $table->string(‘priority_name’); $table->smallInteger(‘rank’); $table->text(‘class’); $table->timestamps(‘timecreated’); }); Schema::table(‘priorities’, function($table) { $table->foreign(‘user_id’)->references(‘id’)->on(‘users’); }); }

How to Get the Current URL Inside @if Statement (Blade) in Laravel 4?

by

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

Eloquent Collection: Counting and Detect Empty

by

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

Laravel requires the Mcrypt PHP extension

by

Do you have MAMP installed? Use which php in the terminal to see which version of PHP you are using. If it’s not the PHP version from MAMP, you should edit or add .bash_profile in the user’s home directory, that is : cd ~ In .bash_profile, add following line: export PATH=/Applications/MAMP/bin/php/php5.4.10/bin:$PATH Edited: First you should … Read more

How can I remove a package from Laravel using PHP Composer?

by

Composer 1.x and 2.x Running the following command will remove the package from vendor (or wherever you install packages), composer.json and composer.lock. Change vendor/package appropriately. composer remove vendor/package Obviously you’ll need to remove references to that package within your app. I’m currently running the following version of Composer: Composer version 1.0-dev (7b13507dd4d3b93578af7d83fbf8be0ca686f4b5) 2014-12-11 21:52:29 Documentation … Read more