PayPal IPN

[millercj]

I'm hoping someone here is familiar with PayPal IPN...I'm having issues implementing unit pricing to transfer to my database. Without it it runs perfectly but with my attempt at an implementation it does less.

 

I have the item price is initialized with

$item_price=$post['mc_gross'];

 

then

 

$result = mysql_query($strQuery) or die("Cart - paypal_payment_info, Query failed:<br>" . mysql_error() . "<br>" . mysql_errno());
for ($i = 1; $i <= $num_cart_items; $i++)
{
$itemname = "item_name".$i;
$itemnumber = "item_number".$i;
$itemprice = "mc_gross_".$i;
$on0 = "option_name1_".$i;
$os0 = "option_selection1_".$i;
$on1 = "option_name2_".$i;
$os1 = "option_selection2_".$i;
$quantity = "quantity".$i;

$struery = "insert into OrderData(tid,itemname,itemnumber,qty, price) values ('".$txn_id."','".$_POST[$itemname]."','".$_POST[$itemnumber]."','".$_POST[$quantity]."','".$_POST[$itemprice]."')";

$result = mysql_query($struery) or die("Cart - paypal_cart_info, Query failed:<br>" . mysql_error() . "<br>" . mysql_errno());
}

 

What's happening is it's just saving the first product (and no subsequent) with no price so it's hanging up somewhere cause it terminates the php script (i never get an IPN Verfication Email but it still posts data to my DB)...I really need help on this one

 

I'm not sure if you need the full code. Just ask if it'll be helpful.

[mrMarcus]

first and foremost .. $post['mc_gross'] will not work .. perhaps it's a typo?  should be $_POST['mc_gross'];

 

i don't see $item_price or $post['mc_gross'] in the script posted .. is that correct?

 

i'm also not sure if mc_gross can be posted-back .. you may want to look into the fields that can be used to pass values back via IPN.

 

i know 'custom' can be used .. and 'item_number' .. check into the rest.

 

i just finished implementing PayPal and IPN recently, so i'll be more than willing to help.

 

just make sure your variables are in order and such.

[millercj]

Ok that $_POST was a typo on my part. As far as what you're saying it makes sense but let me post you my whole code. I got most of it from on online IPN generator and it worked great until i tried to expand it.

 

<?php
// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';
foreach ($_POST as $key => $value) 
{
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}
// post back to PayPal system to validate
$header = "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";

$fp = fsockopen ('ssl://www.paypal.com', 443, $errno, $errstr, 30);

