insert current date time using laravel

php mysql laravel php-carbon
seema picture seema · Dec 13, 2018 · Viewed 26.2k times · Source

I want to store current date time in MySQL using following laravel function. Actually, I stored static date instead of this i want store current date time at created_at,updated_at field in database. 

 function insert(Request $req)
   {
       $name=$req->input('name');
       $address=$req->input('address');
       $data=array("name" => $name,"address" => $address,"created_at"=>'2017-04-27 10:29:59',"updated_at"=>'2017-04-27 10:29:59');
       DB::table('student')->insert($data);
       echo "Record inserted successfully.<br/>";
       return redirect('/');
   }

Answer

Jignesh Joisar picture Jignesh Joisar · Dec 13, 2018

use laravel helper function

now()

other wise used carbon class

Carbon\Carbon::now()

used like that

$data = array("name" => $name,"address" => $address,"created_at"=> Carbon::now(),"updated_at"=> now());
DB::table('student')->insert($data);

for more information see

Related questions

Converting a carbon date to mysql timestamp.

I have a timestamp variable column in a mysql database. Trying to convert a carbon timestamp to something that I can input there, but Carbon::now() only returns a Carbon object and when I try to use the timestamp string …

Read More
Laravel - How to get year property of date

I have a "datetime" field in mysql. $time = "1900-01-01 00:00:00"; I cant get only year. I tried $time -> year, but its not good. (Trying to get property of non-object) Maybe i need to convert this string to date? …

Read More
Retrive all rows from last month (Laravel + Eloquent)

I'm trying to get all records that belongs to last month, so far I managed to get all from last month but to date today, I'm not sure how I can get only for last month $revenueMonth = Callback::where('created_…

Read More