query
Новичок
Вот моя фун-я для извлечения БД:
Код:
function GetTableContent($table) {
global $mysql;
$result = $mysql->query("SELECT * FROM $table");
$result_rows = mysql_num_rows($result);
$result_num = mysql_num_fields($result);
$data = '';
for ( $i = 0; $i < $result_rows; $i++ ) {
$result_arr = mysql_fetch_array($result);
$data .= "INSERT INTO `$table`";
/*for ( $number = 0; $number < $result_num; $number++ ) {
$feldname = mysql_field_name($result, $number);
if ($number == ($result_num - 1)) {
$data .= "`".$feldname."`";
} else {
$data .= "`".$feldname."`".",";
}
}*/
//$data .= ") VALUES (";
$data .= " VALUES (";
for ( $k = 0; $k < $result_num; $k++ ) {
if ($k == ($result_num - 1)) {
$result_arr[$k] = str_replace("\r\n", '\r\n', $result_arr[$k]);
$data .= "'".addslashes($result_arr[$k])."'";
} else {
$result_arr[$k] = str_replace("\r\n", '\r\n', $result_arr[$k]);
$data .= "'".$result_arr[$k]."', ";
}
}
$data.= ");\n";
}
return $data;
}
function backup() {
$data = "#\n# DATE : ".gmdate("d-m-Y H:i:s", time())." GMT\n#\n";
$tables = array( _______ТАБЛИЦЫ________ );
$max = sizeof($tables);
for ( $i = 0; $i < $max; $i++ ) {
$data .= "\n#\n# TABLE: ".$tables[$i]."\n#\n\n";
$data .= GetTableContent($tables[$i]);
}
return $data;
}
