echo '<script>window.open("outputcsv.php?number='.$maxnum.'");</script>';
echo '<script>window.open("label_outputcsv.php?number='.$maxnum.'");</script>';
这两个页面分别从数据库导出两个不同的excel表格,然后下载单独调用一个,没问题,同时打开两个都没有
echo '<script>window.open("label_outputcsv.php?number='.$maxnum.'");</script>';
这两个页面分别从数据库导出两个不同的excel表格,然后下载单独调用一个,没问题,同时打开两个都没有
这两段代码在一个页面,我想同时打开两个页面,这两个页面会生成两个excel下载,现在问题是只有一个有作用echo '<script>window.open("outputcsv.php?number='.$maxnum.'");</script>';
echo '<script>window.open("label_outputcsv.php?number='.$maxnum.'");</script>';
echo '<script>window.open("labela_outputcsv.php?number='.$maxnum.'","_blank");</script>';
echo '<script>location.href="outputcsv.php?number='.$maxnum.'"</script>';由labela_outputcsv.php跳转到label_outputcsv.php
但是又产生了一个问题
就是echo '<script>location.href="outputcsv.php?number='.$maxnum.'"</script>';我点下载文件,结果网页刷新了一下,导出来的就是空数据了
echo '<script>window.open("http://www.sina.com");</script>';
echo '<script>window.open("http://www.sohu.com");</script>';除非你里面的变量有问题,或者是浏览器拦截了你的弹出窗口,现在浏览器都具备这种基础功能,拦截弹出窗口。
$id=$_GET['number'];
include("conn.php");
$Date = date("YmdHis");
$Filename = "Warehouse".$Date.".csv";
$Table = isset($_GET['tid'])?$_GET['tid']:'';
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=".$Filename);
echo "SKU,product-name,sum(quantity),\r\n";
$Sql = "select *,sum(`quantity-purchased`) from sale_orders WHERE `number`=$id group by `jj_sku`";
$Result = mysql_query($Sql);
while($rs = mysql_fetch_array($Result) ){
$j_sku=$rs['jj_sku'];
$Sqlpr = "SELECT * FROM `product_co` WHERE `jj_sku`= $j_sku";
$Resulta = mysql_query($Sqlpr);
$resultaa= mysql_fetch_array($Resulta);echo $j_sku.",".$resultaa['product-name'].",". $rs['sum(`quantity-purchased`)']."\r\n";$sqlab="SELECT * FROM `sale_orders` WHERE `number`=$id AND `jj_sku`='$j_sku'";
$resultb=mysql_query($sqlab);while($row = mysql_fetch_array($resultb))
{
echo " ".$row['order_id'].",".$resultaa['product-name'].",".$row['quantity-purchased']."\r\n";
}
}
?>