PHP Dosya Yöneticisi

<?php
if(isset($_GET['sil_id'])){
    $delete = $db->exec("DELETE FROM vitrin_urun1 WHERE urun_id = '{$_GET['sil_id']}' LIMIT 1");
    echo b();
}

if($_POST AND !isset($_POST['siralama'])){
	
    $islem = $db->prepare("INSERT INTO vitrin_urun1 SET vitrin_id = ?, urun_id = ?, sira = ?");
    $islem = $islem->execute(array($_GET['vitrin_id'],$_POST['urun_id'],999));

if($islem){
        echo b();
    }else{
        echo h();
    }

}

if($_POST AND isset($_POST['siralama'])){

$siralama = str_replace('\"', '"', $_POST['siralama']);
	$data = json_decode($siralama);
	$readbleArray = parseJsonArray($data);
	$i = 1;
	foreach($readbleArray as $row){
		$islem = $db->prepare("UPDATE vitrin_urun1 SET sira = ? WHERE id = ?");
		$islem = $islem->execute(array($i,$row['id']));
		$i++;
	}
	echo b();

}
?>
<div class="breadcrumb-header justify-content-between">
	<div class="my-auto">
		<div class="d-flex">
			<h4 class="content-title mb-0 my-auto">Tasarla Vitrin Ürün</h4><span class="text-muted mt-1 tx-13 ml-2 mb-0">/ Ekle - Düzenle</span>
		</div>
	</div>
</div>

<div class="row">
	<div class="col-md-6">
		<div class="card">
			<div class="card-header pb-0">
				<div class="d-flex justify-content-between">
					<h4 class="card-title mg-b-0">Eklenen Veriler</h4>
				</div>
			</div>
			<div class="card-body">
				<div class="row">
					<div class="col-md-12">
						<?php 
							$cek = $db->query("SELECT * FROM vitrin_urun1 WHERE vitrin_id = '{$_GET['vitrin_id']}' ORDER BY sira ASC", PDO::FETCH_ASSOC);
							if($cek->rowCount()){
								?>
								<form action="" method="post">
									<div class="dd" id="nestable" style="float: left;width: 100%">
							            <ol class="dd-list">
							                <?php
										        foreach ($cek as $ak) {
										          $u = $db->query("SELECT * FROM turun WHERE id = '{$ak['urun_id']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
									              echo '<li data-id="'.$ak['id'].'" class="dd-item">
									                      <div class="dd-handle">
									                      	#'.$u['id'].' - '.$u['baslik'].'
									                      </div>
									                      	<a href="'.$sayfa.'/'.$_GET['vitrin_id'].'/sil/'.$u['id'].'" class="sil" style="float:right;color:red">Sil</span></a>
									                    </li>';
									            }
									        ?>
							            </ol>
							        </div>
							        <input type="hidden" name="siralama" id="nestable-output">
									<div class="col-md-12">
										<button type="submit" class="btn btn-success" style="float: right;">Kaydet <i class="fa fa-check"></i></button>
									</div>
								</form>
								<?php
							}else{
		                      	echo '<center><h3>Veri Bulunamadı.</h3></center>';
		                    }
						?>
					</div>
				</div>
			</div>
		</div>
	</div>
	<div class="col-md-6">
		<div class="card">
			<div class="card-body">
				<form action="" method="post">
					<div class="col-lg-12 col-md-12">
						<div class="form-group row">
						  <label class="col-sm-3 form-label">Ürün Seçiniz</label>
						  <div class="col-sm-9">
							<select class="form-control select2" name="urun_id" required="">
								<?php
									$cek = $db->query("SELECT * FROM turun", PDO::FETCH_ASSOC);
									if($cek->rowCount()){
										foreach( $cek as $c ){
											echo '<option value="'.$c['id'].'">#'.$c['id'].' - '.$c['baslik'].'</option>';
										}
									}
								?>
							</select>
						  </div>
						</div>
			            <div class="row">
							<div class="col-md-12">
								<div class="form-group"><center><button type="submit" class="btn btn-success">Değişiklikleri Kaydet</button></center></div>
							</div>
						</div>
					</div>
				</form>
			</div>
		</div>
	</div>
</div>

$('#nestable').nestable({
        group: 1
    }).on('change', updateOutput);

updateOutput($('#nestable').data('output', $('#nestable-output')));

});
</script>

<script src="assets/plugins/time-picker/jquery.timepicker.js"></script>
<script src="assets/plugins/time-picker/toggles.min.js"></script>

<script src="assets/plugins/date-picker/date-picker.js"></script>
<script src="assets/plugins/date-picker/jquery-ui.js"></script>
<script src="assets/plugins/input-mask/jquery.maskedinput.js"></script>

İptal

📁 PHP Dosya Yöneticisi

📝 vitrin-urun-ekle1.php

📝 vitrin-urun-ekle1.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)