After a great deal of research and testing, the php scripting feature is obviously in great need of examples and documentation. I'm putting this here to help others until that can be done. Feel free to share any examples to help each other out.
Topic #1
don't use <?, <?php, or ?> they aren't needed
Topic #2
echo and redirects don't work as you'd expect due to internal re-directs that prevent you from seeing them.
details from a help ticket I submitted:
"The echo command could not used to check in this case because right after subscription completed, you will be redirected to a different page, so you won't see the output of your echo command"
Here is some code to test in the PHP Script Settings tab to see if php is working on your server
die('The PHP code is running');
if it is working you will get the text echoed to a blank page
Keep in mind that this feature uses php's eval() to work so if you don't get the code above to work start looking to insure eval() is supported on your server.
using this code in a test php file (ie test.php) might be useful should you need to look into this further
<?php
$isevalfunctionavailable = false;
$evalcheck = "\$isevalfunctionavailable = true;";
eval($evalcheck);
if ($isevalfunctionavailable === true) {
echo "\$isevalfunctionavailable is true.\n";
echo var_dump($isevalfunctionavailable);
}
?>
Topic #3
$row only supports the predefined fields that come with the installation i.e. first_name, last_name, email, etc.
custom fields like osmRace, osmSex, osmBirthDate, etc. can't be accessed with $row. You will need to write custom SQL to obtain these values.
Good luck and I hope others find this useful
