Ultra File Manager

Edit: /home/u523034047/domains/badshacric.com/public_html/admin/add-blog.php

<?php
include('conn.php');
session_start();

if (!isset($_SESSION['username'])) {
    header('location:index.php');
    exit;
}

$message = "";

// =====================================
// ADD BLOG
// =====================================
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add'])) {

$title   = trim($_POST['title'] ?? '');
    $slug    = trim($_POST['slug'] ?? '') ?: strtolower(preg_replace('/[^a-z0-9-]+/', '-', $title));
    $summary = $_POST['summary'] ?? '';
    $content = $_POST['content'] ?? '';
    $author  = $_POST['author'] ?? 'PlayBro';
    $tags    = $_POST['tags'] ?? '';
    $status  = $_POST['status'] ?? 'published';

// Image upload
    $featured_image = null;

if (!empty($_FILES['featured_image']['name'])) {
        $filename = time() . "_" . basename($_FILES['featured_image']['name']);
        $path = "uploads/" . $filename;

if (move_uploaded_file($_FILES['featured_image']['tmp_name'], $path)) {
            $featured_image = $filename;
        }
    }

// Insert using MySQLi
    $stmt = $conn->prepare("
        INSERT INTO posts (title, slug, summary, content, author, tags, featured_image, status)
        VALUES (?, ?, ?, ?, ?, ?, ?, ?)
    ");

$stmt->bind_param(
        "ssssssss",
        $title, $slug, $summary, $content, $author, $tags, $featured_image, $status
    );

if ($stmt->execute()) {
        echo "<script>alert('Blog Added Successfully!'); window.location='add-blog.php';</script>";
        exit;
    } else {
        echo "<script>alert('Failed to add blog!');</script>";
    }

$stmt->close();
}

