how to print model query in laravel

Question

i am new in laravel and have to save the record in table , i am using this code to insert the value

$model->studentRollId = $value1;
$model->resident_permit_number = $value2;
$model->save()

i am not getting any error but record not inserting in the table , so can anyone please tell me how can i print the executed query by the $model->save(), i tried DB::getQueryLog() but its not shiwing the query log so i can fin what is the issue . thanks in advance

Answer 1

Use ->toSql(), after your $model->save(), just do a dd($model->toSql())

Edit: Have you do a \DB::enableQueryLog();?

\DB::enableQueryLog();
$model->studentRollId = $value1;
$model->resident_permit_number = $value2;
$model->save()
dd(\DB::getQueryLog());

Answer 2

Try This

$model->studentRollId = $value1;
$model->resident_permit_number = $value2;
$data = $model->toSql();
dd($data);