php _findfirst,lastorder.php-CSDN博客

这段代码定义了一个名为findFirstOrder的函数，用于从MySQL数据库中查找特定微信开放ID（$openID）的订单，条件是订单价格大于100且订单状态在预设的状态列表中。它首先连接到本地的MySQL数据库，然后执行SQL查询，该查询按订单ID排序并限制返回第一条匹配的记录。最后，函数返回查询结果的订单ID或0。

摘要由CSDN通过智能技术生成

echo findFirstOrder("oCxKG1g-CaDrTtCwYsa0Dfh0a_Y0");

function findFirstOrder($openID){

$arr = ["'50504030'","'350504048'","'350796210'","'350796228'","'350796237'","'350796243'","'350836627'","'352758730'","'357337707'","'403371642'","'408181576'","'409529950'","'413187007'","'416584864'","'420406250'"];

$status = ["'TRADE_BUYER_SIGNED'","'WAIT_SELLER_SEND_GOODS'","'WAIT_BUYER_CONFIRM_GOODS'","'TRADE_CLOSED'"];

$goodids = implode(",", $arr);

$statuss = implode(",", $status);

$con = mysql_connect("localhost","root","88524494");

if ($con)

{

mysql_select_db("fenshiOrder", $con);

}

$sql = "SELECT orderID FROM `orders` WHERE price > 100 AND `status` IN (".$statuss.") AND `goodid`IN(".$goodids.") AND `wxopenID` = '".$openID."' ORDER BY `orders`.`orderID` ASC limit 1";

$result = mysql_query($sql,$con);

while ($obj = mysql_fetch_array($result,MYSQL_ASSOC)) {

$begintime = $obj['orderID'];

return $begintime;

}

return 0;

}

一键复制

编辑

Web IDE

原始数据

按行查看