0x1998 - MANAGER
Edit File: envoi_template_sendinblue.php
<?php include "config/garde.php"; $result=mysqli_query($link,"select email, nom, gsm,rem, A.id as id from ".PREF."users A inner join user_type B on A.id=B.id where rem like 'A%' "); while ($row=mysqli_fetch_array($result)) { $row['rem']=substr($row['rem'],1); $curl = curl_init(); curl_setopt_array($curl, array( CURLOPT_URL => "https://api.sendinblue.com/v3/smtp/email", CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => "", CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 30, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => "POST", CURLOPT_POSTFIELDS => "{\"to\":[{\"email\":\"".$row['email']."\"}],\"templateId\":1, \"params\":{\"nom\":\"".$row['nom']."\",\"code\":\"".$row['rem']."\",\"tel\":\"".$row['gsm']."\",\"email\":\"".$row['email']."\"}}", CURLOPT_HTTPHEADER => array( "accept: application/json", "api-key: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", "content-type: application/json" ), )); $response = curl_exec($curl); $err = curl_error($curl); curl_close($curl); if ($err) { echo "cURL Error #:" . $err; } else { // a compléter : il faut qu'il y ait envoi et pas erreur sendinblue mysqli_query($link,"update user_type set rem='".$row['rem']."' where id='".$row['id']."'"); echo $response; } sleep(5); } ?>