Ovo je sve:
PHP kôd:
<?php
ob_start();
include('include/config.php');
mysql_query("set names 'utf8'");
function toCSV($header, $data, $filename) {
$sep = "\t";
$eol = "\n";
$csv = count($header) ? '"'. implode('"'.$sep.'"', escape_csv($header) ).'"'.$eol : '';
foreach($data as $line) {
$csv .= '"'. implode('"'.$sep.'"', escape_csv($line) ).'"'.$eol;
}
header('Content-Description: File Transfer');
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename='.$filename.'.csv');
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
$csv = chr(255) . chr(254) . mb_convert_encoding($csv, 'UTF-16LE', 'UTF-8');
header('Content-Length: '. strlen($csv));
echo $csv;
exit;
ob_flush();
}
function escape_csv(array $row) {
$sep = "\t";
$eol = "\n";
return str_replace(array($sep, $eol, '"'), array(' ', ' ', '\"'), $row);
}
?>
<?php
if (isset($_POST['submit']))
{
$select = "SELECT *from radnik where pozicija ='Uprava' ";
$export = mysql_query( $select ) or die ( "Sql error : " . mysql_error( ) );
$fields = mysql_num_fields( $export );
$header = $data = array();
for ( $i = 0; $i < $fields; $i++ )
{
$header[] = mysql_field_name( $export , $i );
}
while( $row = mysql_fetch_row( $export ) )
{
$data[] = $row;
}
if ( !$data )
{
$data[] = array("(0) Pronadjeno zapisa!");
}
$filename='test';
toCSV($header, $data, $filename);
} else {
?>
<html>
<body>
<?php echo'<form method="POST" action="'.$_SERVER['PHP_SELF'].'">
<select name="pozicija">
<option value="Uprava">Uprava</option>
</select>
<input type="submit" name="submit" value="export">
</form>';?>
</body>
</html>
<?php } ?>