// assign posted variables to local variables
$item_name = $_POST['item_name'];
$business = $_POST['business'];
$item_number = $_POST['item_number'];
$item_price = $_POST['mc_gross'];
$payment_status = $_POST['payment_status'];
$mc_gross = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$receiver_id = $_POST['receiver_id'];
$quantity = $_POST['quantity'];
$num_cart_items = $_POST['num_cart_items'];
$payment_date = $_POST['payment_date'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$payment_type = $_POST['payment_type'];
$payment_status = $_POST['payment_status'];
$payment_gross = $_POST['payment_gross'];
$payment_fee = $_POST['payment_fee'];
$settle_amount = $_POST['settle_amount'];
$memo = $_POST['memo'];
$payer_email = $_POST['payer_email'];
$txn_type = $_POST['txn_type'];
$payer_status = $_POST['payer_status'];
$address_street = $_POST['address_street'];
$address_city = $_POST['address_city'];
$address_state = $_POST['address_state'];
$address_zip = $_POST['address_zip'];
$address_country = $_POST['address_country'];
$address_status = $_POST['address_status'];
$item_number = $_POST['item_number'];
$tax = $_POST['tax'];
$option_name1 = $_POST['option_name1'];
$option_selection1 = $_POST['option_selection1'];
$option_name2 = $_POST['option_name2'];
$option_selection2 = $_POST['option_selection2'];
$for_auction = $_POST['for_auction'];
$invoice = $_POST['invoice'];
$custom = $_POST['custom'];
$notify_version = $_POST['notify_version'];
$verify_sign = $_POST['verify_sign'];
$payer_business_name = $_POST['payer_business_name'];
$payer_id =$_POST['payer_id'];
$mc_currency = $_POST['mc_currency'];
$mc_fee = $_POST['mc_fee'];
$exchange_rate = $_POST['exchange_rate'];
$settle_currency  = $_POST['settle_currency'];
$parent_txn_id  = $_POST['parent_txn_id'];
$pending_reason = $_POST['pending_reason'];
$reason_code = $_POST['reason_code'];



//DB connect creds and email 
$notify_email =  "XX";         //email address to which debug emails are sent to
$DB_Server = "localhost"; //your MySQL Server
$DB_Username = "XX"; //your MySQL User Name
$DB_Password = "XX"; //your MySQL Password
$DB_DBName = "XX"; //your MySQL Database Name


if (!$fp)
{/* HTTP ERROR*/}
else {
		fputs ($fp, $header . $req);
		while (!feof($fp)) 
		{
			$res = fgets ($fp, 1024);
			if (strcmp ($res, "VERIFIED") == 0) 
			{
				//create MySQL connection
				$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)
				or die("Couldn't connect to MySQL:<br>" . mysql_error() . "<br>" . mysql_errno());

				//select database
				$Db = @mysql_select_db($DB_DBName, $Connect)
				or die("Couldn't select database:<br>" . mysql_error(). "<br>" . mysql_errno());

				$fecha = date("m")."/".date("d")."/".date("Y");
				$fecha = date("Y").date("m").date("d");

				//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)
				{
					if ($txn_type == "cart")
					{
						$strQuery = "insert into BuyerData(tid,lastName,firstName,email,address,city,state,zip,invoice,pmt,paypalFee,salesTax,status,shipping,shipped,date) values ('".$txn_id."','".$last_name."','".$first_name."','".$payer_email."','".$address_street."','".$address_city."','".$address_state."','".$address_zip."','','".$mc_gross."','".$mc_fee."','".$tax."','".$payment_status."','".$custom."','0','".$fecha."')";

					     $result = mysql_query($strQuery) or die("Cart - paypal_payment_info, Query failed:<br>" . mysql_error() . "<br>" . mysql_errno());
					     for ($i = 1; $i <= $num_cart_items; $i++) 
						 {
							 $itemname = "item_name".$i;
							 $itemnumber = "item_number".$i;
							 $itemprice = "item_price_".$i;
							 $on0 = "option_name1_".$i;
							 $os0 = "option_selection1_".$i;
							 $on1 = "option_name2_".$i;
							 $os1 = "option_selection2_".$i;
							 $quantity = "quantity".$i;

							 $struery = "insert into OrderData(tid,itemname,itemnumber,qty,price) values ('".$txn_id."','".$_POST[$itemname]."','".$_POST[$itemnumber]."','".$_POST[$quantity]."','".$_POST[$itemprice]."')";

					         $result = mysql_query($struery) or die("Cart - paypal_cart_info, Query failed:<br>" . mysql_error() . "<br>" . mysql_errno());
							 }
						}

			    else{
					     $strQuery = "insert into paypal_payment_info(paymentstatus,buyer_email,firstname,lastname,street,city,state,zipcode,country,mc_gross,mc_fee,itemnumber,itemname,os0,on0,os1,on1,quantity,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."','".$item_number."','".$item_name."','".$option_name1."','".$option_selection1."','".$option_name2."','".$option_selection2."','".$quantity."','".$memo."','".$payment_type."','".$payment_date."','".$txn_id."','".$pending_reason."','".$reason_code."','".$tax."','".$fecha."')";

						 $result = mysql_query("insert into paypal_payment_info(paymentstatus,buyer_email,firstname,lastname,street,city,state,zipcode,country,mc_gross,mc_fee,itemnumber,itemname,os0,on0,os1,on1,quantity,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."','".$item_number."','".$item_name."','".$option_name1."','".$option_selection1."','".$option_name2."','".$option_selection2."','".$quantity."','".$memo."','".$payment_type."','".$payment_date."','".$txn_id."','".$pending_reason."','".$reason_code."','".$tax."','".$fecha."')") or die("Default - paypal_payment_info, Query failed:<br>" . mysql_error() . "<br>" . mysql_errno());
						 }

				 // send an email in any case
				 echo "Verified";
			     mail($notify_email, "VERIFIED IPN", "$res\n $req\n $strQuery\n $struery\n  $strQuery2");
				 }
				else {
						// send an email
						mail($notify_email, "VERIFIED DUPLICATED TRANSACTION", "$res\n $req \n $strQuery\n $struery\n  $strQuery2");
						}

				//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());


            			 mail($notify_email, "VERIFIED IPN", "$res\n $req\n $strQuery\n $struery\n  $strQuery2");
					 }
			}

// if the IPN POST was 'INVALID'...do this
else if (strcmp ($res, "INVALID") == 0) {
// log for manual investigation

mail($notify_email, "INVALID IPN", "$res\n $req");
}
}
fclose ($fp);
}
?>

[mrMarcus]

well, right off, i can see this :

$item_price = $_POST['mc_gross'];
$mc_gross = $_POST['mc_gross'];

 

since $mc_gross is being set after $item_price, and you only have $mc_gross in your query, it's not creating any problems .. just fix $item_price[];

 

i don't see 'amount' in there .. perhaps it was meant to be for the item_price['amount'];

 

your query seems fine .. have you tried the IPN simulator in the Sandbox environment?  best and quickest way to test your IPN for functionality.