Hello all:
I am working on a massive project using the InDesign SDK and MySQL. Essentially, I am gathering data and storing it in a MySQL table for later reporting. The InDesign SDK is a C++ based SDK so I have to write the plugin in C++ using Visual C++ on the PC and CodeWarrior on the Mac. This is all complicated by the fact that I have to write the code for three different versions of InDesign and two versions of Pagemaker (thank the Great Coder that those versions vary almost not at all), as well as two separate machine platforms (Mac and PC).
I have one version done for the PC side of things, but for some reason, the Mac side of the show is proving to be a most painful experience. The MySQL C interface just seems flaky; one day it will work, the next, not without any indication of why the program is blowing up.
At any rate, I have another big project I wrote in Applescript, and I used PHP to access a MySQL table through a "do shell" call, and it was extremely stable. What I would like to try, if feasible, is call a PHP script through a C/C++ call (kind of like a spawn or exec call). Has anyone done such a thing? If so, would you mind showing me the code? Please bear in mind that I only need it on the Mac.
TIA!
John
