Skip to content

Instantly share code, notes, and snippets.

@wadson-pereira

wadson-pereira/gist:fd32c4b6315f93377968bafdc424dc70

Forked from jesseobrien/gist:7418983
Created March 26, 2021 12:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save wadson-pereira/fd32c4b6315f93377968bafdc424dc70 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save wadson-pereira/fd32c4b6315f93377968bafdc424dc70 to your computer and use it in GitHub Desktop.
Download ZIP
Bind parameters into the SQL query for Laravel ORM
Raw
gistfile1.php
<?php
class MyModel extends Eloquent {
public function getSql()
{
$builder = $this->getBuilder();
$sql = $builder->toSql();
foreach($builder->getBindings() as $binding)
{
$value = is_numeric($binding) ? $binding : "'".$binding."'";
$sql = preg_replace('/\?/', $value, $sql, 1);
}
return $sql;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment