I need help. Looking for a php example where I can get the response codes, that I then can enter into my mysql tables.
example : customer name, amount they sent, timestamp.
Do not care about seeing on screen, I need to enter automatically into table
The amount is not fixed, the customer is sending a payment ( each amount might be different)
Please help,
Thanks
08-17-2011 05:35 AM
What I did was first generate a transaction and then log the output to a text file using the callback page:
$logfile = "{$_SERVER['DOCUMENT_ROOT']}/mylogfolder/log.txt"; $handle = fopen($logfile, 'a'); fwrite($handle, print_r($_POST, true));
This is with some of the field data modified or the fields removed entirely for security reasons, but it will give you an idea of what the output looks like:
Array ( [x_response_code] => 1 [x_response_reason_code] => 1 [x_response_reason_text] => This transaction has been approved. [x_avs_code] => Y [x_auth_code] => 012335 [x_trans_id] => 12345678 [x_card_type] => Visa [x_first_name] => Theodore [x_last_name] => Pride [x_company] => Fenton Web Design Firm. [x_address] => 1731 Smizer Mill Rd. [x_city] => Fenton [x_state] => MO [x_zip] => 63026 [x_country] => US [x_description] => My transaction description [x_cust_id] => 1234 [x_amount] => 19.95 [x_MD5_Hash] => X5C2BA75F23E5666AD9D3A3B693E584X )
From there it was simple - I knew what the field names were and what the data looked like, just had to test for success (I'm using x_response_code == 1) and if successful, store the transaction record in the database. I'll leave the database storage part up to you.
08-17-2011 07:42 AM
Thanks,
That helped but I really need more.
What I am used to is : our customer login to my website, enters how much they are paying and press the "buy now" button. I then send along their userid and the payment amount to be processed. The return, goes to an IPN and then posts to my mysql tables.
Do you by chance have a more complete script I might be able to cannibalize?
08-17-2011 10:35 AM
The data is all there in a simple associative array in $_POST. Just go into your Authorize.net control panel, set the callback URL to the page you want logging the transactions (https://), then have the callback page take the $_POST variables and store them in the database. Not sure what part you need code for - is it the initial charge, the logging, the database interaction, what? I can certainly try to help, but you have to have some amount of experience with PHP and databases - I'm not writing the entire system for free. Might be fun, but I have paying work I have to do.
08-17-2011 06:49 PM