php 写数据库查询语句吗,反复写入数据库之后，同样的查询语句却查询不出结果...

小鱼儿 2023-01-16 14:29 106阅读 0赞

重复写入数据库之后，同样的查询语句却查询不出结果

set\_time\_limit(0);

$filepath=$\_GET\['uploadfile'\];

require\_once '../conn.php';

error\_reporting(E\_ALL ^ E\_NOTICE);

$line=0;

$shipments=0;

$i=0;

$s=0;

$f=0;

$strSqla="SELECT MAX(number) FROM \`sale\_orders\_restock\`";  //查询sale\_orders\_restock表id字段最大值

$querya = mysql\_query($strSqla,$conn);

$resultaa= mysql\_fetch\_row($querya);

$maxnum=$resultaa\[0\];

$maxnum++;

$file = fopen($filepath,"r") or die("打开文件失败");

while (!feof($file)) \{

$buffer = fgets($file);

if ($line<>0)

$u=explode('', trim($buffer));

if(!empty($u\[0\]))\{

$sku=$u\[10\];

$sql\_itemcode="SELECT \* FROM \`sku\_rule\` WHERE \`sku\` = '$sku'";

$querya = mysql\_query($sql\_itemcode,$conn);

$rs= mysql\_fetch\_array($querya);

$jj\_sku=$rs\['item\_code'\];

$delivery\_areas=$rs\['delivery\_areas'\];

$zhanghao=$rs\['account'\];

$or\_id=$u\[0\];

$or\_it\_id=$u\[1\];

$payments\_date=$u\[3\];

$buyer\_email=$u\[7\];

$buyer\_name=mb\_convert\_encoding(addslashes($u\[8\]), 'UTF-8','utf-8, shft-jis, gbk');

$buyer\_phone=mb\_convert\_encoding(addslashes($u\[9\]), 'UTF-8','utf-8, shft-jis, gbk');

$product\_name=mb\_convert\_encoding(addslashes($u\[11\]), 'UTF-8','utf-8, shft-jis, gbk');

$quantity=$u\[12\];

$recipient\_name=mb\_convert\_encoding(addslashes($u\[16\]), 'UTF-8','utf-8, shft-jis, gbk');

$ship\_address1=mb\_convert\_encoding(addslashes($u\[17\]), 'UTF-8','utf-8, shft-jis, gbk');

$ship\_address2=mb\_convert\_encoding(addslashes($u\[18\]), 'UTF-8','utf-8, shft-jis, gbk');

$ship\_address3=mb\_convert\_encoding(addslashes($u\[19\]), 'UTF-8','utf-8, shft-jis, gbk');

$ship\_city=mb\_convert\_encoding(addslashes($u\[20\]), 'UTF-8','utf-8, shft-jis, gbk');

$ship\_state=mb\_convert\_encoding(addslashes($u\[21\]), 'UTF-8','utf-8, shft-jis, gbk');

$ship\_postal=mb\_convert\_encoding(addslashes($u\[22\]), 'UTF-8','utf-8, shft-jis, gbk');

$ship\_country=mb\_convert\_encoding($u\[23\], 'UTF-8','utf-8, shft-jis, gbk');

$cancel\_order=0;

$logistics\_number="";

$logistics\_company="";

$strSql\_item="SELECT \* FROM \`jperp\`.\`1\_item\_codes\` WHERE \`item\_code\`='$jj\_sku'";

$query\_item = mysql\_query($strSql\_item,$conn);

$rs=mysql\_affected\_rows();

$kit=0;

if($rs>1)

while($rs = mysql\_fetch\_array($query\_item) )\{

$or\_it="";

$jj\_sku=$rs\['stock\_id'\];

$item\_quantity=$rs\['quantity'\];

$quantity=$quantity\*$item\_quantity;

if($kit>0)\{

$or\_it=$or\_it\_id.$kit;

else

$or\_it=$or\_it\_id;

$sql\_sale=" INSERT INTO \`amazon\_erp\`.\`sale\_orders\_restock\` (\`number\` ,\`order\_id\` ,\`order\_item\_id\`,\`shipments\` ,\`payments\_date\` ,\`buyer\_email\` ,\`buyer\_name\`,\`buyer\_phone\_number\`,\`sku\`,\`jj\_sku\`,\`product\_name\`,\`quantity\_purchased\`,\`recipient\_name\`,\`ship\_address\_1\`,\`ship\_address\_2\`,\`ship\_address\_3\`,\`ship\_state\`,\`ship\_postal\_code\`,\`ship\_country\`,\`account\`,\`ship\_city\`,\`cancel\_order\`,\`delivery\_areas\`,\`logistics\_number\`,\`logistics\_company\`)VALUES ('$maxnum','$or\_id','$or\_it',  '$shipments', '$payments\_date','$buyer\_email', '$buyer\_name','$buyer\_phone','$sku' ,'$jj\_sku', '$product\_name', '$quantity', '$recipient\_name', '$ship\_address1', '$ship\_address2','$ship\_address3','$ship\_state' , '$ship\_postal', '$ship\_country', '$zhanghao', '$ship\_city','$cancel\_order','$delivery\_areas','$logistics\_number','$logistics\_company')";