jrdev/mysql

MySQLi Wrapper for PHP

MySQLi wrapper for PHP.

, _(*1)

Requirements

1. MySQL 5.5 or newer.
2. PHP 5.4 or newer.

Installation

Install the latest version with:, _(*2)

$ composer require jrdev/mysql

How to use

First, connect to a database:, _(*3)

$db = new \jrdev\MySQL('host', 'user', 'pass', 'database');

Next, prepare your data, and call the necessary methods., _(*4)

Generic query method

This method accepts only one param, the SQL to execute.
And returns a jrdev\MySQL\Result object., _(*5)

$query = $db->query('SELECT ...');

A SELECT statement

This method accepts:, _(*6)

1. tableName: The name of the table.
2. fields: (Optional) The fields you want to obtain in the result. Accepts array or string
3. where: (Optional) The where. Accepts array, string or intenger
4. orderBy (Optional) The order by.
5. limit (Optional) The limit.

Returns a jrdev\MySQL\Result object., _(*7)

$query = $db->select('table_name', 'field1, field2');

if ($query)
{
    echo 'Num Rows: ', $query->num_rows, '<br>';

    foreach ($query as $row) 
    {
        echo $row['first_name'], '<br>';
    }
}
else
{
    echo $db->error();
}

// The $where (third param) accepts array, string or integer:
$query = $db->select('table_name', 'field1', ['name' => 'Pepe']); // With array.
$query = $db->select('table_name', 'field1', 'name = "Pepe"'); // With string.
$query = $db->select('table_name', 'field1', 1); // With integer. In this case, the resulting sql for the "WHERE" is "id = 1".

An INSERT statement

This method accepts:, _(*8)

1. tableName: The name of the table.
2. fields: The fields you want to insert.

Returns the ID of the inserted row, or FALSE on error., _(*9)

$inserted_id = $db->insert('table_name', [
    'field1' => 'Value 1',
    'field2' => 2,
]);

An UPDATE statement

This method accepts:, _(*10)

1. tableName: The name of the table.
2. fields: The fields to update.
3. where: The where. Accepts array, string or intenger.
4. limit (Optional) The limit of rows to update.

Returns the number of affected rows, or FALSE on error., _(*11)

// NOTE: The $where (third param) like the select method accepts array, string or integer.

$row = [
    'field1' => 'Value',
];

$updated_rows = $db->update('table_name', $row, ['id' => 58]); // With array.
$updated_rows = $db->update('table_name', $row, 'id=58'); // With string.
$updated_rows = $db->update('table_name', $row, 58); // With integer.

A DELETE statement

This method accepts:, _(*12)

1. tableName: The name of the table.
2. where: The where. Accepts array, string or intenger.
3. limit (Optional) The limit of rows to delete.

Returns the number of affected rows, or FALSE on error., _(*13)

// NOTE: The $where (second param) like the select method accepts array, string or integer.

$deleted_rows = $db->delete('table_name', ['id' => 58]); // With array.
$deleted_rows = $db->delete('table_name', 'id=58'); // With string.
$deleted_rows = $db->delete('table_name', 58); // With integer.

License

Licensed under the MIT licence., _(*14)