rocketphp/mysqli

Prepared statements - implements MySQLi client.

mysqli

, _(*1)

, _(*2)

RocketPHP\MySQLi uses the MySQL Improved Extension to perform queries on a MySQL database via prepared statements., _(*3)

To perform a query on a database – start with an instance of MySQLi and use the select, insert, update, update many and delete query methods., _(*4)

use RocketPHP\MySQLi\MySQLi;

$mysqli = new MySQLi([
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => '',
    'database' => 'example_db',
    'port'     => null,
]);

$sql = "SELECT * FROM table_name
        WHERE column_name = ?";
$values = array('column_value');
$fmt = array('%s');
$result = $mysqli->select($sql, 
                          $values,
                          $fmt);

• File issues at https://github.com/rocketphp/mysqli/issues
• Documentation is at http://rocketphp.io/mysqli