Skip to main content
4everJang
4everJang
Legend
May 20, 2014
Question

Access MySQL from ExtendScript

  • May 20, 2014
  • 1 reply
  • 3274 views

Did anyone use ExtendScript to connect to a MySQL database, for retrieving and storing data?

This topic has been closed for replies.

1 reply

frameexpert
Community Expert
frameexpertCommunity Expert
Community Expert
May 20, 2014

Hi Jang, I have not done this with ExtendScript. I am sure you already know this, but for the record, you can use FrameScript to connect to ODBC databases.

With ExtendScript, you could use XML as an intermediary format between the database and ExtendScript.

Rick

www.frameexpert.com
4everJang
4everJangAuthor
Legend
May 20, 2014

Thanks Rick, but FrameScript is not an option here. And using XML does not solve the problem, as I would need to fire some script from elsewhere to do the pushing and pulling of data. I currently write a series of SQL queries into a text file and have the customer execute the textfile from a PHP script running on their web server. For a localization project I would want to pull little bits of info out of the SQL database on the fly, i.e. using an ExtendScript that might then become event-triggered. The format to exchange info is not changing the need for an active link.

I am investigating sockets. From the CS6 JavaScript Tools Guide, that seems to be the right candidate to make this work. I will keep people posted on my progress. If anyone has used sockets before, please share some working code samples.

Ciao

frameexpert
Community Expert
frameexpertCommunity Expert
Community Expert
May 20, 2014

Hi Jang, I know Russ Ward has some sample code using the socket object. I am sure he will give you some advice. Rick

www.frameexpert.com
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices