¿ìËÙÒµÎñͨµÀ

ͨ¹ý»º´æÊý¾Ý¿â½á¹ûÌá¸ßPHPÐÔÄÜ

×÷Õß ØýÃû¼¼Êõ À´Ô´ NET±à³Ì ä¯ÀÀ ·¢²¼Ê±¼ä 2012-05-25
ºó£º

IF (tblname = ''OE.ORDERS'') THEN
FOR j IN 1..numrows LOOP
row_id := ntfnds.table_desc_array(i).row_desc_array(j).row_id;
SELECT order_id INTO ord_id FROM orders WHERE rowid = row_id;
sendNotification(url, tblname, ord_id); 
END LOOP;
END IF;
¡¡¡¡²åÈëÒÔÏ´úÂ룺

IF (tblname = ''OE.ORDER_ITEMS'') THEN
FOR rec IN (SELECT DISTINCT(o.order_id) o_id FROM 
TABLE(CAST(ntfnds.table_desc_array(i).row_desc_array AS rdesc_tab)) t,
orders o, order_items d WHERE t.row_id = d.rowid AND d.order_id=o.order_id)
LOOP
sendNotification(url, tblname, rec.o_id); 
END LOOP;
END IF;
¡¡¡¡ÖØд´½¨ orders_nf_callback ºó£¬ÄúÐèÒª²âÊÔËüÄÜ·ñÕý³£¹¤×÷¡£Îª´Ë£¬Äú¿ÉÒÔÕë¶Ô ORDER_ITEMS ±íÖ´ÐÐÏÂÁÐ UPDATE Óï¾ä²¢Ìá½»¸ÃÊÂÎñ£º

UPDATE ORDER_ITEMS SET quantity = 160 WHERE order_id=2421 AND line_item_id=1;
UPDATE ORDER_ITEMS SET quantity = 160 WHERE order_id=2421 AND line_item_id=2;
COMMIT;
¡¡¡¡È»ºó£¬¼ì²é nfresults ±í£¬ÈçÏÂËùʾ£º

SELECT TO_CHAR(operdate, ''dd-mon-yy hh:mi:ss'') operdate, 
rslt_msg FROM nfresults WHERE tblname = ''OE.ORDER_ITEMS'';¡¡¡¡Êä³ö¿ÉÄÜÈçÏÂËùʾ£º

OPERDATE            RSLT_MSG
------------------- --------------
03-mar-06 12:32:27  Not Found
¡¡¡¡Äú¿ÉÄܺÜÆæ¹ÖΪʲôֻÏò nfresults ±íÖвåÈëÁËÒ»ÐÐ ¨C ±Ï¾¹Äú¸üÐÂÁË ORDER_ITEMS ±íÖеÄÁ½ÐС£Êµ¼ÊÉÏ£¬ÕâÁ½¸ö¸üÐÂÁ˵ÄÐоßÓÐÏàͬµÄ order_id ¨C ¼´ËüÃÇÊôÓÚͬһ¶©µ¥¡£´Ë´¦£¬ÎÒÃǼÙÉè¿Í»§¶ËÓ¦ÓóÌÐò½«Ê¹ÓÃÒ»¸öÓï¾äÑ¡Ôñ¶©µ¥µÄËùÓж©µ¥ÏÒò´ËËü²¢²»ÐèҪȷÇÐÖªµÀÒѾ­¸ü¸ÄÁËij¸ö¶©µ¥µÄÄÄЩ¶©µ¥Ïî¡£Ïà·´£¬¿Í»§¶ËÐèÒªÖªµÀÆäÖÐÖÁÉÙÐ޸ġ¢É¾³ý»ò²åÈëÁËÒ»¸ö¶©µ¥ÏîµÄ¶©µ¥ ID¡£

¹¹½¨¿Í»§¶Ë

¡¡¡¡ÏÖÔÚ£¬ÄúÒѾ­Õë¶Ô ORDERS ºÍ ORDER_ITEMS ±í´´½¨ÁË×¢²á£¬ÏÂÃæÎÒÃǽ«Á˽âһϷÃÎÊÕâЩ±íÖд洢µÄ¶©µ¥¼°Æ䶩µ¥ÏîµÄ¿Í»§¶ËÓ¦ÓóÌÐòÈçºÎʹÓøü¸Ä֪ͨ¡£Îª´Ë£¬Äú¿ÉÒÔ¹¹½¨Ò»¸ö PHP Ó¦ÓóÌÐò£¬Ëü½«»º´æÕë¶ÔÒÔÉϱíµÄ²éѯ½á¹û£¬²¢²ÉÈ¡ÏàÓ¦µÄ²Ù×÷À´ÏìÓ¦ÓйضÔÕâЩ±íËù×ö¸ü¸ÄµÄ֪ͨ£¨´ÓÊý¾Ý¿â·þÎñÆ÷ÖÐÊÕµ½ÕâЩ֪ͨ£©¡£Ò»¸ö¼òµ¥µÄ·½·¨ÊÇʹÓà PEAR::Cache_Lite ³ÌÐò°ü£¬ËüΪÄúÌṩÁËÒ»¸ö¿É¿¿µÄ»úÖÆÀ´Ê¹»º´æÊý¾Ý±£³Ö×îÐÂ״̬¡£ÓÈÆäÊÇ£¬Äú¿ÉÒÔʹÓà Cache_Lite_Function ÀࣨPEAR::Cache_Lite ³ÌÐò°üµÄÒ»²¿·Ö£©£¬Í¨¹ý¸ÃÀàÄú¿ÉÒÔ»º´æº¯Êýµ÷Óá£

