- This topic has 5 replies, 2 voices, and was last updated 10 years, 5 months ago by .
Viewing 6 posts - 1 through 6 (of 6 total)
Viewing 6 posts - 1 through 6 (of 6 total)
- You must be logged in to reply to this topic.
Support site for Tips and Tricks HQ premium products
by
Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › How to add serial number to external MySQL database
Tagged: serial number
Hi there,
Just purchased the plugin for my site: [www.focusme.co] and I love it!
I have it working sending emails out to customer with the purchased product serial number – that’s working great.
For my software activation I also need to add the serial number and customer name/email to an external MySQL database. Can anyone advise of how I can do that? I guess I need to run some kind of custom PHP.. but I don’t know how to get the information out of the plugin and into PHP when a customer makes a purchase.
Any help would be much appreciated!!
If this is outside the scope of the product, then I do apologise.
Thanks!
Jon
Is the “external database” on the same, or a different system?
Hi, it’s on a different system. Many thanks!
Okay, you sound like you might be able to “pull this off,” but it will require some PHP coding on both ends.
What you want to do is intercept the information that is emailed to the buyer, that contains both the buyer’s email address and the serial number. You want to somehow BCC the “other system,” perhaps with a secret email address. On the other end, you can then parse out the information and add it to your database on that side.
Thank you wzp for the suggestion! I guess I might need to hire a freelancer to help me.
What would your suggestion have been if the database was on the same system? As I might be able to relocate it..
If the database were on the same system, you would try intercepting the information when the Thank You page is displayed. You’d then save the unique information required in another WordPress table and then periodically export that one table. This approach is less expensive than the first one.
If you’d like, reference this thread and please complete the custom work order quote form, and someone will get back to you: