Download the PHP package bentools/mysqliextended without Composer

This package is abandonned. Consider upgrading to bentools/simple-dbal, which can handle PDO and Mysqli connections as well, and favors composition over inheritance.

MySqli Extended

A better experience of PHP MySqli.

Shortcuts

BenTools\MySqliExtended\MySqliExtended is a child class of \MySqli. It has several shortcut methods to fetch data :

• sqlArray() -> fetch a multi-dimensionnal array, basically several rows in a table.
• sqlRow() -> fetch an associative array, for example a row.
• sqlColumn() -> fetch the 1st column as an indexed array.
• sqlValue() -> fetch a specific value.

Prepared Statements

Working with prepared statements is now easier than before :

You no longer need to create variables, create references and create a weird type-hinting string, i.e. 'ssi'.

You can also use named parameters (like with PDO), that you can duplicate in the same query :

Easily work with prepared statements.

Installation

Add the following line into your composer.json :

{
    "require": {
        "bentools/mysqliextended": "1.0.x"
    }
}  

Enjoy.