PHP - Very Minor Paypal Sandbox Problem

Hi Friends,
I am not sure i am looking for help here in right category or not.
I am integrating paypal with IPN, (i have done this on many websites and never had this issue before.)

I am testing it on sandbox account.
All the data i am receiving back from paypal is fine. But always IPN verifications fails.

I have used same class on many projects but never got this issue, please guide me, what can be the reason for this issue.
Need help urgently,

Thanks

This is what i am getting in log file

[10/30/2011 12:15 PM] - FAIL: IPN Validation Failed.
IPN POST Vars from Paypal:
mc_gross=525.00, protection_eligibility=Eligible, address_status=confirmed, payer_id=QLJGBWYEGPFWW, tax=0.00, address_street=1 Main St, payment_date=11:15:27 Oct 30, 2011 PDT, payment_status=Completed, charset=windows-1252, address_zip=95131, first_name=Test, mc_fee=15.53, address_country_code=US, address_name=Test User, notify_version=3.4, custom=, payer_status=verified, business=sharaf_1195546587_biz@hotmail.com, address_country=United States, address_city=San Jose, quantity=1, verify_sign=AiPC9BjkCyDFQXbSkoZcgqH3hpacAlUS.f.l0d1.lPU2NAC3pqJbClgv, payer_email=sharaf_1239776872_per@hotmail.com, txn_id=2VC808708R401452A, payment_type=instant, last_name=User, address_state=CA, receiver_email=sharaf_1195546587_biz@hotmail.com, payment_fee=15.53, receiver_id=KN2K54ELKVMV6, txn_type=web_accept, item_name=SLACKER MONK GRAPHICS - Shoes Design, mc_currency=USD, item_number=19%##%1, residence_country=US, test_ipn=1, handling_amount=0.00, transaction_subject=SLACKER MONK GRAPHICS - Shoes Design, payment_gross=525.00, shipping=0.00, ipn_track_id=zLpG8h32fEiFoCdtCglq.w,
IPN Response from Paypal Server:
 HTTP/1.0 302 Found

Location: https://www.sandbox.paypal.com

Server: BigIP

Connection: close

Content-Length: 0

ok , this is to request someone to be your friend and i keep getting an error saying "mysql_error() expects parameter 1 to be resource" i dont know what is wrong , it worked before ... please help.
Code: [Select]
<?php

if ($_POST["request"] == "requestFriendship") {

    $mem1 = preg_replace('#[^0-9]#i', '', $_POST['mem1']); 
    $mem2 = preg_replace('#[^0-9]#i', '', $_POST['mem2']); 
//
if (!$mem1 || !$mem2 || !$thisWipit) {
echo  'Error: Missing data';
     exit(); 
}
//
if ($mem1 == $mem2) {
     echo  'Error: You cannot add yourself as a friend';
     exit(); 
} 


//See if already friends
$sql1 = "SELECT id FROM friends WHERE mem2='$mem1' AND mem1='$mem2' LIMIT 1";
$result1 = mysql_query($sql1) or die (mysql_error("sql1 failed")); 
$data1 = mysql_fetch_row($result1);
    if ($data1[0]) {
echo  'This member is already your Friend'; 
exit(); 
}
//Check if user already requested to be friends
$sql2 = "SELECT id FROM friends_requests WHERE mem1='$mem1' AND mem2='$mem2' Limit 1";
$result2 = mysql_query($sql2) or die (mysql_error("sql2 failed")); 
$data2 = mysql_fetch_row($result2);
    if ($data2[0]) {
echo '<img src="images/round_error.png" width="20" height="20" alt="Error" /> You have a Friend request pending for this member. Please be patient.';
        exit(); 
}
//Check if friend already requested to be friends
$sql3 = "SELECT id FROM friends_requests WHERE mem1='$mem2' AND mem2='$mem1' Limit 1";
$result3 = mysql_query($sql3) or die (mysql_error("sql3 failed"));  
$data3 = mysql_fetch_row($result3);
    if ($data3[0]) {
echo '<img src="images/round_error.png" width="20" height="20" alt="Error" /> This user has requested you as a Friend already! Check your Requests on your profile.';
        exit(); 
}
//If still here make insert
$mem1=mysql_real_escape_string($mem1);
$mem2=mysql_real_escape_string($mem2);
$sql = mysql_query("INSERT INTO friends (mem1, mem2, timedate) VALUES('$mem1','$mem2',now())") or die (mysql_error("Friend Request Insertion Error"));
echo '<img src="images/round_success.png" width="20" height="20" alt="Success" /> Friend request sent successfully. This member must approve the request.';
    exit(); 
}
?>

