File: //home2/yenicep/public_html/policeler.php
<? include 'functions-development.php';?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>YENİCEP POLİÇELER</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.4/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
</head>
<body>
<style>
td,tr,table,th{
border-collapse: collapse;
padding:2px 15px;
text-align:center;
font-size:11px;
}
</style>
<div class="row" style="margin:30px 0;">
<div class="container-fuild">
<div class="col-12" >
<table class="table-striped table2">
<tr>
<th>Poliçe No</th>
<th>Transaction Id</th>
<th>Cihaz</th>
<th>Tutar</th>
<th>Ad Soyad</th>
<th>TC</th>
<th>Telefon</th>
<th>Email</th>
<th>Bayi</th>
<th>Baş Tarihi</th>
<th>Bitiş Tarihi</th>
<th>Ödeme</th>
<th>Aktiflik</th>
</tr>
<?
$s = "select * from kaskolu_cihazlar order by id desc ";
$q = $func->query($s);
$row= $q->fetchAll();
foreach($row as $kasko){
?>
<tr>
<td><?=$kasko->hdi_policeNo?></td>
<td><?=$kasko->TransactionId?></td>
<td><?=$func->markagetir($kasko->marka)?> <?=$func->modelgetir($kasko->model)?> <?=$func->hafizagetir($kasko->hafiza)?> <?=$func->hafizaturgetir($kasko->hafiza)?> <br> #<?=$kasko->imei?></td>
<td><?=trfiyat($kasko->tutar)?></td>
<td><?=$kasko->m_ad?> <?=$kasko->m_soyad?></td>
<td><?=$kasko->m_tc?></td>
<td><?=$kasko->m_gsm?></td>
<td><?=$kasko->m_eposta?></td>
<td><?=$func->policebayigetir($kasko->bayi_id)?></td>
<td><?=$kasko->basTar?></td>
<td><?=$kasko->bitTar?></td>
<td>
<? if($kasko->police_onay==1){ echo "<span style='color:green;font-weight:bold'>BAŞARILI</span>"; }else{ echo "<span style='color:red;font-weight:bold'>BAŞARISIZ<br>".$kasko->odeme_return."</span>";}?>
</td>
<td>
<? if($kasko->policeno_aktiflik==0){ echo "<span style='color:red;font-weight:bold'>PASİF</span>"; }else{ echo "<span style='color:green;font-weight:bold'>AKTİF</span>";}?>
</td>
</tr>
<?}?>
</table>
</div>
</div>
</div>
</body>
</html>