tenerant

Selecting and Aliasing Columns in Laravel

When you want to select specific columns using Eloquent or Query Builder in Laravel, no one would blame you for reaching for sleect() or selectRaw(). But, did you know that you can specify column to select in the all(), get(), and first() methods as well? What’s more, aliasing columns,...

October 9, 2018 Shawn Laravel.

Laravel str_ordinal Helper Function

I recently submitted a PR to the Laravel framework to add a str_ordinal helper function. The function adds an ordinal indicator to a numeric value passed to its first argument. Simply put, it adds “st”, “nd”, “rd” and “th” to numbers. The PR was closed by Taylor within the...

May 5, 2017 Shawn Laravel.

Deleting Files with Laravel and PHP

I was perusing the Laracasts forum yesterday when I spotted a thread I recalled seeing a long time ago that someone had resurrected: How to delete a file using Filesystem. The original poster was having an issue using the File facade to delete a file. What followed was...

November 15, 2016 Shawn Laravel.

Using OR in a Where Clause with Laravel’s Query Builder

While upgrading to Laravel 5.3 last night, I ran across a case where I had used whereRaw() for a Select2 autocomplete lookup. It was pretty obvious I did this because I wanted to group two columns inside parenthesis and at the time I didn’t know how to do it...

October 27, 2016 Shawn Laravel.

Laravel Homestead Add Packages After Provisioning

Laravel Homestead offers much of what you’ll need to develop your applications out of the box. However, you may end up with a project that requires software beyond what is installed by default. For shared/universal Homestead, be aware that anything extra you install or configure may affect your projects....

July 24, 2016 Shawn Laravel.

Convert MySQL 5.7 to MariaDB 10.1

The happy path to converting a server newly provisioned by Laravel Forge on Do from MySQL 5.7 to MariaDB 10.1.

February 10, 2016 Shawn Laravel.

Laravel Forge SSL Obsolete Cipher Suite

If you use Laravel Forge to provision your servers, you probably already know that it can install SSL via Let’s Encrypt. The process is as simple as clicking two buttons–one for the install and a second to activate. However, what Forge fails to mention is you need to add...

February 1, 2016 Shawn Laravel.

Laravel No Supported Encrypter Found

When you create a new laravel project using composer create-project laravel/laravel, composer will generate an app key for your app after renaming .env.example to .env and write it as the value for APP_KEY. IF you install by another means, this key may not get generated and you will get the...

October 26, 2015 Shawn Laravel.

Priming MySQL Using Laravel Migrations

In my current project, I needed to load zip code data into a MySQL table. There are a number of ways to do this, but I wanted a solution that could flex to much larger datasets and run fast. After doing some research, it seemed like the best way...

July 1, 2015 Shawn Laravel.