wobblies

Back Back Up Advanced Editor

<?php 
include 'head.php';
include 'header.php';
?>

<body class="skin-default fixed-layout">
    <div id="main-wrapper">
        <?php 
        include 'sidebar.php';
        if (isset($message)) {
            foreach ($message as $message) {
                echo '<div class="message"><span>' . $message . '</span> <i class="fas fa-times" onclick="this. parentElement.style.display = `none`;"></i> </div>';
            };
        };
        ?>
        
        <div class="page-wrapper">
            <div class="container-fluid">
                <?php include 'nav.php'; ?>
                <div class="container">
                   
                    
            <div class=""> 
            <?php
// Assuming you have a database connection established
if (isset($_GET['blog_id'])) {
    $blog_id = $_GET['blog_id'];

// Fetch blog data from the database based on the provided blog_id
    $query = "SELECT * FROM blog WHERE blog_id = ?";
    
    if ($stmt = $conn->prepare($query)) {
        $stmt->bind_param("s", $blog_id);
        
        if ($stmt->execute()) {
            $result = $stmt->get_result();

// Check if there are rows in the result set
            if ($result->num_rows > 0) {
                $row = $result->fetch_assoc();
                $categoriesArray = array($row['categories']);
            
?>

<div class="text-right my-4">
                        <a href="#" data-toggle="modal" data-target="#myModal" class="btn btn-info "><i class="bi bi-pencil-square"></i> Edit</a>
            
                        <a href="blog-controller.php?delete=<?php echo $row['id']; ?>" class="btn btn-danger" onclick="return confirm('are you sure you want to delete this?');"><i class="bi bi-trash3-fill"></i> Delete</a>
                </div>
                <div class=" card">
                    <div class=" card-header">
                        <h3 class="">Manage Blog Details</h3>
                    </div> 
                    <div class="card-body">
                        <div class="row">
                            <div class="col-md-6">
                                <img src="../blog/<?php echo $row['blog_img']; ?>" class="img-fluid" height="700" alt="">
                            </div>
                            
                            <div class="col-md-3">
                                <h2>BLOG NAME:</h2>
                                <p><?php echo html_entity_decode($row['title']); ?></p>
                            </div>

<h2>Categories:</h2>
                                <p><?php echo html_entity_decode($row['categories']); ?></p>

<h2>Description:</h2>
                                <p><?php echo html_entity_decode($row['description']); ?></p>
                            </div>
                     
                    </div>  
                </div>                            
            </div>

<div class="modal fade" id="myModal">
            <div class="modal-dialog modal-lg">
              <div class="modal-content">
              
                
                <div class="modal-header">
                  <h4 class="modal-title">Manage Services</h4>
                  <button type="button" class="close" data-dismiss="modal">&times;</button>
                </div>
                
                
                <div class="modal-body">
                  <form action="manage-blog-process.php" method="post">

</div>
                
                  
                  <div class="form-group">
                      <input type="text" name="sub_title" placeholder="Enter Blog Sub title" class="form-control my-2  " value="<?php echo $row['sub_title']; ?>" required>

</div>
                  
                  <div class="form-group">
                      <select class="form-select ps-4 mb-1" aria-label="Default select example" name="categories">
                       
                        <?php
                        // Loop through the categoriesArray and generate options
                        foreach ($categoriesArray as $category) {
                            // Check if the option value matches the one retrieved from the database
                            $selected = ($category == $selectedCategoryFromDatabase) ? 'selected' : '';

echo "<option class='option-item' value='$category' $selected>$category</option>";
                        }
                        ?>
                         <option class="option-item " value="Wall art" class="">Wall art</option>
                        <option class="option-item " value="Game" class="">Game</option>
                        <option class="option-item " value="Character" class="">Character</option>
                        <option class="option-item " value="Animal" class="">Animal</option>
                        <option class="option-item " value="Robot" class="">Robot</option>
                        <option class="option-item " value="Fashion" class="">Fashion</option>
                        <option class="option-item " value="Wild Life" class="">Wild Life</option>
                      </select>
                  </div>

<div class="form-group">
                      <input type="decimal" name="tags" placeholder="Enter  Blog Tags" class="form-control my-2  " value="<?php echo $row['tags']; ?>" required>

</div>
                  
                  <div class="form-group">
                    <input type="file" name="blog_img" accept="image/png, image/jpeg, image/jpg" class="form-control-file box" value="<?php echo $row['blog_img']; ?>" >
                  </div>
                  <div class="form-group">
                    <textarea name="description" id="" cols="30" rows="15" class="form-control my-2  "><?php echo $row['description']; ?></textarea>
                  </div>

<div class="modal-footer">
                <button type="submit" name="aaddblogUpdate"  class="btn btn-success bg-warn">Update</button>
                  <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                </div>
                </form>
              </div>
            </div>
        </div> 
        </div> 
      </div>
    </section>
            </div>
          </div>
        </div>
        <?php } else {
                echo "No blog found for the provided blog_id.";
            }

// Close the result set
            $result->close();
        } else {
            echo "Error executing the query: " . $stmt->error;
        }

// Close the prepared statement
        $stmt->close();
    } else {
        echo "Error preparing the query: " . $conn->error;
    }
} else {
    echo "No blog_id provided in the URL.";
}
 ?>
    <?php
    include 'footer.php';
    ?>