database.php

一个简单的网站管理系统,他能实现你所需要的功能,是个值得一看的系统

<?php
/*
*######################################
* PHPCMS v2.00 - Advanced Content Manage System.
* Copyright (c) 2004-2005 phpcms.cn
*
* For further information go to http://www.phpcms.cn/
* This copyright notice MUST stay intact for use.
*######################################
*/

if(!defined('IN_PHPCMS')) {
        exit('Access Denied');
}

$tables=$_CACHE['tables'];

$action = $action ? $action : 'exportdata' ;

switch($action){

case 'exportdata':
     if($submit){
           set_time_limit(1200);
           foreach($tables as $table) {
	           $sqldump .= sqldumptable($table);
	   }
           $sqldump="# <?php /*\n".$sqldump."\n# */ ?>";
           $filename=$dbname.'_'.date("Ymd",time()).".php";
           @$fp = fopen($phpcms_root."/data/bakup/".$filename, "w");
           @flock($fp, 3);
           if(@!fwrite($fp, $sqldump)) {
                showmessage('数据无法备份到服务器！请检查 ./data/bakup 目录是否可写。',$referer);
           }
           ob_clean();
           header("Content-type: application/force-download");
           header("Content-Disposition: attachment; filename=".$filename);
           echo $sqldump;
           exit;
     }else{
           include template('database_exportdata',1);
     }
     break;

case 'importdata':
     if($submit){
          set_time_limit(1200);
          if($from == "server") {
	          $datafile = $datafile_server;
	          $datafile_size = @filesize($datafile_server);
          }
          @$fp = fopen($datafile, "r");
          if($datafile_size) {
	          @flock($fp, 3);
	          $sqldump = @fread($fp, $datafile_size);
          }else{
	          $sqldump = @fread($fp, 99999999);
          }
          @fclose($fp);
          $sqlquery = splitsql($sqldump);
          unset($sqldump);
          foreach($sqlquery as $sql) {
		if(trim($sql) != '') {
			$db->query($sql);
		}
          }
          showmessage('数据恢复成功！',$referer);
     }else{
          $datadir=opendir("./data/bakup");
          while($file=readdir($datadir)){
                if($file!='.' && $file!='..'){
                   $files[]=$file;
                }
          }
          closedir($datadir);
          include template('database_importdata',1);
     }
     break;

case 'executesql':
     if($submit){
          set_time_limit(1200);
          $sqlquery = splitsql(str_replace(" phpcms_", " $tablepre", $sqldump));
          unset($sqldump);
          foreach($sqlquery as $sql) {
		if(trim($sql) != '') {
			$db->query(stripslashes($sql), 1);
		}
          }
          showmessage('操作成功！',$referer);
     }else{
          include template('database_executesql',1);
     }
     break;
}
?>