having trouble updating a variable to database + PayPal Integration

[eberdome]

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); }

   }

?>

[macleodjb]

Try removing the quotes from $new_amount

Originally Posted by eberdome

PHP Code:

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


[eberdome]

sorry, that did nothing

[macleodjb]

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.

Originally Posted by eberdome

PHP Code:

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


[eberdome]

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

[macleodjb]

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.