Adding multiple emails to my mailing list database

[discostudio]

I have been trying and trying to add multiple emails to 'mysql database.

I am using the following method:
<form action="add_mutiple.php">
<textarea name="emails"></textarea>

<form>

So my emails end up at page 'add_multiple.php'
as $emails and look like this

[e-mail]
[e-mail]

etc etc etc.

How do I add the to my database as seperate row, remember they are in a form's <textarea> thingy.

I am just a beginner and I hope someone can help me.

[TheDefender]

Well, you have to determine how you are wanting them to be separated, and you may wish to explicitly state that on your web page or something like that...

We'll start with the add_multiple.php page...
And, let's say the $emails variable looks like this:

$emails = "[e-mail],[e-mail],[e-mail]";

So, you'd explode it:

$splitemails = explode(",", $emails);

Now, it is in an array, so you can loop through the array, and add each individually:

foreach($splitemails AS $v){
  if(mysql_query("INSERT INTO table (emails) VALUES('".trim($v)."')")){
  echo "Email added";
} else {
  echo "Email not added";
}
}

Or whatever. The trick is to get it into an array. We add the trim, just in case there are spaces before or after the commas. If you need help with this, post back with your code, and we can help you tweak.

[discostudio]

Well that was an exellent reply but you assumed that my emails would be formated bt a ","..

If I add 100 email addresses into a "TEXTAREA" box they would be formated my ME pressing the "ENTER KEY"

I presume this is entered as a \r called a line return.

So how would I seperate this into seperate rows?

[discostudio]

Well maybe not, erm I dunno.

I am talking about using a "textarea" form box, and adding one email per line then pressing enter, after entering another email on evry line.

I have absoutely no idea how to seperate these into independent "ROWS".

Soeone please help!

[TheDefender]

Then, you'd use \r\n in your explode:

$splitemails = explode("\r\n", $_POST['emails']);

(assuming you are using POST for your method. Otherwise, change to $_GET['emails']... Obviously I am not good at reading your mind, and you didn't state which method you were using, so I leave it up to you from here. You have what you need now.)