Custom Receipts

[carder]

I am currently using DPM and the processing of a transaction is working just fine.  I am also using relay_response that then takes me to my own receipt page.  I would like to display transaction details on this page for the user but can't figure out how to get that information included there.  

I am using the basic PHP code from the manual so the only thing that displays is the transaction code through "Transaction id: ".htmlentities($_GET['transaction_id'])" 

I tried using this same code to display amount but just haven't been able to figure it out.  How can I get these fields to appear on my receipt page?  

[TJPride]

If you have the transaction ID, you can look up the transaction using the Transaction Details API. Alternately, if you were smart and stored the important parts of the transaction on the relay response page, then you can just look up the transaction in your own database.

[carder]

Ok I have tried doing a simple INSERT query into my db from the relay response page but now I do not get redirected and it keeps me at https://secure.authorize.net/gateway/transact.dll and nothing gets inserted in my db.

I added the INSERT statement right after 

  if ($response->isAuthorizeNet()) {

using this approach to try and capture the values and insert into my db

$response->amount 

...

[carder]

In trying to see if any of the values I am looking for exist on the relay page I changed the redirect url to 

$redirect_url .= '?response_code=1&transaction_id=' .

         $response->transaction_id.'item='.$response->amount;

This works just fine and gives me a value for amount within the url but if I change it from 

  $response->amount; to $response->first_name;  this section of the url is blank

[carder · Accepted solution]

Ok found the answer in here...had to change my db connection as is mentioned in the following post.

http://community.developer.authorize.net/t5/Integration-and-Testing/Update-database-via-SIM-Method/t...