one input, much mails, insert each mail in one register

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi?

Thanks to Vinay for your help? works very good...

But I can?t validate if one or more of the emails insert in the textarea
exist in the table of the DB to not insert it, but yes insert the others
mails that not exist in the db.

This the cod:

 

<html>

<head>

<title>Explode trial</title></head>

<body>

<?php

if($_GET['emailreader'])

{

         $username="root";

         $password="root";

         $database="anda";

         $con = mysql_connect("localhost",$username,$password);

         mysql_select_db("$database", $con);

         $str = $_GET['emailreader'];

         $text=$_GET['emailreader'];

         $spacecount=substr_count($text," ");

         $emails_exploded=(explode(" ",$str));

         

         $sql = "SELECT * FROM mailing";

         $result = mysql_query($sql);

         $array = mysql_fetch_array($result);

         $mail = $array['mail'];

         

         for ($i=0;$i<=$spacecount;$i++)

                   {

                   if($emails_exploded[$i] != $mail)

                   {

                            echo $emails_exploded[$i];

                            mysql_query("INSERT INTO mailing (mail)
VALUES('$emails_exploded[$i]')") or die(mysql_error());

                   }

         }

}

  

?>

<form action="<?php $_SERVER['PHP_SELF'] ?>" method="get" name="emailform">

<label for=email>Email</label>

<input type="text" name="emailreader" size="200" />

<input type="submit" name="submit" value="Ok !" />

<input type="hidden" name="trigger" value="6" />

<input type="reset" name="cancel" value="Cancel" />

</form>

</body>

</html>

 

Thanks a lot

 

+                                                                          _
   // Emiliano Boragina _
   // Diseño & Comunicación //////////////////
+                                                                          _
   // emiliano.boragina@xxxxxxxxx  /
   // 15 40 58 60 02 ///////////////////////////
+                                                                          _

 


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux