function build_table_field_str($table)
{
$field_name = get_table_fields($table);
$insert_field_str = "";
foreach ($field_name as $value) {
$insert_field_str .= $value["Field"] . ", ";
}
return rtrim($insert_field_str, ", ");
}
<?php
include "functions.php";
$table_name = "kids";
$arr_column = get_table_fields($table_name);
$arr_table_values = get_table_values($table_name);
$str = "CREATE TABLE IF NOT EXISTS " . $table_name . " (";
foreach ($arr_column as $key => $value) {
$str .= $value['Field'] . " " . get_field_value($value) . ", ";
}
$str = rtrim($str, ", ");
$str .= ")&#";
//echo "<pre>";
//print_r($arr_table_values);
//echo "</pre>";
foreach ($arr_table_values as $key => $value) {
$str .= build_insert_str($table_name, $value) . "&#";
}
//header("Content-Type: text/html charset=utf-8");
$str = utf8_encode(nl2br(rtrim($str, "&#")));
echo json_encode($str);
mysqli_close($connection);
function export_db($is_backup = false)
{
global $db, $db_host, $db_user, $db_pass, $db_name, $db_port;
$stime = microtime(true);
if ($is_backup) {
$output_file = str_replace('\\', '/', getcwd()) . "/backup/" . date("Y-m-d_H-i-s") . ".php";
} else {
$changes = get_changes();
$i = 0;
while (true) {
$i += 1;
$file_name = date("Y-m-d") . "-" . sprintf("%02d", $i);
$ver = (int) str_replace('-', '', $file_name);
if (array_key_exists($ver, $changes) == false) {
break;
}
}
$output_file = str_replace('\\', '/', getcwd()) . "/changes/" . $file_name . ".dump.php";
}
$file = fopen($output_file, 'c');
$tables = get_tables($db_host, $db_user, $db_pass, $db_name, $db_port);
$max_length = get_max_length($tables);
fwrite($file, "<?php\n\n");
fwrite($file, "echo \"\\n\\n\";\n");
fwrite($file, "\n execute(\"\n /*!40101 SET NAMES utf8 */;\n\n /*!40101 SET SQL_MODE=''*/;\n\n /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;\n /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;\n /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;\n /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;\n \");\n ");
foreach ($tables as $table) {
if ($table == "db_version") {
continue;
}
if ($is_backup) {
echo "backup ";
} else {
echo "dump ";
}
echo $table . " ";
$dots = generate_char($max_length, strlen($table), '.');
echo $dots . "......... ";
$sql = get_create_table_sql($db, $table);
fwrite($file, 'if ($db_version == 0)' . "\n{\n");
fwrite($file, " echo \" " . $table . " " . $dots . "......... \";\n\n");
fwrite($file, " execute(\"\n");
fwrite($file, $sql);
fwrite($file, "\n\");\n\n");
fwrite($file, " echo \"[created]\\n\"; \n");
fwrite($file, "}\n\n");
if ($is_backup == false && strpos($table, "player") === 0) {
echo "[ignore]\n";
continue;
}
$fields = get_table_fields($db, $table);
$sql = get_insert_into_sql($db, $table, $fields);
fwrite($file, "echo \" " . $table . " " . $dots . "......... \";\n\n");
fwrite($file, "execute(\"DELETE FROM `" . $table . "`\");\n\n");
if ($sql != "") {
fwrite($file, "execute(\"\n");
fwrite($file, $sql);
fwrite($file, "\");\n\n");
}
fwrite($file, "echo \"[loaded]\\n\"; \n");
fwrite($file, "\n");
echo "[done]\n";
}
fwrite($file, "\n execute(\"\n /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;\n /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;\n /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;\n /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;\n \");\n ");
fwrite($file, "echo \"\\n\";\n");
fwrite($file, "?>\n");
fclose($file);
if ($is_backup == false) {
$sql = "UPDATE `db_version` SET `version` = " . $ver . ", `change_time` = UNIX_TIMESTAMP()";
if ($db->query($sql) === FALSE) {
die("can't update db_version");
}
}
$etime = microtime(true);
echo "\ndatabase ";
if ($is_backup) {
echo "backup ";
} else {
echo "dump ";
}
echo "complete in " . round($etime - $stime, 2) . "s\n";
}
function systable_field_select($table, $field = NULL)
{
global $db_strings;
$cols = get_table_fields($table);
return '<b>' . $db_strings['FField'] . "</b><br>\n" . get_selectlist('db_sysfield', $cols, $field, TRUE, array('onChange' => "getFilterValues('" . $table . "' ,selectedElement(this))", 'id' => 'db_sysvalues_list'));
}
if (unpackZip($dir_modelli . $modello, $dir . "/")) {
//echo "Dovrei aver scompattato!!!!<br>";
//Acquisisco il file xml
if (!($dom = domxml_open_file(getcwd() . "/{$dir}/content.xml"))) {
echo "error";
exit;
}
}
$db = new sql_db($dbhost, $dbuname, $dbpass, $dbname, false);
if (!$db->db_connect_id) {
die("Impossibile connettersi al database {$dbtype}");
}
$root = $dom->document_element();
$start = $root->get_elements_by_tagname("body");
$lista_field = $root->get_elements_by_tagname("user-field-get");
$out = get_table_fields($root);
$risultato = array();
//Ciclo sulle Tabelle
foreach ($out as $key => $value) {
$sql_query[$key] = crea_query($key, $value, $cond);
$db->sql_query($sql_query[$key]);
$ris[$key] = $db->sql_fetchrowset();
//Ciclo sui campi delle tabelle
foreach ($value as $val) {
$s = $key . "." . $val;
$risultato[$s] = array();
//Ciclo sui valori dei campi
//echo "<br>";print_r($ris[$key]);
foreach ($ris[$key] as $k => $v) {
array_push($risultato[$s], $v[$val]);
}
function preview($table, $file, $path)
{
global $mysql;
// write($table);
$sql = array();
$wines = array();
$backupFile = $path . 'backup/' . $table . '/' . $file . '.txt';
$fh = fopen($backupFile, 'r');
$fields = implode(', ', get_table_fields($table));
$fieldsInformations = implode(', ', get_table_fields_informations($table));
$data = fread($fh, filesize($backupFile));
fclose($fh);
$products = explode(';', $data);
array_pop($products);
echo $data;
exit;
foreach ($products as $product) {
$product_info = explode(' / ', $product);
$data = '';
$numData = count($product_info);
$cpt = 1;
foreach ($product_info as $info) {
if (!is_numeric($info) && $info != "NULL") {
$data .= '"' . addSlashes($info) . '"';
// add double quotes for fields with string type
} else {
$data .= $info;
}
if ($cpt == $numData) {
$data .= '';
} else {
$data .= ', ';
}
$cpt++;
}
array_push($sql, '(' . $data . ')');
}
clear_preview_table();
create_preview_table($fieldsInformations);
$dataList = implode(', ', $sql);
$query = 'INSERT INTO t_preview (' . $fields . ') VALUES ' . $dataList;
$result = $mysql->sql_query($query);
}
