Since a couple of hours I'm trying to find out why the IPN from paypal isn't accepting a foreach loop inside.
If i write
if (strcmp (trim($res), "VERIFIED") == 0) {
$resDB = mysql_connect("localhost", "user","pass");
mysql_select_db("database", $resDB);
$files = array(
'key1' => 'value1',
'key2' => 'value2',
'key3' => 'value3'
);
foreach($files as $key => $value) {
if($_POST['item_name'] == $key){
mysql_query("INSERT INTO downloads (downloadkey, file, expires) VALUES ('{$strKey}', '$value', '".(time()+(60*60*24*7))."')");
}
};
}
ecc...
it's not working and i get a 500 error from the ipn simulator in the sandbox account, but
if(strcmp (trim($res), "VERIFIED") == 0) {
$resDB = mysql_connect("localhost", "user","pass");
mysql_select_db("database", $resDB);
if($_POST['item_name'] == 'key1'){
mysql_query("INSERT INTO downloads (downloadkey, file, expires) VALUES('{$strKey}', 'value1', '".(time()+(60*60*24*7))."')");
}elseif($_POST['item_name'] == 'key2'){
mysql_query("INSERT INTO downloads (downloadkey, file, expires) VALUES('{$strKey}', 'value2', '".(time()+(60*60*24*7))."')");{
}else($_POST['item_name'] == 'key3'){
mysql_query("INSERT INTO downloads (downloadkey, file, expires) VALUES ('{$strKey}', 'value3', '".(time()+(60*60*24*7))."')");
}
ecc...
is working.
Any idea why?
Please note that work is still in progress, so i know that i have to update mysql to mysqli.
Thanks for any suggestion