php通过windows。open传递值问题以及中文字符匹配问题

Question

php

Answer 1

A页面<?php
//订单查询
if ($_POST['1shijian1'])
{
echo '<link rel="stylesheet" type="text/css" href="i_code/style.css" /><title>数据查询</title>';
echo "<script type='text/javascript'>
document.getElementById('1shijian1').value='".$_POST['1shijian1'].
"';document.getElementById('1shijian2').value='".$_POST['1shijian2'].
"';</script>";if ($_POST['1shijian1']<>NULL)
$shijian1=" and COPTC.TC003>=".$_POST['1shijian1'];
else
$shijian1="";if ($_POST['1shijian2']<>NULL)
$shijian2=" and COPTC.TC003<=".$_POST['1shijian2'];
else
$shijian2="";
require_once('i_code/connect.php');$query="select leixing,null as xifen,null as sewen,null as ddgm,bztdb, null as daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007
FROM chaxun
LEFT JOIN DDTJMX ON MA003=leixing
left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002 
where xifen=''".$shijian1.$shijian2." GROUP BY leixing,bztdb
union all
select leixing,xifen,null as sewen,null as ddgm,bztdb,null as daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007
FROM chaxun
LEFT JOIN DDTJMX ON MA003=leixing and xifen=XIFEN 
left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002 
where  xifen='5050' ".$shijian1.$shijian2." GROUP BY leixing,xifen,bztdb
union all
select leixing,xifen,sewen,ddgm,bztdb,daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007
FROM chaxun
LEFT JOIN DDTJMX ON MA003=leixing and xifen=XIFEN AND sewen=DDTJMX.UDF10 AND ddgm=DDGM and daba=XINGHAO 
left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002 
where xifen<>'' and xifen<>'5050'".$shijian1.$shijian2." GROUP BY leixing,xifen,sewen,ddgm,bztdb,daba order by xifen,sewen,daba";
$result=mssql_query($query);
$row_num=mssql_num_rows($result);if ($row_num>0)
{
echo "<table class='tablehkled'  id='tablecolor' align='center' border='1' cellspacing='1'cellpadding='1' style='width:80%'>
<tr align='center'>";
echo "<th  style='width:80px'>产品类别</th>;
<th style='width:80px'>产品细分</th>;
<th style='width:150px'>色温</th>;
<th style='width:100px'>订单规模</th>;
<th style='width:100px'>标准投单比</th>;
<th style='width:100px'>打靶</th>;
<th style='width:100px'>订单量</th>;
<th style='width:100px'>预计产量</th>;
<th style='width:100px'>总入库数</th>;
<th style='width:80px'>标准入库</th>;
<th style='width:80px'>销货数量</th>;
<th style='width:80px'>销退数量</th>;
<th style='width:80px'>跟踪信息</th>;
</tr></tr>";while($row=mssql_fetch_assoc($result))
{
echo"<tr  align='center'>";
    echo"<td>".$row['leixing']."</td>";
echo"<td>".$row['xifen']."</td>";
echo"<td>".$row['sewen']."</td>";
echo"<td>".$row['ddgm']."</td>";
echo"<td>".$row['bztdb']."</td>";
echo"<td>".$row['daba']."</td>";
echo"<td>".number_format($row['TD008'],0)."</td>";
echo"<td>".number_format($row['TA015'],0)."</td>";
echo"<td>".number_format($row['RKZS'],0)."</td>";
echo"<td>".number_format($row['D310'],0)."</td>";
echo"<td>".number_format($row['TH008'],0)."</td>";
echo"<td>".number_format($row['TJ007'],0)."</td>";
echo"<td  onclick='window.open(\"c_huizongall.php?n1=".strval($row['xifen'])."&n2=".strval($row['daba'])."\")'>跟踪信息</td>";

echo"</tr> \n";
}
echo"</table>";
echo'<SCRIPT type="text/javascript" src="i_code/color.js"></SCRIPT>';}mssql_close($conn);}
?>

Answer 2

