Tiny File Manager

Back Back Up Advanced Editor

<?php

include('config/dbcon.php');
include('authentication.php');
//session_start();

include('include/header.php');
?>

<div class="container-fluid px-4">
    
       <div class="row mt-4">
        <div class="col-md-12">
        <?php include('message.php'); ?>
         <div class="card">
                <div class="card-header">
                    <h4>Edit Category<a href="category-view.php" class="btn btn-danger float-end">Back</a></h4>
                     
                </div>
                <div class="card-body">

<?php
                 if (isset($_GET['id']) && filter_var($_GET['id'], FILTER_VALIDATE_INT)) {
                    $category_id = mysqli_real_escape_string($con, $_GET['id']);

$stmt = $conn->prepare("SELECT * FROM categories WHERE id = ? LIMIT 1"); 
                    $stmt->bind_param("i", $category_id);
                    $stmt->execute();
                    $result = $stmt->get_result();
                    $stmt->close();

if(mysqli_num_rows($result) >0 )
                    {
                        $row = mysqli_fetch_array($result);
                      ?>
                      
                      
                    
                <form action="code.php" method="POST">
                
                            <input type="hidden" name="category_id" value="<?= $row['id']; ?>">
                            <div class="row">
                                <div class="col-md-6 md-3">
                                  <label for="">Name</label>
                                    <input type="text" name="name" value="<?= $row['name']; ?>" required class="form-control">
                                </div>
                               
                                <div class="col-md-12 md-3">
                                  <label for="">Description</label>
                                    <textarea  name="description" required class="form-control" rows="4"><?= $row['description']; ?></textarea>
                                </div>
                                <div class="col-md-6 md-3">
                                    <label for="">Category Type</label>
                                    <?php 
                                        $category = "SELECT distinct category_type from categories WHERE status ='0'";
                                        $category_run = mysqli_query($con, $category);

if(mysqli_num_rows($category_run) > 0 )
                                        {
                                            ?>
                                            <select name="category_type" required class="form-control">
                                                <option value="">--Select Category--</option>
                                                <?php 
                                                foreach($category_run as $categoryitem)
                                                { 
                                                ?>
                                                <option value="<?=$categoryitem['category_type']; ?>" <?= $categoryitem['category_type']==$row['category_type'] ? 'selected':''?> >
                                                     <?=$categoryitem['category_type']; ?>
                                                </option>
                                                <?php
                                                } 
                                                ?>

</select>
                                           <?php     
                                        }else{

}
                                    ?>
                                   
                                </div>
                                <div class="col-md-6 md-3">
                                  <label for="">Meta Title</label>
                                    <input type="text" name="meta_title" value="<?= $row['meta_title']; ?>" max="191" required class="form-control">
                                </div>
                                <div class="col-md-6 md-3">
                                  <label for="">Meta Description</label>
                                    <textarea  name="meta_description" required class="form-control" rows="4"><?= $row['meta_description']; ?></textarea>
                                </div>
                                <div class="col-md-6 md-3">
                                  <label for="">Meta Keyword</label>
                                    <textarea  name="meta_keyword" required class="form-control" rows="4"><?= $row['meta_keyword']; ?></textarea>
                                </div>
                                 
                                <div class="col-md-6 md-3">
                                    <label for="Status">Navbar Status</label>
                                        <input type="checkbox" name="navbar_status" <?= $row['navbar_status'] == '1' ? 'checked': ''  ?>  width="70px" height="70px" />
                                        Checked = Hidden In Menubar, Unchecked = Visible In Menubar
                                </div>
                                <div class="col-md-6 md-3">
                                    <label for="Status">Status</label>
                                        <input type="checkbox" name="status" <?= $row['status'] == '1' ? 'checked': ''  ?>   width="70px" height="70px" />
                                        Checked = Hidden, Unchecked = Visible
                                </div>
                                <div class="col-md-6 md-3">
                                       <button type="submit" class="btn btn-primary" name="category_update">Update Category</button> 
                                </div>
                                
                            </div>
                </form>

<?php

}else{
                    ?>

<h4>No Record Found</h4>

<?php
                        
                    }

}

</div>
            </div>

</div>

</div>
</div>

<?php
include('include/footer.php');

include('include/script.php');