Download the PHP package kkszymanowski/laravel-6-odbc without Composer
On this page you can find all versions of the php package kkszymanowski/laravel-6-odbc. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download kkszymanowski/laravel-6-odbc
More information about kkszymanowski/laravel-6-odbc
Files in kkszymanowski/laravel-6-odbc
Package laravel-6-odbc
Short Description ODBC Connector for Laravel 6
License MIT
Informations about the package laravel-6-odbc
ODBC driver for Laravel 6, 7 and 8
Package inspired by tck/odbc but simplified, modernized and made compatible with Laravel 6, 7 and 8.
Installation
Add you database configuration in config/database.php, for example:
Add the environment variables referenced in the configuration to your .env file, for example:
If you would like to customize the schema grammar, query grammar, or the post processor used in the ODBC connection you can do that by extending \Odbc\OdbcSchemaGrammar, \Odbc\OdbcQueryGrammar and \Odbc\OdbcProcessor respectively.
Then add the following configuration entries:
For example in config/database.php add:
One of the more common cases would be to customize the compileLimit() method used in pagination and in the skip() method.
You can do this in the following way:
Note that the custom processor is not used when running raw queries, for example $connection->select('SELECT * FROM USERS').
To use it you must build the queries with the Eloquent query builder, for example:
Usage
With Eloquent
To override your default database connection define $connection name in your Eloquent Model
After defining the connection name you perform all the standard Eloquent operations:
Without Eloquent
You can also perform queries without Eloquent models. Make sure you specify the connection name if it isn't your default one, for example:
If you're running raw queries make sure to use parameter bindings wherever possible to avoid SQL Injection vulnerabilities.
All versions of laravel-6-odbc with dependencies
ext-pdo Version *
illuminate/support Version >=6.0
illuminate/container Version >=6.0
illuminate/database Version >=6.0