// =====================================
// DELETE BLOG
// =====================================
if (isset($_POST['del'])) {

$id = (int)$_POST['id'];

// Step 1: Fetch image name
    $stmt = $conn->prepare("SELECT featured_image FROM posts WHERE id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $stmt->bind_result($image);
    $stmt->fetch();
    $stmt->close();

// Step 2: Delete blog
    $stmt = $conn->prepare("DELETE FROM posts WHERE id = ?");
    $stmt->bind_param("i", $id);

if ($stmt->execute()) {

// Step 3: Delete image file
        if (!empty($image) && file_exists("uploads/" . $image)) {
            unlink("uploads/" . $image);
        }

echo "<script>alert('Blog deleted successfully'); window.location.href='add-blog.php';</script>";
        exit;

} else {
        echo "<script>alert('Failed to delete blog');</script>";
    }

$stmt->close();
}

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
      <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>Admin</title>
    
    <link href="assets/css/bootstrap.css" rel="stylesheet" />
     
    <link href="assets/css/font-awesome.css" rel="stylesheet" />
        
    <link href="assets/css/custom.css" rel="stylesheet" />
     
   <link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' />
</head>
<body>
     
           
          
    <div id="wrapper">
         <div class="navbar navbar-inverse navbar-fixed-top">
           <?php include ('header.php');?>
        </div>
        
        <nav class="navbar-default navbar-side" role="navigation">
           <?php include ('menu.php');?>

</nav>
        
        <div id="page-wrapper" >
            <div id="page-inner">
              
                
          
           
  <?php if($message) echo "<p style='color:green'>$message</p>"; ?>
  <style>
body{
  background:linear-gradient(180deg,#071b34,#0a2a52);
  font-family:Arial, Helvetica, sans-serif;
}
.admin-wrap{
  max-width:900px;
  margin:30px auto;
  background:#0d2a4d;
  padding:25px;
  border-radius:14px;
  box-shadow:0 15px 40px rgba(0,0,0,.5);
}
.admin-wrap h2{
  color:#4da3ff;
  margin-bottom:20px;
  text-align:center;
}
.form-grid{
  display:grid;
  grid-template-columns:1fr 1fr;
  gap:16px;
}
.form-group{
  display:flex;
  flex-direction:column;
}
.form-group.full{
  grid-column:1 / -1;
}
.form-group label{
  font-size:14px;
  color:#c7d9ff;
  margin-bottom:6px;
}
.form-group input,
.form-group textarea,
.form-group select{
  padding:12px;
  background:#071b34;
  border:1px solid #1f4b7a;
  border-radius:8px;
  color:#fff;
  font-size:14px;
}
.form-group input::placeholder{
  color:#8fb7ff;
}
.form-group input:focus,
.form-group textarea:focus,
.form-group select:focus{
  border-color:#4da3ff;
  outline:none;
}
.submit-btn{
  margin-top:22px;
  padding:14px;
  width:100%;
  background:linear-gradient(45deg,#4da3ff,#1e6fd9);
  border:none;
  color:#fff;
  font-size:16px;
  font-weight:600;
  border-radius:50px;
  cursor:pointer;
  box-shadow:0 8px 20px rgba(77,163,255,.4);
}
.submit-btn:hover{
  transform:scale(1.03);
}
@media(max-width:768px){
  .form-grid{
    grid-template-columns:1fr;
  }
}
</style>

<div class="form-group full">
      <label>Title</label>
      <input name="title" placeholder="Enter blog title" required>
    </div>

<div class="form-group full">
      <label>Slug (optional)</label>
      <input name="slug" placeholder="auto-generated if empty">
    </div>

<div class="form-group full">
      <label>Summary</label>
      <textarea name="summary" rows="3"></textarea>
    </div>

<div class="form-group full">
      <label>Content (HTML allowed)</label>
      <textarea name="content" rows="8"></textarea>
    </div>

<div class="form-group">
      <label>Author</label>
      <input name="author" placeholder="PlayBro">
    </div>

<div class="form-group">
      <label>Tags (comma separated)</label>
      <input name="tags" placeholder="cricket, betting, casino">
    </div>

<div class="form-group">
      <label>Featured Image</label>
      <input type="file" name="featured_image" accept="image/*">
    </div>

<div class="form-group">
      <label>Status</label>
      <select name="status">
        <option value="published">Published</option>
        <option value="draft">Draft</option>
      </select>
    </div>

</div>

</form>

</div>        
    </div>
    <div class="panel panel-primary" data-collapsed="0">
            <div class="panel-heading">
                <div class="panel-title" >
                    <i class="entypo-plus-circled"></i>
                   Status
                </div>
            </div>
            <div class="panel-body"> 
            
                  <div style="overflow-x:auto;">
    <div class="col-lg-12 col-md-12">
        <div class="table-responsive">
            <table class="table">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>Image</th>
                        <th>Title</th>
                        <th>Slug</th>
                        <th>Action</th>
                    </tr>
                </thead>

<tbody>
                <?php
                    $sql = "SELECT id, title, slug, featured_image FROM posts ORDER BY id DESC";
                    $query = mysqli_query($conn, $sql);
                    $count = 1;

while ($row = mysqli_fetch_assoc($query)) {
                ?>
                    <tr class="info">
                        <td><?php echo $count++; ?></td>

<td>
                            <?php if ($row['featured_image']) { ?>
                                <img src="uploads/<?php echo $row['featured_image']; ?>" height="50" width="50">
                            <?php } else { ?>
                                <img src="https://via.placeholder.com/50" height="50" width="50">
                            <?php } ?>
                        </td>

<td>
                           <form method="POST" style="display:inline;">
    <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
    <button type="submit" name="del" class="btn btn-danger"
        onclick="return confirm('Are you sure?')">
        Delete
    </button>
</form>

<a href="edit-post.php?id=<?php echo $row['id']; ?>" class="btn btn-primary">
                                Edit
                            </a>
                        </td>
                    </tr>

<?php } ?>
                </tbody>

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

</div>
         </div>
                
                   
                    
                     
                    </div>        
    </div>
            </div>
            </div> 
            </div>
         
        </div>
    <div class="footer">
    <?php include ('footer.php');?>
        </div>

<script src="assets/js/jquery-1.10.2.js"></script>
      
    <script src="assets/js/bootstrap.min.js"></script>
      
    <script src="assets/js/custom.js"></script>
    
   
</body>
</html>

Ukuran: 9.8 KB