\Database__MySQLi

MySQLi数据库操作类.

Summary

Methods

Properties

Constants

__construct()
EscapeString()
Open()
CreateDB()
Close()
QueryMulit()
QueryMulti()
Query()
Update()
Delete()
Insert()
CreateTable()
DelTable()
ExistTable()

$type
$version
$dbpre
$dbname
$dbengine
$sql

No constants found

No protected methods found

No protected properties found

N/A

No private methods found

$db

N/A

File: zb_system/function/lib/database/mysqli.php
Package: Default
Class hierarchy: \Database__MySQLi
Implements: \Database__Interface

Properties

$type

$type :

Type

$version

$version :

Type

$dbpre

$dbpre : string|null

Type

string|null — 数据库名前缀

$dbname

$dbname : string|null

Type

string|null — 数据库名

$dbengine

$dbengine : string|null

Type

string|null — 数据库引擎

$sql

$sql : \DbSql|null

Type

\DbSql|null — DbSql实例

$db

$db :

Type

Methods

__construct()

__construct()

构造函数，实例化$sql参数.

EscapeString()

EscapeString(string  $s) : string

对字符串进行转义，在指定的字符前添加反斜杠，即执行addslashes函数.

Parameters

string

Returns

string

Open()

Open(array  $array) : boolean

连接数据库.

Parameters

array

$array

数据库连接配置 $array=array( 'dbmysql_server', 'dbmysql_username', 'dbmysql_password', 'dbmysql_name', 'dbmysql_pre', 'dbmysql_port', 'persistent' 'engine')

Returns

boolean

CreateDB()

CreateDB(string  $dbmysql_server, string  $dbmysql_port, string  $dbmysql_username, string  $dbmysql_password, string  $dbmysql_name) : boolean

创建数据库.

Parameters

string	$dbmysql_server
string	$dbmysql_port
string	$dbmysql_username
string	$dbmysql_password
string	$dbmysql_name

Returns

boolean

Close()

Close()

关闭数据库连接.

QueryMulit()

QueryMulit(string  $s) : array

执行多行SQL语句.

Parameters

string

以;号分隔的多条SQL语句

Returns

array

QueryMulti()

QueryMulti(  $s)

Parameters

Query()

Query(  $query) : array

Parameters

$query

Returns

array

Update()

Update(  $query) : boolean|\mysqli_result

Parameters

$query

Returns

boolean|\mysqli_result

Delete()

Delete(  $query) : boolean|\mysqli_result

Parameters

$query

Returns

boolean|\mysqli_result

Insert()

Insert(  $query) : integer|string

Parameters

$query

Returns

integer|string

CreateTable()

CreateTable(  $table,   $datainfo,   $engine = null)

Parameters

	$table
	$datainfo
	$engine

DelTable()

DelTable(  $table)

Parameters

$table

ExistTable()

ExistTable(  $table) : boolean

Parameters

$table

Returns

boolean