How to disable model timestamps in Laravel 5.3?
In this post we will give you information about How to disable model timestamps in Laravel 5.3?. Hear we will give you detail about How to disable model timestamps in Laravel 5.3?And how to use it also give you demo for it if it is necessary.
Sometimes we require to disable created_at and updated_at timestamps on Model on Laravel, so we can do it simply by using
$timestamps variable of model. It is very small things but important to understand and how to use it.
When you create new item or user using model at that time created_at and updated_at column set default time by default but you can prevent to set false value of $timestamps variable.
Laravel 5.5 group by doesn't work - fixed
In this post we will give you information about Laravel 5.5 group by doesn't work - fixed. Hear we will give you detail about Laravel 5.5 group by doesn't work - fixedAnd how to use it also give you demo for it if it is necessary.
Someday ago i just installed laravel 5.5 application and i was checking new feature and making some examples. But i was working on database query builder example one by one, i got following error when i used group by on single column.
My query was like as bellow example, so you can see on database query i simple get all users and group by with name. So, let's simply see how it is:
DB Query:
$users = DB::table("users")
->groupBy("name")
->get();
dd($users);
But when i run above query using database query builder i got following error, as you can see:
SQLSTATE[42000]: Syntax error or access violation: 1055 'laravel_test.users.id' isn't in GROUP BY (SQL: select * from 'users' group by 'name')
I was thinking what is the issue because without group by it was working, but at last i found it how to solve it So we have to simply "strict" mode make it true into false in database.php file. So let's do it as bellow:
config/database.php
...
'strict' => true,
To
'strict' => false,
....
After that i hope you found your solution.
Thank you...
Hope this code and post will helped you for implement Laravel 5.5 group by doesn't work - fixed. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs
I am creating new records using create method of model like as bellow example:
Item::create(['title'=>'ItSolutionStuff.com']);
Ok, above code will simply add new records on items table with current timestamps value in created_at and updated_at. But you can prevent by add $timestamps variable value false. So your model will be like this way:
app/Item.php
<?php
namespace App;
use IlluminateDatabaseEloquentModel;
class Item extends Model
{
public $fillable = ['title'];
public $timestamps = false;
}
Now, you can check, created_at and updated_at will be null.
Maybe it can help you….
Hope this code and post will helped you for implement How to disable model timestamps in Laravel 5.3?. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs