Štampaš html kod pre cvs podataka.
PHP kôd:
<?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>
//Select lista samo za jednu opciju
<?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 } ?>