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