Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    Regular Coder
    Join Date
    Dec 2010
    Location
    California
    Posts
    201
    Thanks
    30
    Thanked 8 Times in 8 Posts

    having trouble updating a variable to database + PayPal Integration

    Hello Everyone,

    I am pretty new to the forums and was curious if i could get some help here. Basically, in a nutshell, i have PayPal integrated into my website. I will use this to collect money from clients. when a client logs into his/her account they see their balance (which is pulled from the database to correspond with the user that's logged-in). Now, everytime a payment is submitted a notify_url is contacted after payment has been verified, that notify_url is the code written below. What I am trying to execute here is when this notify_url is called the current balance is reduced from the amount paid through paypal.

    In the second If condition, you will see that the word success is being entered into the paypal.txt file, which is working perfectly fine. Now, you will also see the variable
    PHP Code:
    $update_balance
    which is suppose to update the original balance with the balance paid through PayPal

    BUT IT'S NOT!! WHY?? LOL

    Thank You in advance!

    PHP Code:
    <?php
    ob_start
    ();

    session_start();

    include_once (
    '/home/rdewebde/public_html/includes/paypal.php');

    $myPaypal = new Paypal();

    $myPaypal->ipnLog TRUE;
            
    include_once 
    "/home/rdewebde/public_html/includes/_config.php";

    $username "".$_SESSION['username']."";

    $users_data mysql_query("SELECT * FROM `members` WHERE `username`='".$username."'");

    $user_info mysql_fetch_array($users_data);

    $current_amount $user_info['balance'];
         
    $deduct_amount $myPaypal->ipnData['payment_gross'];

    $new_amount $current_amount $deduct_amount;

    $update_balance mysql_query("UPDATE `members` SET `balance` = '$new_amount' WHERE `username` = '".$username."'");

    if (
    $myPaypal->validateIpn()) {

        if (
    $myPaypal->ipnData['payment_status'] == 'Completed') {

             
    $update_balance;  

             
    file_put_contents('/home/rdewebde/public_html/lounge/paypal.txt''SUCCESS');

                

        }

    else { 
    file_put_contents('/home/rdewebde/public_html/lounge/paypal.txt'"FAILURE\n\n" $myPaypal->ipnData); }

       }

    ?>
    Last edited by eberdome; 01-29-2011 at 11:45 PM.

  • #2
    Regular Coder
    Join Date
    Apr 2007
    Posts
    317
    Thanks
    24
    Thanked 3 Times in 3 Posts
    Try removing the quotes from $new_amount

    Quote Originally Posted by eberdome View Post
    PHP Code:
    $update_balance mysql_query("UPDATE `members` SET `balance` = $new_amount WHERE `username` = '".$username."'"); 

  • #3
    Regular Coder
    Join Date
    Dec 2010
    Location
    California
    Posts
    201
    Thanks
    30
    Thanked 8 Times in 8 Posts
    sorry, that did nothing

  • #4
    Regular Coder
    Join Date
    Apr 2007
    Posts
    317
    Thanks
    24
    Thanked 3 Times in 3 Posts
    to me it sounds like you have a syntax issue with your mysql query.

    Try printing out the values of deduct amount and the original amount and see if they are populated.

    Remove the slashes from your query as shown. I always get more issues adding them then without.
    I added the die() statement to the end of your query so you can see what is happening.
    Quote Originally Posted by eberdome View Post
    PHP Code:
    $update_balance mysql_query("UPDATE members SET balance = $new_amount WHERE username = '".$username."'") or die(mysql_error()); 

  • #5
    Regular Coder
    Join Date
    Dec 2010
    Location
    California
    Posts
    201
    Thanks
    30
    Thanked 8 Times in 8 Posts
    that didn't work, i think it has something to do with

    PHP Code:
    $myPaypal->ipnData['payment_gross']; 
    I dont think its recognizing this, but this info can be entered into paypal.txt and that seems to work

  • #6
    Regular Coder
    Join Date
    Apr 2007
    Posts
    317
    Thanks
    24
    Thanked 3 Times in 3 Posts
    You have to try and trace down what is not working. If you think that is the problem try touble shooting that variable by printing it or checking its type. Print everything out and see what is missing.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •