A页面一个跟踪信息按钮通过windows.open打开另一个页面B,需要通过A页面的同一行的条件来查询出结果显示在B上,数值是通过post还是get可以从A页面的数值取出呢
回复讨论(解决方案)
A页面 //订单查询
if ($_POST['1shijian1'])
{
echo '
echo "<script> <br /> document.getElementById('1shijian1').value='".$_POST['1shijian1']. <br /> "';document.getElementById('1shijian2').value='".$_POST['1shijian2']. <br /> "';</script>";
if ($_POST['1shijian1']NULL)
$shijian1=" and COPTC.TC003>=".$_POST['1shijian1'];
else
$shijian1="";
if ($_POST['1shijian2']NULL)
$shijian2=" and COPTC.TC003 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 "
产品类别 | ;产品细分 | ;色温 | ;订单规模 | ;标准投单比 | ;打靶 | ;订单量 | ;预计产量 | ;总入库数 | ;标准入库 | ;销货数量 | ;销退数量 | ;跟踪信息 | ;
---|---|---|---|---|---|---|---|---|---|---|---|---|
".$row['leixing']." | ";".$row['xifen']." | ";".$row['sewen']." | ";".$row['ddgm']." | ";".$row['bztdb']." | ";".$row['daba']." | ";".number_format($row['TD008'],0)." | ";".number_format($row['TA015'],0)." | ";".number_format($row['RKZS'],0)." | ";".number_format($row['D310'],0)." | ";".number_format($row['TH008'],0)." | ";".number_format($row['TJ007'],0)." | ";跟踪信息 | ";
echo'<script></script>';
}
mssql_close($conn);
}
?>
B页面
if ($_GET['n1'])
{
echo '
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.TD0080 THEN convert(decimal(18,3),DDZS.TA015/DDGM1.TD008) END AS SJB,DDZS.RKZS,D310,
CASE WHEN DDGM1.TD008=0 THEN 0 WHEN DDGM1.TD0080 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 "
订单单别单号 | ;类型 | ;色温 | ;型号 | ;细分 | ;订单规模 | ;订单数量 | ;预计产量 | ;标准投单比 | ;实际投单比 | ;入库总数 | ;合格品入库 | ;订单达成率 | ;非标准入库 | ;零头入库 | ;废品入库 | ;销货数量 | ;销退数量 | ;
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
".$rowdd['TD001']."-".$rowdd['TD002']."-".$rowdd['TD003']." | ";".$rowdd['MA003']." | ";".$rowdd['UDF10']." | ";".$rowdd['XINGHAO']." | ";".$rowdd['XIFEN']." | ";".$rowdd['DDGM']." | ";".number_format($rowdd['TD008'],0)." | ";".number_format($rowdd['TA015'],0)." | ";".$rowdd['TDB']." | ";".$rowdd['SJB']." | ";".number_format($rowdd['RKZS'],0)." | ";".number_format($rowdd['D310'],0)." | ";".$rowdd['DDDCL']." | ";".number_format($rowdd['D305'],0)." | ";".number_format($rowdd['D304'],0)." | ";".number_format($rowdd['D3023'],0)." | ";".number_format($rowdd['TH008'],0)." | ";".number_format($rowdd['TJ007'],0)." | ";
}
mssql_close($conn);
}
?>
需要的是从A页面的leixing xifen sewen daba条件来给B页面作为查询条件,如何做呢

ThebestapproachforsendingemailsinPHPisusingthePHPMailerlibraryduetoitsreliability,featurerichness,andeaseofuse.PHPMailersupportsSMTP,providesdetailederrorhandling,allowssendingHTMLandplaintextemails,supportsattachments,andenhancessecurity.Foroptimalu

The reason for using Dependency Injection (DI) is that it promotes loose coupling, testability, and maintainability of the code. 1) Use constructor to inject dependencies, 2) Avoid using service locators, 3) Use dependency injection containers to manage dependencies, 4) Improve testability through injecting dependencies, 5) Avoid over-injection dependencies, 6) Consider the impact of DI on performance.

PHPperformancetuningiscrucialbecauseitenhancesspeedandefficiency,whicharevitalforwebapplications.1)CachingwithAPCureducesdatabaseloadandimprovesresponsetimes.2)Optimizingdatabasequeriesbyselectingnecessarycolumnsandusingindexingspeedsupdataretrieval.

ThebestpracticesforsendingemailssecurelyinPHPinclude:1)UsingsecureconfigurationswithSMTPandSTARTTLSencryption,2)Validatingandsanitizinginputstopreventinjectionattacks,3)EncryptingsensitivedatawithinemailsusingOpenSSL,4)Properlyhandlingemailheaderstoa

TooptimizePHPapplicationsforperformance,usecaching,databaseoptimization,opcodecaching,andserverconfiguration.1)ImplementcachingwithAPCutoreducedatafetchtimes.2)Optimizedatabasesbyindexing,balancingreadandwriteoperations.3)EnableOPcachetoavoidrecompil

DependencyinjectioninPHPisadesignpatternthatenhancesflexibility,testability,andmaintainabilitybyprovidingexternaldependenciestoclasses.Itallowsforloosecoupling,easiertestingthroughmocking,andmodulardesign,butrequirescarefulstructuringtoavoidover-inje

PHP performance optimization can be achieved through the following steps: 1) use require_once or include_once on the top of the script to reduce the number of file loads; 2) use preprocessing statements and batch processing to reduce the number of database queries; 3) configure OPcache for opcode cache; 4) enable and configure PHP-FPM optimization process management; 5) use CDN to distribute static resources; 6) use Xdebug or Blackfire for code performance analysis; 7) select efficient data structures such as arrays; 8) write modular code for optimization execution.

OpcodecachingsignificantlyimprovesPHPperformancebycachingcompiledcode,reducingserverloadandresponsetimes.1)ItstorescompiledPHPcodeinmemory,bypassingparsingandcompiling.2)UseOPcachebysettingparametersinphp.ini,likememoryconsumptionandscriptlimits.3)Ad


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

Notepad++7.3.1
Easy-to-use and free code editor
