Avi documentation

Db
in package

Table of Contents

Properties

$oc  : mixed
$connection  : mixed
$debug  : mixed
$log  : mixed

Methods

__construct()  : mixed
__destruct()  : mixed
add()  : bool|array<string|int, mixed>|int
Alias of insert
del()  : bool|array<string|int, mixed>|int
Alias of del query
delete()  : bool|array<string|int, mixed>|int
Execite am DELETE query
exec()  : bool|int|array<string|int, mixed>
Execute query
get()  : bool|array<string|int, mixed>|int
Alias of select
getDebug()  : mixed
getLastId()  : bool|int
Return the last inserted id from table
getOneRow()  : bool
Return only one row (1st one) - usefull when search something specific
insert()  : bool|array<string|int, mixed>|int
Execute an insert query
isOpen()  : mixed
parse()  : array<string|int, mixed>|string
Parsing the query from array to string
parseTableFromValues()  : string
Return an mysql synthax temporary table based on values
parseVar()  : mixed
Parsing a variable value to be included in the querystring
parseVars()  : array<string|int, mixed>
Similar with parse var but used to Parse multiple variables
select()  : bool|array<string|int, mixed>|int
Execute a select query
set()  : bool|array<string|int, mixed>|int
Alias of update
update()  : bool|array<string|int, mixed>|int
Execute an UPDATE query
encloseInBacktick()  : string
Parse element and include it in Backtick
connect()  : bool
Connection to database server
getPatternFromQuery()  : mixed
parseDelete()  : string
Parse delete query
parseInsert()  : string
Parse an insert query
parseSelect()  : string
Parsing a query with select pattern
parseUpdate()  : string
Parsing update query

Properties

$oc

protected mixed $oc

$connection

private mixed $connection = []

$debug

private mixed $debug = ['con' => 0, 'sql' => []]

$log

private mixed $log

Methods

__construct()

public __construct([array<string|int, mixed>|null $options = [] ]) : mixed
Parameters
$options : array<string|int, mixed>|null = []

__destruct()

public __destruct() : mixed

add()

Alias of insert

public add(array<string|int, mixed> $query[, array<string|int, mixed> $vars = [] ]) : bool|array<string|int, mixed>|int
Parameters
$query : array<string|int, mixed>
$vars : array<string|int, mixed> = []
Return values
bool|array<string|int, mixed>|int

del()

Alias of del query

public del(array<string|int, mixed> $query[, array<string|int, mixed> $vars = [] ]) : bool|array<string|int, mixed>|int
Parameters
$query : array<string|int, mixed>
$vars : array<string|int, mixed> = []
Return values
bool|array<string|int, mixed>|int

delete()

Execite am DELETE query

public delete(array<string|int, mixed> $query[, array<string|int, mixed> $vars = [] ]) : bool|array<string|int, mixed>|int
Parameters
$query : array<string|int, mixed>
$vars : array<string|int, mixed> = []
Return values
bool|array<string|int, mixed>|int

exec()

Execute query

public exec(array<string|int, mixed> $query, mixed $type[, array<string|int, mixed> $vars = [] ]) : bool|int|array<string|int, mixed>
Parameters
$query : array<string|int, mixed>
$type : mixed
$vars : array<string|int, mixed> = []
Return values
bool|int|array<string|int, mixed>

get()

Alias of select

public get(array<string|int, mixed> $query[, array<string|int, mixed> $vars = [] ]) : bool|array<string|int, mixed>|int
Parameters
$query : array<string|int, mixed>
$vars : array<string|int, mixed> = []
Return values
bool|array<string|int, mixed>|int

getDebug()

public getDebug() : mixed

getLastId()

Return the last inserted id from table

public getLastId(mixed $table[, mixed $pk = 'id' ]) : bool|int
Parameters
$table : mixed
$pk : mixed = 'id'
Return values
bool|int

getOneRow()

Return only one row (1st one) - usefull when search something specific

public getOneRow(array<string|int, mixed> $query[, array<string|int, mixed> $vars = [] ]) : bool
Parameters
$query : array<string|int, mixed>
$vars : array<string|int, mixed> = []
Return values
bool

