php邮件功能没有显示小时

Question

I am reading values from the post and sending them via mail(). Now some of the data i get from the database. However i have a problem with HOUR! Why am i not getting this value? Where am i doing wrong?

<?php
   include("config.php");
   session_start();


$update_ime=$_POST['ime'];
$update_priimek=$_POST['priimek'];
$update_email=$_POST['email'];
$update_telefon=$_POST['telefon'];
$update_izobrazba=$_POST['izobrazba'];
$update_kraj=$_POST['kraj'];
$id_posta = $_POST['prijava_na_datum'];

$result = mysqli_query($db,"SELECT DATUM, HOUR FROM razpisani_tecaji WHERE ID_TECAJA = '$id_posta'");
while($row = mysqli_fetch_array($result))
$date = $row['DATUM']; 
$hour = $row['HOUR']; 

$to      = '[e-mail],[e-mail]';
$subject = 'prijava_na_tecaj_fizicna';
$headers = "Prijavljam se na tečaj dne: " . $date . "
";
$headers .= "Ob: " . $hour . "
";
$headers .= "Ime: " . $update_ime . "
";
$headers .= "Priimek: " . $update_priimek . "
";
$headers .= "Email: " . $update_email . "
";
$headers .= "Telefon: " . $update_telefon . "
";
$headers .= "Status/izobrazba: " . $update_izobrazba . "
";
$headers .= "Ime ustanove/kraja: " . $update_kraj . "
";




if(@mail($to, $subject, $headers)){
 header('Location: email_uspesno_poslan.html'); exit;
}else{
 header('Location: email_neuspesno_poslan.html'); exit;
}

?>

Answer 1

$row is empty when you try to get the HOUR key:

while($row = mysqli_fetch_array($result))
$date = $row['DATUM']; 
$hour = $row['HOUR'];

evaluates to:

while ($row = mysqli_fetch_array($result)) {
    $date = $row['DATUM']; 
}
$hour = $row['HOUR'];

So $row is empty / null when you try to use it.

And you need to read-up on sql injection.