mireiawen/mysqlie

MySQLi extended

Maintainers

Details

github.com/Mireiawen/mysqlie

Source

Issues

Installs: 81

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 2

Forks: 0

Open Issues: 0

0.3.0 2021-12-09 14:40 UTC

Requires

  • php: >=8.1.0
  • ext-gettext: *
  • ext-mysqli: *

MIT 8bb37bdacd7dcf4af75975f3e7dfedc19d951854

  • Mira Manninen <mir.woop@mireiawen.net>

This package is auto-updated.

Last update: 2024-04-10 02:44:31 UTC

README

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 the AUTO_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