Payment gateway, database access?

[MartijnD]

Hi,

 

I'm currently creating a payment gateway for a Dutch payment service provider. This provider supports a callback to a URL, but the only parameter given in the URL is the transaction_id.

 

In other words, I need to store some settings like the invoiceid in the database. In that way I'm able to lookup the transaction at the callback according to the given transaction_id and update the invoiceid.

 

But if I need to use a database(table), what would be the best way to do so?

 

Thanks,

Martijn