下面是我完整程序~~<?php
header("Content-type:text/csv");
header("Content-Disposition:filename=test.csv");$result = mysql_query("******");
$rows=mysql_num_rows($result);
for($i=0;$i<$rows;$i++)
{
$row=mysql_fetch_array($result);
echo "$row[0],";
echo "$row[1],";
echo "$row[2],";
echo "$row[3]\n";
}
?>
header("Content-type:text/csv");
header("Content-Disposition:filename=test.csv");$result = mysql_query("******");
$rows=mysql_num_rows($result);
for($i=0;$i<$rows;$i++)
{
$row=mysql_fetch_array($result);
echo "$row[0],";
echo "$row[1],";
echo "$row[2],";
echo "$row[3]\n";
}
?>
$fp = fopen($filename,"r");
while($data = fgetcsv($fp,'1000',','))
{
for($m = 0 ; $m < 7 ; $m++)
{
$data[$m] = mysql_escape_string($data[$m]);
}
insert_data ($data[0],$data[1],$data[2],$data[3],$data[4],$data[5],$data[6],$language);
}
}
}
fclose ($fp);