jrdev/mysql

This package is abandoned and no longer maintained. No replacement package was suggested.

MySQLi Wrapper for PHP

v1.0.0 2017-07-07 23:35 UTC

Requires

• php: >=5.4

Requires (Dev)

• codeception/codeception: ^2.3
• pdepend/pdepend: ^2.5
• phpmd/phpmd: ^2.6
• squizlabs/php_codesniffer: ^3.0

MIT

• Jose Robinson

• database
• mysql
• wrapper
• mysqli

README

Requirements

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

Installation

Install the latest version with:

$ composer require jrdev/mysql

How to use

First, connect to a database:

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

Next, prepare your data, and call the necessary methods.

Generic query method

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

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

A SELECT statement

This method accepts:

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.

$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:

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.

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

An UPDATE statement

This method accepts:

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.

// 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:

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.

// 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.