¡¡¡¡ÀýÈ磬Äú¿ÉÒÔ´´½¨Ò»¸öº¯ÊýÀ´Ö´ÐÐÏÂÁÐÈÎÎñ£º½¨Á¢Êý¾Ý¿âÁ¬½Ó¡¢Õë¶Ô¸ÃÊý¾Ý¿âÖ´ÐÐ select Óï¾ä¡¢»ñÈ¡¼ìË÷½á¹û²¢×îÖÕÒÔÊý×éÐÎʽ·µ»Ø½á¹û¡£È»ºó£¬Äú¿ÉÒÔͨ¹ý Cache_Lite_Function ʵÀýµÄ call ·½·¨»º´æÓɸú¯Êý·µ»ØµÄ½á¹ûÊý×飬ÒÔ±ã¿ÉÒÔ´Ó±¾µØ»º´æ¶ø²»ÊÇ´Óºó¶ËÊý¾Ý¿â¶ÁÈ¡ÕâЩÊý×飬ÕâÑù¿ÉÒÔÏÔÖøÌá¸ßÓ¦ÓóÌÐòµÄÐÔÄÜ¡£È»ºó£¬ÔÚÊÕµ½»º´æÊý¾Ý¸ü¸ÄµÄ֪ͨʱ£¬Äú½«Ê¹Óà Cache_Lite_Function ʵÀýµÄ drop ·½·¨É¾³ý»º´æÖеĹýÆÚÊý¾Ý¡£

¡¡¡¡»Ø¹ýÍ·À´¿´¿´±¾ÎĵÄʾÀý£¬Äú¿ÉÄÜÒª´´½¨Á½¸öº¯Êý£¬ÓÃÓÚÓ¦ÓóÌÐòÓëÊý¾Ý¿â½»»¥£ºµÚÒ»¸öº¯Êý½«²éѯ ORDERS ±í²¢·µ»Ø¾ßÓÐÖ¸¶¨ ID µÄ¶©µ¥£¬¶øÁíÒ»¸öº¯Êý½«²éѯ ORDER_ITEMS ±í²¢·µ»Ø¸Ã¶©µ¥µÄ¶©µ¥Ïî¡£¡°Çåµ¥ 4¡±ÏÔʾÁË°üº¬ getOrderFields º¯Êý£¨¸Ãº¯Êý½ÓÊܶ©µ¥ ID ²¢·µ»ØÒ»¸ö°üº¬Ëù¼ìË÷µ½¶©µ¥µÄijЩ×ֶεĹØÁªÊý×飩µÄ getOrderFields.php ½Å±¾¡£

¡¡¡¡Çåµ¥ 4. »ñÈ¡Ö¸¶¨¶©µ¥µÄ×Ö¶Î

£¼?php
//File:getOrderFields.php
require_once ''connect.php'';
function getOrderFields($order_no) {
if (!$rsConnection = GetConnection()){
return false;
   }
$strSQL = "SEL

ÁèÖڿƼ¼×¨ÒµÌṩ·þÎñÆ÷×âÓᢷþÎñÆ÷Íйܡ¢ÆóÒµÓʾ֡¢ÐéÄâÖ÷»úµÈ·þÎñ£¬¹«Ë¾ÍøÕ¾£ºhttp://www.lingzhong.cn ΪÁ˸ø¹ã´ó¿Í»§Á˽â¸ü¶àµÄ¼¼ÊõÐÅÏ¢£¬±¾¼¼ÊõÎÄÕÂÊÕ¼¯À´Ô´ÓÚÍøÂç,ÁèÖڿƼ¼×ðÖØÎÄÕÂ×÷ÕߵİæȨ£¬Èç¹ûÓÐÉæ¼°ÄãµÄ°æȨÓбØҪɾ³ýÄãµÄÎÄÕ£¬ÇëºÍÎÒÃÇÁªÏµ¡£ÒÔÉÏÐÅÏ¢ÓëÎÄÕÂÕýÎÄÊDz»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúҪתÔر¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»!

·ÖÏíµ½£º ¸ü¶à
Äã¿ÉÄܶÔÏÂÃæµÄÎÄÕ¸ÐÐËȤ
HTTP/1.1 401 Access Denied æÖƸ߹âË®¾§ÖʸÐË®¾§Æ»¹û" target="_blank">Photoshop»æÖƸ߹âË®¾§ÖʸÐË®¾§Æ»¹û

Copyright ©1999-2011 ÏÃÃÅÁèÖڿƼ¼ÓÐÏÞ¹«Ë¾ ÏÃÃÅÓÅͨ»¥Áª¿Æ¼¼¿ª·¢ÓÐÏÞ¹«Ë¾ All rights reserved

µØÖ·(ADD)£ºÏÃÃÅÈí¼þÔ°¶þÆÚÍûº£Â·63ºÅ701E£¨¶«ÄÏÈÚͨÅÔ£© Óʱà(ZIP)£º361008

µç»°£º0592-5908028 ´«Õ棺0592-5908039 ×ÉѯÐÅÏ䣺web@lingzhong.cn ×ÉѯOICQ£º173723134

¡¶ÖлªÈËÃñ¹²ºÍ¹úÔöÖµµçÐÅÒµÎñ¾­ÓªÐí¿ÉÖ¤¡·ÃöB2-20100024  ICP±¸°¸:ÃöICP±¸05037997ºÅ