Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Pass variable x_line_item through authorize.net

Posted on 2014-03-04
6
Medium Priority
?
584 Views
Last Modified: 2014-03-05
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
0
Comment
Question by:stkoontz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 111

Accepted Solution

by:
Ray Paseur earned 2000 total points
ID: 39903359
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
 
LVL 54

Expert Comment

by:Scott Fell, EE MVE
ID: 39903419
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
 
LVL 2

Author Comment

by:stkoontz
ID: 39903423
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 111

Expert Comment

by:Ray Paseur
ID: 39903462
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
 
LVL 2

Author Closing Comment

by:stkoontz
ID: 39907560
Ray: thanks for the helpful response and teaching me a new command.  REPLACE INTO is working great.

Steve
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 39907618
Steve: Thanks for the points and thanks for using EE,  Best, ~Ray
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses how to create an extensible mechanism for linked drop downs.
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question