AsifKhan Posted August 16, 2010 Posted August 16, 2010 Hello, Sorry for bad english. Some one help me plz Actually i m using smarty, i am facing an issue with payment status. i use query to update the status of order id. when i click on pay now button from paypal page, there are two cases now, 1. if i use hard coded order id like $_oid = '683-7048307-8132954'; it works fine. 2. if use $_SESSION['order_id']; it does not work. and both session order id and hard coded are same. code is here in front of u /********************************************/ $_oid = $_SESSION['order_id_string']; // $_oid = '683-7048307-8132954'; $check = $db->executeScalar("Select status from table where order_id = '".$_oid."'"); // var_dump($check); // exit; if ($check == 0){ $_memberid = $_SESSION['userid']; $oname = $db->executeTwise("Select fname, lname from members where id= '".$_memberid."'"); // var_dump($oname); // exit; $update_trans = "Update orders set status = '1', standingstatus = '1' where order_id = '".$_oid."'"; $db->execute($update_trans); }
web-project Posted August 16, 2010 Posted August 16, 2010 PayPal IPN should return the order number to process the order status. You can debug the PayPal IPN, using the PayPal INP log which available in PayPal account. Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.