sene_mysqli_engine Class

class SENE_MySQLi_Engine
{
    // properties
    protected static $__instance;
    public $__mysqli;
    protected $koneksi;
    protected $fieldname = array();
    protected $fieldvalue = array();
    public $last_id = 0;
    public $in_select = '';
    public $in_where = '';
    public $in_order = '';
    public $in_group = '';
    public $table = '';
    public $is_flush = '';
    public $is_cache = '';
    public $page = '';
    public $pagesize = '';
    public $cache_save = '';
    public $cache_flush = '';
    public $is_limit=0;
    public $tis_limit=0;
    public $limit_a=0;
    public $limit_b=0;
    public $as_from=0;
    public $join=0;
    public $in_join=0;
    public $join_multi=0;
    public $in_join_multi=0;
    public $query_last;
    public $union;
    public $is_debug;

    //methods
    public function __construct();

    private function has_bracket_open(int $flag): self;
    private function has_bracket_close(int $flag): self;

    public function autocommit(int $var): int;
    public function begin(): int;
    public function commit(): int;
    public function rollback(): int;
    public function savepoint(): int;

    public function exec(string $sql): int;
    public function query(string $sql): array;

    public function lastId(): int;
    public function esc(string $value): string;
    
    public function insert(string $table_name, array $data_to_insert, [int $array_of_array_flag = 0 [, int $debug_flag=0]]): string;
    public function update(string $table_name, array $data_to_update [, int $debug_flag=0]): string;
    public function delete(string $table_name [, int $debug_flag=0]): string;

    public function select(string $column_name [, string $column_name_alias]): self;
    public function select_as(string $column_name, string $column_name_alias): self;
    public function from(string $table_name [, string $table_name_alias]): self;
    public function join(string $table2, string $table2_alias, string $table2_column_to_joined, string $table1_alias, string $table1_column_to_joined [, string $join_type='']): self;

    public function between(string $column_name, string $value_from, string $value_to): self;
    public function where(string $column_name, mixed $filter_value [, string $operator = 'AND' [, string $relation_operator = '=' [, int $bracket_open = 0 [, int $bracket_close = 0 ]]]]): self;
    public function where_as(string $column_name, mixed $filter_value [, string $operator = 'AND' [, string $relation_operator = '=' [, int $bracket_open = 0 [, int $bracket_close = 0 ]]]]): self;
    public function where_in(string $column_name, array $array_selector[, int $where_not_in_flag=0]): self;
    public function order_by(string $column_name, string $sort_direction): self;
    public function limit(int $offset, int $count): self;
    public function page(int $page, int $page_size): self;
    public function flushQuery(): self;

    public function get(string $result_type [, int $debug_flag=0]): self;
    public function get_first(int $result_type [, int $debug_flag=0]): self;
}