insert()

Execute an insert query

public insert(array<string|int, mixed> $query[, array<string|int, mixed> $vars = [] ]) : bool|array<string|int, mixed>|int
Parameters
$query : array<string|int, mixed>
$vars : array<string|int, mixed> = []
Return values
bool|array<string|int, mixed>|int

isOpen()

public isOpen() : mixed

parse()

Parsing the query from array to string

public parse(array<string|int, mixed>|string $query[, string $pattern = 'auto' ][, array<string|int, mixed> $vars = [] ]) : array<string|int, mixed>|string
Parameters
$query : array<string|int, mixed>|string

the query as array or string

$pattern : string = 'auto'

the conversion patter for query

$vars : array<string|int, mixed> = []

those vars will be replaced with their values on final query sting

Return values
array<string|int, mixed>|string —

the query in string format

parseTableFromValues()

Return an mysql synthax temporary table based on values

public parseTableFromValues(string $name, array<string|int, mixed> $values) : string
Parameters
$name : string
  • the name of the table
$values : array<string|int, mixed>
  • the values of the array
Tags
example

: | @param $name = 'test' | @param $values = [ | ['id' => 1, 'type' => 'Offer'], | ['id' => 2, 'type' => 'Hotel')] | ['id' => 3, 'type' => 'Upsell'], | ]; | @return "(SELECT * FROM (VALUES | ROW(1,'Offer'), | ROW(2,'Hotel'), | ROW(3,'Upsell')) AS Test (id,type)) Test" | |

Return values
string —

sql

parseVar()

Parsing a variable value to be included in the querystring

public parseVar(mixed $var[, string $type = null ]) : mixed
Parameters
$var : mixed
$type : string = null
Tags
@return

?string|int Return the value parsed for sql

parseVars()

Similar with parse var but used to Parse multiple variables

public parseVars(array<string|int, mixed> $vars[, array<string|int, mixed> $types = [] ]) : array<string|int, mixed>
Parameters
$vars : array<string|int, mixed>
$types : array<string|int, mixed> = []
Return values
array<string|int, mixed>

select()

Execute a select query

public select(array<string|int, mixed> $query[, array<string|int, mixed> $vars = [] ]) : bool|array<string|int, mixed>|int
Parameters
$query : array<string|int, mixed>
$vars : array<string|int, mixed> = []
Return values
bool|array<string|int, mixed>|int

set()

Alias of update

public set(array<string|int, mixed> $query[, array<string|int, mixed> $vars = [] ]) : bool|array<string|int, mixed>|int
Parameters
$query : array<string|int, mixed>
$vars : array<string|int, mixed> = []
Return values
bool|array<string|int, mixed>|int

update()

Execute an UPDATE query

public update(array<string|int, mixed> $query[, array<string|int, mixed> $vars = [] ]) : bool|array<string|int, mixed>|int
Parameters
$query : array<string|int, mixed>
$vars : array<string|int, mixed> = []
Return values
bool|array<string|int, mixed>|int

encloseInBacktick()

Parse element and include it in Backtick

protected encloseInBacktick(string $element) : string
Parameters
$element : string
Return values
string

connect()

Connection to database server

private connect() : bool
Return values
bool

getPatternFromQuery()

private getPatternFromQuery(mixed $query) : mixed
Parameters
$query : mixed

parseDelete()

Parse delete query

private parseDelete(array<string|int, mixed> $query) : string
Parameters
$query : array<string|int, mixed>
Return values
string

parseInsert()

Parse an insert query

private parseInsert(array<string|int, mixed> $query) : string
Parameters
$query : array<string|int, mixed>
Return values
string

parseSelect()

Parsing a query with select pattern

private parseSelect(array<string|int, mixed> $query) : string
Parameters
$query : array<string|int, mixed>
Return values
string —

formated query as string

parseUpdate()

Parsing update query

private parseUpdate(array<string|int, mixed> $query) : string
Parameters
$query : array<string|int, mixed>
Return values
string 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results