-
Notifications
You must be signed in to change notification settings - Fork 0
/
Trainings.php
35 lines (34 loc) · 1.41 KB
/
Trainings.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?php
$Name = $_POST['Name'];
$CandidateTitle=$_POST['CandidateTitle'];
$Email = $_POST['Email'];
$MobileNumber=$_POST['MobileNumber'];
$Training=$_POST['Training'];
$Country=$_POST['Country'];
$Company=$_POST['Company'];
$NumberOfSeats=$_POST['NumberOfSeats'];
$Message = $_POST['Message'];
$TrainingVersion=$_POST['TrainingDate'];
if(empty($Name) || empty($Email) ||empty($MobileNumber)||empty($Training)||empty($Company)||empty($Country)||empty($NumberOfSeats)){
echo"Fill all fields";
}
else{
//Testing DB String
$conn = new mysqli('localhost', 'root', '', 'testitqan');
if ($conn->connect_error) {
die('Connection Failed: ' . $conn->connect_error);
echo"Connection Error";
} else {
$conn->query("SET time_zone = '+02:00'");
$stmt = $conn->prepare("insert into TrainingRegistrations(Name, Email,JobTitle,Mobile,TrainingName,TrainingPlace,TrainingVersion,Country,Company,NumberOfSeats,Message, TimeStamp) values( ?, ?, ?, ?, ?,?,?, ?,?,?,NOW())");
$stmt->bind_param("ssssssssis", $Name, $Email,$CandidateTitle,$MobileNumber,$Training,$TrainingVersion,$Country,$Company,$NumberOfSeats, $Message);
if ($stmt->execute()) {
header('Location:Success.html');
} else {
echo "Error sending message: " . $stmt->error;
}
$conn->close();
$stmt->close();
}
}
?>