AnsweredAssumed Answered

Post to MySQL using "Insert from URL" - loop

Question asked by weirded on Nov 30, 2016
Latest reply on Dec 3, 2016 by fmpdude

Hi to all,

I'm absolutely newbie to php/MySQL and was trying to see how to manage data transfer from Filemaker (ideally GO) to other databases using "Insert from URL" script step with httppost.

I've put up a locally working sample following a tutorial.

FM basically calls a php script via "Insert from URL" passing the record field values, then the script opens the connection, inserts the data and closes the connection.

I can put this step in a loop, to call the php script for every record I want to post, but then the script opens and closes the connection for every record. Is there a more efficient way to do this (in order to open the connection only once at the beginning of the push process and close it at the end) ? Am I forced to push the whole dataset as a sigle variable (sort of list) and then unwrap it in MySQL ? Any ideas ?