<?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "selida_krathsewn";
// Δημιουργία σύνδεσης
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Έλεγχος σύνδεσης
if (!$conn) {
 die("Connection failed: " . mysqli_connect_error());
}
// Έλεγχος σύνδεσης
if (!$conn) {
 die("Connection failed: " . mysqli_connect_error());
}
//ορισμός charset της σύνδεσης ώστε να παρουσιάζονται τα ελληνικά σωστά
mysqli_set_charset($conn, "utf8");

//oi metablhtes apo ta pedia ths formas
$afixh=$_POST["date1"];
$anaxwrhsh=$_POST["date2"];
$onoma=$_POST["firstname"];
$epitheto=$_POST["lastname"];
$email=$_POST["email"];
$ekdromh=$_POST["ekdromh"];

$atoma = isset($_POST['atoma']) ? $_POST['atoma'] : '';
if($ekdromh == 1 || $ekdromh == 2 ){
	$xrewsh=$atoma * 30;}
else if($ekdromh == 3 || $ekdromh == 4){
	$xrewsh=$atoma * 20;}
else{$xrewsh=$atoma * 25;}
echo $xrewsh;

//INSERT tis metablites sth bash dedwmenwn
//$sql = "INSERT INTO ekdromes ( EMAIL , AFIXH , ANAXWRHSH , ONOMA , EPITHETO , EKDROMH , ATOMA , XREWSH ) VALUES ( '$email' , '$afixh' , '$anaxwrhsh' , '$onoma' , '$epitheto' , '$ekdromh' , '$atoma' , '$xrewsh' )";

//$sql = "INSERT INTO krathseis_xenodoxeiou ( AFIXH , ANAXWRHSH , ARDWMATIOY ,  ENHLIKES , XREWSH , EMAIL) VALUES ( '$afixh' , '$anaxwrhsh' , '$arithmos_dwmatiou'   ,  '$enhlikes' , $xrewsh , '$email' )";

$sql= "INSERT INTO `ekdromes`(`EMAIL`, `AFIXH`, `ANAXWRISH`, `ONOMA`, `EPITHETO`, `EKDROMH`, `ATOMA`, `XREWSH`) VALUES ([$email],[$afixh],[$anaxwrhsh],[$onoma],[$epitheto],[$ekdromh],[$atoma],[$xrewsh])";













?>