Interface IAdapter

Direct known implementers

Phramework\Database\PostgreSQL

Indirect known implementers

Phramework\Database\MySQL, Phramework\Database\SQLite

Namespace: Phramework\Database
License: Apache-2.0
Author: Xenofon Spafaridis nohponex@gmail.com
Since: 0.0.0
Located at IAdapter.php

Methods summary

`public string`	# `getAdapterName( )` Get adapter's name Get adapter's name Returns string Adapter's name (lowercase)
`public integer`	# `execute( string $query, array $parameters = [] )` Execute a query and return the row count Execute a query and return the row count Parameters `$query` `$parameters` Returns integer Throws Phramework\Exceptions\DatabaseException
`public integer`	# `executeLastInsertId( string $query, array $parameters = [] )` Execute a query and return last inserted id Execute a query and return last inserted id Parameters `$query` `$parameters` Query parameters Returns integer Returns the number of rows affected or selected Throws Phramework\Exceptions\DatabaseException
`public array`	# `executeAndFetch( string $query, array $parameters = [], $castModel = null )` Execute a query and fetch first row as associative array Execute a query and fetch first row as associative array Parameters `$query` `$parameters` Query parameters `$castModel` Returns array Returns a single row Throws Phramework\Exceptions\DatabaseException
`public array[]`	# `executeAndFetchAll( string $query, array $parameters = [], $castModel = null )` Execute a query and fetch all rows as associative array Execute a query and fetch all rows as associative array Parameters `$query` `$parameters` Query parameters `$castModel` Returns array[] Throws Phramework\Exceptions\DatabaseException
`public array`	# `executeAndFetchArray( string $query, array $parameters = [] )` Execute a query and fetch first row as array Execute a query and fetch first row as array Parameters `$query` `$parameters` Query parameters Returns array Throws Phramework\Exceptions\DatabaseException
`public array[]`	# `executeAndFetchAllArray( string $query, array $parameters = [] )` Parameters `$query` Query string `$parameters` Query parameters Returns array[] Throws Phramework\Exceptions\DatabaseException
`public mixed`	# `bindExecuteLastInsertId( string $query, array $parameters = [] )` Bind Execute a query and return last inserted id Bind Execute a query and return last inserted id Parameters `$query` Query string `$parameters` parameters Returns mixed Throws Phramework\Exceptions\DatabaseException
`public integer`	# `bindExecute( string $query, array $parameters = [] )` Bind Execute a query and return the row count Bind Execute a query and return the row count Parameters `$query` Query string `$parameters` Query parameters Returns integer Throws Phramework\Exceptions\DatabaseException Todo provide documentation
`public array`	# `bindExecuteAndFetch( string $query, array $parameters = [], $castModel = null )` Bind Execute a query and fetch first row as associative array Bind Execute a query and fetch first row as associative array Parameters `$query` Query string `$parameters` Query parameters `$castModel` Returns array Throws Phramework\Exceptions\DatabaseException
`public array[]`	# `bindExecuteAndFetchAll( string $query, array $parameters = [], $castModel = null )` Bind Execute a query and fetch all rows as associative array Bind Execute a query and fetch all rows as associative array Parameters `$query` Query string `$parameters` Query parameters `$castModel` Returns array[] Throws Phramework\Exceptions\DatabaseException
`public`	# `close( )` Close the connection to database Close the connection to database