It looks like you're new here. If you want to get involved, click one of these buttons!
I'm making an app that ties in with Sendy. I used the official API where I could, but many things I wanted to do weren't covered. So, I am making PHP scripts to pull the data I want out of the SQL database.
Currently, I'm trying to find how many people have opened my autoresponder.
It's easy enough to find how many it was sent to - in the recipients column of the ares_emails table there is just a plain number. Great!
But now I want to find how many opened it. The next column over, opens, seems to be what I want.
But here's what it says:
Not exactly plaintext :(
How do I extract how many people have opened the autoresponder email from the database?
You need to use PHP explode to get the individual subscriber ids and their country code for opens.
So this should work:
$array = explode(',', $stringFromDB);
And then count the array?
Yes - count($array)