PHP Dosya Yöneticisi

<div class="grid grid-cols-1 pb-6">
                <div class="md:flex items-center justify-between px-[2px]">
                    <h4 class="text-[18px] font-medium text-gray-800 mb-sm-0 grow dark:text-gray-100 mb-2 md:mb-0">Satışlar</h4>
                    <nav class="flex" aria-label="Breadcrumb">
                        <ol class="inline-flex items-center space-x-1 ltr:md:space-x-3 rtl:md:space-x-0">
                            <li class="inline-flex items-center">
                                <a href="#" class="inline-flex items-center text-sm text-gray-800 hover:text-gray-900 dark:text-zinc-100 dark:hover:text-white">
                                    Sistem
                                </a>
                            </li>
                            <li>
                                <div class="flex items-center rtl:mr-2">
                                    <i class="font-semibold text-gray-600 align-middle far fa-angle-right text-13 rtl:rotate-180 dark:text-zinc-100"></i>
                                    <a href="#" class="text-sm font-medium text-gray-500 ltr:ml-2 rtl:mr-2 hover:text-gray-900 ltr:md:ml-2 rtl:md:mr-2 dark:text-gray-100 dark:hover:text-white">Tüm Satışlar</a>
                                </div>
                            </li>
                        </ol>
                    </nav>
                </div>
            </div>
            <div class="grid grid-cols-12 gap-6">
                <div class="col-span-12">
                    <div class="card dark:bg-zinc-800 dark:border-zinc-600">
                        <div class="relative overflow-x-auto card-body">
                            <table id="datatable" class="table w-full pt-4 text-gray-700 dark:text-zinc-100">
                                <thead>
                                    <tr>
                                        <th class="p-4 pr-8 border rtl:border-l-0  border-gray-50 dark:border-zinc-600">ID</th>
                                        <th class="p-4 pr-8 border rtl:border-l-0  border-gray-50 dark:border-zinc-600">Kullanıcı UID</th>
                                        <th class="p-4 pr-8 border rtl:border-l-0  border-gray-50 dark:border-zinc-600">Tarih</th>
                                        <th class="p-4 pr-8 border rtl:border-l-0  border-gray-50 dark:border-zinc-600">Kredi</th>
                                        <th class="p-4 pr-8 border rtl:border-l-0  border-gray-50 dark:border-zinc-600">Kazanç</th>
                                    </tr>
                                </thead>
                                <tbody>
                                <?php
                                  header('Content-Type: application/json');
                                  $query = "SELECT tarih,kredi,fiyat,id,uid FROM satislar";
                                  $result = $conn->query($query);

$data = [];

if ($result->num_rows > 0) {
                                      while ($row = $result->fetch_assoc()) {
                                          $data[] = [
                                            'tarih' => $row['tarih'],
                                            'uid' => $row['uid'],
                                            'kredi' => $row['kredi'],
                                            'fiyat' => $row['fiyat'],
                                            'id' => $row['id'],
                                          ];

echo '
                                          <tr id="'.$row["id"].'">

<td class="p-4 pr-8 border border-t-0 rtl:border-l-0 border-gray-50 dark:border-zinc-600">'.date("d.m.Y",strtotime($row["tarih"])).'</td>
                                              <td class="p-4 pr-8 border border-t-0 rtl:border-l-0 border-gray-50 dark:border-zinc-600">'.$row["kredi"].'</td>
                                              <td class="p-4 pr-8 border border-t-0 rtl:border-l-0 border-gray-50 dark:border-zinc-600">'.$row["fiyat"].' TL</td>
                                          </tr>
                                          ';
                                      }
                                  }

$yazdir = json_encode(['data' => $data]);
                                  $conn->close();
                                  ?>
                                </tbody>
                            </table>

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

<footer class="absolute bottom-0 left-0 right-0 px-5 py-5 bg-white border-t footer border-gray-50 dark:bg-zinc-700 dark:border-zinc-600 dark:text-gray-200">
                <div class="grid grid-cols-2 text-gray-500 dark:text-zinc-100">
                    <div class="grow">
                        &copy;
                        <script>
                            document.write(new Date().getFullYear());
                        </script> Minia
                    </div>
                    <div class="hidden md:inline-block text-end">Design & Develop by <a href="#" class="underline text-violet-500">Themesbrand</a></div>
                </div>
            </footer>
        </div>
    </div>
</div>

İptal

📁 PHP Dosya Yöneticisi

📝 satislar.php

📝 satislar.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)