Capture time from server mysql and assign to variable

[fernandopm]

I need capture time from server mysql using command NOW(); and assign to variable global y possible?

Thank's

[Janschenkel]

Assuming you've already connected to the database using the revOpenDatabase function, it's as easy as using the revDataFromQuery function to call into the remote function:

Code: Select all

on mouseUp
  global gDatabaseId  -- return value from revOpenDatabase
  answer revDataFromQuery(comma, return, gDatabaseId, "SELECT NOW()")
end mouseUp

If the database is not on the same local network, I urge you to move this logic to a CGI script on the server, as it is not recommended to allow world-wide direct access to your MySQL database. Instead, you should always go through an 'application' layer.

Jan Schenkel.