Pass variable x_line_item through authorize.net

I'm using the SIM method for an authorize.net payment page.  x_line_item is working fine to pass information into the Authorize.net payment page.  But after the transaction is completed, I need to store the x_line_item information into my database.  

Does anyone know how to get the x_line_item information out after the transaction is completed?

Thanks,

Steve
LVL 2
stkoontzAsked:
Who is Participating?
 
Ray PaseurConnect With a Mentor Commented:
Why not put the x_line_item into the data base before the transaction is sent to Authorize.net?  Then you have a record of both successful and failed transactions.
0
 
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
The only option is what Ray suggests.  You can get data back using the Relay Response but the  x_line_item is not one of those things.
0
 
stkoontzAuthor Commented:
Thanks, Ray, for the suggestion.  I could do that.  I'd just need to write the code to check if the transaction exists and run an update instead of an insert if the user changes their order.

I was hoping there would be an easier way and inserting x_line_item into the database once after the transaction was completed seemed to be that way.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Ray PaseurCommented:
If you're using MySQL you might find REPLACE INTO to be useful.  Not sure - it would depend on your design, but it's kind of a helpful concept.
0
 
stkoontzAuthor Commented:
Ray: thanks for the helpful response and teaching me a new command.  REPLACE INTO is working great.

Steve
0
 
Ray PaseurCommented:
Steve: Thanks for the points and thanks for using EE,  Best, ~Ray
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.