2017 © Pedro PelĂĄez
 

library laravel-eloquent-mysqli

MySQLi driver (connector) for Laravel 5.4 Eloquent database

image

shakahl/laravel-eloquent-mysqli

MySQLi driver (connector) for Laravel 5.4 Eloquent database

  • Saturday, May 13, 2017
  • by shakahl
  • Repository
  • 1 Watchers
  • 5 Stars
  • 119 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 5 Forks
  • 1 Open issues
  • 1 Versions
  • 10 % Grown

The README.md

shakahl/laravel-eloquent-mysqli

MySQLi driver (connector) for Laravel 8.x Eloquent database, (*1)

Installation

  • Install via composer
composer require shakahl/laravel-eloquent-mysqli
  • After installing, add provider on config/app.php on your project.
// app.php

    'providers' => [
        ...

        'LaravelEloquentMySQLi\MySQLiServiceProvider',
    ],

Usage

You should configure your database connection to use the mysqli driver., (*2)

Example, (*3)

//...
  'connections' => [
        'mysql' => [
            'driver'    => 'mysqli', // Sets mysqli driver
            'host'      => env('DB_HOST', 'localhost'),
            'port'      => env('DB_PORT', 3306),
            'database'  => env('DB_DATABASE', 'forge'),
            'username'  => env('DB_USERNAME', 'forge'),
            'password'  => env('DB_PASSWORD', ''),
            'charset'   => env('DB_CHARSET', 'utf8'),
            'collation' => env('DB_COLLATION', 'utf8_unicode_ci'),
            'prefix'    => env('DB_PREFIX', ''),
            'timezone'  => env('DB_TIMEZONE', '+00:00'),
            'strict'    => env('DB_STRICT_MODE', false),
        ],
    ]
//...

Notes

Accessing underlying mysqli instance

There are some inconsistent methods since Laravel only supports PDO officially. You can access the raw, underlying MySQLi instance using the following methods on a connection instance:, (*4)

$mysqli = DB::connection()->getMySqli();
// or
$mysqli = DB::connection()->getReadMySqli();
// or
$mysqli = DB::connection()->getPdo();
// or
$mysqli = DB::connection()->getReadPdo();

Escaping

Unfortunately PHP's mysqli driver does not support named parameter binding so this connector uses custom implementation for it., (*5)

The Versions

13/05 2017

dev-master

9999999-dev http://github.com/shakahl/laravel-eloquent-mysqli

MySQLi driver (connector) for Laravel 5.4 Eloquent database

  Sources   Download

MIT

The Requires

 

The Development Requires

by Soma Szélpål

laravel lumen mysql mysqli driver connector