\CLASS_DATABASE

Summary

Methods

Properties

Constants

__construct()
connect()
select_db()
query()
fetch_row()
fetch_assoc()
affected_rows()
insert_id()
close()
create_table()
create_index()
create_view()
copy_table()
alter_table()
duplicate()
insert()
update()
delete()
count()
select()
show_columns()
show_indexs()
show_tables()
show_databases()
__destruct()

$db_host
$db_port
$db_user
$db_pass
$db_name
$db_charset
$db_debug
$obj_mysqli
$obj_result

No constants found

No protected methods found

No protected properties found

N/A

No private methods found

No private properties found

N/A

File: core/class/database.class.php
Package: Default
Class hierarchy: \CLASS_DATABASE

Properties

$db_host

$db_host :

Type

$db_port

$db_port :

Type

$db_user

$db_user :

Type

$db_pass

$db_pass :

Type

$db_name

$db_name :

Type

$db_charset

$db_charset :

Type

$db_debug

$db_debug :

Type

$obj_mysqli

$obj_mysqli :

Type

$obj_result

$obj_result :

Type

Methods

__construct()

__construct(  $cfg_host)

Parameters

$cfg_host

connect()

connect()

select_db()

select_db()

query()

query(  $sql)

Parameters

$sql

fetch_row()

fetch_row(  $rs = '')

Parameters

$rs

fetch_assoc()

fetch_assoc(  $rs = '')

Parameters

$rs

affected_rows()

affected_rows()

insert_id()

insert_id()

close()

close()

create_table()

create_table(  $table,   $data,   $primary,   $comment = '',   $engine = 'InnoDB')

Parameters

	$table
	$data
	$primary
	$comment
	$engine

create_index()

create_index(  $index,   $table,   $data,   $type = 'BTREE',   $drop_overlap = false)

Parameters

	$index
	$table
	$data
	$type
	$drop_overlap

create_view()

create_view(  $view,   $data,   $table,   $join)

Parameters

	$view
	$data
	$table
	$join

copy_table()

copy_table(  $table,   $table_src,   $data,   $primary,   $comment = '',   $engine = 'InnoDB')

Parameters

	$table
	$table_src
	$data
	$primary
	$comment
	$engine

alter_table()

alter_table(  $table,   $data = false,   $rename = false)

Parameters

	$table
	$data
	$rename

duplicate()

duplicate(  $table_dst,   $data_dst,   $table_src,   $data_src,   $where = '')

Parameters

	$table_dst
	$data_dst
	$table_src
	$data_src
	$where

insert()

insert(  $table,   $data,   $field = false)

Parameters

	$table
	$data
	$field

update()

update(  $table,   $data,   $where = '',   $field = false)

Parameters

	$table
	$data
	$where
	$field

delete()

delete(  $table,   $where)

Parameters

	$table
	$where

count()

count(  $table,   $where = '',   $distinct = '')

Parameters

	$table
	$where
	$distinct

select()

select(  $table,   $data = '',   $where = '',   $group = '',   $order = '',   $length,   $start,   $field = false)

Parameters

	$table
	$data
	$where
	$group
	$order
	$length
	$start
	$field

show_columns()

show_columns(  $table)

Parameters

$table

show_indexs()

show_indexs(  $table)

Parameters

$table

show_tables()

show_tables()

show_databases()

show_databases()

__destruct()

__destruct()