Joomla Extensions Club 20,483 posts

[fiumeciane Friend fiumecianeJoin date: June 2009Posts: 208Downloads:13Uploads:57 Thanks: 16 Thanked: 6 times in 1 posts]

#168180

Hi, is there a way to extract (at once) all the email addresses of those who comment on articles?

Thanks

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#410729

Hi,
What kind of extraction you are looking for ?
Via PHP code on live site or directly from database ?
Thank you
Viet Vu

[fiumeciane Friend fiumecianeJoin date: June 2009Posts: 208Downloads:13Uploads:57 Thanks: 16 Thanked: 6 times in 1 posts]

#410751

<em>@jooservices 265318 wrote:</em><blockquote>Hi,
What kind of extraction you are looking for ?
Via PHP code on live site or directly from database ?
Thank you
Viet Vu</blockquote>

Any, the simplest and most reliable.

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#410752

Hi
Both of above is not target on simply or not. It’s target for who will use it or how will use it ?
If you want extract it and put it for another php for processing -> we’ll use php
If you want extract it and keep it as back-up / storing into another storage -> mysql query
Thank you
Viet Vu

[fiumeciane Friend fiumecianeJoin date: June 2009Posts: 208Downloads:13Uploads:57 Thanks: 16 Thanked: 6 times in 1 posts]

#410753

<em>@jooservices 265347 wrote:</em><blockquote>Hi
Both of above is not target on simply or not. It’s target for who will use it or how will use it ?
If you want extract it and put it for another php for processing -> we’ll use php
If you want extract it and keep it as back-up / storing into another storage -> mysql query
Thank you
Viet Vu</blockquote>

I just want to have a backup of my readers email (csv, txt, it does not matter).

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#410764

Hi
Please moment, i’m checking in code.
Thank you
Viet Vu

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#410770

Hi
In you phpmyadmin table #__jacomment_items you can use this query for query all email records


SELECT email
FROM `joo_jacomment_items`

( please replace joo_ by your own prefix ).
After got result you can extract it 🙂
Thank you
Viet Vu

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#416378

Hi
Just wonder you can go and have done w/ my above suggestion ?
Thank you
Viet Vu

[fiumeciane Friend fiumecianeJoin date: June 2009Posts: 208Downloads:13Uploads:57 Thanks: 16 Thanked: 6 times in 1 posts]

#416489

Correct string: SELECT email FROM prefix_jacomment_items WHERE email != ”

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#416576

Ya
it’s okay ! my query just as sample logic 🙂
Btw thank you for correction ,
Viet Vu

[Author]

Posts