if(isset($_POST['submit'])) { $con = mysqli_connect("localhost","betong_event","poC8%GrASWjU","betong_event") or die("Some error occurred during connection " . mysqli_error($con)); mysqli_set_charset( $con, 'utf8'); $datum = date("Y-m-d H:i:s"); $sql = "INSERT INTO `ncr2022` (`Id`, `datum`, `name`, `phone`, `email`, `address1`, `address2`, `address3`, `country`, `compuniv`, `phd`, `abstract`, `dinner17`, `dinner18`, `vat`, `invoiceemail`, `sitevisit`, `prevabstract`, `info`) VALUES (NULL, '$datum', '{$_POST['name']}', '{$_POST['phone']}', '{$_POST['email']}', '{$_POST['address1']}', '{$_POST['address2']}', '{$_POST['address3']}', '{$_POST['country']}', '{$_POST['compuniv']}', '{$_POST['phd']}', '{$_POST['abstract']}', '{$_POST['dinner17']}', '{$_POST['dinner18']}', '{$_POST['vat']}', '{$_POST['invoiceemail']}', '{$_POST['sitevisit']}', '{$_POST['prevabstract']}', '{$_POST['info']}')"; mysqli_query($con, $sql); mysqli_close($con); $to = $_POST['email']; $mailmsg = "Thanks for your registration for XXIV NCR Symposium 2022 on August 16, 2022 - August 19 2022 You have registered participation with the following information: Name: ".$_POST['name']." Cellphone: ".$_POST['phone']." Email: ".$_POST['email']." PhD student: ".$_POST['phd']." Country of current employment/studies: ".$_POST['country']."\n I am interested in: Dinner at the venue, Wednesday 17th of August: ".$_POST['dinner17']."\n Conference dinner, Thursday 18th of August: ".$_POST['dinner18']."\n Site visit, Friday afternoon, 19th of August: ".$_POST['sitevisit']."\n INVOICE ADDRESS: ".$_POST['compuniv']." ".$_POST['address1']." ".$_POST['address2']." ".$_POST['address3']." ".$_POST['invoiceemail']."\n VAT: ".$_POST['vat']."\n Additional information: ".$_POST['info']."\n See you in August! Best regards, Swedish Concrete Association"; $subject = "Registration for XXIV NCR Symposium 2022"; $headers = "From: NCR@betongforeningen.se". "\r\n". $headers.= "Content-Type: text/plain;charset=utf-8\r\n". "Reply-To: NCR@betongforeningen.se"."\r\n". "Bcc: info@rikoschett.com"; mail($to, '=?utf-8?B?'.base64_encode($subject).'?=', $mailmsg, $headers); header("Location: https://ncr.betongforeningen.se/thanks/"); } ?>