How to show SQL query formed by ::create Laravel?

Question

Is it possible to display a ready formed SQL after operation:

 $r = \App\Visitor::create($item);

Where $item is array data.

I wonder why this operation returns in $r inserted model, but there is no changes in db table.

So, thanks for answers I tried yours solutions:

This is query:

insert into `visitors` (`lastname`, `firstname`, `middlename`, `birthday`, `company`, `document_number`, `pincode`, `code`, `idEvent`) values ("Huse", "Huseynkhanov", "Akif", "1981-04-09", "XXX", 16428285, "QT0FE12", 19283746564923, "17");

This is screen of binding:

If execute query above in database it works. But Laravel does not insert data.

Model is:

class Visitor extends Model
{
    public $timestamps = false;

    public $table = 'visitors';

    protected $fillable = [
        "lastname",
        "firstname",
        "middlename",
        "birthday",
        "company",
        "document_number",
        "pincode",
        "status",
        "code",
        "idEvent"
    ];

    protected $primaryKey = 'idVisitor';

    protected static function boot()
    {
        parent::boot();

        static::addGlobalScope(new StatusScope);
    }
}

Code is:

foreach ($items as $item) {
    \App\Visitor::create($item);
}

please be specific. do you want the sql query that preformed to insert data? — Salar Bahador
– Salar Bahador, Commented Mar 9, 2019 at 19:21
yes that's correct. looks like I replied too late to your question :D — Salar Bahador
– Salar Bahador, Commented Mar 9, 2019 at 19:27

Benjamin Beganović · Accepted Answer · 2019-03-09 19:21:15Z

2

I believe, you can do something like this:

$r = \App\Visitor::create($item)->toSql();
dd($r);

answered Mar 9, 2019 at 19:21

Benjamin Beganović

1,1781 gold badge9 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

POV Over a year ago

Very strange but it gives me SELECT query instead INSERT: "select * from visitors` where status = ?"`

Benjamin Beganović Over a year ago

You can either try wigh the Davit's answer, or running with debugbar. github.com/barryvdh/laravel-debugbar

marc_s · Accepted Answer · 2019-03-10 07:41:47Z

1

You can use this

DB::enableQueryLog();
\App\Visitor::create(['key' => 'value', ....]);
$data = DB::getQueryLog();
$query = str_replace(array_fill(0, count($data[0]['bindings']), '?'), $data[0]['bindings'],  $data[0]['query']);
dd($query);

edited Mar 10, 2019 at 7:41

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Mar 9, 2019 at 19:27

Davit Zeynalyan

8,6485 gold badges33 silver badges57 bronze badges

6 Comments

Davit Zeynalyan Over a year ago

What is a problem?? Show $item value

POV Over a year ago

See my question please

Davit Zeynalyan Over a year ago

Are you use transactions??

POV Over a year ago

What does it mean? I use ::create in loop

Davit Zeynalyan Over a year ago

See laravel.com/docs/5.7/database#database-transactions. Also can you show your whole code?

|

Collectives™ on Stack Overflow

How to show SQL query formed by ::create Laravel?

2 Answers 2

2 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related