PHPFUI/InstaDoc
 
Copied!
Instantiable
Constants
public PDO::ATTR_AUTOCOMMIT = 0
public PDO::ATTR_CASE = 8
public PDO::ATTR_CLIENT_VERSION = 5
public PDO::ATTR_CONNECTION_STATUS = 7
public PDO::ATTR_CURSOR = 10
public PDO::ATTR_CURSOR_NAME = 9
public PDO::ATTR_DEFAULT_FETCH_MODE = 19
public PDO::ATTR_DEFAULT_STR_PARAM = 21
public PDO::ATTR_DRIVER_NAME = 16
public PDO::ATTR_EMULATE_PREPARES = 20
public PDO::ATTR_ERRMODE = 3
public PDO::ATTR_FETCH_CATALOG_NAMES = 15
public PDO::ATTR_FETCH_TABLE_NAMES = 14
public PDO::ATTR_MAX_COLUMN_LEN = 18
public PDO::ATTR_ORACLE_NULLS = 11
public PDO::ATTR_PERSISTENT = 12
public PDO::ATTR_PREFETCH = 1
public PDO::ATTR_SERVER_INFO = 6
public PDO::ATTR_SERVER_VERSION = 4
public PDO::ATTR_STATEMENT_CLASS = 13
public PDO::ATTR_STRINGIFY_FETCHES = 17
public PDO::ATTR_TIMEOUT = 2
public PDO::CASE_LOWER = 2
public PDO::CASE_NATURAL = 0
public PDO::CASE_UPPER = 1
public PDO::CURSOR_FWDONLY = 0
public PDO::CURSOR_SCROLL = 1
public PDO::ERR_NONE = '00000'
public PDO::ERRMODE_EXCEPTION = 2
public PDO::ERRMODE_SILENT = 0
public PDO::ERRMODE_WARNING = 1
public PDO::FETCH_ASSOC = 2
public PDO::FETCH_BOTH = 4
public PDO::FETCH_BOUND = 6
public PDO::FETCH_CLASS = 8
public PDO::FETCH_CLASSTYPE = 262144
public PDO::FETCH_COLUMN = 7
public PDO::FETCH_DEFAULT = 0
public PDO::FETCH_FUNC = 10
public PDO::FETCH_GROUP = 65536
public PDO::FETCH_INTO = 9
public PDO::FETCH_KEY_PAIR = 12
public PDO::FETCH_LAZY = 1
public PDO::FETCH_NAMED = 11
public PDO::FETCH_NUM = 3
public PDO::FETCH_OBJ = 5
public PDO::FETCH_ORI_ABS = 4
public PDO::FETCH_ORI_FIRST = 2
public PDO::FETCH_ORI_LAST = 3
public PDO::FETCH_ORI_NEXT = 0
public PDO::FETCH_ORI_PRIOR = 1
public PDO::FETCH_ORI_REL = 5
public PDO::FETCH_PROPS_LATE = 1048576
public PDO::FETCH_SERIALIZE = 524288
public PDO::FETCH_UNIQUE = 196608
public PDO::MYSQL_ATTR_COMPRESS = 1003
public PDO::MYSQL_ATTR_DIRECT_QUERY = 1004
public PDO::MYSQL_ATTR_FOUND_ROWS = 1005
public PDO::MYSQL_ATTR_IGNORE_SPACE = 1006
public PDO::MYSQL_ATTR_INIT_COMMAND = 1002
public PDO::MYSQL_ATTR_LOCAL_INFILE = 1001
public PDO::MYSQL_ATTR_LOCAL_INFILE_DIRECTORY = 1015
public PDO::MYSQL_ATTR_MULTI_STATEMENTS = 1013
public PDO::MYSQL_ATTR_SERVER_PUBLIC_KEY = 1012
public PDO::MYSQL_ATTR_SSL_CA = 1009
public PDO::MYSQL_ATTR_SSL_CAPATH = 1010
public PDO::MYSQL_ATTR_SSL_CERT = 1008
public PDO::MYSQL_ATTR_SSL_CIPHER = 1011
public PDO::MYSQL_ATTR_SSL_KEY = 1007
public PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT = 1014
public PDO::MYSQL_ATTR_USE_BUFFERED_QUERY = 1000
public PDO::NULL_EMPTY_STRING = 1
public PDO::NULL_NATURAL = 0
public PDO::NULL_TO_STRING = 2
public PDO::PARAM_BOOL = 5
public PDO::PARAM_EVT_ALLOC = 0
public PDO::PARAM_EVT_EXEC_POST = 3
public PDO::PARAM_EVT_EXEC_PRE = 2
public PDO::PARAM_EVT_FETCH_POST = 5
public PDO::PARAM_EVT_FETCH_PRE = 4
public PDO::PARAM_EVT_FREE = 1
public PDO::PARAM_EVT_NORMALIZE = 6
public PDO::PARAM_INPUT_OUTPUT = 2147483648
public PDO::PARAM_INT = 1
public PDO::PARAM_LOB = 3
public PDO::PARAM_NULL = 0
public PDO::PARAM_STMT = 4
public PDO::PARAM_STR = 2
public PDO::PARAM_STR_CHAR = 536870912
public PDO::PARAM_STR_NATL = 1073741824
public PDO::SQLITE_ATTR_EXTENDED_RESULT_CODES = 1002
public PDO::SQLITE_ATTR_OPEN_FLAGS = 1000
public PDO::SQLITE_ATTR_READONLY_STATEMENT = 1001
public PDO::SQLITE_DETERMINISTIC = 2048
public PDO::SQLITE_OPEN_CREATE = 4
public PDO::SQLITE_OPEN_READONLY = 1
public PDO::SQLITE_OPEN_READWRITE = 2
Methods
public __construct(string $dsn, ?string $username = NULL, ?string $password = NULL, ?array $options = NULL)
 
  • param ?array<string,string> $options
public beginTransaction() : bool
 

Clears an existing errors and begins a transaction

public PDO::commit()
public describeTable(string $table) : array
 
  • return \PHPFUI\ORM\Schema\Field[]
public PDO::errorCode()
public PDO::errorInfo()
public PDO::exec(string $statement)
public execute(string $sql, array $input = []) : bool
 

Executes the SQL string using the matching $input array

  • param array $input
  • return bool status of command run
public executeStatement(PDOStatement $statement, array $input = []) : ?PDOStatement
 

Executes the query and catches any errors

  • param array $input
public getArrayCursor(string $sql = 'select 0 limit 0', array $input = []) : PHPFUI\ORM\ArrayCursor
 
  • param array $input
  • return \PHPFUI\ORM\ArrayCursor tracking the sql and input passed
public PDO::getAttribute(int $attribute)
public static PDO::getAvailableDrivers()
public getDataObjectCursor(string $sql = 'select 0 limit 0', array $input = []) : PHPFUI\ORM\DataObjectCursor
 
  • param array $input
  • return \PHPFUI\ORM\DataObjectCursor tracking the sql and input passed
public getDSN() : string
public getIndexes(string $table) : array
 
  • return \PHPFUI\ORM\Schema\Index[]
public getLastError() : string
 
  • return string error string from the most recent operation
public getLastErrorCode() : int
 
  • return int error code from the most recent operation
public getLastErrors() : array
 
  • return array<string,string>[] all errors since the last transaction or last time cleared
public getLastParameters() : array
 
  • return array parameters from the last operation
public getLastSql() : string
 
  • return string SQL statement with the ? inserted
public getRecordCursor(PHPFUI\ORM\Record $crud, string $sql = 'select 0 limit 0', array $input = []) : PHPFUI\ORM\RecordCursor
 
  • param array $input
  • return \PHPFUI\ORM\RecordCursor tracking the sql and input passed
public getRow(string $sql, array $input = []) : array
 
  • param array $input
  • return array<string,string> a single row of the first matching record or an empty array if an error
public getRows(string $sql, array $input = [], int $fetchType = 2PDO::FETCH_ASSOC) : array
 

Similar to getArrayCursor except returns a fully populated array

It is recommended to use getArrayCursor if you don't need array functionality

  • param array $input
  • return array<string,string>[]
public getTables() : array
 
  • return string[]
public getValue(string $sql, array $input = []) : string
 
  • param array $input
  • return string value returned from the first field in the first row returned by the querry, or blank if error
public getValueArray(string $sql, array $input = []) : array
 
  • param array $input
  • return array of the first value in each row from the query
public PDO::inTransaction()
public PDO::lastInsertId(?string $name = NULL)
public log(string $level, string $message, array $context = []) : void
 

Logs array of errors via logger

  • param array $context
public PDO::prepare(string $query, array $options = [])
public PDO::query(string $query, ?int $fetchMode = NULL, ?mixed $fetchModeArgs)
public PDO::quote(string $string, int $type = 2PDO::PARAM_STR)
public reportErrors() : void
 

Logs errors and clears error log

public PDO::rollBack()
public PDO::setAttribute(int $attribute, ?mixed $value)
Properties
private string $dsn
private array $lastError = []
 
  • var string[]
private int $lastErrorCode = 0
private array $lastErrors = []
 
  • var array<string,string>[]
private array $lastParameters = []
 
  • var array
private string $lastSql = ''
Methods
private run(string $sql, array $input = []) : ?PDOStatement
 

Runs the query and sets and records errors

  • param array $input
Methods
public static PDO::getAvailableDrivers()
© 2024 Bruce Wells
Search Namespaces \ Classes
Configuration