<form action="/src/xls2.php">
     <p>Экспортировать с даты:
         <br><input type="date" name="date1" value="01.01.1900"><br/></p>
     <p>По дату:
         <br><input type="date" name="date2" value="01.01.1900"><br/></p>

     <input type="submit" value="export to excel">
 </form>

<?php
include('config.php');
$db = mysql_connect($server, $username, $password);
mysql_select_db("$database",$db) or die ('Can\'t use anketa : ' . mysql_error());
$array = array("");
$result = mysql_query("SELECT * from anketa where data_z>='".$_POST[date1]."' and data_z<='".$_POST[date2]."'");
if (!$result) die("Couldn\'t fetch records");
$fields = mysql_num_fields ( $result);
for ( $i = 0; $i < sizeof($array); $i++ )
    {
       // $header .= mysql_field_name( $result , $i ) . "\t";
        $header .=mb_convert_encoding($array[$i],"cp1251","utf-8") . "\t";
    }
while( $row = mysql_fetch_row( $result ) )
    {
        $line = '';
        foreach( $row as $value )
        {
            if ( ( !isset( $value ) ) || ( $value == "" ) )
            {
                $value = "\t";
            }
            else
            {
                $value = str_replace( '"' , '""' , $value );
                $value = '"' . $value . '"' . "\t";
            }
            $line .= $value;
        }
        $data .= trim( $line ) . "\n";
    }
    $data = str_replace( "\r" , "" , $data );

    if ( $data == "" )
    {
        $data = "\n(0) Records Found!\n";
    }

    header ('Content-type: text/html; charset=utf-8');
    header("Content-type: application/octet-stream");
    header("Content-Disposition: attachment; filename=export.xls");
    header("Pragma: no-cache");
    header("Expires: 0");
    print "$header\n$data";

print($d1);
mysql_close($db);

?>