<?php
include "../database.php";
require_once '../../plugins/sendgrid/config.php';
require "../../plugins/sendgrid/sendgrid-php.php";
$user_email  = $_POST['email'];
$code        = rand(1000, 9999);
$date        = date("Y-m-d H:i:s");
$currentDate = strtotime($date);
$futureDate  = $currentDate + (60 * 5);
$formatDate  = date("Y-m-d H:i:s", $futureDate);
$sql_insert  = "INSERT INTO verification_codes VALUES (NULL,'" . $user_email . "','Password forgot'," . $code . ",'" . $formatDate . "')";
if ($con->query($sql_insert) === true) {
 //Invio mail creatore
 $email = new \SendGrid\Mail\Mail();
 $email->setFrom("info@n-hub.com", "NH-HR");
 $email->addTo("$user_email", "$user_email");
 $email->SetTemplateId("d-4cc102622d9e45f780395130e8e44196");
 //Here is the Place holder values you need to replace.
 $email->addDynamicTemplateData("NHHR_verification_code", "$code");
 $email->addDynamicTemplateData("NHHR_code_expiration", "" . date('d/m/Y H:i', strtotime($formatDate)) . "");
 $sendgrid = new \SendGrid(SENDGRID_API_KEY);
 try {
  $response = $sendgrid->send($email);
  echo "ok";
 } catch (Exception $e) {
  echo 'Caught exception: ' . $e->getMessage() . "\n";
 }
} else {
 echo "error";
}