
 Alex V - 2011-09-26 15:12:13
 
I want to loop through all emails in my inbox, save them to my database and then delete them one by one.
I manage to read and save the first one but when I try to delete it, I always get "connection is not in TRANSACTION state".
My code looks like this:
$messages = $mailReader->ListMessages('', 0);
        if (is_array($messages)) {
            if (count($messages) > 0) {
                $parser = new Core_MimeParser();
                for(reset($messages), $message = 0; $message < count($messages); next($messages), $message++) {
                    $error = $mailReader->OpenMessage(key($messages));
                    if ($error != '') {
                        return false;
                    }
                    $error = $mailReader->GetMessage($messages[key($messages)], $msgContent, $eofReached);
                    //Decode & save here
                    $mailReader->DeleteMessage(key($messages));
                }
            }
        }
I guess I miss something in my loop... Anyone can help me point what it is?