Yok arkadaşlar beceremedim ya kodları buraya atayım yardımcı olmak isteyen düzenlerse sevinirim. Ücret isterseniz de sırf anlamak için uygun bir şey verebilirim
Araçların Gösterildiği Kod Dizimi;
<?php
$page = 'araclar';
require 'header.php';
?>
<!-- ============================================================== -->
<!-- end navbar -->
<!-- ============================================================== -->
<!-- ============================================================== -->
<!-- left sidebar -->
<!-- ============================================================== -->
<?php require 'sidebar.php'; ?>
<!-- ============================================================== -->
<!-- end left sidebar -->
<!-- ============================================================== -->
<!-- ============================================================== -->
<!-- wrapper -->
<!-- ============================================================== -->
<div class="dashboard-wrapper">
<div class="container-fluid dashboard-content">
<div class="row">
<div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
<!-- ============================================================== -->
<!-- hoverable table -->
<!-- ============================================================== -->
<div class="card">
<!-- ============================================================== -->
<!--Araç Ekleme Alert-->
<?php if ($_GET['aracekledurum']=="OK") { ?>
<div class="alert alert-success alert-dismissible fade show" role="alert">
<center><strong style="font-size:15px;">Araç Başarılı Bir Şekilde Eklendi!<button style="float: right;" type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">X</button></strong></center>
</div>
<?php } if ($_GET['aracekledurum']=="NO") { ?>
<div class="alert alert-danger alert-dismissible fade show" role="alert">
<center><strong style="font-size:15px;">Araç Ekleme Başarısız!!!<button style="float: right;" type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">X</button></strong></center>
</div>
<?php } ?>
<!-- ============================================================== -->
<!--Araç Güncelleme Alert-->
<?php if ($_GET['aracgunceldurum']=="OK") { ?>
<div class="alert alert-success alert-dismissible fade show" role="alert">
<center><strong style="font-size:15px;">Araç Başarılı Bir Şekilde Güncellendi!<button style="float: right;" type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">X</button></strong></center>
</div>
<?php } if ($_GET['aracgunceldurum']=="NO") { ?>
<div class="alert alert-danger alert-dismissible fade show" role="alert">
<center><strong style="font-size:15px;">Güncelleme Başarısız!!!<button style="float: right;" type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">X</button></strong></center>
</div>
<?php } ?>
<!-- ============================================================== -->
<!--Araç Silme Alert-->
<?php if ($_GET['aracsildurum']=="OK") { ?>
<div class="alert alert-success alert-dismissible fade show" role="alert">
<center><strong style="font-size:15px;">Silme Başarılı<button style="float: right;" type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">X</button></strong></center>
</div>
<?php } if ($_GET['aracsildurum']=="NO") { ?>
<div class="alert alert-danger alert-dismissible fade show" role="alert">
<center><strong style="font-size:15px;">Silme Başarısız!!!<button style="float: right;" type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">X</button></strong></center>
</div>
<?php } ?>
<center><h5 class="card-header">Araç Envanteri
<?php
if ($yetki == 'q' OR $yetki == 'w' OR $yetki == 'e' OR $yetki == 'r' OR $yetki == 't' OR $yetki == 'y') {
}elseif ($yetki == 'admin') {
?>
<a rel="nofollow noreferrer ugc" href="aracekle.php"><button style="float:right;" class="btn btn-success">Araç Ekle</button></a>
<?php
}
?>
</h5></center>
<div class="table-responsive">
<table class="table table-hover">
<thead>
<tr>
<th scope="col">#</th>
<th scope="col">1</th>
<th scope="col">2</th>
<th scope="col">3</th>
<th scope="col">4</th>
<th scope="col">5</th>
<th scope="col">6</th>
<th scope="col">7</th>
<th scope="col">8</th>
<th scope="col">9</th>
<th scope="col">1</th>
<th scope="col">1</th>
<th scope="col">1</th>
<th scope="col">1</th>
<th scope="col">1</th>
<th scope="col">1</th>
<th scope="col">1</th>
<?php
if ($yetki == 'q' OR $yetki == 'w' OR $yetki == 'e' OR $yetki == 'r' OR $yetki == 't' OR $yetki == 'y') {
}elseif ($yetki == 'admin') {
?>
<th scope="col"></th>
<th scope="col"></th>
<?php
}
?>
</tr>
</thead>
<?php
$rakam=0;
while ($araccek=$arac->fetch(PDO::FETCH_ASSOC)) { $rakam++;
?>
<tbody style="font-size:11px; font-family: Calibri;">
<tr>
<td><?php echo $rakam; ?></td>
<td><?php echo $araccek['q']; ?></td>
<td><?php echo $araccek['w']; ?></td>
<td><?php echo $araccek['e']; ?></td>
<td><?php echo $araccek['r']; ?></td>
<td><?php echo $araccek['t']; ?></td>
<td><?php echo $araccek['y']; ?></td>
<td><?php echo $araccek['u']; ?></td>
<td><?php echo $araccek['ı']; ?></td>
<td><?php echo $araccek['o']; ?></td>
<td><?php echo $araccek['p']; ?></td>
<td><?php echo $araccek['a']; ?></td>
<td><?php echo $araccek['s']; ?></td>
<td><?php echo $araccek['d']; ?></td>
<td><?php echo $araccek['f']; ?></td>
<td><?php echo $araccek['g']; ?></td>
<td><?php echo $araccek['h']; ?></td>
<?php
if ($yetki == '1' OR $yetki == '2' OR $yetki == '3' OR $yetki == '4' OR $yetki == '5' OR $yetki == '6') {
}elseif ($yetki == 'admin') {
?>
<td><a rel="nofollow noreferrer ugc" href="aracduzenle.php?id=<?php echo $araccek['id'] ?>"><button style="font-size: 1px; float: right; border-radius: 15px;" class="btn btn-success"><i style="font-size:10px;" class="fas fa-edit"></i></button></a></td>
<td>
<form action="islem/islem.php" method="POST">
<input type="hidden" name="id" value="<?php echo $araccek['id'] ?>">
<button name="aracsil" style="font-size: 1px; border-radius: 15px;" class="btn btn-danger"><i style="font-size:10px;" class="fas fa-trash"></i></button>
</form>
</td>
<?php
}
?>
</tr>
<?php } ?>
</tbody>
</table><br>
</div>
</div>
<!-- ============================================================== -->
<!-- end hoverable table -->
<!-- ============================================================== -->
</div>
</div>
</div>
</div>
<?php require 'footer.php' ?>Veritabanı Bağlantısı:
<?php
try {
$db = new PDO('mysql:host=localhost;dbname=akmasterenvanter;charset=utf8', 'akmaster', '');
} catch (PDOException $e) {
print "Hata!: " . $e-> getMessage(). "<br/>";
die();
}
/* Ayarlar */
$ayar=$db->prepare("SELECT * from ayar WHERE id=?");
$ayar->execute(array(1));
$ayarcek=$ayar->fetch(PDO::FETCH_ASSOC);
/* Araçlar */
$arac=$db->prepare("SELECT * from araclar");
$arac->execute();
/* Kullanıcılar */
$kullanici=$db->prepare("SELECT * from kullanici");
$kullanici->execute();
$kullanicicek=$kullanici->fetch(PDO::FETCH_ASSOC);
$yetki=$kullanicicek['birimyetki'];
?>Dediğim gibi ücret isterseniz de uygun bir şey talep edin ki sonuçta öğrenmek için yapıyorum bunu.
Şimdiden teşekkür ederim.