PHP Dosya Yöneticisi

<?php

if(isset($_GET['sil_id'])){

$delete = $db->exec("DELETE FROM urun WHERE id = '{$_GET['sil_id']}' LIMIT 1");

$delete = $db->exec("DELETE FROM urun_kategori WHERE urun_id = '{$_GET['sil_id']}' ");

$delete = $db->exec("DELETE FROM urun_renk WHERE urun_id = '{$_GET['sil_id']}'");

$delete = $db->exec("DELETE FROM urun_img WHERE urun_id = '{$_GET['sil_id']}'");

$delete = $db->exec("DELETE FROM vitrin_urun WHERE urun_id = '{$_GET['sil_id']}'");

$query = $db->query("SELECT * FROM urun_secenek WHERE urun_id = '{$_GET['sil_id']}' ", PDO::FETCH_ASSOC);

if($query->rowCount()){

foreach( $query as $row ){

$delete = $db->exec("DELETE FROM urun_secenek_alt WHERE urun_secenek_id = '{$row['id']}'");

$delete = $db->exec("DELETE FROM urun_secenek WHERE id = '{$row['id']}'");

}

echo b();

}

$sorgusay = $db->prepare("SELECT count(id) FROM urun");

$sorgusay->execute();

$say = $sorgusay->fetchColumn();

$top_sayfa = $say;

$page      = $_GET['no'];

$limit     = 10;

$page_url  = $sayfa.'/';

$baslangic = ($page * $limit) - $limit;

<h4 class="content-title mb-0 my-auto">Ürünler</h4><span class="text-muted mt-1 tx-13 ml-2 mb-0">/ Listele</span>

</div>

</div>

</div>

</form>

<thead>

<th class="border-bottom-0">Fotoğraf </th>

<th class="border-bottom-0">Fiyatı </th>

<th class="border-bottom-0">İşlem</th>

</tr>

</thead>

<tbody>

<?php

if($_POST){

$query = $db->query("SELECT * FROM urun WHERE baslik LIKE '%{$_POST['ara']}%' OR barkod LIKE '%{$_POST['ara']}%' ", PDO::FETCH_ASSOC);

}else{

$query = $db->query("SELECT * FROM urun LIMIT {$baslangic},{$limit}", PDO::FETCH_ASSOC);

}

if($query->rowCount()){

foreach( $query as $row ){

$img = $db->query("SELECT * FROM urun_img WHERE urun_id = '{$row['id']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);

echo '

<tr>

<td>'.$row['baslik'].'</td>

<td>'.fiyat($row['fiyat']).' TL</td>

<td><a href="'.$site.'urun/'.$row['sef'].'/">Ürüne gitmek için tıklayın...</a></td>

<td>

<a href="urun-kopyala/duzenle/'.$row['id'].'" data-toggle="tooltip" data-original-title="Düzenle">Kopyala</a>

</td>

</tr>

}

}else{

echo '<tr><td colspan="6"><center><h2>Ürün bulunamadı.</h2></center></td></tr>';

}

</tbody>

</table>

</div>

<?php Sayfala($top_sayfa,$page,$limit,$page_url); ?>

</ul>

</nav>

</div>

İptal

📁 PHP Dosya Yöneticisi

📝 urunler.php

📝 urunler.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)