| 标题 | thinkphp 备份类 |
| 内容 | <?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); } ?> |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。