Hi All,

I have been handed a site from a friend of mine to fix as there were a few errors on it. I have only had very little experience with php coding and believe im doing well so far as i only have one more error to rectify on this particular site. Is any one familiar with the following error codes and how to resolve them?


Warning: include(list_.inc.php) [function.include]: failed to open stream: No such file or directory in /home/user/public_html/list.php on line 13

Warning: include(list_.inc.php) [function.include]: failed to open stream: No such file or directory in /home/user/public_html/list.php on line 13

Warning: include() [function.include]: Failed opening 'list_.inc.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/user/public_html/list.php on line 13

Iv done a bit of research and to me it doesn't seem like a huge fix and i think its something i am capable of doing myself i just need a bit of guidance. Any help greatly appreciated.

Michael

Hi   I have a small script, on a single file that needs to be optimized. file is about 300 lines (16Kb), and basiccaly looks like the "PHP-monster" threw up on it. Script is working ok, but surely could be much better.   PM if interested and I can send you a copy of file. If possible leave price/hourly rate.

I have a form with a table that contains ONLY dropdown menus for users to select quantities from 25 dinner items.  It contains some Javascript, but nothing fancy.  In an effort to establish my database and TEST to see how some PHP functions might respond so I could improve my form, I created a mini version of the db in MySQL.

But when I click the submit button, the page blinks, the address bar fills with field names, but there is no connect.  No error messages.  No data transfer.  NO NOTHING!

I searched the web and copied a form and plugged it in (an html form, a php insert file, and a MySQL database) and it worked fine.  I peared down my page to mirror it, and still, no success.

What little detail am I missing??  If I have 25 fields but create a db for the first 6, should it function?
If I reduce it and try to re-use the same db, am I persuing a problem?
I've tried error trapping and changing the form inputs, but it just still doesn't connect.

Please help!

Hey guys im having 2 minor problems with my script if someone can give me some advise please? (all 2 problems are commented on the script itself)   1.  highlighting string characters when typed. 2. also im trying to add "Hide Suggestions" at the bottom of my menu so people can turn on/off autocomplete

$(document).ready(function()
{	
	function search_autocomplete(selector, tags, default_value)
	{	
		
		$('#' + selector).focus(function() 
		{
			if($('#' + selector).val() == default_value)
			{
				$('#' + selector).val('');
			}
		});
		
		$('#' + selector).blur(function() 
				{
					if($('#' + selector).val() == '')
					{
						$('#' + selector).val(default_value);
					}
				});
		
	    $('#' + selector).autocomplete(
	    {
	    	source: tags,
	    	timeout: 0,
	    	
	    	select: function (a, b) 
	    	{
	    		$(this).val(b.item.value);
	    	    //submit
	    	},
	    	
	    	create: function () 
	    	{
	            $(this).data('ui-autocomplete')._renderItem = function (ul, item) 
	            { 	
	            	// not highlighting when string characters match
	            	var re = new RegExp('^' + this.term);
	            	var t = item.label.replace(re, "<span id='dropdown-item-highlight'>" + "$&" + "</span>");
	            	
	            	
	                return $('<li></li>')
	                .append('<a>' + t + ' in ' + item.type + '</a>')
	                .addClass( 'dropdown-item' )
	                .appendTo(ul);
	                
	            };
	    	}
	    }); 
	    
	    $(this).data('ui-autocomplete')._renderMenu = function (ul, item) 
        { 	
	    	// unable to show "Hide Suggestions at the bottom of the autocomplete menu
    		return $('<ul></ul>')
    		.append('<a>Hide Suggestions</a>')
    		.addClass( 'dropdown-menu' );
        };
	
	}
	
	var availableTags = [{"label" : "XBOX 360", "type":"Electronics"},
	                     {"label":"XBOX One", "type":"Electronics"},
	                     {"label":"Nike", "type":"Clothing & Footwear"}];
	
	search_autocomplete('query', availableTags, 'Search...');
});

thanks

Good day dear community.

I need to build a function which parses the domain from a url. I have used various ways to parse html sources. But this one is is a bit tricky! See the target i want to parse - it has some invaild Markup:

http://www.schulministerium.nrw.de/BP/SchuleSuchen?action=644.0013008534253&SchulAdresseMapDO=194190

well what do you think - can i apply this code here


<?php
require_once('config.php'); // call config.php for db connection
$filename = "url.txt"; // Include the txt file which have urls
$each_line = file($filename);
foreach($each_line as $line_num => $line)
{
    $line = trim($line);
    $content = file_get_contents($line);
    //echo ($content)."<br>";
    $pattern = '/<td>(.*?)<\/td>/si';
    preg_match_all($pattern,$content,$matches);

    foreach ($matches[1] as $match) {
        $match = strip_tags($match);
        $match = trim($match);
        //var_dump($match);
        $sql = mysqli_query("insert into tablename(contents) values ('$match')");
        //echo $match;
    }
}
?>


well i have to rework the parser-part of this script. I need to parse somway different - since i have other site here.

Can anybody help me  here to get a better regex - or a better way to parse this site ...

Any and all help will be greatly apprecaited.

regards
db1

I just installed this new script here http://webhost.pro/domain-check.php it's a basic domain availability tool.

I am trying to make a form that can be used on any page forward to this page with the content.

The page loads with this in the url webhost.pro/domain-check.php?domain=dwhs.net and will run the page.

So I can make a form that just submits to that page and sends the details.

I made this page for testing

http://webhost.pro/test.html

But no go, here is the code:

<form id="search" action="/domain-check.php" method="GET">
<input type="text" name="s">
<a onClick="document.getElementById('search').submit()" class="button1">Search</a>
<div class="clear"></div>
</form>


Thanks!

Hi

Does any one know of any good tutorials for paypal web payments pro, or recommend books

Thanks in advance

Hey All, 

I have setup a Paypal API to handle the recurring payments on my website, once the payment is completed I get a token id and ba_token id return. 

I am storing this in a database, but wondered how people link this with a user table? I could use a cookie to store the user's id before payment and then get it once the payment is complete, but this would not work with the subsequent recurring payments. 

How do you go about sending the user id when a recurring payment happens?

Any advise would be appreciated.

Edd

Hi guys, my code below works with sanbox for paypal IPN but since it has gone live it doesnt do anything, so i made emails to send me where the issue is and it keep sending me $req = 'cmd=_notify-validate';

could you please tell me what im doing wrong here? my db connection should be fine as it does update the users on sanbox.

the account im paying with in paypal keep saying payment status unclaimed. it means the reciever has not recieved the money. I checked the paypal account where i recieve the moeny and looked into my ipn history, nothing there.

the same ipn address is used for my account when i tested it on sanbox,

 thanks


<?php
$email="princeofpersia@hotmail.co.uk";

include 'global.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);
//$fp = fsockopen ('ssl://www.paypal.com', 443, $errno, $errstr, 30);//Live
// assign posted variables to local variables

if (!$fp)// failed to connect to url
{
 //write to file
 $fh = fopen("logipn.txt", 'a');//open file and create if does not exist
 fwrite($fh, "\r\n/////////////////////////////////////////\r\n HTTP ERROR \r\n");//Just for spacing in log file
 fwrite($fh, $errstr);//write data
 fclose($fh);//close file
 
 //email
 $mail_From = "From: IPN@tester.com";
 $mail_To = $email;
 $mail_Subject = "HTTP ERROR";
 $mail_Body = $errstr;//error string from fsockopen
 mail($mail_To, $mail_Subject, $mail_Body, $mail_From);
} 
else//successful connect to url
{
 fputs ($fp, $header . $req);//send request
 while (!feof($fp)) //while not end of file
 {
  $res = fgets ($fp, 1024);//get response
  if (strcmp ($res, "VERIFIED") == 0) 
  {
   //write to file
   $fh = fopen("logipn.txt", 'a');//open file and create if does not exist
   fwrite($fh, "\r\n/////////////////////////////////////////\r\n Verified \r\n");//Just for spacing in log file
   fwrite($fh, $req);//write data
   fclose($fh);//close file
 
   //email
   $mail_From = "From: IPN@tester.com";
   $mail_To = $email;
   $mail_Subject = "VERIFIED IPN";
   $mail_Body = $req;
   mail($mail_To, $mail_Subject, $mail_Body, $mail_From);
  }
    else if (strcmp ($res, "INVALID") == 0) 
  {
   //write to file
   $fh = fopen("logipn.txt", 'a');//open file and create if does not exist
   fwrite($fh, "\r\n/////////////////////////////////////////\r\n Invalid \r\n");//Just for spacing in log file
   fwrite($fh, $req);//write data
   fclose($fh);//close file
 
   //email
   $mail_From = "From: IPN@tester.com";
   $mail_To = $email;
   $mail_Subject = "INVALID IPN";
   $mail_Body = $req;
   mail($mail_To, $mail_Subject, $mail_Body, $mail_From);
  }
 }
 fclose ($fp);//close file pointer
}

$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];
//$username=$_POST['username'];
if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {

if (strtolower($payment_status)=="completed")

{

if ($payment_amount==0.01&&$payment_currency=="GBP") 
{

$update = mysql_query("UPDATE users SET credit= credit+5  WHERE email='$payer_email'");

}











}


// check the payment_status is Completed
// check that txn_id has not been previously processed
// check that receiver_email is your Primary PayPal email
// check that payment_amount/payment_currency are correct
// process payment


}
else if (strcmp ($res, "INVALID") == 0) {
// log for manual investigation
}
}
fclose ($fp);
}
?>

Hey Guys,

i have another problem, i am using paypal IPN, and i want the details of the order to be stored in my orders table of the databse as well as sending me an email. Im pretty sure the code is ok, but it is not working. Can some one please take a look?

<?php

 include('db_fns.php');
 
 
 // change these to your paypal settings
 $paypal_email = "benmunns@gmail.com";
 $paypal_currency = 'USD';
 $shipping = 10.00;
 
 
 /**
  * checks if paypal trans id is already in database
  * @param int $trans_id
  * @return bool
  */
 function no_paypal_trans_id($trans_id)
 {
    $connection = db_connect();
    $query = sprintf("SELECT id from orders WHERE paypal_trans_id = '%s'",
                      mysql_real_escape_string($trans_id));
    $result = mysql_query($query);
   
    $num_results = mysql_num_rows($result);
   
    if($num_results == 0)
    {
       return true;
    }
   
    return false;
   
 }
 
 /**
  * checks to make sure that paypal payment amount is correct
  * @param int $shipping
   * @param array $params
  * @return bool
  */
 function payment_amount_correct($shipping, $params)
 {
     $amount = 0.00;
      
      for ($i=1;  $i <= $params['num_cart_items']; $i++)
      {
        $query = sprintf("SELECT price from products where id='%s'",
         mysql_real_escape_string($params["item_number{$i}"]));
         $result = mysql_query($query);
         if($result)
         {
              $item_price = mysql_result($result, 0, 'price');
           $amount += $item_price * $params["quantity{$i}"];
         }
      }
      
      if(($amount+$shipping) == $params['mc_gross'])
      {
        return true;   
      }
      else
      {
        return false;   
      }
   
 }
 
 
    
/**
 * creates order and adds items
 * @param array $params
 * @return bool
 */
   function create_order($params)
   {
      db_connect();
      
       $query =  sprintf("INSERT INTO orders set
                             orders.firstname = '%s',
                                      orders.lastname = '%s',
                                      orders.email = '%s',
                                      orders.country = '%s',
                          orders.address = '%s',
                          orders.city = '%s',
                                     orders.zip_code = '%s',
                                     orders.state = '%s',
                                     orders.status = '%s',
                                     orders.amount = '%s',
                                     orders.paypal_trans_id = '%s',
                                      created_at = NOW()
                           ",
                              mysql_real_escape_string($params['first_name']),
                               mysql_real_escape_string($params['last_name']),
                               mysql_real_escape_string($params['payer_email']),
                              mysql_real_escape_string($params['address_country']),
                               mysql_real_escape_string($params['address_street']),
                               mysql_real_escape_string($params['address_city']),
                               mysql_real_escape_string($params['address_zip']),
                               mysql_real_escape_string($params['address_state']),
                               mysql_real_escape_string($params['payment_status']),
                               mysql_real_escape_string($params['mc_gross']),
                               mysql_real_escape_string($params['txn_id'])
               
                           );

      $result = mysql_query($query);
      if(!$result)
      {
          return false;
      }
      
      $order_id = mysql_insert_id();
      
      for ($i=1;  $i <= $params['num_cart_items'] ; $i++)
      {
           $product = find_product($params["item_number{$i}"]);
            
           $query = sprintf("INSERT
                                    INTO items
                                         set
                                                      order_id = '%s',
                                                      product_id = '%s',
                                                      title = '%s',
                                                      price = '%s',
                                                      qty = '%s'
                                                      ",
                                                       mysql_real_escape_string($order_id),
                                                       mysql_real_escape_string($product['id']),
                                                       mysql_real_escape_string($product['title']),
                                                      mysql_real_escape_string($product['price']),
                                                       mysql_real_escape_string($params["quantity{$i}"])   
                                                   
                                                       );
            
             $result = mysql_query($query);
            
             if(!$result)
             {
                return false;
             }
            
          }
 

       return true;
   }   




// 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 ('www.paypal.com', 80, $errno, $errstr, 30);

// assign posted variables to local variables
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];

if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {
 
   if ($_POST['payment_status'] == 'Completed'
        && no_paypal_trans_id($_POST['txn_id'])
         && $paypal_email == $_POST['receiver_email']
         && $paypal_currency == $_POST['mc_currency']
         && payment_amount_correct($shipping, $_POST)
         )
   {
     // process payment
       create_order($_POST);
    
   }

}
else if (strcmp ($res, "INVALID") == 0) {
// log for manual investigation
}
}
fclose ($fp);
}
?>

Hi all

I have a quick PayPal IPN question, is this the right group to post the message and does anyone know much about the PayPal IPN?

Thanks

I just did the ipn page to store paypal transactions into my database but it doesnt seem to be working.

Is there anything else that i need to do other than creating the ipn page?

<?php

mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("pbstore") or die(mysql_error());

// 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.sandbox.paypal.com', 443, $errno, $errstr, 30);

if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {

// PAYMENT VALIDATED & VERIFIED!
$email = $_POST['payer_email'];
$name = $_POST['item_name'];

mysql_query("INSERT into sales (name, email) VALUES('".$name."', '".$email."')")or die(mysql_error());
mysql_query("INSERT INTO users (email, password) VALUES('". mysql_escape_string($email) ."', '".md5($password)."' ) ") or die(mysql_error());
}

else if (strcmp ($res, "INVALID") == 0) {

// PAYMENT INVALID & INVESTIGATE MANUALY!

}
}
fclose ($fp);
}
?>

Hey guys i have created a paypal IPN script and it takes various info from users via paypal. Anyways i store their info into a database along with their email however i dont want them to be able to purchase again with the same email (long story) anways by the time i receive the info from paypal the payments already gone through so its too late for me to do the checking against the database. Is there anyway i can auto refund the payment do paypal allow this? Hope someone can help.

Thanks!