function MusteriDoktorGunGoster($tarih, $id)
 {
     $musteriList = array();
     try {
         $sutunlar = "id,musteriAd,musteriSoyad,email,tel,randevuTarihi,mesaj,saat_id,doktor_id,randevuOnay";
         $baglanti = new VeriTabaniBaglanti();
         $conn = $baglanti->pdo_baglanti();
         $tarihSorgu = $conn->query("select {$sutunlar}  from musteri where randevuTarihi='{$tarih}' and doktor_id={$id} and CURDATE()<=randevuTarihi ");
         $rows = $tarihSorgu->fetchAll(PDO::FETCH_CLASS);
         foreach ($rows as $row) {
             $musteri = new Musteri();
             $musteri->setMusteriId($row->id);
             $musteri->setAd($row->musteriAd);
             $musteri->setSoyad($row->musteriSoyad);
             $musteri->setEmail($row->email);
             $musteri->setTel($row->tel);
             $musteri->setRandevuTarihi($row->randevuTarihi);
             $musteri->setSaatId($row->saat_id);
             $musteri->setMesaj($row->mesaj);
             $musteri->setDoktorId($row->doktor_id);
             array_push($musteriList, $musteri);
         }
     } catch (Exception $ex) {
         die($ex->getMessage());
     } finally {
         if ($conn != null) {
             $conn = $baglanti->pdo_sonlandir();
         }
     }
     return $musteriList;
 }
                    </select>
                </td>
            </tr>
            <tr>
                <td></td>
                <td><input type="submit" value="Randevuyu Onayla"></td>
            </tr>
        </table>
        </form>
    
    <?php 
        if (isset($_POST['musteriId1'])) {
            //echo  $_POST['musteriId1'];
            $musteri = new Musteri();
            $musteri->setMusteriId($_POST['musteriId1']);
            $musteri->setDoktorId($_POST['doktor']);
            $musteri->setRandevuTarihi($_POST['tarih']);
            $musteri->setSaatId($_POST['saat']);
            $musteri->setMesaj(trim($_POST['mesaj']));
            $musteri->setRandevuOnay(1);
            $musteridao = new MusteriDAO();
            $musteridao->randevuOnayla($musteri);
        }
    }
    $header->footer();
    ?>
</div>
</div>
</body>
</html>
<?php 
 function musteriTarihListesi()
 {
     $musteriList = array();
     try {
         $baglanti = new VeriTabaniBaglanti();
         $conn = $baglanti->pdo_baglanti();
         $sorgu = $conn->query("Select *from musteri where randevuTarihi >= CURDATE()");
         $rows = $sorgu->fetchAll(PDO::FETCH_CLASS);
         foreach ($rows as $row) {
             $musteri = new Musteri();
             $musteri->setMusteriId($row->id);
             $musteri->setAd($row->musteriAd);
             $musteri->setSoyad($row->musteriSoyad);
             $musteri->setEmail($row->email);
             $musteri->setTel($row->tel);
             $musteri->setRandevuTarihi($row->randevuTarihi);
             $musteri->setSaatId($row->saat_id);
             $musteri->setMesaj($row->mesaj);
             $musteri->setDoktorId($row->doktor_id);
             array_push($musteriList, $musteri);
         }
     } catch (Exception $ex) {
         die($ex->getMessage());
     } finally {
         if ($conn != null) {
             $conn = $baglanti->pdo_sonlandir();
         }
     }
     return $musteriList;
 }