MysqlHandler

MMO\pdo · 1 symbol · generated 5 Oct 2026

class

MysqlHandler

class MMO\pdo\MysqlHandler extends MMO\pdo\classes\aHandler

Namespace: MMO\pdo
Extends: aHandler

Index

	database
	host
	password
	port
	user
	utf8
	configureStatement($statement)
	connect()
	CreateDatabase($name, $host, $rootUser, $rootPassword, $port, $dbUser, $dbPassword) static
	getDatabase()
	getHost()	Get the column type as a json type: integer, number, string, null, boolean, array, object, byte, date, date-time, json
	getHref()
	getPassword()
	getPort()
	getUser()
	isUtf8()
	table($name)
	tableExists($name, $usePrefix)
	tables()
	__construct($host, $database, $user, $password, $port, $utf8)

Properties6

database

protected string $database

Type: string

host

protected string $host

Type: string

password

protected string $password

Type: string

port

protected ?string $port = null

Type: null | string

user

protected string $user

Type: string

utf8

protected bool $utf8 = true

Type: bool

Methods14

configureStatement($statement)

MysqlHandler.php:61

function configureStatement(MMO\pdo\statements\Statement $statement): MMO\pdo\statements\Statement

$statement	Statement
returns	Statement

connect()

MysqlHandler.php:51

function connect(): void

returns

void

CreateDatabase($name, $host, $rootUser, $rootPassword, $port, $dbUser, $dbPassword)

staticMysqlHandler.php:19

static function CreateDatabase( string $name, string $host, string $rootUser, string $rootPassword, ?string $port = null, ?string $dbUser = null, ?string $dbPassword = null ): void

$name	string
$host	string
$rootUser	string
$rootPassword	string
$port = null	null \| string
$dbUser = null	null \| string
$dbPassword = null	null \| string
returns	void

getDatabase()

MysqlHandler.php:168

function getDatabase(): string

returns

string

getHost()

MysqlHandler.php:164

Get the column type as a json type: integer, number, string, null, boolean, array, object, byte, date, date-time, json

function getHost(): string

returns

string

getHref()

MysqlHandler.php:67

function getHref(): string

returns

string

getPassword()

MysqlHandler.php:176

function getPassword(): string

returns

string

getPort()

MysqlHandler.php:184

function getPort(): string

returns

string

getUser()

MysqlHandler.php:172

function getUser(): string

returns

string

isUtf8()

MysqlHandler.php:180

function isUtf8(): bool

returns

bool

table($name)

MysqlHandler.php:89

function table(string $name): MMO\pdo\helpers\Table

$name	string
returns	Table

tableExists($name, $usePrefix)

MysqlHandler.php:72

function tableExists(string $name, bool $usePrefix = true): bool

$name	string
$usePrefix = true	bool
returns	bool

tables()

MysqlHandler.php:78

function tables(): array

returns

array

__construct($host, $database, $user, $password, $port, $utf8)

MysqlHandler.php:42

function __construct( string $host, string $database, string $user, string $password, ?string $port = null, bool $utf8 = true )

$host	string
$database	string
$user	string
$password	string
$port = null	null \| string
$utf8 = true	bool

Inherited members (63)

Constants	Declared by	Description
`ALERT`	iLogLevel	Alert: Action must be taken immediately.
`ALL`	iLogLevel	Mask for all
`ALL_PLUS`	iLogLevel	debug everything
`BACKTRACE`	iLogLevel
`CRITICAL`	iLogLevel	Critical: Critical conditions.
`DEBUG`	iLogLevel	Debug: Detailed debug information.
`DEEP`	iLogLevel	debug everything with arguments
`EMERGENCY`	iLogLevel	Emergency: System is unusable.
`ERROR`	iLogLevel	Error: Runtime errors that do not require immediate action but should typically be logged and monitored.
`ERROR_PLUS`	iLogLevel	Mask for all error
`FATAL`	iLogLevel	Mask for all fatal error
`INFO`	iLogLevel	Info: Interesting events.
`INFO_PLUS`	iLogLevel	Mask for all errors/warning/notices/info
`MEMORY`	iLogLevel	include backtrace object
`NOTICE`	iLogLevel	Notice: Normal but significant events.
`NOTICE_PLUS`	iLogLevel	Mask for all errors/warning/notices/info
`TRACE`	iLogLevel	include backtrace as origins
`WARNING`	iLogLevel	Warning: Exceptional occurrences that are not errors.
`WARNING_PLUS`	iLogLevel	Mask for all errors and warnings

Properties	Declared by	Description
`handle`	aHandler	Handle to sql object
`tablePrefix`	aHandler
`tables`	aHandler
`transCount`	aHandler
`verbosity`	aHandler

Methods	Declared by	Description
`addTable($table, $name)`	aHandler
`addTableClass($class, $name)`	aHandler
`alert($message, $context)`	aHandler	Action must be taken immediately.
`backtraces($message, $context)`	aHandler	Force-log a message at INFO level together with a full stack trace/memory snapshot (`iLogLevel::BACKTRACE`), bypassing the verbosity mask entirely (any non-zero verbosity is enough to trigger it).
`commit()`	aHandler	Alias to \PDO::commit().
`createStatement($table, $fields, $primary, $index)`	aHandler
`critical($message, $context)`	aHandler	Critical conditions. No-op if CRITICAL is currently filtered out by the verbosity mask.
`debug($message, $context)`	aHandler	Detailed debug information.
`debugName()`	aHandler	Human-readable identifier used as the default `{origin}` in this instance's log messages.
`deleteStatement($table, $filter)`	aHandler
`disconnect()`	aHandler
`do($fn)`	aHandler	do a safe transaction on the database if an exception is thrown, it rollbacks the database
`dropStatement($table, $ifExists)`	aHandler
`emergency($message, $context)`	aHandler	System is unusable. No-op if EMERGENCY is currently filtered out by the verbosity mask.
`endTransaction()`	aHandler	Unwind one level of `startTransaction`, without committing or rolling anything back.
`error($message, $context)`	aHandler	Runtime errors that do not require immediate action but should typically be logged and monitored.
`getHandle()`	aHandler
`getTables()`	aHandler
`getVerbosity()`	aHandler
`hasTable($table)`	aHandler
`info($message, $context)`	aHandler	Interesting events. No-op if INFO is currently filtered out by the verbosity mask.
`insertStatement($table, $values)`	aHandler
`inTransaction()`	aHandler
`isConnected()`	aHandler
`lastId()`	aHandler	Return last id in insert.
`log($level, $message, $context)`	aHandler	Logs with an arbitrary level.
`notice($message, $context)`	aHandler	Normal but significant events.
`prepare($query)`	aHandler	Prepare a pdo statement
`removeTable($table)`	aHandler
`rollBack()`	aHandler	Abort the whole transaction, whatever the nesting depth: SQL has no partial rollback without savepoints, so one rollback discards every level at once and resets `$transCount` to zero.
`selectStatement($table, $fields, $filter)`	aHandler
`setVerbosity($verb)`	aHandler	Set the current verbosity mask, replacing whatever it was before.
`startTransaction()`	aHandler	Safe Alias to \PDO::beginTranscation() if inside another transaction, doesn't throw an exception and ignore call.
`statement($template, $content, $opts)`	aHandler
`testVerbosity($level)`	aHandler	Test whether a given level (or set of levels) is currently enabled by this instance's verbosity mask.
`updateStatement($table, $values, $filter)`	aHandler
`warning($message, $context)`	aHandler	Exceptional occurrences that are not errors.
`__destruct()`	aHandler
`__wakeup()`	aHandler