arnoldfederis/builder-to-sql
Render Eloquent or Query builder to Sql
4,233
1
| Install | |
|---|---|
composer require arnoldfederis/builder-to-sql:dev-master |
|
| PHP: | ^7.0 |
| License: | MIT |
| Last Updated: | Jul 24, 2021 |
| Links: | GitHub · Packagist |
Maintainer: arnoldfederis
Laravel Builder to SQL
Description
Render Eloquent or Query builder to Sql.
In this package will automatically replace all ? from toSql() result with your bindings.
This is useful when you don't want to manual query.
Compatibility
Laravel 5 to latest version
PHP ^7.0
How to install
composer require arnoldfederis/builder-to-sql
How to use
Import BuilderToSql class or use the helper function.
class TestController extends Controller
{
public function index()
{
/* Class base */
// Query Builder
return BuilderToSql::render(DB::table('users')->where('email', 'query_builder_to_sql@email.com')->orderByDesc('created_at'));
// Eloquent Builder
return BuilderToSql::render(User::where('email', 'query_builder_to_sql@email.com')->orderByDesc('created_at'));
/* Function base */
// Query Builder
return query_builder_to_sql(DB::table('users')->where('email', 'query_builder_to_sql@email.com')->orderByDesc('created_at'));
// Eloquent Builder
return query_builder_to_sql(User::where('email', 'query_builder_to_sql@email.com')->orderByDesc('created_at'));
// Result
// select * from users where email = 'query_builder_to_sql@email.com' order by created_at desc
}
}
License
This is a free software licensed under the MIT license.
Related Packages
doctrine/dbal
Powerful PHP database abstraction layer (DBAL) with many features for database s...
655,942,320
9,702
laravel/serializable-closure
Laravel Serializable Closure provides an easy and secure way to serialize closur...
442,489,569
607
nunomaduro/collision
Cli error handling for console/command-line PHP applications.
412,228,818
4,664