tp框架简易导出数据库

类库,将以下文件放入vendor文件夹中,命名空间vendor,使用think下的model类
<?php
/** 
 *  描述:基于ThinkPHP框架的Mysql数据库导出类 
 *  日期:2012-07-15 
 *  作者:龚辟愚
　　 
 */ 
 namespace Vendor; 
 use Think\Model;
class DBExport  
{  
    /** 
     * @description 获取当前数据库的所有表名。 
     * @static 
     * @return array 
     */  
    public function t(){
        echo "a";
    }
    static protected function gettables()  
    {  
        $dbName=C('DB_NAME');  
        
        $result=M()->query("SHOW FULL tableS FROM `{$dbName}` WHERE table_Type = 'BASE table'");  
        
        foreach ($result as $v){  
            $tbArray[]=$v['tables_in_'.C('DB_NAME')];  
        }  
        return $tbArray;  

    }  
    static protected function getViews()  
    {  
        $dbName=C('DB_NAME');  
        $result=M()->query("SHOW FULL tableS FROM `{$dbName}` WHERE table_Type = 'VIEW'");  
  
        foreach ($result as $v){  
            $tbArray[]=$v['tables_in_'.C('DB_NAME')];  
        }  
        return $tbArray;  
    }  
  
    /** 
     * @description 导出SQL数据，但不包含表创建代码。 
     * @static 
     * @return string 
     */  
    static public function ExportAllData()  
    {  
        $tables = self::gettables();  
        $arrAll = array(  
            "SET FOREIGN_KEY_CHECKS=0;",  
            self::BuildAllTriggerDropSql(),  
            self::BuildtableSql(),  
            self::BuildViewSql()  
        );  
        $tbl = new Model();  
        foreach($tables as $table)  
        {  
            $arrAll[]="\r\nDELETE FROM {$table};";  
  
            /* 
            $rs = $tbl->query("SHOW COLUMNS FROM {$table}"); 
            $arrFields = array(); 
            foreach ($rs as $k=>&$v){ 
                $arrFields[] = "`{$v['Field']}`"; 
 
            } 
 
            $sqlFields = implode($arrFields,","); 
            */  
            $rs=$tbl->query("select * from `{$table}`");  
            foreach ($rs as $k=>&$v){  
                $arrValues = array();  
                foreach($v as $key=>$val)  
                {  
                    if(is_numeric($val)){  
                        $arrValues[]=$val;  
                    }else if(is_null($val)){  
                        $arrValues[]='NULL';  
                    }else{  
                        $arrValues[]="'".addslashes($val)."'";  
                    }  
                }  
                $arrAll[] = "INSERT INTO `{$table}` VALUES (".implode(',',$arrValues).");";  
            }  
        }  
        $arrAll[]=self::BuildTriggerCreateSql();  
        return implode("\r\n",$arrAll);  
    }  
  
    static protected function BuildtableSql()  
    {  
        $tables = self::gettables(); 
        $arrAll = array();  
        foreach($tables as &$val){  
            $rs = M()->query("SHOW CREATE table `{$val}`");  
  
            $tbSql = preg_replace("#CREATE(.*)\\s+table#","CREATE table",$rs[0]['Create table']);  
  
            $arrAll[] = "DROP table IF EXISTS `{$rs[0]['table']}`;\r\n{$tbSql};\r\n";  
        }  
  
        return implode("\r\n",$arrAll);  
    }  
  
    static protected function BuildViewSql()  
    {  
        $views = self::getViews();  
        $arrAll = array();  
        foreach($views as &$val){  
            $rs = M()->query("SHOW CREATE VIEW `{$val}`");  
            $tbSql = preg_replace("#CREATE(.*)\\s+VIEW#","CREATE VIEW",$rs[0]['Create View']);  
  
            $arrAll[] = "DROP VIEW IF EXISTS `{$rs[0]['View']}`;\r\n{$tbSql};\r\n";  
        }  
        return implode("\r\n",$arrAll);  
    }  
    /** 
     * @description 如果存在触发器，生成删除代码。原因是:插入数据的时候可能会受到触发器影响。 
     * @static 
     * @return string 
     */  
    static public function BuildAllTriggerDropSql()  
    {  
        $rs = M()->query("show triggers");  
        $arrAll = array();  
        foreach ($rs as $k=>&$v)  
        {  
            $arrSql = array(  
                'DROP TRIGGER IF EXISTS `',$v['Trigger'],'`;'  
            );  
  
            $arrAll[] = implode('',$arrSql);  
        }  
        return implode("\r\n",$arrAll);  
    }  
  
    /** 
     * @description 生成所有触发器的创建代码。 
     * @static 
     * @return string 
     */  
    static protected function BuildTriggerCreateSql()  
    {  
        $rs = M()->query("show triggers");  
        $arrAll = array();  
        foreach ($rs as $k=>&$v)  
        {  
            $arrSql = array(  
                'CREATE TRIGGER `',$v['Trigger'],'` ',$v['Timing'],' ',$v['Event'],' ON `',  
                $v['table'],'` FOR EACH ROW ',$v['Statement'],';'  
            );  
  
            $arrAll[] = implode('',$arrSql);  
        }  
        return implode("\r\n",$arrAll);  
    }  
}  

//调用方法    

public function   tiaoshi(){
header('Content-type: text/plain; charset=UTF-8');  
$dbName = C('DB_NAME');  
header("Content-Disposition: attachment; filename=\"{$dbName}.sql\""); 
vendor('DBExport','','.class.php');


echo \vendor\DBExport::ExportAllData();
    }

 

转载于:https://www.cnblogs.com/ch459742906/p/6160206.html