Overview

Namespaces

  • zsql
  • PHP

Classes

  • Database
  • Delete
  • Expression
  • ExtendedQuery
  • Insert
  • Model
  • Query
  • Result
  • Select
  • Update

Exceptions

  • Exception
  • Overview
  • Namespace
  • Class
  • Tree

Class Database

Namespace: zsql
Located at zsql/Database.php
Methods summary
public
# __construct( mysqli $connection )

Construct a new database object.

Construct a new database object.

Parameters

$connection
mysqli
$connection
public
# __destruct( )

Close the mysql connection on destruct

Close the mysql connection on destruct

public integer
# getAffectedRows( )

Get affected rows

Get affected rows

Returns

integer
public mysqli
# getConnection( )

Exposes the local connection object

Exposes the local connection object

Returns

mysqli
public zsql\Database
# setConnection( mysqli $connection = null )

Sets the local mysqli object

Sets the local mysqli object

Parameters

$connection
mysqli
$connection

Returns

zsql\Database
public integer
# getInsertId( )

Get the last insert ID

Get the last insert ID

Returns

integer
public integer
# getQueryCount( )

Gets number of queries run using this adapter.

Gets number of queries run using this adapter.

Returns

integer
public zsql\Select
# select( )

Wrapper for \zsql\Select

Wrapper for \zsql\Select

Returns

zsql\Select
public zsql\Insert
# insert( )

Wrapper for \zsql\Insert

Wrapper for \zsql\Insert

Returns

zsql\Insert
public zsql\Update
# update( )

Wrapper for \zsql\Update

Wrapper for \zsql\Update

Returns

zsql\Update
public zsql\Delete
# delete( )

Wrapper for \zsql\Delete

Wrapper for \zsql\Delete

Returns

zsql\Delete
public Engine\Database\Result|mixed
# query( string|zsql\Query $query, string $resultmode = MYSQLI_STORE_RESULT )

Executes an SQL query

Executes an SQL query

Parameters

$query
string|zsql\Query
$query
$resultmode
string
$resultmode

Returns

Engine\Database\Result|mixed
public string
# quote( string $value )

Quote a raw string

Quote a raw string

Parameters

$value
string
$value

Returns

string
Properties summary
protected integer $affectedRows
#
protected mysqli $connection
#
protected integer $insertId
#
protected integer $queryCount 0
#

Holds the total number of queries ran for the database object's lifetime.

Holds the total number of queries ran for the database object's lifetime.

API documentation generated by ApiGen 2.8.0