', $bacheca_body); $datetime = date("Y-m-d H:i:s"); $sql_insert = "INSERT INTO bacheca VALUES (NULL,'$bacheca_object','$body','$datetime',".$_SESSION['id'].")"; if ($con->query($sql_insert) === true) { $id = mysqli_insert_id($con); //Invio mail a tutti $sql = "SELECT * FROM users WHERE bacheca_notifies = 1"; $result = mysqli_query($con, $sql); if ($result->num_rows > 0) { while ($row = mysqli_fetch_assoc($result)) { $email = new \SendGrid\Mail\Mail(); $email->setFrom("info@n-hub.com", "NH-HR"); $email->addTo("" . $row["email"] . "", "" . $row["name"] . " " . $row["surname"] . ""); $email->SetTemplateId("d-55b033ba0ed74378a00855406e634540"); //Here is the Place holder values you need to replace. $email->addDynamicTemplateData("NHHR_oggetto_pubblicazione", "" . $bacheca_object . ""); $email->addDynamicTemplateData("NHHR_data_pubblicazione", "" . date('d/m/Y H:i', strtotime($datetime)) . ""); $email->addDynamicTemplateData("NHHR_link_visualizza_pubblicazione", $view_bacheca_url."?bacheca_id=" . $id); $sendgrid = new \SendGrid(SENDGRID_API_KEY); try { $response = $sendgrid->send($email); } catch (Exception $e) { echo 'Caught exception: ' . $e->getMessage() . "\n"; } } } $sql = "SELECT * FROM bacheca ORDER BY id DESC LIMIT 1"; $result = mysqli_query($con, $sql); $first_bacheca = mysqli_fetch_assoc($result); echo $first_bacheca["id"]; } else { echo "error"; } $con->close();