Gitee
\

\DbManage

Summary

Methods
Properties
Constants
__construct()
getTables()
backup()
restore()
__destruct()
$db
$database
$sqldir
$sqlContent
$sqlEnd
No constants found
No protected methods found
No protected properties found
N/A
_showMsg()
_retrieve()
_insert_table_structure()
_insert_record()
_write_file()
_import()
_insert_into()
close()
lock()
unlock()
$ds
N/A

Properties

$db

$db :

Type

$database

$database :

Type

$sqldir

$sqldir :

Type

$sqlContent

$sqlContent :

Type

$sqlEnd

$sqlEnd :

Type

$ds

$ds :

Type

Methods

__construct()

__construct()

初始化

getTables()

getTables()

backup()

backup(  $tablename = '',   $dir = './', integer  $size = 20480)

数据库备份 参数：备份哪个表(可选),备份目录(可选，默认为backup),分卷大小(可选,默认2000，即2M)

Parameters

$tablename
$dir
integer $size

restore()

restore(string  $sqlfile)

导入备份数据 说明：分卷文件格式20120516211738_all_v1.sql 参数：文件路径(必填)

Parameters

string $sqlfile

__destruct()

__destruct()

_showMsg()

_showMsg(  $msg,   $err = false)

Parameters

$msg
$err

_retrieve()

_retrieve() : string

插入数据库备份基础信息

Returns

string

_insert_table_structure()

_insert_table_structure(\unknown_type  $table) : string

插入表结构

Parameters

\unknown_type $table

Returns

string

_insert_record()

_insert_record(string  $table, integer  $num_fields, array  $record) : string

插入单条记录

Parameters

string $table
integer $num_fields
array $record

Returns

string

_write_file()

_write_file(string  $sql, string  $filename, string  $dir) : boolean

写入文件

Parameters

string $sql
string $filename
string $dir

Returns

boolean

_import()

_import(string  $sqlfile) : boolean

将sql导入到数据库（普通导入）

Parameters

string $sqlfile

Returns

boolean

_insert_into()

_insert_into(  $sql)

Parameters

$sql

close()

close()

lock()

lock(  $tablename,   $op = "WRITE")

Parameters

$tablename
$op

unlock()

unlock()