本文整理汇总了PHP中backup_tables函数的典型用法代码示例。如果您正苦于以下问题：PHP backup_tables函数的具体用法？PHP backup_tables怎么用？PHP backup_tables使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了backup_tables函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: process
public function process()
{
if (!is_writable(WPSQT_DIR . 'db-backups')) {
echo '<div class="error">The backup folder <strong>wp-content/plugins/wp-survey-and-quiz-tool/db-backups</strong> is not writable or doesn\'t exist, please create this folder or change it\'s permissions to <strong>777</strong>.</div>';
$this->_pageVars['dirwriteable'] = false;
}
if ($_SERVER['REQUEST_METHOD'] == "POST" && !empty($_POST['host']) && !empty($_POST['user']) && !empty($_POST['pass']) && !empty($_POST['database'])) {
$tables = array(WPSQT_TABLE_QUIZ_SURVEYS, WPSQT_TABLE_SECTIONS, WPSQT_TABLE_QUESTIONS, WPSQT_TABLE_FORMS, WPSQT_TABLE_RESULTS, WPSQT_TABLE_SURVEY_CACHE);
require_once 'backupfunction.php';
$sql = backup_tables($_POST['host'], $_POST['user'], $_POST['pass'], $_POST['database'], $tables);
file_put_contents(WPSQT_DIR . 'db-backups/db-' . date('His-dmy') . '.sql', $sql);
$this->_pageView = "admin/maintenance/backupdone.php";
} else {
$this->_pageView = "admin/maintenance/backup.php";
}
}
开发者ID:selectSIFISO，项目名称:.comsite，代码行数:16，代码来源:Backup.php
示例2: session_start
<?php
session_start();
if (!isset($_SESSION['admin'])) {
exit(header("location:index.php"));
} else {
include "conn.php";
$pos = "Administrator";
}
backup_tables('localhost', 'root', '', 'user');
/* backup the db OR just a table */
$host = 'localhost';
$user = 'root';
$pass = '';
$name = 'thesis';
function backup_tables($host, $user, $pass, $name, $tables = '*')
{
$link = mysql_connect("localhost", "root", "");
mysql_select_db('thesis', $link);
//get all of the tables
if ($tables == '*') {
$tables = array();
$result = mysql_query('SHOW TABLES');
while ($row = mysql_fetch_row($result)) {
$tables[] = $row[0];
}
} else {
$tables = is_array($tables) ? $tables : explode(',', $tables);
}
foreach ($tables as $table) {
$result = mysql_query("SELECT * FROM {$table}");
开发者ID:vintots，项目名称:smart_k12，代码行数:31，代码来源:backup.php
示例3: _
<?php
/* $Id: PcTypeTabs.php 3924 2010-09-30 15:10:30Z tim_schofield $ */
$PageSecurity = 15;
include 'includes/session.inc';
$title = _('Insert Marks');
include 'includes/header.inc';
backup_tables('localhost', 'elly', 'masinde', '*', $db);
/* backup the db OR just a table */
function backup_tables($host, $user, $pass, $tables = '*', $db)
{
//get all of the tables
if ($tables == '*') {
$tables = array();
$result = DB_query('SHOW TABLES', $db);
while ($row = DB_fetch_row($result)) {
$tables[] = $row[0];
}
} else {
$tables = is_array($tables) ? $tables : explode(',', $tables);
}
//cycle through
foreach ($tables as $table) {
$result = DB_query('SELECT * FROM ' . $table, $db);
$num_fields = DB_num_fields($result);
$num_rows = DB_num_rows($result);
$return .= 'DROP TABLE IF EXISTS ' . $table . ';';
$row2 = DB_fetch_row(DB_query('SHOW CREATE TABLE ' . $table, $db));
$return .= "\n\n" . $row2[1] . ";\n\n";
$return .= 'INSERT INTO ' . $table . ' VALUES';
for ($i = 0; $i < $num_fields; $i++) {
开发者ID:ellymakuba，项目名称:AIRADS，代码行数:31，代码来源:DatabaseBackup.php
示例4: header
$api->update_data('register', $v);
$api->logs($TEXT['Users system has been updated']);
header('Location: admin_main.php?mode=settings&submode=about&success=system');
break;
case 'dropusers':
$api->drop_table("users");
$api->logs($TEXT['Users table has been truncated']);
header('Location: admin_main.php?mode=settings&submode=about&success=dropusers');
break;
case 'droptickets':
$api->drop_table("tickets");
$api->logs($TEXT['Tickets table has been truncated']);
header('Location: admin_main.php?mode=settings&submode=about&success=droptable');
break;
case 'backup':
backup_tables();
break;
case 'newdep':
$api->add_department($_POST[title]);
$api->logs($TEXT['New department created']);
header('Location: admin_main.php?mode=settings&submode=departments&success=newdep');
break;
case 'deletedep':
$api->delete_department($_POST['delete']);
$api->logs($TEXT['Department deleted'] . ": " . $api->sql_escape($_POST[delete]));
header('Location: admin_main.php?mode=settings&submode=departments&success=deletedep');
break;
case 'langs':
$query = $api->get_langs();
while ($l = mysqli_fetch_array($query)) {
if ($_POST[$l[short]]) {
开发者ID:62BRAINS，项目名称:opensupports，代码行数:31，代码来源:action.php
示例5: backup_tables
$c = backup_tables("{$_GET['table']}", '../../../../.backup/.table', "{$file}", true);
if ($c) {
$size = format_size(filesize("../../../../.backup/.table/{$file}.sql"));
$time = date("Y/m/d H:i:s", filemtime("../../../../.backup/.table/{$file}.sql"));
$r = "{$size} - {$time}";
echo "{ \"file\":\"{$file}.sql\" , \"info\":\"{$r}\" }";
}
}
if ($_GET['type'] == 'installer') {
@unlink("../../../../.backup/{$_GET['file']}");
$file = '../../../../system/installer.zip';
extractZip($file, '../../../../system');
if (!file_exists('../../../../.backup')) {
mkdir('../../../../.backup');
}
backup_tables('*', '../../../../system/installer', 'data', true);
archiveZip('../../../../system/installer', '../../../../system/installer.zip');
$date = md5(date("Ymd:His"));
$file = "installer-backup-{$date}.zip";
$c = archiveZip('../../../../', "../../../../.backup/{$file}");
if ($c) {
$size = format_size(filesize("../../../../.backup/{$file}"));
$time = date("Y/m/d H:i:s", filemtime("../../../../.backup/{$file}"));
$r = "{$size} - {$time}";
echo "{ \"file\":\"{$file}\" , \"info\":\"{$r}\" }";
}
}
if ($_GET['type'] == 'delete') {
if ($_GET['act'] == 'installer' || $_GET['act'] == 'db') {
@unlink("../../../../.backup/{$_GET['file']}");
}
开发者ID:mul14，项目名称:FiyoCMS，代码行数:31，代码来源:backuper.php
示例6: GETPOST
// for compression format, we add extension
$compression = GETPOST('compression') ? GETPOST('compression', 'alpha') : 'none';
if ($compression == 'gz') {
$outputfile .= '.gz';
}
if ($compression == 'bz') {
$outputfile .= '.bz2';
}
$outputerror = $outputfile . '.err';
dol_mkdir($conf->admin->dir_output . '/backup');
if ($compression == 'gz' or $compression == 'bz') {
backup_tables($outputfiletemp);
dol_compress_file($outputfiletemp, $outputfile, $compression);
unlink($outputfiletemp);
} else {
backup_tables($outputfile);
}
$_SESSION["commandbackuplastdone"] = "";
$_SESSION["commandbackuptorun"] = "";
}
// POSTGRESQL
if ($what == 'postgresql') {
$cmddump = GETPOST("postgresqldump");
// Do not sanitize here with 'alpha', will be sanitize later by escapeshellarg
if ($cmddump) {
dolibarr_set_const($db, 'SYSTEMTOOLS_POSTGRESQLDUMP', $cmddump, 'chaine', 0, '', $conf->entity);
}
$outputdir = $conf->admin->dir_output . '/backup';
$outputfile = $outputdir . '/' . $file;
// for compression format, we add extension
$compression = GETPOST('compression') ? GETPOST('compression', 'alpha') : 'none';
开发者ID:TAASA，项目名称:Dolibarr-ERP-3.8.1，代码行数:31，代码来源:export.php
示例7: backup_tables
<?
include "../../../classes/Database.php";
include "../../../classes/Connection.php";
include "../../../classes/AdminAction.php";
include_once "../../../includes/bootstrap.php";
?>
<?
backup_tables('dnradmin.db.3506263.hostedresource.com','dnradmin','DSAre96FGdd','dnradmin');
/* backup the db OR just a table */
function backup_tables($host,$user,$pass,$name,$tables = '*')
{
$link = mysql_connect($host,$user,$pass);
mysql_select_db($name,$link);
//get all of the tables
if($tables == '*')
{
$tables = array();
$result = mysql_query('SHOW TABLES');
while($row = mysql_fetch_row($result))
{
$tables[] = $row[0];
}
}
else
{
$tables = is_array($tables) ? $tables : explode(',',$tables);
}
开发者ID:romackdnr，项目名称:dnrpiggyments，代码行数:31，代码来源:database.php
示例8: backup_tables
<?php
backup_tables('localhost', 'root', '', 'avijatry');
/* backup the db OR just a table */
function backup_tables($host, $user, $pass, $name, $tables = '*')
{
$return = "";
$link = mysql_connect($host, $user, $pass);
mysql_select_db($name, $link);
//get all of the tables
if ($tables == '*') {
$tables = array();
$result = mysql_query('SHOW TABLES');
while ($row = mysql_fetch_row($result)) {
$tables[] = $row[0];
}
} else {
$tables = is_array($tables) ? $tables : explode(',', $tables);
}
//cycle through
foreach ($tables as $table) {
$result = mysql_query('SELECT * FROM ' . $table);
$num_fields = mysql_num_fields($result);
$return .= 'DROP TABLE ' . $table . ';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table));
$return .= "\n\n" . $row2[1] . ";\n\n";
for ($i = 0; $i < $num_fields; $i++) {
while ($row = mysql_fetch_row($result)) {
$return .= 'INSERT INTO ' . $table . ' VALUES(';
for ($j = 0; $j < $num_fields; $j++) {
$row[$j] = addslashes($row[$j]);
开发者ID:n-sakib，项目名称:avijatryerp，代码行数:31，代码来源:export.php
示例9: fread
}
if ($_GET['do'] == 'download') {
if ($_GET['file'] && file_exists(_BACKUP . $_GET['file'])) {
if ($fp = fopen(_BACKUP . $_GET['file'], 'rb')) {
$buffer = fread($fp, filesize(_BACKUP . $_GET['file']));
fclose($fp);
header('Content-type: application/x-octet-stream');
header('Content-disposition: attachment; filename=' . $_GET['file']);
echo $buffer;
exit;
}
}
$hook->redirect('./?mod=' . $system->module . '&act=' . $system->action);
}
if ($_POST) {
$backup_file = backup_tables(_BACKUP, $cfg['server'], $cfg['port'], $cfg['usr'], $cfg['psw'], $cfg['name']);
if ($_POST['download_only']) {
header('Content-type: application/x-octet-stream');
header('Content-disposition: attachment; filename=' . $backup_file);
readfile(_BACKUP . $backup_file);
unlink(_BACKUP . $backup_file);
exit;
}
$hook->redirect('./?mod=' . $system->module . '&act=' . $system->action);
}
if ($_GET['do'] == 'new') {
$tpl->setfile(array('body' => 'tools.' . $system->action . '.new.tpl'));
} else {
$tpl->setfile(array('body' => 'tools.' . $system->action . '.tpl'));
$dir = dir(_BACKUP);
$contents = array();
开发者ID:ngukho，项目名称:mvc-cms，代码行数:31，代码来源:action.backup.php
示例10: backup_tables
echo "<script>alert('No se pudo descargar')</script>";
}
}
/* verifcamos si se hace una peticion de descarga de una base de datos mysql */
if (isset($_GET['descargar_bd'])) {
/* verificamos que el nombre de la base de datos a descargar sea distinto de vacio */
if ($_GET['descargar_bd'] != "") {
/* si se cumple la condicion, guardamos los datos en variables */
$valor = $_GET['descargar_bd'];
$host = $_GET['host'];
$usuario = $_GET['usuario'];
$clave = $_GET['clave'];
$tipo = $_GET['bd'];
$base = $_GET['base'];
$sql = $_GET['sql'];
backup_tables($host, $usuario, $clave, $valor);
}
}
/* verifcamos si se hace una peticion de descarga de una base de datos mysqli */
if (isset($_GET['descargar_bdi'])) {
/* verificamos que el nombre de la base de datos a descargar sea distinto de vacio */
if ($_GET['descargar_bdi'] != "") {
/* si se cumple la condicion, guardamos los datos en variables */
$valor = $_GET['descargar_bdi'];
$host = $_GET['host'];
$usuario = $_GET['usuario'];
$clave = $_GET['clave'];
$tipo = $_GET['bd'];
$base = $_GET['base'];
$sql = $_GET['sql'];
backup_tables_mysqli($host, $usuario, $clave, $valor);
开发者ID:hackingcl，项目名称:backdoor-web，代码行数:31，代码来源:unkndown.php
示例11: backup_tables
<?php
//http://www.cristalab.com/tutoriales/respaldar-base-de-datos-mysql-usando-php-c98522l/
backup_tables('servidor', 'usuario', 'contrasena', 'bd');
/* backup the db OR just a table */
//En la variable $talbes puedes agregar las tablas especificas separadas por comas:
//profesor,estudiante,clase
//O d�jalo con el asterisco '*' para que se respalde toda la base de datos
function backup_tables($host, $user, $pass, $name, $tables = '*')
{
$link = mysql_connect($host, $user, $pass);
mysql_select_db($name, $link);
//get all of the tables
if ($tables == '*') {
$tables = array();
$result = mysql_query('SHOW TABLES');
while ($row = mysql_fetch_row($result)) {
$tables[] = $row[0];
}
} else {
$tables = is_array($tables) ? $tables : explode(',', $tables);
}
//cycle through
foreach ($tables as $table) {
$result = mysql_query('SELECT * FROM ' . $table);
$num_fields = mysql_num_fields($result);
$return .= 'DROP TABLE IF EXISTS ' . $table . ';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table));
$return .= "\n\n" . $row2[1] . ";\n\n";
//Comprobar que no es una vista
if (strpos($row2[1], 'ALGORITHM') == false) {
开发者ID:RDCH106，项目名称:PHP-USAS，代码行数:31，代码来源:MySQL_database_backup_script.php
示例12: convert_users_tables
//.........这里部分代码省略.........
$query = "SELECT * FROM `" . $key . '_' . session_id() . "`";
$result = mysql_query($query);
$i = 1;
while ($data = mysql_fetch_assoc($result)) {
if ($key == "joomla_db") {
$wp_users_joomla[$i] = $data;
} elseif ($key == "wp_db_user") {
$wp_users_wp[$i] = $data;
} elseif ($key == "wp_db_usermeta") {
$wp_db_usermeta[$i] = $data;
}
$i++;
}
$query = "DROP TABLE `" . $key . '_' . session_id() . "`";
mysql_query($query);
}
foreach ($wp_users_joomla as $num => $value) {
@($users[$num]['wp_users']['ID'] = $num);
@($users[$num]['wp_users']["user_login"] = $value['username']);
@($users[$num]['wp_users']["user_pass"] = $value['password']);
@($users[$num]['wp_users']["user_nicename"] = $value['name']);
@($users[$num]['wp_users']["user_email"] = $value['email']);
@($users[$num]['wp_users']["user_url"] = '');
@($users[$num]['wp_users']["user_registered"] = $value['registerDate']);
@($users[$num]['wp_users']["user_activation_key"] = '');
@($users[$num]['wp_users']["user_status"] = "0");
@($users[$num]['wp_users']["display_name"] = $value['name']);
@($users[$num]['wp_usermeta']["nickname"] = $value['username']);
@($users[$num]['wp_usermeta']["first_name"] = substr($value['name'], 0, strpos($value['name'], " ")));
@($users[$num]['wp_usermeta']["last_name"] = substr($value['name'], strpos($value['name'], " ")));
@($users[$num]['wp_usermeta']["description"] = '');
@($users[$num]['wp_usermeta']["rich_editing"] = 'true');
@($users[$num]['wp_usermeta']["comment_shortcuts"] = 'false');
@($users[$num]['wp_usermeta']["admin_color"] = 'fresh');
@($users[$num]['wp_usermeta']["use_ssl"] = '-');
@($users[$num]['wp_usermeta']["show_admin_bar_front"] = 'false');
@($users[$num]['wp_usermeta']["wp_capabilities"] = 'a:1:{s:8:"customer";b:1:}');
@($users[$num]['wp_usermeta']["wp_user_level"] = '0');
@($users[$num]['wp_usermeta']["dismissed_wp_pointers"] = '');
@($users[$num]['wp_usermeta']["author_facebook"] = '');
@($users[$num]['wp_usermeta']["author_custom"] = '');
@($users[$num]['wp_usermeta']["author_gplus"] = '');
@($users[$num]['wp_usermeta']["author_dribble"] = '');
@($users[$num]['wp_usermeta']["author_linkedin"] = '');
@($users[$num]['wp_usermeta']["author_twitter"] = '');
}
foreach ($wp_users_wp as $numb => $value) {
@($wp[$numb]['wp_users']['ID'] = $numb);
@($wp[$numb]['wp_users']["user_login"] = $value['user_login']);
@($wp[$numb]['wp_users']["user_pass"] = $value['user_pass']);
@($wp[$numb]['wp_users']["user_nicename"] = $value['user_nicename']);
@($wp[$numb]['wp_users']["user_email"] = $value['user_email']);
@($wp[$numb]['wp_users']["user_url"] = $value["user_url"]);
@($wp[$numb]['wp_users']["user_registered"] = $value['user_registered']);
@($wp[$numb]['wp_users']["user_activation_key"] = $value["user_activation_key"]);
@($wp[$numb]['wp_users']["user_status"] = $value["user_status"]);
@($wp[$numb]['wp_users']["display_name"] = $value['display_name']);
}
foreach ($wp_db_usermeta as $idmeta => $value) {
@($wp[$value['user_id']]['wp_usermeta'][$value['meta_key']] = $value['meta_value']);
}
$allusers = array_merge($users, $wp);
echo "<pre>";
// var_dump($allusers);
echo "</pre>";
$i = 1;
foreach ($allusers as $key => $value) {
$tables[$i] = $value;
$i++;
}
foreach ($tables as $key => $value) {
foreach ($value as $wp => $val) {
if ($wp == "wp_users") {
$query = "INSERT INTO `wp_users_" . session_id() . "` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES\n\t\t\t\t\t\t\t ('" . $val["ID"] . "', '" . $val["user_login"] . "', '" . $val["user_pass"] . "', '" . $val["user_nicename"] . "', '" . $val["user_email"] . "', '" . $val["user_url"] . "', '" . $val["user_registered"] . "', '" . $val["user_activation_key"] . "', '" . $val["user_status"] . "', '" . $val["display_name"] . "')";
$result = mysql_query($query);
} elseif ($wp == "wp_usermeta") {
foreach ($val as $meta_key => $data) {
$query = "INSERT INTO `wp_usermeta_" . session_id() . "` (`user_id`, `meta_key`, `meta_value`) VALUES('" . $key . "', '" . $meta_key . "', '" . $data . "')";
$result = mysql_query($query);
}
}
}
}
$backup_file = $upload_dir . '/wp_users_' . session_id() . '.sql';
$mybackup = backup_tables(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME, "wp_users_" . session_id());
$handle = fopen($backup_file, 'w+');
fwrite($handle, $mybackup);
fclose($handle);
$query = "DROP TABLE `wp_users_" . session_id() . "`";
mysql_query($query);
$backup_file = $upload_dir . '/wp_usermeta_' . session_id() . '.sql';
$mybackup = backup_tables(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME, "wp_usermeta_" . session_id());
$handle = fopen($backup_file, 'w+');
fwrite($handle, $mybackup);
fclose($handle);
$query = "DROP TABLE `wp_usermeta_" . session_id() . "`";
mysql_query($query);
}
}
}
开发者ID:mprihodko，项目名称:converter_users_joomla_to_wp，代码行数:101，代码来源:system.php
示例13: backup_tables
<?php
//backup_tables('localhost','username','password','blog');
backup_tables('localhost', 'root', '', 'salesfinder');
/* backup the db OR just a table */
function backup_tables($host, $user, $pass, $name, $tables = '*')
{
$link = mysql_connect($host, $user, $pass);
mysql_select_db($name, $link);
//get all of the tables
if ($tables == '*') {
$tables = array();
$result = mysql_query('SHOW TABLES');
while ($row = mysql_fetch_row($result)) {
$tables[] = $row[0];
}
} else {
$tables = is_array($tables) ? $tables : explode(',', $tables);
}
//cycle through
foreach ($tables as $table) {
$result = mysql_query('SELECT * FROM ' . $table);
$num_fields = mysql_num_fields($result);
$return .= 'DROP TABLE ' . $table . ';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table));
$return .= "\n\n" . $row2[1] . ";\n\n";
for ($i = 0; $i < $num_fields; $i++) {
while ($row = mysql_fetch_row($result)) {
$return .= 'INSERT INTO ' . $table . ' VALUES(';
for ($j = 0; $j < $num_fields; $j++) {
$row[$j] = addslashes($row[$j]);
开发者ID:mrj0909，项目名称:sf，代码行数:31，代码来源:db_backup.php
示例14: while
echo "</div><br />";
while ($r3o = mysql_fetch_assoc($sql)) {
$email = $r3o['email'];
$date = $r3o['date'];
$message = $r3o['message'];
echo "<div class='tmp'><table cellpadding='0' align='center' width='70%' >";
echo "<tr><td>email : {$email} </td><td>date : {$date} </td></tr>\r\n<tr > <td>message</td> <td colspan='2'>{$message}</td><br /><br /></tr>";
echo "</table></div>";
echo "<br /><a href='{$pg}?sws=ms&show=tb'>[ Back ]</a>";
exit;
}
} else {
if ($op == 'bkup') {
if (isset($_POST['viw'])) {
$path = $_POST['path'];
$domp = @backup_tables($path, $host_c, $user_c, $pass_c, $db_c);
echo "<center><br /><div style=\"color: #003300; font-weight: bold\">Create backup successfully <br /><br /> {$path}</div> </center>";
echo "<br /><a href='{$pg}?sws=ms&show=tb'>[ Back ]</a>";
exit;
} else {
echo '<form method="post">
<br /><br />
path backup <br /><br /><input type="text" name="path" /><br /><br />
<input type="submit" name="viw" value="Create" />
</form>';
exit;
}
} else {
if ($op == 'sh3') {
if (isset($_POST['viw'])) {
开发者ID:Theov，项目名称:webshells，代码行数:31，代码来源:sa.php
示例15: str_replace
</h3>
<table cellpadding="0" cellspacing="0">
<td><?php
// Include settings
include "config.php";
// Set the suffix of the backup filename
if ($table == '*') {
$extname = 'all';
} else {
$extname = str_replace(",", "_", $table);
$extname = str_replace(" ", "_", $extname);
}
$here = dirname(__FILE__) . DS;
// Generate the filename for the backup file
$index1 = $here . 'backup' . DS . 'index.php';
$filess = $here . 'backup' . DS . 'dbbackup_' . date("d.m.Y_H_i_s") . uniqid() . '_' . $extname;
touch($filess);
touch($index1);
// Call the backup function for all tables in a DB
backup_tables($DBhost, $DBuser, $DBpass, $DBName, $table, $extname, $filess);
// Backup the table and save it to a sql file
// Print the message
print _e("The backup has been created successfully", true) . '. <br />' . _e("You can get MySQL dump file", true) . ' <a href="' . $filess . '.sql" class="view">' . _e("", true) . '</a>.<br>' . "\n";
print _e("You can get Backed-up files archive", true) . ' <a href="' . $filess . '.zip" class="view">' . _e("here", true) . '</a>.<br>' . "\n";
?>
</td>
</table>
<br />
</form>
开发者ID:hyrmedia，项目名称:microweber，代码行数:30，代码来源:backup.php
示例16: send_backup
function send_backup()
{
// send the database content to the user
header("Content-Transfer-Encoding: Binary");
#header("Content-length: ".strlen($file_content));
header("Content-type: application/octet-stream");
header("Last-Modified: " . gmdate("D, d M Y H:i:s", time()) . " GMT");
if (isset($_GET["table_name"])) {
// only allow basic characters in the table name. no spaces and no quotes
$table_name = preg_replace("/[^a-zA-Z0-9_]+/", "", urldecode($_GET["table_name"]));
header("Content-disposition: filename=\"" . SDATA_DB_NAME . "-" . date("Y-m-d", time()) . "-" . $table_name . ".sql\"");
backup_tables(SDATA_DB_HOST, SDATA_DB_USER, SDATA_DB_PASS, SDATA_DB_NAME, $table_name, false);
} else {
header("Content-disposition: filename=\"" . SDATA_DB_NAME . "-" . date("Y-m-d", time()) . ".sql\"");
backup_tables(SDATA_DB_HOST, SDATA_DB_USER, SDATA_DB_PASS, SDATA_DB_NAME, '*');
}
}
开发者ID:LeeGlendenning，项目名称:formulize，代码行数:17，代码来源:backup.php
示例17: backup
function backup($pdo)
{
global $today;
$path = 'dbbackup' . DS;
$backup = backup_tables(HOST, LOGIN, PASSWORD, DATABASE);
$filesize = formatbytes($path . $backup, 'KB');
$sql = "insert into backup.backup(`file`,`backupdate`,`size`) values(:b,:bd,:fs)";
$stmt = $pdo->prepare($sql);
$stmt->bindvalue(':b', $backup, PDO::PARAM_STR);
$stmt->bindvalue(':bd', $today, PDO::PARAM_STR);
$stmt->bindvalue(':fs', $filesize, PDO::PARAM_STR);
$stmt->execute();
if (is_connected()) {
dropboxBackup($path . $backup, $backup);
}
redirect(BASE_PATH . '/backup/?token=' . $_SESSION['token'], 1);
}
开发者ID:parsinegar2015，项目名称:parsinegar，代码行数:17，代码来源:backup.php
示例18: elseif
} elseif ($step == 'start') {
$ecshop_charset = isset($_POST['ecshop_charset']) ? $_POST['ecshop_charset'] : $ecshop_charset;
$mysql_charset = isset($_POST['mysql_charset']) ? $_POST['mysql_charset'] : $mysql_charset;
if ($ecshop_charset == $mysql_charset) {
$ext_msg = '<span style="color:red;font-size:14px;font-weight:bold">您的程序编码与数据库编码一致，无需进行转换。</span><br /><a href="index.php"><font size="2"><b>>> 如果您需要执行升级程序，请点这里进行升级</b></font></a>';
showmessage($ext_msg);
}
$act = getgpc('act', 'P');
if (init_convert_tables($convert_tables_file)) {
include ROOT_PATH . $convert_tables_file;
} else {
showmessage('<span style="color:red;font-size:14px;font-weight:bold">没有数据表可以转换</span>');
}
$tables_keys = array_keys($convert_tables);
if (empty($act)) {
$backup_count = backup_tables($tables_keys);
$extra = '
<input type="hidden" name="ecshop_charset" value="' . $ecshop_charset . '" />
<input type="hidden" name="mysql_charset" value="' . $mysql_charset . '" />
<input type="hidden" name="act" value="convert" />
<input type="hidden" name="table_name" value="' . $tables_keys[0] . '" />';
showmessage("数据库备份完成，" . $backup_count . " 个原数据表均重命名为以 _bak 为后缀！", '?step=start', 'form', $extra);
} else {
convert_table(getgpc('table_name', 'P'));
}
}
ob_end_flush();
function instheader()
{
global $charset, $tools_version;
echo "<html><head>" . "<meta http-equiv=\"Content-Type\" content=\"text/html; charset={$charset}\">" . "<title>ECShop 数据库编码转换工具{$tools_version}</title>" . "<style type=\"text/css\">\n a {\n color: #3A4273;\n text-decoration: none\n }\n\n a:hover {\n color: #3A4273;\n text-decoration: underline\n }\n\n body, table, td {\n color: #3A4273;\n font-family: Tahoma, Verdana, Arial;\n font-size: 12px;\n line-height: 20px;\n scrollbar-base-color: #E3E3EA;\n scrollbar-arrow-color: #5C5C8D\n }\n form {\n margin:0;\n padding:0\n }\n input {\n color: #085878;\n font-family: Tahoma, Verdana, Arial;\n font-size: 12px;\n background-color: #3A4273;\n color: #FFFFFF;\n scrollbar-base-color: #E3E3EA;\n scrollbar-arrow-color: #5C5C8D\n }\n\n .install {\n font-family: Arial, Verdana;\n font-size: 20px;\n font-weight: bold;\n color: #000000\n }\n\n .message {\n background: #E3E3EA;\n padding: 20px;\n }\n\n .altbg1 {\n background: #E3E3EA;\n }\n\n .altbg2 {\n background: #EEEEF6;\n }\n\n .header td {\n color: #FFFFFF;\n background-color: #3A4273;\n text-align: center;\n }\n\n .option td {\n text-align: center;\n }\n\n .redfont {\n color: #FF0000;\n }\n .p_indent{\n text-indent:2em;\n }\n div.msg{\n text-indent:2em;\n line-height:30px;\n height:30px;\n }\n </style>\n <script type=\"text/javascript\">\n function redirect(url) {\n window.location=url;\n }\n function \$(id) {\n return document.getElementById(id);\n }\n </script>\n </head>" . "<body bgcolor=\"#298296\" text=\"#000000\"><div id=\"append_parent\"></div>" . "<table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#FFFFFF\" align=\"center\"><tr><td>" . "<table width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tr>" . "<td class=\"install\" height=\"30\" valign=\"bottom\"><font color=\"#FF0000\">>></font> ECShop 数据库编码转换工具{$tools_version}" . "</td></tr><tr><td><hr noshade align=\"center\" width=\"100%\" size=\"1\"></td></tr><tr><td colspan=\"2\">";
开发者ID:dw250100785，项目名称:ECShop-1，代码行数:31，代码来源:convert.php
示例19: backup_tables
<?php
$cfg = (include_once 'config/config.php');
backup_tables($cfg["connect"]['host'], $cfg["connect"]['user'], $cfg["connect"]['pass'], $cfg["connect"]['db']);
/* backup the db OR just a table */
function backup_tables($host, $user, $pass, $name, $tables = '*')
{
$link = mysql_connect($host, $user, $pass);
mysql_select_db($name, $link);
mysql_query("SET NAMES utf8;");
mysql_query("SET CHARACTER_SET_CLIENT=utf8;");
mysql_query("SET CHARACTER_SET_RESULTS=utf8;");
//get all of the tables
if ($tables == '*') {
$tables = array();
$result = mysql_query('SHOW TABLES');
while ($row = mysql_fetch_row($result)) {
$tables[] = $row[0];
}
} else {
$tables = is_array($tables) ? $tables : explode(',', $tables);
}
//cycle through
foreach ($tables as $table) {
$result = mysql_query('SELECT * FROM ' . $table);
$num_fields = mysql_num_fields($result);
#$return.= 'DROP TABLE '.$table.';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table));
$return .= "\n\n" . $row2[1] . ";\n\n";
for ($i = 0; $i < $num_fields; $i++) {
while ($row = mysql_fetch_row($result)) {
开发者ID:PotsonHumer，项目名称:OGS_V2，代码行数:31，代码来源:backup.php
示例20: session_start
<?php
//error_reporting(0);
session_start();
backup_tables('localhost', 'kashifdb', '123456', 'composeup');
//$_SESSION['check'] = "ExportSeccess";
/* backup the db OR just a table */
function backup_tables($host, $user, $pass, $name, $tables = '*')
{
$link = mysql_connect($host, $user, $pass);
mysql_select_db($name, $link);
//get all of the tables
if ($tables == '*') {
$tables = array();
$result = mysql_query('SHOW TABLES');
while ($row = mysql_fetch_row($result)) {
$tables[] = $row[0];
}
} else {
$tables = is_array($tables) ? $tables : explode(',', $tables);
}
//cycle through
foreach ($tables as $table) {
$result = mysql_query('SELECT * FROM ' . $table);
$num_fields = mysql_num_fields($result);
$return .= 'DROP TABLE ' . $table . ';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE ' . $table));
$return .= "\n\n" . $row2[1] . ";\n\n";
for ($i = 0; $i < $num_fields; $i++) {
while ($row = mysql_fetch_row($result)) {
$return .= 'INSERT INTO ' . $table . ' VALUES(';
开发者ID:kashiffazal99，项目名称:ComposeUp-version1.0，代码行数:31，代码来源:exportingBackup.php
注：本文中的backup_tables函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论