<?php

header('Content-type:text/html; charset=utf-8');

Header("Content-type: application/octet-stream");

header("Content-Disposition:attachment; filename=".date( 'YmdHis ').".sql");

class BakAction extends Action{

/**

*返回数据库中的数据表

*/

protected function getTable(){

$dbName=C('DB_NAME');

$result=M()->query('show tables from '.$dbName);

foreach ($result as $v){

$tbArray[]=$v['Tables_in_'.C('DB_NAME')];

}

return $tbArray;

}

public function index(){

$table=$this->getTable();

$struct=$this->bakStruct($table);

$record=$this->bakRecord($table);

echo $struct;

echo $record;

}

/**

*备份数据表结构

*/

protected function bakStruct($array){

foreach ($array as $v){

$tbName=$v;

$result=M()->query('show columns from '.$tbName);

$sql.="--\r\n";

$sql.="-- 数据表结构: `$tbName`\r\n";

$sql.="--\r\n\r\n";

$sql.="create table `$tbName` (\r\n";

$rsCount=count($result);

foreach ($result as $k=>$v){

$field = $v['Field'];

$type = $v['Type'];

$default= $v['Default'];

$extra = $v['Extra'];

$null = $v['Null'];

if(!($default=='')){

$default='default '.$default;

}

if($null=='NO'){

$null='not null';

}else{

$null="null";

}

if($v['Key']=='PRI'){

$key = 'primary key';

}else{

$key = '';

}

if($k<($rsCount-1)){

$sql.="`$field` $type $null $default $key $extra ,\r\n";

}else{

//最后一条不需要","号

$sql.="`$field` $type $null $default $key $extra \r\n";

}

}

$sql.=")engine=innodb charset=utf8;\r\n\r\n";

}

return str_replace(')',')',$sql);

}

/**

*备份数据表数据

*/

protected function bakRecord($array){

foreach ($array as $v){

$tbName=$v;

$rs=M()->query('select * from '.$tbName);

if(count($rs)<=0){

continue;

}

$sql.="--\r\n";

$sql.="-- 数据表中的数据: `$tbName`\r\n";

$sql.="--\r\n\r\n";

foreach ($rs as $k=>$v){

$sql.="INSERT INTO `$tbName` VALUES (";

foreach ($v as $key=>$value){

if($value==''){

$value='null';

}

$type=gettype($value);

if($type=='string'){

$value="'".addslashes($value)."'";

}

$sql.="$value," ;

}

$sql.=");\r\n\r\n";

}

}

return str_replace(')',')',$sql);

}

}

?>

在做FOMS时需要个数据库备份类，但是在thinkphp官网论坛上面好像没有这个东西，随便弄了个，自我感觉不是很好，只是能用。

该类需要有thinkphp框架支持。

--------------------------------------分割线----------------------------------------

<?php

protected function bakStruct($array)

{

foreach ($array as $v)

{

$tbName = $v;

//$sql.="DROP TABLE IF EXISTS `$v`;\r\n\r\n";

$result = M()->query('SHOW CREATE TABLE ' . $tbName);

$sql .= $result['0']['Create Table'] . ";\r\n\r\n";

}

return str_replace('CREATE TABLE', 'CREATE TABLE IF NOT EXISTS', $sql);

}

?>

更多信息请查看IT技术专栏