Documentation

Html
in package
Uses SQL

HTML Utility

Table of Contents

Methods

datalist()  : string
Generates a datalist HTML element with options based on the provided data string.
FSQL()  : array<string|int, mixed>
Flat SQL array result. The order of the field is important.
FSQL1()  : string
Single value SQL result.
FSQLC()  : array<string|int, mixed>
Flat SQL array result Column.
FSQLR()  : array<string|int, mixed>
Flat SQL array result Row.
selectOption()  : string
Select option for jqGrid form
SQL()  : mixed
Execute SQL, if select operation return result in associative array.
SQLBI()  : void
Bulk Insert.
SQLBU()  : void
Bulk Update, only single pk is allowed.
SQLR()  : array<string|int, mixed>
Execute SQL, return first row from result.
textOption()  : string

Methods

datalist()

Generates a datalist HTML element with options based on the provided data string.

public datalist(string $id, string $data) : string
Parameters
$id : string
$data : string
Return values
string

FSQL()

Flat SQL array result. The order of the field is important.

public FSQL() : array<string|int, mixed>
Return values
array<string|int, mixed>

FSQL1()

Single value SQL result.

public FSQL1() : string
Return values
string —

value of the query with 1 row, 1 column (e.g. SELECT COUNT(1))

FSQLC()

Flat SQL array result Column.

public FSQLC() : array<string|int, mixed>
Return values
array<string|int, mixed>

FSQLR()

Flat SQL array result Row.

public FSQLR() : array<string|int, mixed>
Return values
array<string|int, mixed> —

result that only needed only the first record

selectOption()

Select option for jqGrid form

public selectOption(string $class[, string $default = '' ][, string $code_field = 'code' ][, string $name_field = 'name' ][, array<string|int, mixed> $condition = [] ]) : string
Parameters
$class : string
$default : string = ''
$code_field : string = 'code'
$name_field : string = 'name'
$condition : array<string|int, mixed> = []
Return values
string

SQL()

Execute SQL, if select operation return result in associative array.

public SQL() : mixed
Return values
mixed —

result in associative array

SQLBI()

Bulk Insert.

public SQLBI(string $sql, array<string|int, mixed> $values[, int $chunk_size = 100 ]) : void
Parameters
$sql : string
$values : array<string|int, mixed>
$chunk_size : int = 100

(optional)

SQLBU()

Bulk Update, only single pk is allowed.

public SQLBU(string $sql, string $pk, array<string|int, mixed> $values[, int $chunk_size = 100 ]) : void
Parameters
$sql : string
$pk : string
$values : array<string|int, mixed>
$chunk_size : int = 100

(optional)

SQLR()

Execute SQL, return first row from result.

public SQLR() : array<string|int, mixed>
Return values
array<string|int, mixed>

textOption()

public textOption(string $class[, string $default = '' ][, string $code_field = '' ][, string $name_field = 'name' ][, array<string|int, mixed> $condition = [] ]) : string
Parameters
$class : string
$default : string = ''
$code_field : string = ''
$name_field : string = 'name'
$condition : array<string|int, mixed> = []
Return values
string 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results