DALMP\Database

The DALMP\Database class contains a set of methods that allow to query a database in a more easy and secure way.

The next table contains, 5 common methods for retrieving data:

Name	Normal	Prepared Statements	Cache Normal	Cache Prepared Statements
all	GetAll	PGetAll	CacheGetAll	CachePGetAll
assoc	GetAssoc	PGetAssoc	CacheGetAssoc	CachePGetAssoc
col	GetCol	PGetCol	CacheGetCol	CachePGetCol
one	GetOne	PGetOne	CacheGetOne	CachePGetOne
row	GetRow	PGetRow	CacheGetRow	CachePGetRow

See also

DALMP\Cache

Any query or either for Inserting or Updating:

Name	Normal	Prepared statements
Execute	Execute	PExecute

See also

Prepared statements

The available methods are:

• AutoExecute
  • Parameters
  • Examples
• Cache
  • DSN Cache format
  • The Cache methods
  • Constants
  • How to use
  • Parameters
  • TTL example
  • Custom key example
  • Group caching, group:X
• CacheFlush
  • Parameters
  • Examples
• Close
• CompleteTrans
  • Example
• __construct
  • DSN format
  • Examples
• csv
  • Parameters
  • Example
• debug
  • Parameters
  • Constants
  • Example
• ErrorMsg
  • Example
• ErrorNum
  • Example
• Execute
  • Parameters
  • Examples
• FetchMode
  • Parameters
  • Examples
  • Chainable example
  • ASSOC mode, example
  • No mode
• forceTruncate
  • Parameters
  • Example
• getAll / PgetAll
  • Parameters
  • Prepared statements Parameters
  • Example
• getASSOC / PgetASSOC
  • Parameters
  • Prepared statements Parameters
  • Example
• getCol / PgetCol
  • Parameters
  • Prepared statements Parameters
  • Example
• getOne / PGetOne
  • Parameters
  • Prepared statements Parameters
  • Example
• getRow / PgetRow
  • Parameters
  • Prepared statements Parameters
  • Example
• getClientVersion
  • Example
• getColumnNames
  • Parameters
  • Example
• getNumOfFields
  • Example
• getNumOfRows
  • Example
• getNumOfRowsAffected
• getServerVersion
  • Example
• Insert_Id
  • Example
• isConnected
• map
  • Parameters
  • Example
• multipleInsert
  • Parameters
  • Example
• PClose
• PExecute
  • Parameters
  • Examples
• Pquery
  • Parameters
  • Example
• Prepare
  • Parameters
  • Example
• qstr
  • Parameters
  • Example
• Query
  • Example
• renumber
  • Parameters
  • Example
• RollBackTrans
  • Example
• StartTrans
  • Example
• useCache
  • Parameters
  • Example
• UUID
  • Parameters
  • Examples
• X
  • Example

Thanks Navicat for supporting Open Source projects.

A great amount of time has been spent creating, crafting and maintaining this software, please consider donating.

Donating helps ensure continued support, development and availability.

comments powered by Disqus