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 ?