Jump to content

data888

Members
  • Content Count

    12
  • Joined

  • Last visited

  • Days Won

    1

data888 last won the day on June 9 2015

data888 had the most liked content!

Community Reputation

1 Neutral

About data888

  • Rank
    Member

Profile Information

  • Gender
    Male
  1. It seems there is conflicting information regarding this matter. I read a certain article which seems to claim that in 2016, the largest single transaction value through PayPal donation was $230,000. Elsewhere on PayPals site exist somewhat conflicting data. If the merchant and donor have verified accounts, is there any limit on the value of any single transaction? Does the donor experience any errors if the transaction amount exceeds $10,000?
  2. It isn't illegal. There often are websites that request and store financial information... there has to be a business need for it though and you have to store it responsibly and obviously obtain their consent. Regardless, if you get hacked and should a customer incur some sort of economic injury, you may be liable if you get sued and were negligent somewhere. If you are simply just collecting the data to store offline for some sort of authorized usage, a form might be a more familiar/normal method compared to having them email the info. Bitcoin can be an alternative but it does have its risk.
  3. I did find all the data is typically returned as a very large string...I currently can post and assign to variables to store to database. It is a useful messaging service because we can choose to only write data to database if we get confirmation the payment process is actually complete or that user is verified etc. tons of information.
  4. Finally got this a few days ago. Good grief...it turns out 95% of the code posted in most of the forums regarding this is absolutely not required to get the job done. The process we are using requires the buyer to fill out a form to provide certain basic information: Name, login, password, address etc... before hitting the paypal site to process payment. You essentially have to use the paypal 'custom' variable to store all non paypal variables as a large string which you then retrieve and explode into separate variables when the buyer is routed back to our site. Also, all along the actual PayPal data/variables I was initially trying to retrieve was always there to be retrieved by using POST[];
  5. There was an issue with the code.. apparently you need to specify the 'return method' initially when passing the data to PayPal for processing -- it wasn't. So it appears PayPal got confused when told to POST the transaction string in code. Currently it displays a string of data that covers entire page. Apparently it is trying to display all of last 28 transactions in a single string? How did you implement exporting the sting to a test file? That might be a start to getting the transaction details it in a database on the server.
  6. Perhaps there is a misunderstanding. I do not have an issue testing functionality of payment process using sandbox or live environment. Currently user is routed to whatever page is specified in PayPal after PayPal processes payment but process is not completed after user makes a payment. The goal here is not to simply get a response from PayPal that transaction was processed but to have PayPal "pass" back certain transaction detail (user and transaction variables) in real time for further processing. We can technically manually log into PayPal and manually review each transaction to gather transaction details to figure out how to configure each customer account so they can have correct access when they log in but that would be technically unwise. Rather, actual capture and display of user and transaction detail/variables is required after customer's payment has been processed and received. Think of it this way.... what is required is something similar to having the ability to store transaction details in a globally accessible session variable and being able to access the session variable after receipt of payment has been made and received $_SESSION['user_email']; $_SESSION['user_password']; //not paypal password but password on our site $_SESSION['order_date']; $_SESSION['item_name1']; $_SESSION['item_name2']; etc... The current process with PayPal is to collect the information, process payment and then route the user to a page you specify. That is not enough. I need to retrieve same info in real time from PayPal for further processing. Manually combing through transaction records to figure who ordered what and when just isn't an option.
  7. Will try keep description of issue to less than 500 pages... After a customer makes a payment using PayPal standard (note: user may add single or multiple items to cart & checkout), I need to capture/retrieve certain transaction details which would then be used to authenticate the user and display content based on their order. So there could be multiple items associated with a particular transaction. When user supplies an email address during order process (along with other info), I need to retrieve the value of the email variable, item name, user address etc., through the instant payment messaging service while simultaneously writing the info to database and emailing user for their records. Note: Emailing user or writing variable data to database is not the issue but actually capturing/retieving the transaction data from PayPal. Aparently PayPal offers something called 'Instant Payment Notification'. So the developer can place a call in code to PayPal to have transaction data sent to a page (notify_url) as a string of some sort, which you can then split to store into separate variables. Problem, none of the integration code either by PayPal or others that I have seen, seem to function properly. It simply displays a blank page on the page where data should be displayed. Does anyone have a version of the 'listener' script that performs the stated function and actually displays the transaction info? This is supposed to be an example of a similar code: https://www.geekality.net/2011/05/28/php-tutorial-paypal-instant-payment-notification-ipn/
  8. By the way.. this finally did execute; there was an issue with the SQL string that was affecting things although there wasn't an error on the screen.
  9. not sure where you are going with this but what is required is that the average field be computed and stored; the issue isn't with performing calculations for display on the screen but the average data does need to be calculated and stored. Each of the fields for the values column are also constantly and randomly updated and not necessarily simultaneously.
  10. Theoretically it seems like that should execute but it doesn't; if you happen to have it execute on your end feel free to discuss. This seems like it should have the capability but the thought was not to spend 5 hours researching it if someone else have utilized this in the past: http://dev.mysql.com/doc/refman/5.6/en/triggers.html
  11. This should help you understand. You get a table with a bunch of values column (value1, value2, value3, value4, value5 and such) . It initially doesn't have an average column and looks like this: ------------------------------------------------------ | value1 | value2 | value3 | value4 | value5 | ------------------------------------------------------- | 10000 | 15000 | 20000 | 25000 | 30000 | ------------------------------------------------------ | 10100 | 15100 | 20100 | 25100 | 30100 | ------------------------------------------------------ | 10200 | 15200 | 20200 | 25200 | 30200 | ------------------------------------------------------ at some stage you then need to also have an 'average' column in the table to compute and store the average of the values. After adding the 'average' column, each row looks like this. All data type for both values and average =int: ------------------------------------------------------------------ | value1 | value2 | value3 | value4 | value5 | average | ------------------------------------------------------------------ | 10000 | 15000 | 20000 | 25000 | 30000 | 0 | ------------------------------------------------------------------ | 10100 | 15100 | 20100 | 25100 | 30100 | 0 | ------------------------------------------------------------------ | 10200 | 15200 | 20200 | 25200 | 30200 | 0 | ------------------------------------------------------------------ So what is needed is to have the average for each of the rows populated based on data in the values fields and should then look something like this: ------------------------------------------------------------------ | value1 | value2 | value3 | value4 | value5 | average | ------------------------------------------------------------------ | 10000 | 15000 | 20000 | 25000 | 30000 | 20000 | ------------------------------------------------------------------ | 10100 | 15100 | 20100 | 25100 | 30100 | 20100 | ------------------------------------------------------------------ | 10200 | 15200 | 20200 | 25200 | 30200 | 20200 | ------------------------------------------------------------------ Do you understand?
  12. It appears I need a trigger of some sort to have a certain function performed. Would like to hear any suggestions on how to have this done. What I need is to have data in a field populated dynamically by calculating the average of other fields within the same table. Example of column names: Value1, Value2, Value3, Value4, Value5, Average Values 1 through 5 may be entered through a form but I need to have the average field populated by dynamically using the entered data to compute the average.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.