Tag "database" tricks

This query searches the data from the Table and also with its relation table columns dynamically.

GroupBy clause with multiple columns select in laravel

DB Seeder tool: https://github.com/haruncpi/db-seeder

If I Let You Go, I Will Never Know - Westlife

search query from scope in laravel model

Here posts and categories have many to many relationships. the tricks are to fetch posts having a particular category attribute with categories details.

if you want to use ORM eloquent to get a query with the third table and select only particular attributes then here is the trick. Here users can have multiple positions in a company and each user has their own user profile. *note that user_id must be here to fetch data with a specific column. without foreign key eloquent cannot map relational table

As I will cover this Post with live Working example to develop how to save ckeditor content in mysql database, so the Laravel ckeditor display raw data in the database and post form is used for this example is following below.

maybe this is a nice way to prevent an eloquent model field being updated with mutators like this: