Geek Answers Handbook

PayPal IPN and update database

I understand how IPN works, and the basic idea of ​​sending information, checking, etc. But for life, I can’t make it work !!

This is what I'm trying to do ...

The user selects a certain part of the product for purchase, as soon as they click on it, they are associated with the Paypal button, in which I added 2 text fields. Firstly, there is a user identifier, and the second is the name of the selected part - both values ​​are automatically added. Everything works perfectly.

Then click "Buy Now" and fill out the details of your card, and it will be purchased and redirected to the success page.

However, I want him to update his profile in my database to show that they have purchased this product.

I understand that using the PayPal IP address, I can send information to my site page to check it, and if the payment is completed, follow all the necessary steps.

I tried the scripts from the PayPal website itself and I don’t get a response at all. Can someone give me a really, REALLY simple method to achieve what I need? Because each textbook is too complicated or does not work, and the examples do not help me in the least, and they talk to you as if you should know how to do it already.

I even read the entire PDF, and yet I do not know how to do this. Any help?

+5
source share
1 answer

It depends on how your users are stored in the database.

  • , ?
  • , PayPal?

, IPN Variables , , IPN script.

, :

Users: ID, email, etc.. etc..

Transactions: ID, emailofUser, invoiceID, Success/Fail(bool)

PayPal - ", PayPal, ".

IPN , , . - PayPal, , . IPN, "-" ( PayPal).

, , PayPal, , script IPN. - :

  • IPN

  • ,

    mysql_query ( "SELECT * FROM Transactions WHERE invoiceID = $_ POST ['invoice']" );

  • , .

    if ($_POST['payment_status'] == 'completed')
{ 
//update whatever information you need to
}
else
{
//something else happened with this transaction, put a flag on it for review by
//an admin
}

, .

+5

More articles:


All Articles