如题所述
è¿é没æå¾å®æ¹ç解é,æ个人认为mysql_query ä¸è½æ¹éæ§è¡SQLè¯å¥çåå æ主è¦çä¸ä¸ªå°±æ¯Mysql_queryä¸è½å¤æä½ çæ¹éè¯å¥éé¢æ¯å¦å
å«é误.为äºæ大çä¿è¯ç¨åºç顺å©æ§è¡,æ以,å¹²è罢工äº.
解å³çåæ³,æå¾å¤ç§.è¿éä» ååºæçå¿å¾ä¹ä¸(å©ç¨æ°ç»ç¨Mysql_queryæ¹éæ§è¡SQLè¯å¥)
$query = âdelete from ecs_goods_attr where attr_id=138 and goods_id=442;Insert into ecs_goods_attr (goods_attr_id,goods_id,attr_id,attr_value,attr_price)values(Null,442,138,â欧ç ç½è²â,0);update ecs_goods set goods_number=10,shop_price=955 where goods_id=442;â
$query æ¯æéè¦æ§è¡çSQLè¯å¥,æ¾ç¶è¿é mysql_query($query); æ¯æ æ³å¾å°æ们æ³è¦çç»æç.è¿éæ们éç¨ä¸ä¸ªæ°ç».ç¨explode å½æ°,å°$queryè¯å¥æç §â;âç¸å¼.è¿ä¸ªè¯´çæ¯è¾å½¢è±¡.åµåµ
$query = âdelete from ecs_goods_attr where attr_id=138 and goods_id=442;Insert into ecs_goods_attr (goods_attr_id,goods_id,attr_id,attr_value,attr_price)values(Null,442,138,â欧ç ç½è²â,0);update ecs_goods set goods_number=10,shop_price=955 where goods_id=442;â
$query_e = explode(â;â,â$queryâ);
foreach ($query_e as $k =>$v)
{
mysql_query($query_e[$k]);
}
è¿æ · $queryè¯å¥å°±è¢«æ¹éçæ§è¡äº.åµåµ
解å³çåæ³,æå¾å¤ç§.è¿éä» ååºæçå¿å¾ä¹ä¸(å©ç¨æ°ç»ç¨Mysql_queryæ¹éæ§è¡SQLè¯å¥)
$query = âdelete from ecs_goods_attr where attr_id=138 and goods_id=442;Insert into ecs_goods_attr (goods_attr_id,goods_id,attr_id,attr_value,attr_price)values(Null,442,138,â欧ç ç½è²â,0);update ecs_goods set goods_number=10,shop_price=955 where goods_id=442;â
$query æ¯æéè¦æ§è¡çSQLè¯å¥,æ¾ç¶è¿é mysql_query($query); æ¯æ æ³å¾å°æ们æ³è¦çç»æç.è¿éæ们éç¨ä¸ä¸ªæ°ç».ç¨explode å½æ°,å°$queryè¯å¥æç §â;âç¸å¼.è¿ä¸ªè¯´çæ¯è¾å½¢è±¡.åµåµ
$query = âdelete from ecs_goods_attr where attr_id=138 and goods_id=442;Insert into ecs_goods_attr (goods_attr_id,goods_id,attr_id,attr_value,attr_price)values(Null,442,138,â欧ç ç½è²â,0);update ecs_goods set goods_number=10,shop_price=955 where goods_id=442;â
$query_e = explode(â;â,â$queryâ);
foreach ($query_e as $k =>$v)
{
mysql_query($query_e[$k]);
}
è¿æ · $queryè¯å¥å°±è¢«æ¹éçæ§è¡äº.åµåµ
温馨提示:答案为网友推荐,仅供参考