| 12
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 
 | $res_name=$_POST['res_name'];
$count=count($res_name);
include("banniere.php");
include("menutop.php");
echo '<div class="corps">';
for($n=0;$n<$count;$n++)
{
      $ressource_name=$res_name[$n];
      $requete=@oci_parse($connection, "SELECT EMAIL,LOWER(SUBSTR(FIRST_NAME,1,1)||LAST_NAME) FROM tdm.EDI_RESSOURCE_NAME WHERE RESSOURCE_NAME='".$ressource_name."'");
      oci_execute($requete);
      $mailto=oci_result($requete, "EMAIL");
      $login=oci_result($requete, "LOWER(SUBSTR(FIRST_NAME,1,1)||LAST_NAME)");
      $password="TSA_USER";
      $headers  = "From: <adresse@haha.com>\n";
      $headers .= "X-Priority: 1\n";
      $headers .= "Content-Type: text/plain; charset=\"iso-8859-1\"\n";
      $headers .= "Content-Transfer-Encoding: 8bit";
      $subject  = 'Register to TSA';
      $message  = "Hello, \n\n";
      $message .= "Votre login:".$login."\n";
      $message .= "Votre password:".$password."\n\n";
      $message .= "Bonne journée.";
      $result=@mail($mailto, $subject, $message, $headers);
      if($result==true)
      {
         $requete1=@oci_parse($connection, "UPDATE tdm.EDI_RESSOURCE_NAME SET STATUT_TSA='ON' WHERE RESSOURCE_NAME='".$ressource_name."'");
         oci_execute($requete1);
         $requete2=@oci_parse($connection, "INSERT INTO tdm.TSA_USER_LOGIN VALUES('$login','$password','',SYSDATE,''");
         oci_execute($requete2);
         echo 'L\'email a bien été envoyé';
      }
      else
      {
        echo 'L\'email n\'a pas pu être envoyé !';
      }
      oci_free_statement($requete);
      oci_free_statement($requete1);
      oci_free_statement($requete2); | 
Partager