PHP Tarih Listeleme

[younglover]

sa kıymetli hocalarım.
aşağıdaki kodlarda yardımcı olabilirmisiniz.

yapmak istediğim şu: listelettiğim kayıtları birleştirip bir tabloda listelemek ve tarihe göre listelemek
<?php
require_once 'header.php';

if (!isset($_SESSION ['kullanici_tc'])) {
header('location:login.php');
}


if (isset($_POST['arama'])) {

$aranan = $_POST['aranan'];



$covidsor=$db->prepare("SELECT * FROM covid WHERE kayit_tarihi LIKE '%$aranan%'");
$covidsor->execute();

$say = $covidsor->rowCount();

}else{

$covidsor=$db->prepare("SELECT * FROM covid");
$covidsor->execute();
$say = $covidsor->rowCount();
}

/*Arama İşlemi Finish*/



?>

<!-- page content -->
<div class="right_col" role="main">
<div class="">

<div class="clearfix"></div>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2> <small>


</small></h2>

<div class="clearfix"></div>



</div>
<div class="x_content">


<div class="col-md-12" >
<div class="title_right">
<div class="col-md-3 col-sm-3 col-xs-12 form-group pull-right top_search">
<!--<?php //echo $_POST['aranan']; ?>-->
<form action="" method="POST">
<div class="input-group">
<input type="date" id="first-name" required="required" name="aranan" class="form-control col-md-7 col-xs-12">
<span class="input-group-btn">
<button class="btn btn-default" type="submit" name="arama">Ara!</button>
</span>
</div>
</form>
</div>
</div>
</div>


<?php

while($covidcek=$covidsor->fetch(PDO::FETCH_ASSOC)) { ?>


<table id="datatable-responsive" class="table table-striped table-bordered dt-responsive nowrap" cellspacing="0" width="100%">
<tr>
<td colspan="3" bgcolor="#CCFFCC"><div align="center"><strong>.:: DENETİM RAPORU ::.</strong></div> <div align="left"></div></td>
</tr>

<tr>
<td width="31%"><div align="left"><strong>Kayıt Tarihi</strong></div></td>
<td width="2%"><div align="center"><strong>:</strong></div></td>
<td width="67%"><div align="left"><strong><?php echo $covidcek['kayit_tarihi'];?></strong></div></td>
</tr>


<tr>
<td width="31%"><div align="left"><strong>Evde Ziyaret Edilen Hasta Sayısı</strong></div></td>
<td width="2%"><div align="center"><strong>:</strong></div></td>
<td width="67%"><div align="left"><strong><?php echo $covidcek['ev_ziyareti_yapilan_hasta_sayisi'];?></strong></div></td>
</tr>


<tr>
<td><div align="left"><strong>İzolasyona Uymayan Hasta Sayısı <br>(Adreste Bulunmayan Hasta Sayısı)</strong></div></td>
<td><div align="center"><strong>:</strong></div></td>
<td><div align="left"><?php echo $covidcek['izolasyona_uymayan_hasta_sayisi'];?></div></td>
</tr>

<tr>
<td><div align="left"><strong>Talepler</strong></div></td>
<td><div align="center"><strong>:</strong></div></td>
<td><div align="left"><strong><?php echo $covidcek['talepler'];?></strong></div></td>
</tr>


<tr>
<td><div align="left"><strong>Yanlış İletişim Bilgileri</strong></div></td>
<td><div align="center"><strong>:</strong></div></td>
<td><div align="left"><strong><?php echo $covidcek['yanlis_iletisim_bilgileri'];?></strong></div></td>
</tr>

<tr>
<td><div align="left"><strong>Şikayetler</strong></div></td>
<td><div align="center"><strong>:</strong></div></td>
<td><div style="text-align: justify;" align="left"><strong><?php echo $covidcek['sikayet'];?></strong></div></td>
</tr>



<?php } ?>










<tr>
<td colspan="3" align="center"><hr align="center" size="3" noshade="noshade" /> </td>
</tr>
<tr>
<td colspan="3"><div align="center">*** Bu sorgulama bilgi amaçlıdır. ***</div></td>
</tr>
<tr>
<td colspan="3"><div align="center">
<button class="btn btn-primary" onclick="window.print()" name="yazdir">Yazdır</button></a></td>
</div>
<div align="center"></div></td>
</tr>
</table>



</div>
</div>
</div>
</div>




</div>
</div>