asked on

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

ASKER CERTIFIED SOLUTION

Ray Paseur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott Fell

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.

stkoontz

ASKER

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.

Ray Paseur

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.

stkoontz

ASKER

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

Steve

Ray Paseur

Steve: Thanks for the points and thanks for using EE, Best, ~Ray