PHP Kod:
<?php
$personel = $_SESSION['ekp'];
$count=1;
$randevuTarih=date("Y-m-d");
echo $personel."<br>";
echo $randevuTarih."<br>";
$sel_query="Select * from randevuzaman WHERE ekip = $personel and tarih like '%$randevuTarih%'";
$result = mysqli_query($con,$sel_query);
while($row = mysqli_fetch_assoc($result)) {
$baslangic = "08:30:00";
$baslangic = strtotime($baslangic);
$bitis = "22:00:00";
$bitis = strtotime($bitis);
$aranan = "11:30:00";
$aranan = strtotime($aranan);
while (intval($baslangic)<intval($bitis)){
$baslangic = strtotime("+30 minute", $baslangic);
$rsaat = date_create($row["saat"]); $rsaat1 = date_format($rsaat,"H:i:s");$aranan = strtotime($rsaat1);
echo date("H:i:s",$baslangic); if($baslangic == $aranan){echo " Randevu Var";}echo "<br>";
}
}
?>