B页面<?phpif ($_GET['n1'])
{
echo '<link rel="stylesheet" type="text/css" href="i_code/style.css" /><title>跟踪信息</title>';
require_once('i_code/connect.php');$querydd="select DDGM1.TD001,DDGM1.TD002,DDGM1.TD003,COPTD.TD004,COPTD.TD005,COPTD.TD016,MA003,DDGM1.UDF10,XINGHAO,XIFEN,DDGM,DDGM1.TD008,COPTD.UDF03,MOCTA.TA001,MOCTA.TA002,DDZS.TA015,MOCTA.TA011,MOCTA.UDF06,TDB,
CASE WHEN DDGM1.TD008=0 THEN 0 WHEN DDGM1.TD008<>0 THEN convert(decimal(18,3),DDZS.TA015/DDGM1.TD008) END AS SJB,DDZS.RKZS,D310,
CASE WHEN DDGM1.TD008=0 THEN 0 WHEN DDGM1.TD008<>0 THEN convert(decimal(18,3),D310/DDGM1.TD008) END AS DDDCL,D305,D304,D3023,TH008,TJ007
FROM DDGM1
LEFT JOIN  DDZS ON DDZS.TD001=DDGM1.TD001 AND DDZS.TD002=DDGM1.TD002 AND DDZS.TD003=DDGM1.TD003
LEFT JOIN COPTC ON COPTC.TC001=DDGM1.TD001 AND COPTC.TC002=DDGM1.TD002
left join MOCTA ON TA026=DDZS.TD001 AND TA027=DDZS.TD002 AND TA028=DDZS.TD003
left join COPTD ON COPTD.TD001=DDGM1.TD001 AND COPTD.TD002=DDGM1.TD002 AND COPTD.TD003=DDGM1.TD003
where  XIFEN LIKE ".$_GET['n1']." and XINGHAO LIKE ".$_GET['n2'];
$resultdd=mssql_query($querydd);
$row_numdd=mssql_num_rows($resultdd);
if ($row_numdd>0)
{
echo "<table class='tablehkled'  id='tablecolor' align='center' border='1' cellspacing='1'cellpadding='1' style='width:80%'>
<tr align='center'>";
echo "<th  style='width:200px'>订单单别单号</th>;
<th style='width:100px'>类型</th>;
<th style='width:160px'>色温</th>;
<th style='width:100px'>型号</th>;
<th style='width:80px'>细分</th>;
<th style='width:150px'>订单规模</th>;
<th style='width:100px'>订单数量</th>;
<th style='width:100px'>预计产量</th>;
<th style='width:100px'>标准投单比</th>;
<th style='width:120px'>实际投单比</th>;
<th style='width:80px'>入库总数</th>;
<th style='width:80px'>合格品入库</th>;
<th style='width:80px'>订单达成率</th>;
<th style='width:80px'>非标准入库</th>;
<th style='width:80px'>零头入库</th>;
<th style='width:80px'>废品入库</th>;
<th style='width:80px'>销货数量</th>;
<th style='width:80px'>销退数量</th>;
</tr></tr>";while($rowdd=mssql_fetch_assoc($resultdd))
{
echo"<tr  align='center'>";
 echo"<td>".$rowdd['TD001']."-".$rowdd['TD002']."-".$rowdd['TD003']."</td>";
echo"<td>".$rowdd['MA003']."</td>";
echo"<td>".$rowdd['UDF10']."</td>";
echo"<td>".$rowdd['XINGHAO']."</td>";
echo"<td>".$rowdd['XIFEN']."</td>";
echo"<td>".$rowdd['DDGM']."</td>";
echo"<td>".number_format($rowdd['TD008'],0)."</td>";
echo"<td>".number_format($rowdd['TA015'],0)."</td>";
echo"<td>".$rowdd['TDB']."</td>";
echo"<td>".$rowdd['SJB']."</td>";
echo"<td>".number_format($rowdd['RKZS'],0)."</td>";
echo"<td>".number_format($rowdd['D310'],0)."</td>";
echo"<td>".$rowdd['DDDCL']."</td>";
echo"<td>".number_format($rowdd['D305'],0)."</td>";
echo"<td>".number_format($rowdd['D304'],0)."</td>";
echo"<td>".number_format($rowdd['D3023'],0)."</td>";
echo"<td>".number_format($rowdd['TH008'],0)."</td>";
echo"<td>".number_format($rowdd['TJ007'],0)."</td>";

echo"</tr> \n";
}
echo"</table>";
}mssql_close($conn);
}
?>

Answer 3

需要的是从A页面的leixing  xifen  sewen  daba条件来给B页面作为查询条件，如何做呢