Documentation

EasyBlogSql
in package

Table of Contents

Properties

$db  : mixed
$instance  : mixed
$action  : string
Set the last action of the sql
$data  : array<string|int, mixed>
Stores the data internally in index format.
$mode  : string
Set the mode of the sql
$string  : string
Stores the a unparsed Sql

Methods

__construct()  : mixed
__toString()  : mixed
buildExists()  : mixed
clear()  : mixed
START OF USER BUILD FUNCTIONS
column()  : mixed
debug()  : mixed
START OF STRING RETURN FUNCTIONS
delete()  : mixed
exists()  : mixed
factory()  : mixed
getConditionSql()  : mixed
getSql()  : mixed
getTotalSql()  : mixed
group()  : mixed
having()  : mixed
innerjoin()  : mixed
insert()  : mixed
isnull()  : mixed
join()  : mixed
leftjoin()  : mixed
limit()  : mixed
nameQuote()  : mixed
START OF PARSING FUNCTIONS
on()  : mixed
order()  : mixed
parse()  : mixed
quote()  : mixed
raw()  : mixed
rightjoin()  : mixed
select()  : mixed
set()  : mixed
toString()  : mixed
update()  : mixed
values()  : mixed
where()  : mixed
buildCondition()  : mixed
buildDelete()  : mixed
buildDirectives()  : mixed
buildGroup()  : mixed
buildHaving()  : mixed
buildInsert()  : mixed
buildJoin()  : mixed
buildLimit()  : mixed
buildOrder()  : mixed
buildSelect()  : mixed
buildSet()  : mixed
buildSql()  : mixed
START OF INTERNAL BUILDING FUNCTIONS
buildTotal()  : mixed
buildUpdate()  : mixed
buildValues()  : mixed
buildWhere()  : mixed
hasColumnFunction()  : mixed
parseColumnName()  : mixed
parseFunction()  : mixed
parseNameQuote()  : mixed
parseQuote()  : mixed
parseTableName()  : mixed

Properties

$db

public mixed $db = \null

$instance

public static mixed $instance = \null

$action

Set the last action of the sql

private string $action = 'where'

$data

Stores the data internally in index format.

private array<string|int, mixed> $data = array()

$mode

Set the mode of the sql

private string $mode = 'select'

$string

Stores the a unparsed Sql

private string $string = ''

Methods

__construct()

public __construct() : mixed

__toString()

public __toString() : mixed

buildExists()

public buildExists() : mixed

clear()

START OF USER BUILD FUNCTIONS

public clear() : mixed

column()

public column(mixed $column[, mixed $alias = '' ][, mixed $function = '' ][, mixed $psuedo = false ]) : mixed
Parameters
$column : mixed
$alias : mixed = ''
$function : mixed = ''
$psuedo : mixed = false

debug()

START OF STRING RETURN FUNCTIONS

public debug() : mixed

delete()

public delete(mixed $table) : mixed
Parameters
$table : mixed

exists()

public exists(mixed $query) : mixed
Parameters
$query : mixed

factory()

public static factory() : mixed

getConditionSql()

public getConditionSql() : mixed

getSql()

public getSql() : mixed

getTotalSql()

public getTotalSql() : mixed

group()

public group() : mixed

having()

public having(mixed $column[, mixed $value = '' ][, mixed $type = '=' ][, mixed $condition = 'AND' ]) : mixed
Parameters
$column : mixed
$value : mixed = ''
$type : mixed = '='
$condition : mixed = 'AND'

innerjoin()

public innerjoin(mixed $tableName[, mixed $alias = '' ]) : mixed
Parameters
$tableName : mixed
$alias : mixed = ''

insert()

public insert(mixed $table[, mixed $columns = array() ]) : mixed
Parameters
$table : mixed
$columns : mixed = array()

isnull()

public isnull(mixed $column) : mixed
Parameters
$column : mixed

join()

