Documentation

Query
in package

Table of Contents

Properties

$sql  : string
$statement  : PDOStatement|null

Methods

deleteFrom()  : Query
drop()  : Query
execute()  : Query
executeWith()  : Query
fetch()  : mixed
fetchAll()  : array<string|int, array<string|int, mixed>>
fetchAllFrom()  : array<string|int, array<string|int, mixed>>
fetchFrom()  : mixed
fromSqlFile()  : Query
fromString()  : Query
getSQL()  : string
getStatement()  : PDOStatement
insertInto()  : Query
prepare()  : Query
selectAllFrom()  : Query
selectRowFrom()  : Query
truncate()  : Query
updateIn()  : Query
__construct()  : mixed

Properties

$statement

private PDOStatement|null $statement = null

Methods

deleteFrom()

public static deleteFrom(Table $table[, string $primaryKey = 'id' ]) : Query
Parameters
$table : Table
$primaryKey : string = 'id'
Return values
Query

execute()

public execute([array<string, mixed>|array<string|int, mixed>|null $params = null ]) : Query
Parameters
$params : array<string, mixed>|array<string|int, mixed>|null = null
Return values
Query

executeWith()

public executeWith(PDO $pdo[, array<string, mixed>|array<string|int, mixed>|null $params = null ]) : Query
Parameters
$pdo : PDO
$params : array<string, mixed>|array<string|int, mixed>|null = null
Return values
Query

fetch()

public fetch([int $mode = PDO::FETCH_ASSOC ]) : mixed
Parameters
$mode : int = PDO::FETCH_ASSOC

fetchAll()

public fetchAll([int $mode = PDO::FETCH_ASSOC ]) : array<string|int, array<string|int, mixed>>
Parameters
$mode : int = PDO::FETCH_ASSOC
Return values
array<string|int, array<string|int, mixed>>

fetchAllFrom()

public fetchAllFrom(PDO $pdo[, array<string, mixed>|array<string|int, mixed>|null $params = null ][, int $mode = PDO::FETCH_ASSOC ]) : array<string|int, array<string|int, mixed>>
Parameters
$pdo : PDO
$params : array<string, mixed>|array<string|int, mixed>|null = null
$mode : int = PDO::FETCH_ASSOC
Return values
array<string|int, array<string|int, mixed>>

fetchFrom()

public fetchFrom(PDO $pdo[, array<string, mixed>|array<string|int, mixed>|null $params = null ][, int $mode = PDO::FETCH_ASSOC ]) : mixed
Parameters
$pdo : PDO
$params : array<string, mixed>|array<string|int, mixed>|null = null
$mode : int = PDO::FETCH_ASSOC

fromSqlFile()

public static fromSqlFile(string $pathToFile) : Query
Parameters
$pathToFile : string
Return values
Query

fromString()

public static fromString(string $sqlString) : Query
Parameters
$sqlString : string
Return values
Query

getSQL()

public getSQL() : string
Return values
string

getStatement()

public getStatement() : PDOStatement
Return values
PDOStatement

prepare()

public prepare(PDO $pdo) : Query
Parameters
$pdo : PDO
Return values
Query

updateIn()

public static updateIn(Table $table[, string $primaryKey = 'id' ]) : Query
Parameters
$table : Table
$primaryKey : string = 'id'
Return values
Query

__construct()

private __construct(string $sql) : mixed
Parameters
$sql : string 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results