Beyaz.Net İpucu
Mysql Verilerini Excele Aktarma, PHP Excel Alma
<?
ini_set("display_errors",0);
$domain="";
$username="";
$sifre="";
$dbname="";
$dbconnect=@mysql_connect($domain,$username,$sifre);
@mysql_select_db($dbname,$dbconnect);
@mysql_query( "SET NAMES 'utf8'" );
$filename = "urunler-".date('Ymd').".xls";
header("Content-Disposition: attachment; filename=\"$filename\"");
//header("Content-Type: application/vnd.ms-excel");
header('Content-Type: application/x-msexcel; charset=UTF-8; format=attachment;');
$flag = false;
$sqlurunler="select * from urunler where
order by ID";
$sonucurunler=mysql_query($sqlurunler);
while($row = mysql_fetch_assoc($sonucurunler))
{
if(!$flag)
{
echo implode("\t", array_keys($row)) . "\r\n";
$flag = true;
}
echo implode("\t", array_values($row)). "\r\n";
}
exit;
ini_set("display_errors",0);
$domain="";
$username="";
$sifre="";
$dbname="";
$dbconnect=@mysql_connect($domain,$username,$sifre);
@mysql_select_db($dbname,$dbconnect);
@mysql_query( "SET NAMES 'utf8'" );
$filename = "urunler-".date('Ymd').".xls";
header("Content-Disposition: attachment; filename=\"$filename\"");
//header("Content-Type: application/vnd.ms-excel");
header('Content-Type: application/x-msexcel; charset=UTF-8; format=attachment;');
$flag = false;
$sqlurunler="select * from urunler where
order by ID";
$sonucurunler=mysql_query($sqlurunler);
while($row = mysql_fetch_assoc($sonucurunler))
{
if(!$flag)
{
echo implode("\t", array_keys($row)) . "\r\n";
$flag = true;
}
echo implode("\t", array_values($row)). "\r\n";
}
exit;