public join(mixed $table, mixed $alias[, mixed $type = 'LEFT' ]) : mixed
Parameters
$table : mixed
$alias : mixed
$type : mixed = 'LEFT'

leftjoin()

public leftjoin(mixed $tableName[, mixed $alias = '' ]) : mixed
Parameters
$tableName : mixed
$alias : mixed = ''

limit()

public limit(mixed $start[, mixed $limit = null ]) : mixed
Parameters
$start : mixed
$limit : mixed = null

nameQuote()

START OF PARSING FUNCTIONS

public nameQuote(mixed $string) : mixed
Parameters
$string : mixed

on()

public on(mixed $columnA[, mixed $columnB = '' ][, mixed $type = '=' ][, mixed $condition = 'AND' ]) : mixed
Parameters
$columnA : mixed
$columnB : mixed = ''
$type : mixed = '='
$condition : mixed = 'AND'

order()

public order(mixed $column[, mixed $direction = 'ASC' ][, mixed $function = '' ]) : mixed
Parameters
$column : mixed
$direction : mixed = 'ASC'
$function : mixed = ''

parse()

public parse(mixed $string) : mixed
Parameters
$string : mixed

quote()

public quote(mixed $string) : mixed
Parameters
$string : mixed

raw()

public raw(mixed $string) : mixed
Parameters
$string : mixed

rightjoin()

public rightjoin(mixed $tableName[, mixed $alias = '' ]) : mixed
Parameters
$tableName : mixed
$alias : mixed = ''

select()

public select(mixed $table[, mixed $alias = '' ]) : mixed
Parameters
$table : mixed
$alias : mixed = ''

set()

public set(mixed $column, mixed $value[, mixed $isValue = true ]) : mixed
Parameters
$column : mixed
$value : mixed
$isValue : mixed = true

toString()

public toString() : mixed

update()

public update(mixed $table[, mixed $alias = '' ]) : mixed
Parameters
$table : mixed
$alias : mixed = ''

values()

public values() : mixed

where()

public where(mixed $column[, mixed $value = '' ][, mixed $type = '=' ][, mixed $condition = 'AND' ]) : mixed
Parameters
$column : mixed
$value : mixed = ''
$type : mixed = '='
$condition : mixed = 'AND'

buildCondition()

private buildCondition(mixed $column, mixed $value[, mixed $type = '=' ]) : mixed
Parameters
$column : mixed
$value : mixed
$type : mixed = '='

buildDelete()

private buildDelete() : mixed

buildDirectives()

private buildDirectives(mixed $directives) : mixed
Parameters
$directives : mixed

buildGroup()

private buildGroup() : mixed

buildHaving()

private buildHaving() : mixed

buildInsert()

private buildInsert() : mixed

buildJoin()

private buildJoin() : mixed

buildLimit()

private buildLimit() : mixed

buildOrder()

private buildOrder() : mixed

buildSelect()

private buildSelect() : mixed

buildSet()

private buildSet() : mixed

buildSql()

START OF INTERNAL BUILDING FUNCTIONS

private buildSql() : mixed

buildTotal()

private buildTotal() : mixed

buildUpdate()

private buildUpdate() : mixed

buildValues()

private buildValues() : mixed

buildWhere()

private buildWhere() : mixed

hasColumnFunction()

private hasColumnFunction(mixed $string) : mixed
Parameters
$string : mixed

parseColumnName()

private parseColumnName(mixed $string) : mixed
Parameters
$string : mixed

parseFunction()

private parseFunction(mixed $function, mixed $column) : mixed
Parameters
$function : mixed
$column : mixed

parseNameQuote()

private parseNameQuote(mixed $string) : mixed
Parameters
$string : mixed

parseQuote()

private parseQuote(mixed $string) : mixed
Parameters
$string : mixed

parseTableName()

private parseTableName(mixed $string) : mixed
Parameters
$string : mixed 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results