function MesajList() { $mesajList = array(); try { $baglanti = new VeriTabaniBaglanti(); $conn = $baglanti->pdo_baglanti(); $sorgu = $conn->query("select *from iletisim order by id desc limit 10"); $rows = $sorgu->fetchAll(PDO::FETCH_CLASS); foreach ($rows as $row) { $ilt = new Iletisim(); $ilt->setIletisimId($row->id); $ilt->setAd($row->ad); $ilt->setEmail($row->email); $ilt->setMesaj($row->mesaj); array_push($mesajList, $ilt); } } catch (PDOException $ex) { die($ex->getMessage()); } finally { if ($conn != null) { $conn = $baglanti->pdo_sonlandir(); } } return $mesajList; }
<div class="container"> <div id="contact" class="container-fluid bg-grey"> <h3 class="text-center"><strong>İletişim</strong></h3><br><br> <div class="row"> <div class="col-sm-5"> <p>Saat 8:00 ile 18:00 arası telefon iletişimine açığız .</p> <p><span class="glyphicon glyphicon-map-marker"></span> İstanbul, Türkiye</p> <p><span class="glyphicon glyphicon-phone"></span> 0(212) 555 55 55 </p> <p><span class="glyphicon glyphicon-envelope"></span> karadenizklinigi@gmail.com</p> </div> <form class="col-sm-7" action="" method="post"> <?php if ($_POST) { $ilt = new Iletisim(); $iltdao = new IletisimDAO(); $ilt->setAd(trim($_POST['ad'])); $ilt->setEmail(trim($_POST['email'])); $ilt->setMesaj(trim($_POST['mesaj'])); $iltdao->IletisimEkle($ilt); } ?> <div class="row"> <div class="col-sm-6 form-group"> <input class="form-control" type="text" name="ad" placeholder="Adınız.." required> </div> <div class="col-sm-6 form-group"> <input class="form-control" id="email" name="email" placeholder="Eposta Adresiniz..." type="email" required> </div> </div> <textarea class="form-control" id="comments" name="mesaj" placeholder="Mesajınız..." rows="5"></textarea><br> <div class="row">