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;
}
<?php
include_once '../include/include_class.php';
$musteriInclude = new IncludeClass();
$musteriInclude->musteriSil_controller();
if (isset($_SESSION['admin_id'])) {
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Müşteri Güncelle</title>
<?php
$bootstrap = new Bootstrap();
$bootstrap->controller_vb();
?>
</head>
<body>
<?php
if ($_POST) {
$header = new Header();
$header->kokSayfa_header();
$musteri = new Musteri();
$musteri->setMusteriId(trim($_POST['musteriId']));
$musteridao = new MusteriDAO();
$musteridao->musteriSil($musteri);
}
}
?>
</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>
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;
}
