Default belongsToMany relationship in Laravel works really well – you can easily attach, detach or sync records. But what if you want to order pivot records by newest or oldest? This article will show you how. Here’s how default pivot table is described. Migration file: class CreateProjectUserPivotTable extends Migration { public function up() { Schema::create(‘project_user’, …
There are situations where you need to get array of IDs for some records in collection/table. I will show you two quick ways to do it – one is pretty popular, and another is a function which I found out only today. Imagine, that you have hasMany() relationship – one Role has many Permissions. And …
I recently needed to modify the emails that a client project sends out. It was set up to send via SMTP and so the easiest way to do this for me was to add a local MailHog instance and point the application at it. Manually running via Docker The quickest and easiest way to do …
In previous tutorial, we learned about stored procedure in PHP. In this tutorial, we will learn CRURD operation using Stored Procedure. File Structure for CRUD Operation dbconfig.php- used for database connection tblusers.sql– Contain the structure of the database table insert.php- used for add a record in the database index.php– Used for read the record from database . update.php– Used for …
In this tutorial, we are going to learn how to change the district dropdown list option based on the selected state name using PHP-PDO. In this example, we have two dropdowns for listing states and districts. On changing states drop-down values, the corresponding district dropdown values will be loaded dynamically using jQuery AJAX. File structure …
