Download the PHP package mireiawen/mysqlie without Composer
On this page you can find all versions of the php package mireiawen/mysqlie. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package mysqlie
MySQLie
Extended MySQLi classes. All of the methods that can return error, should throw exceptions when and only error occurs.
There are also some custom methods added to make some tasks easier.
- Classes:
MySQLie
,MySQLie_stmt
- Namespace:
Mireiawen\MySQLie
Requirements
- MySQL Native Driver (mysqlnd)
- PHP 7
Installation
You can clone or download the code from the GitHub repository or you can use composer: composer require mireiawen/mysqlie
Methods
Only the custom methods are listed here, the overridden methods should behave like the original methods, except that the errors are thrown.
Class MySQLie
The main MySQLie class
escape_identifier
MySQLie::escape_identifier(string $name)
Escape an identifier name for the SQL query
Arguments
- string
$name
- The identifier name to escape
Return value
- string - The escaped identifier name
escape_query_identifiers
MySQLie::escape_query_identifiers(string $sql, array $identifiers)
Escape the identifiers in the SQL query
Arguments
- string $sql - SQL query with placeholders (
%s
) for the identifiers - string[] $identifiers - Array of the identifiers to be escaped and placed into the query
Return value
- string - The SQL query with identifiers escaped and placed into the query
foreign_key_checks
MySQLie::foreign_key_checks(bool $state)
Set the foreign key checks on or off
Arguments
- bool $state - TRUE to enable foreign key checks, FALSE to disable them
Exceptions thrown
\Exception
- In case of database errors
get_autocommit
MySQLie::get_autocommit()
Return value
- bool - The current
AUTOCOMMIT
status, TRUE if it is on, FALSE if it is off
Exceptions thrown
\Exception
- In case of database errors
get_autoincrement
MySQLie::get_autoincrement(string $table)
Get the table auto increment value
Arguments
- string
$table
- The name of the table to get theAUTO_INCREMENT
value from
Return value
- int - The value of the table
AUTO_INCREMENT
Exceptions thrown
\Exception
- In case of database errors
truncate
MySQLie::truncate(string $table)
Truncates the given table to zero rows
Arguments
- string
$table
- Name of the table to be truncated
Exceptions thrown
\Exception
- In case of database errors
MySQLie_stmt
fetch_assoc
MySQLie_stmt::fetch_assoc()
Fetch the result as an associative array
Return value
- array - An array of result rows
Exceptions thrown
\Exception
- In case of database errors
fetch_first
MySQLie_stmt::fetch_first()
Fetch the first row of the statement and return the result as an associative array
Return value
- array - A result row as an associative array
Exceptions thrown
\Exception
- In case of database errors
All versions of mysqlie with dependencies
ext-gettext Version *
ext-mysqli Version *