Updating account balance

[str3tch4eva]

Hi friends,

  I am creating a  site where  users can add credit  to their account via Liberty Reserve, and after  that their account  will  automatically  be updated with  the amount they added so that they can use it to purchase products.. And  after any purchase,  the amount will be subtracted from their account.. I cant  really  find a  php code  to do that... i have done  a  search on here but still cant  find anything close to it.. Can someone kindly help? Thank you

[fugix]

are you storing account information in a database?

[str3tch4eva]

Yes..  every user has  a user name  so when you  buy credits, its suppose to reflect in your account..

[jakebur01]

Find a shopping cart tutorial.  Build a basic cart that works off a MySQL table then add this other stuff in later.  It would be that hard to do what your wanting to do, but you should build your foundation first.

[ignace]

Liberty Reserve provides ready made scripts for you to test/run at https://www.libertyreserve.com/en/home/downloads

[fugix]

do you want to create this yourself or use someone elses script?

[str3tch4eva]

a friend gave me a script to use but that part isnt  there and i am finding it difficult  to figure it out..

[str3tch4eva]

do you want to create this yourself or use someone elses script?

 

I know about that but it doesnt update the account of the  user that makes the  payment.. Thank you anyway

[jakebur01]

That's the way PHP was for me when I first starting dealing with it.  I finally went and bought a good book on it and started from the beginning and gradually worked my way through it.  It actually had a shopping cart in the back of it.  By the time I got to the shopping cart, I knew my way around in the code.

[fugix]

do you want to create this yourself or use someone elses script?

 

I know about that but it doesnt update the account of the  user that makes the  payment.. Thank you anyway

you could script it to do so

[str3tch4eva]

@ Fugix,  That is why i am asking for help on here..

[ignace]

do you want to create this yourself or use someone elses script?

 

I know about that but it doesnt update the account of the  user that makes the  payment.. Thank you anyway

 

The hard part is actually making the payments updating the account's balance should be easy. Something along the lines of:

 

$sql = "UPDATE account SET balance += $points WHERE account_id = $account_id";
if (mysql_query($sql)) {
  // succeeded
}

[str3tch4eva]

do you want to create this yourself or use someone elses script?

 

I know about that but it doesnt update the account of the  user that makes the  payment.. Thank you anyway

 

The hard part is actually making the payments updating the account's balance should be easy. Something along the lines of:

 

$sql = "UPDATE account SET balance += $points WHERE account_id = $account_id";
if (mysql_query($sql)) {
  // succeeded
}

 

Thank you Ignace.. I think this should work then, because the payment is via LR and that is easy.. so i will try and let you know.. thanks  again.