FileMaker Pro Custom Functions

//mysql_insert(host; user; pw; database; sql; path) //Jim McNeely 4/8/2008 //results in the text of a shell script which will create a php file which will write to a table in the specified DB. //host is the ip address of your mysql database //database is teh database at that address you want to connect to //table is ignored, someday I'll modify this and take it out. //sql: the sql insert text, must be formatted as good sql syntax; be sure to escape single quotes! //path: the path to write the php error script to; should be a folder, and should not end with a forward slash "do shell script (" & Let([ sql = Substitute( sql ; ["\“" ; "\""] ; ["\”" ; "\""] ) ; //this gets rid of smart quotes, which screws things up php_script = path & "/push_to_mysql.php"; x = "echo \"#!/usr/bin/php -q\" > " & php_script & "; " & "echo \"<?php\" >> " & php_script & "; " & "echo \"\$link = mysql_connect(\\\"" & host & "\\\",\\\"" & user & "\\\",\\\"" & pw & "\\\") or die(\\\"I'm sorry Dave, I can't do that. Could not connect: \\\".mysql_error());\" >> " & php_script & "; " & "echo \"mysql_select_db(\\\"" & database & "\\\") or die(\\\"I'm sorry Dave, I can't do that. Could not select " & database & " as database\\\");\" >> " & php_script & "; " & "echo \"\$query = \\\"" & sql & "\\\";\" >> " & php_script & "; " & "echo \"\$result = mysql_query(\$query) or die(\\\"I'm sorry Dave, I can't do that. Query failed: \\\" . mysql_error());\" >> " & php_script & "; " & "echo \"echo \\\"Success\\\";\" >> " & php_script & "; " & "echo \"?>\" >> " & php_script & "; " & "chmod 777 " & php_script & "; " & "echo `php " & php_script & "`; " & "rm " & php_script ]; "\"" & Substitute( x ; ["\\" ; "\\\\"] ; ["\"" ; "\\\""] ) & "\"" ) & ")"
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.