<?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{
    /**
    *返回?cái)?shù)據(jù)庫(kù)中的數(shù)據(jù)表
    */
    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;
    }
    /**
    *備份數(shù)據(jù)表結(jié)構(gòu)
    */
    protected function bakStruct($array){
    foreach ($array as $v){
    $tbName=$v;
    $result=M()->query('show columns from '.$tbName);
    $sql.="--\r\n";
    $sql.="-- 數(shù)據(jù)表結(jié)構(gòu): `$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{
    //最后一條不需要","號(hào)
    $sql.="`$field` $type $null $default $key $extra \r\n";
    }
    }
    $sql.=")engine=innodb charset=utf8;\r\n\r\n";
    }
    return str_replace(')',')',$sql);
    }
    /**
    *備份數(shù)據(jù)表數(shù)據(jù)
    */
    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.="-- 數(shù)據(jù)表中的數(shù)據(jù): `$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時(shí)需要個(gè)數(shù)據(jù)庫(kù)備份類(lèi)，但是在thinkphp官網(wǎng)論壇上面好像沒(méi)有這個(gè)東西，隨便弄了個(gè)，自我感覺(jué)不是很好，只是能用。
    該類(lèi)需要有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);
    }
    ?>