Tag "database" tricks

This is how you get the list of databases using Laravel.

This is the trick i use whenever i want to seed states or countries. I simply put the states inside an array and create a loop through the array and save each record into the database instead of repeating the instance to save the records.

Laravel Load More Data on Page Scroll – Laravel 5

Laravel 5.4 Upload Image with Validation example

Inserts HTML <p> tags before all newlines in a string

This example provides a quick and simple method to generate a hash for a model without saving a UUID/GUID to the database.

Laravel MySQL in default returns "SQLSTATE[HY000]: General error: 1366 Incorrect string value" error in emoji save... this error is because Laravel in default uses utf8 charset in MySQL, change your `config/database.php` like below and reset your migration instead putting out that error...

I'm using a pivot table on the project I'm working with to filter category

X-editable allows you to create editable elements on your page. It can be used with any engine (bootstrap, jquery-ui, jquery only) and includes both popup and inline modes. Let's have a quick look at implementing this in Laravel apps.