1 2 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