\duncan3dc\SqlClassSql

addServer()

addServer( $server, array $options)

Parameters

getInstance()

getInstance( $server)

Parameters

getNewInstance()

getNewInstance( $server)

Parameters

__construct()

__construct(array $options)

Parameters

connect()

connect()

If we have not already connected then connect to the database now

definitions()

definitions( $data)

Parameters

attachDatabase()

attachDatabase( $filename,  $database)

Attach another sqlite database to the current connection

Parameters

query()

query( $query, array $params)

Execute an sql query

Parameters

cache()

cache( $query, array $params,  $timeout)

Convienience method to create a cached query instance

Parameters

getError()

getError()

update()

update( $table, array $set,  $where)

Parameters

insert()

insert( $table, array $params,  $extra)

Parameters

bulkInsert()

bulkInsert( $table, array $params,  $extra)

Parameters

getId()

getId(\duncan3dc\SqlClass\AbstractResult $result)

Parameters

where()

where( $where,  $params)

Convert an array of parameters into a valid where clause

Parameters

selectFields()

selectFields( $fields)

Convert an array/string of fields into a valid select clause

Parameters

delete()

delete( $table,  $where)

Parameters

_fetch()

_fetch(\duncan3dc\SqlClass\AbstractResult $result)

Fetch the next row from the result set

Parameters

fetch()

fetch(\duncan3dc\SqlClass\AbstractResult $result,  $style)

Fetch the next row from the result set and clean it up

Parameters

result()

result(\duncan3dc\SqlClass\AbstractResult $result,  $row,  $col)

Fetch an indiviual value from the result set

Parameters

seek()

seek(\duncan3dc\SqlClass\AbstractResult $result,  $row)

Seek to a specific record of the result set

Parameters

queryFetch()

queryFetch( $query,  $params,  $style)

Execute the query and fetch the first row from the result set This is just a shorter way of doing a query() and then a fetch()

Parameters

queryFetchC()

queryFetchC( $query,  $params,  $style)

Cached version of queryFetch()

Parameters

queryResult()

queryResult( $query,  $params,  $row,  $col)

Execute the query and get a specific value from the result set This is just a shorter way of doing a query() and then a result()

Parameters

queryResultC()

queryResultC( $query,  $params,  $row,  $col)

Cached version of queryResult()

Parameters

select()

select( $table,  $where,  $orderBy)

Grab the first row from a table using the standard select statement This is a convience method for a fieldSelect() where all fields are required

Parameters

selectC()

selectC( $table,  $where,  $orderBy)

Cached version of select()

Parameters

fieldSelect()

fieldSelect( $table,  $fields,  $where,  $orderBy)

Grab specific fields from the first row from a table using the standard select statement

Parameters

fieldSelectC()

fieldSelectC( $table,  $fields,  $where,  $orderBy)

Parameters

selectAll()

selectAll( $table,  $where,  $orderBy)

Create a standard select statement and return the result This is a convience method for a fieldSelectAll() where all fields are required

Parameters

selectAllC()

selectAllC( $table,  $where,  $orderBy)

Parameters

fieldSelectAll()

fieldSelectAll( $table,  $fields,  $where,  $orderBy)

Create a standard select statement and return the result

Parameters

fieldSelectAllC()

fieldSelectAllC( $table,  $fields,  $where,  $orderBy)

Parameters

insertOrUpdate()

insertOrUpdate( $table, array $set, array $where)

Insert a new record into a table, unless it already exists in which case update it

Parameters

updateOrInsert()

updateOrInsert( $table, array $set, array $where)

Synonym for insertOrUpdate()

Parameters

orderBy()

orderBy( $fields)

Create an order by clause from a string of fields or an array of fields

Parameters

search()

search( $query, array $params,  $search, array $fields)

This method allows easy appending of search criteria to queries It takes existing query/params to be edited as the first 2 parameters The third parameter is the string that is being searched for The fourth parameter is an array of fields that should be searched for in the sql

Parameters

startTransaction()

startTransaction()

Start a transaction by turning autocommit off

endTransaction()

endTransaction( $commit)

End a transaction by either committing changes made, or reverting them

Parameters

commit()

commit()

Commit queries without ending the transaction

rollback()

rollback()

Rollback queries without ending the transaction

lockTables()

lockTables( $tables)

Lock some tables for exlusive write access But allow read access to other processes

Parameters

unlockTables()

unlockTables()

Unlock all tables previously locked

addTrigger()

addTrigger( $type,  $table, callable $trigger)

Register a trigger to be called when a query is run using one of the built in methods (update/insert/delete)

Parameters

getDatabases()

getDatabases()

getTables()

getTables( $database)

Parameters

getViews()

getViews( $database)

Parameters

disconnect()

disconnect()

Close the sql connection

__destruct()

__destruct()

Automatically close the connection on destruction

getTableDatabase()

getTableDatabase( $name)

Get the database that should be used for this table

Parameters

getTableName()

getTableName( $name,  $database)

Get the full table name (including database) If the database isn't passed then look it up first

Parameters

modifyQuery()

modifyQuery( $query, callable $callback)

Parameters

quoteChars()

quoteChars( $query)

Replace any quote characters used to the appropriate type for the current mode This function attempts to ignore any instances that are surrounded by single quotes, as these should not be converted

Parameters

functions()

functions( $query)

Replace any non-standard functions with the appropriate function for the current mode

Parameters

limit()

limit( $query)

Convert any limit usage Doesn't work with the mssql variety

Parameters

tableNames()

tableNames( $query)

Convert table references to full database/table names This allows tables to be surrounded in braces, without specifying the database

Parameters

paramArrays()

paramArrays( $query,  $params)

If any of the parameters are arrays, then convert the single marker from the query to handle them

Parameters

namedParams()

namedParams( $query,  $params)

If the params array uses named keys then convert them to the regular markers

Parameters

convertNulls()

convertNulls( $params)

Parameters

prepareQuery()

prepareQuery( $query,  $params)

Parameters

error()

error()

logError()

logError()

quoteField()

quoteField( $field)

Quote a field with the appropriate characters for this mode

Parameters

quoteTable()

quoteTable( $table)

Quote a table with the appropriate characters for this mode

Parameters

callTriggers()

callTriggers( $type,  $table,  $params1,  $params2)

Call any triggers that were previously registered using addTrigger()

Parameters