Skip to content

Instantly share code, notes, and snippets.

@MubinSayed

MubinSayed/helper.php

Created September 23, 2022 10:14
Show Gist options
  • Save MubinSayed/8c41b51337b5fb80d74f42c6ff7d0716 to your computer and use it in GitHub Desktop.
Save MubinSayed/8c41b51337b5fb80d74f42c6ff7d0716 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. MubinSayed created this gist Sep 23, 2022.
    13 changes: 13 additions & 0 deletions helper.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,13 @@
    /**
    * Combines SQL and its bindings
    *
    * @param \Eloquent $query
    * @return string
    */
    public static function getEloquentSqlWithBindings($query)
    {
    return vsprintf(str_replace('?', '%s', $query->toSql()), collect($query->getBindings())->map(function ($binding) {
    $binding = addslashes($binding);
    return is_numeric($binding) ? $binding : "'{$binding}'";
    })->toArray());
    }