Файловый менеджер - Редактировать - /home/itsrcicq/formfilling.xyz/admin/sources/game_categories.php
Ðазад
<?php $b = (isset($_GET['b'])) ? protect($_GET['b']) : ""; $btnsubmit = isset($_POST['btn_submit']) ? protect($_POST['btn_submit']) : ""; if($btnsubmit == "Add") { $category_name = addslashes($_POST["category_name"]); $description = addslashes($_POST["description"]); $slug = strtolower(str_replace(' ', '-', $category_name)); if(empty($category_name)) { echo error("Please enter category name"); } $check_category = $db->query("SELECT * FROM game_categories WHERE name='$category_name'"); if($check_category && $check_category->num_rows > 0) { echo error("Category is already in database"); }else { $ins = $db->query("INSERT INTO game_categories(name, slug, description) VALUES('$category_name', '$slug', '$description')"); if($ins) { echo success("Category was added"); }else { echo error("Something went wrong. please try again"); } } }else if($btnsubmit == "Update") { $id = protect($_POST["category_id"]); $category_name = addslashes($_POST["category_name"]); $description = addslashes($_POST["description"]); $slug = strtolower(str_replace(' ', '-', $_POST["slug"])); if(empty($category_name)) { echo error("Please enter category name"); } $upd = $db->query("UPDATE game_categories SET name='$category_name', slug='$slug', description='$description' WHERE id='$id'"); if($upd) { echo success("Category has been updated."); }else { echo error("Something went wrong. please try again"); } }else if($b == "delete") { $id = protect($_GET['id']); $query = $db->query("SELECT * FROM game_categories WHERE id='$id'"); if($query->num_rows==0) { header("Location: ./?a=game-categories"); }else { $delete = $db->query("DELETE FROM game_categories WHERE id='$id'"); header("Refresh:0"); } } ?> <br> <br> <div class="breadcrumbs"> <div class="col-sm-4"> <div class="page-header float-left"> <div class="page-title"> <h1>Game Categories</h1> </div> </div> </div> <div class="col-sm-8"> <div class="page-header float-right"> <div class="page-title"> <span class="pull-right" style="margin-top:5px;margin-bottom:-10px;"> </span> </div> </div> </div> </div> <div class="content mt-3"> <?php echo warn('This is best tool to categorized your games. You can create category and Its can filter all games automatically. You have not need to worry about categorizing each games. Make sure to store category images under assets/img/.. folder. We have created few category by default.');?> <div class='col-md-8'> <div class="card"> <div class="card-body"> <?php $categories = $db->query("SELECT * FROM game_categories ORDER BY name ASC"); if($categories && $categories->num_rows > 0) { while($data = $categories->fetch_assoc()) { $count_categories = $db->query("SELECT COUNT(*) FROM games WHERE Category LIKE '%$data[name]%'"); $total_categories = $count_categories->fetch_row()[0]; ?> <div class='border p-3 d-inline-block w-100 mb-2'> <div class='col-lg-9 col-md-8 col-sm-7'><img src="/assets/img/<?=$data["slug"];?>.png" style="width:20px;"> <?=$data["name"];?> <a class="text-danger" style="font-size:12px;" target="_blank" href="/category/<?php echo $data['slug']; ?>"><i class="fa fa-external-link-square"></i></a> <span class='bg-primary text-white p-1 ml-2 rounded-circle' style='font-size:10px'><?=$total_categories;?></span></div> <div class='col-lg-3 col-md-4 col-sm-5'> <a href="#" title="Edit"><span class="badge badge-primary" data-toggle="modal" data-target="#editGameModal<?=$data['id'];?>"><i class="fa fa-pencil"></i> Edit</span></a> <a href="./?a=game-categories&b=delete&id=<?=$data['id'];?>" title="Delete"><span class="badge badge-danger" onclick="if(!confirm('Are you sure you want to delete this category ?')) { return false; }else{ return true;}"><i class="fa fa-trash"></i> Delete</span></a> </div> <!-- Modal --> <div class="modal fade mt-5" id="editGameModal<?=$data['id'];?>" tabindex="-1" role="dialog" aria-labelledby="editGameModalLabel" aria-hidden="true"> <div class="modal-dialog" role="document"> <form action="" method="POST"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title" id="editGameLabel">Edit Category</h5> </div> <div class="modal-body"> <div class="form-group"> <label>Category Name</label> <input type='text' name='category_name' value='<?=$data['name'];?>' class='form-control'/> </div> <div class="form-group"> <label>Slug</label> <input type='text' name='slug' value='<?=$data['slug'];?>' class='form-control'/> </div> <div class="form-group"> <label>Description</label> <input type='text' name='description' value='<?=$data['description'];?>' placeholder="Description (Optional)" class='form-control'/> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button> <input type='hidden' name='category_id' value="<?=$data["id"];?>"/> <button type="submit" class="btn btn-primary" name="btn_submit" value="Update">Save changes</button> </div> </div> </form> </div> </div> </div> <?php } }else { ?> <div>No records found</div> <?php } ?> </div> <div class="card-body"> </div> </div> </div> <div class='col-md-4'> <div class="card"> <div class="card-body"> <h4 class='mb-3'>Add New Category</h4> <form action="" method="POST"> <div class='form-group'> <input type='text' name='category_name' class='form-control' placeholder="Category Name"/> </div> <div class='form-group'> <input type='text' name='description' class='form-control' placeholder="Description (Optional)"/> </div> <div class='form-group'> <button type="submit" class="btn btn-primary btn-block" name="btn_submit" value="Add">Add</button> </div> </form> </div> </div> </div> </div>
| ver. 1.4 |
Github
|
.
| PHP 8.1.32 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0.01 |
proxy
|
phpinfo
|
ÐаÑтройка