Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

How to export members emails ?

Asked Modified Viewed 3,523 times
M
motorola
M
  • Member, joined since
  • Contributed 79 posts on the community forums.
  • Started 16 threads in the forums
  • Started this discussions
asked
Member

Hello,

Can someone tell me if is possible to export member emails in a excel file or something like that? I need it to add me members emails to PhpList.


Thanks in advance!
motorola
0 replies

8 posts

A
Ankur
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums
answered
Veteran Member

@V veb: I think that he asked to export it into a single file..... which is solved... ;)
0 replies
R
Rolf Mayer
R
Ex
  • Senior Member, joined since
  • Contributed 391 posts on the community forums.
  • Started 7 threads in the forums
answered
Senior Member

Quote

Vveb--ws wrote:
2)
In phpMyAdmin export needed cell

3)
add e-mail cell in user's list in admin area


More and more I think you are a SPAMER!
0 replies
V
Vveb--ws
V
  • Junior Member, joined since
  • Contributed 39 posts on the community forums.
  • Started 4 threads in the forums
answered
Junior Member

2)
In phpMyAdmin export needed cell

3)
add e-mail cell in user's list in admin area
0 replies
M
motorola
M
  • Member, joined since
  • Contributed 79 posts on the community forums.
  • Started 16 threads in the forums
  • Started this discussions
answered
Member

Great man. Thank you very much.
0 replies
A
Ankur
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums
answered
Veteran Member

Not a Big Job !!! Its just like HTML that you can add yourself...

Just Put a Comma (,) before <br /> and you are done !!!

You just need to put HTML Code...

The Syntax is echo "Your HTML Code Here";
0 replies
M
motorola
M
  • Member, joined since
  • Contributed 79 posts on the community forums.
  • Started 16 threads in the forums
  • Started this discussions
answered
Member

Thanks ankurthakur, its good :)
One more thing, is it possible to separate email adress by commas ?
0 replies
A
Ankur
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums
answered
Veteran Member

Create any temporary file where maincore.php is located, say export.php

Put the below code in that :

[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]<?php

require_once "maincore.php";

$result = dbquery("SELECT user_email FROM ".DB_USERS." WHERE user_status='0'"wink;

while($data=dbarray($result))
{
echo $data['user_email'];
}

?>[/syntaxhighlighter]

Call it through your Browser.

I hope that this is What you want to have...

In case you want to Show each E-Mail on a Next Line, Add

Quote

echo "<br />";
after the

Quote

echo $data['user_email'];


And then You can Copy the Text of the Page and can Save in any File, say .TXT
Edited by Ankur on 23-12-2010 09:08,
0 replies
P
PolarFox
P
  • Veteran Member, joined since
  • Contributed 1,633 posts on the community forums.
  • Started 29 threads in the forums
answered
Veteran Member

For teh spam? :D

You can export it to the txt file.
0 replies

Labels

None yet

Statistics

  • Views 0 views
  • Posts 8 posts
  • Votes 0 votes
  • Topic users 5 members

5 participants

P
P
  • Veteran Member, joined since
  • Contributed 1,633 posts on the community forums.
  • Started 29 threads in the forums
M
M
  • Member, joined since
  • Contributed 79 posts on the community forums.
  • Started 16 threads in the forums
  • Started this discussions
R
R
Ex
  • Senior Member, joined since
  • Contributed 391 posts on the community forums.
  • Started 7 threads in the forums
A
A
Ankur 10
Hi! Its me, Ankur Thakur! smile
  • Veteran Member, joined since
  • Contributed 1,277 posts on the community forums.
  • Started 60 threads in the forums
V
V
  • Junior Member, joined since
  • Contributed 39 posts on the community forums.
  • Started 4 threads in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet