Beispiel #1
0
                $conn->Execute($q5);
            }
            # После этих операций данные не будем брать из кеша.
            header("Location: ?cacheflush=1");
            die;
        }
    }
}
$title = strtr($GUI_LANG['PhoneBook'], $GUI_LANG['UpperCase'], $GUI_LANG['LowerCase']);
if (empty($export)) {
    include "../include/set/header.html";
}
// Export
if (isset($export) && $export == "excel") {
    include "../include/export/2excel.php";
    $expor_excel = new MID_SQLPARAExel();
}
if (empty($export)) {
    ?>
<div>
<table cellpadding=0 cellspacing=0 border=0 width="100%">
    <tr><td colspan=2><?php 
    $user = "";
    if (IsDefaultPass($_SERVER['PHP_AUTH_USER'])) {
        echo "<font color=red><b>" . $GUI_LANG['ChangeDefaultAdminPassword'] . "</b></font><br>&nbsp;";
    }
    ?>
</td>
    </tr>
    <tr>
<?php 
<?php

if ($table == "") {
    echo "Se requiere el nombre de la tabla en la variable <b>table</b>";
    exit;
}
// parametros do seu servidor
require "../config/variables.php";
//echo DB_USER."++".$table;
$usuario = DB_USER;
$senha = DB_PASS;
$banco = DB_NAME;
$conexao = mysql_connect(DB_HOST, $usuario, $senha);
mysql_select_db($banco, $conexao);
require "excel_lib.php";
//Estanciar
$mid_excel = new MID_SQLPARAExel();
$mid_excel2 = new MID_SQLPARAExel();
// data to the file(Dados para o arquivo)
$sql = "select * from " . $table;
//ex.:
//$mid_excel->mid_sqlparaexcel("DataBaseName", "TABLEname", RECORDSET, "FILEname");
$mid_excel->mid_sqlparaexcel(DB_NAME, $table, $sql, "jmm1");
//$mid_excel->mid_sqlparaexcel(DB_NAME, $table, $sql, "111111111");
//$mid_excel->mid_sqlparaexcel(DB_NAME, $table, $sql, "222222222");