require 'php-export-data.class.php';
$filename = uniqid(rand(), true) . '.xls';
$exporter = new ExportDataExcel('string');
$exporter->initialize();
$exporter->addRow(array('Input', 'Value'));
$exporter->addRow(array('School name', $_POST['schoolname']));
$exporter->addRow(array('Name of teacher', $_POST['moderatorname']));
$exporter->addRow(array('Number', $_POST['number']));
$exporter->addRow(array('Email', $_POST['email']));
for ($i = 1; $i <= 34; $i++) {
$participant = array('Participant ' . $i, $_POST['participant' . $i]);
$exporter->addRow($participant);
}
$tmpfile = fopen("register_xls/" . $filename, "w");
fwrite($tmpfile, $exporter->getString());
fclose($tmpfile);
$exporter->finalize();
$url = 'https://api.sendgrid.com/';
$user = '******';
$pass = '******';
$filePath = 'register_xls';
$params = array('api_user' => $user, 'api_key' => $pass, 'to' => '*****@*****.**', 'cc' => '*****@*****.**', 'subject' => 'New register from page', 'html' => 'XLS file attached.', 'text' => 'XLS file attached.', 'from' => '*****@*****.**', 'files[' . $filename . ']' => '@' . $filePath . '/' . $filename);
$request = $url . 'api/mail.send.json';
$session = curl_init($request);
curl_setopt($session, CURLOPT_POST, true);
curl_setopt($session, CURLOPT_POSTFIELDS, $params);
curl_setopt($session, CURLOPT_HEADER, false);
curl_setopt($session, CURLOPT_SSLVERSION, CURL_SSLVERSION_TLSv1_2);
curl_setopt($session, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($session);
