Category: Laravel

How to get the latest and oldest record in Laravel Eloquent through ofMany.

Posted on November 4, 2022November 4, 2022 by Sanjoy

Laravel ships with many awesome and time-saving methods for developers like us.. Here we will see some “One of Many” function’s examples: Get the latest/last record from a model/relation function latestRecord() { return $this->hasOne(RelationModel::class)->latestOfMany(); } Get the oldest/first record from a model/relation function latestRecord() { return $this->hasOne(RelationModel::class)->oldestOfMany(); } Bonus!: Retrieve records with special […]

Copy or duplicate a row in Laravel project

Posted on September 12, 2022March 15, 2023 by Sanjoy

I have been working on an application named “EasySME” with Laravel & MySQL. And a client requested a new feature that he wants to clone/copy/duplicate the existing Invoice. So, I have done a few searches and R&D and found out that Laravel ships with a built-in function called replicate(). Laravel is awesome, you want it […]

How to get or export SQL query from Laravel migration file?

Posted on June 9, 2022June 9, 2022 by Sanjoy

Hey there.. hope you are facing the same problem as I am facing to update the DB from phpMyAdmin.. and no ssh access from Cpanel to run the migration command on the terminal. And you are in the right place.. here is the solution to get the dump query from the Laravel migration file. Command: […]

How to get Column Name from a table in Laravel and PHP

Posted on August 6, 2020August 13, 2020 by Sanjoy

How to get Column Name from a table in Laravel and PHP

Validate Bad Email Address in PHP, Laravel

Posted on May 17, 2020August 13, 2020 by Sanjoy

Hey! what’s up? I am working on a SAAS application for my current company and facing the issue of sending emails, actually bad emails, those comply with the RFC. So that means basic email validation is not working from the Laravel side and we are processing emails to ‘example@gmail’ like email addresses (yes RFC allow […]

Run raw insert query or SQL file in Laravel seeder

Posted on January 12, 2020August 13, 2020 by Sanjoy

Run raw insert query or SQL file in Laravel seeder

Send email using Gmail SMTP in Laravel 5.*

Posted on March 23, 2018 by Sanjoy

Hi there, hope you are not in trouble with your application email sending feature. I am using mailtrap.io for email testing on the development server. It is good, but one problem is all email are going mailtrap’s Demo inbox, not to users individual email. And my client wants to check all email templates and functionality […]

External API calling in Laravel by Guzzle Package

Posted on April 4, 2017 by Sanjoy

Recently I am working on a project that need to access some external API. And it’s a Laravel project, so I am looking for some package that can save my time and meet the deadline too. I am using GuzzleHttp package for accessing external API and its really easy Installation: composer require guzzlehttp/guzzle:~6.0 Uses: […]

Set XSRF(/CSRF) Token Globally or TokenMismatchException in Laravel 5.* (for AJAX)

Posted on July 14, 2016 by Sanjoy

Very easy (পানির লাহান) 🙂 STEP – 1: First we have to ad a meta tag (name=”_token”) in header <meta name=”_token” content=”{{ csrf_token() }}” /> STEP – 2: Then add below jQuery snippet before the </body> tag. Basically here we setting up the csrf token globally for ajax request. And after this we don’t need to […]

Laravel: php artisan commands

Posted on June 15, 2016 by Sanjoy

Here I am trying to list all Laravel PHP Artisan commands one by one for my reference and your too. – To create and update table by migration php artisan make:migration Create_Table_Name -> create a new table php artisan make:migration Update_Table_Name_Column_Name -> update table php artisan make:migration Add_Column_Name_Table_Name -> add a new column to a table […]