Napisałem dziś rano takie cos i chciałbym się dowiedzieć czy moze czegoś przypadkiem nie przeoczyłem. Jesli nie to po niewielkich modyfikacjach ta klasa nadaje sie do backupowania bazy danych. Pozdrawiam.
<?php
include_once( "database_connection.php" );
// main class
class c_backup_download
{
var $backup_file_mame;
var $current_date;
function c_backup_download()
{
$this->backup_file_mame = "backup_temporary.php";
$this->current_date = date('d-m-Y',$t[0
]); }
function create_backup_file()
{
$file = fopen( $this->backup_file_mame, 'a'); fwrite( $file, "include_once( "database_connection
.php
" );n" );
$query = "SHOW TABLES";
{
//deleting all tables...
fwrite( $file, "mysql_query( "DELETE FROM
".$table."" )or die ( mysql_error() );n" ); //getting column names for table...
$result2 = mysql_query( "SHOW COLUMNS FROM ".$table."" ); $col_names= ""; while( $row2 = mysql_fetch_array( $result2) ) $col_names.= $row2[0] . ", "; //getting all rows in table...
{
fwrite( $file, "mysql_query( "INSERT INTO
".$table." ( ".$col_names." ) VALUES
( ".$values." )" ) or die ( mysql_error() ); n" ); }
}
}
function download_file()
{
$type = "application/force-download";
if( isset( $_SERVER['HTTP_USER_AGENT'] ) && preg_match( "/MSIE/", $_SERVER['HTTP_USER_AGENT']) ) {
// IE Bug in download name workaround
ini_set( 'zlib.output_compression','Off' ); }
header( "Content-disposition: ".$disp."; filename=".$this->current_date."" ); header( "Content-type: ".$type ); header( "Connection: close" ); }
}
function panel_drop()
{
$panel = new c_backup_download();
$panel->create_backup_file();
$panel->download_file();
}
panel_drop();
?>