Description:
|
my ipn_res.php file does not seem to be looking for duplicate transaction
therefore if paypal sends me a notification several times regarding the same
transaction the credit gets posted multiple times
I want a check in my script that checks if the transaction id already exist, if
it does then dont process again
a sample check script can be found at
my current file is attached below
Additional information submitted:
04/30/2007 at 22:04 EDT:
sample script can be taken from paypaltech website
eg
/subscription handling branch
if ( $txn_type == "subscr_signup" || $txn_type ==
"subscr_payment" ) {
// insert subscriber payment info into paypal_payment_info table
$strQuery = "insert into
paypal_payment_info(paymentstatus,buyer_email,firstname,lastname,street,city,state,zipcode,country,mc_gross,mc_fee,memo,paymenttype,paymentdate,txnid,pendingreason,reasoncode,tax,datecreation)
values
('".$payment_status."','".$payer_email."','".$first_name."','".$last_name."','".$address_street."','".$address_city."','".$address_state."','".$address_zip."','".$address_country."','".$mc_gross."','".$mc_fee."','".$memo."','".$payment_type."','".$payment_date."','".$txn_id."','".$pending_reason."','".$reason_code."','".$tax."','".$fecha."')";
$result = mysql_query($strQuery) or die("Subscription -
paypal_payment_info, Query failed:<br>" . mysql_error() .
"<br>" . mysql_errno());
// insert subscriber info into paypal_subscription_info table
$strQuery2 = "insert into paypal_subscription_info(subscr_id ,
sub_event, subscr_date ,subscr_effective,period1,period2, period3, amount1
,amount2 ,amount3, mc_amount1, mc_amount2, mc_amount3, recurring,
reattempt,retry_at, recur_times, username ,password, payment_txn_id,
subscriber_emailaddress, datecreation) values ('".$subscr_id."',
'".$txn_type."','".$subscr_date."','".$subscr_effective."','".$period1."','".$period2."','".$period3."','".$amount1."','".$amount2."','".$amount3."','".$mc_amount1."','".$$mc_amount2."','".$$mc_amount3."','".$recurring."','".$reattempt."','".$retry_at."','".$recur_times."','".$username."','".$password."',
'".$txn_id."','".$payer_email."','".$fecha."')";
$result = mysql_query($strQuery2) or die("Subscription -
paypal_subscription_info, Query failed:<br>" . mysql_error() .
"<br>" . mysql_errno());
04/30/2007 at 22:07 EDT:
//check if transaction ID has been processed before
$checkquery = "select txnid from paypal_payment_info where
txnid='".$txn_id."'";
$sihay = mysql_query($checkquery) or die("Duplicate txn id check query
failed:<br>" . mysql_error() . "<br>" .
mysql_errno());
$nm = mysql_num_rows($sihay);
if ($nm == 0){
//execute query
Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now.
Related Projects:
 Oscommerce Contr. Fix
Upload "desi" Videos To Site
Logo for AsteriskFreelancers.com
Convert 17 jpegs to XHTML/CSS2
Sercrc.com/forums
This project is the proprietary information of .
Click here to remove this project from OUR database.
|
