TERMINAL FM // admin

EDITOR
/home/u917864144/domains/dtdesigner.in/public_html/admin/index_edit.php
<?php include ('header.php');

$id = $_GET['id'];
$query = "SELECT * FROM portfolio WHERE id = '$id' ";
$query_run = mysqli_query($con, $query);
$row = mysqli_fetch_array($query_run);


if (isset($_POST['submit'])) {
    $category_name = $_POST['category_name'];
    $graphic_category = $_POST['graphic_category'];

    if($graphic_category == ''){
        $graphic_category = '-';
    }else{
        $graphic_category = $_POST['graphic_category'];
    }




    $name = $_POST['name'];
    $description = $_POST['description'];

    $image_old = $_POST['image_old'];

    $image = $_FILES['image']['name'];
    $tmp_file = $_FILES['image']['tmp_name'];
    $targetPath = '../image/portfolio/' . $image;

    if ($image != '') {
        $update_image = $image;
    } else {
        $update_image = $image_old;
    }


    $query = "UPDATE `portfolio` SET `category_name`='$category_name', `graphic_category`= '$graphic_category', `name`= '$name', `description`='$description', `image`='$update_image' where id=$id";

    $query_run = mysqli_query($con, $query);

    if (move_uploaded_file($tmp_file, $targetPath)) {

        echo "<script> 
                    alert('Successfully Data Send');
                    document.location.href='index.php';
                </script>";
    } else {

        echo "<script> 
                    alert('Image does not send successfully');
                    document.location.href='index.php';
                </script>";
    }
}

?>

<!-- sa-app__body -->
<form action="" method="POST" enctype="multipart/form-data">
    <div id="top" class="sa-app__body">
        <div class="mx-sm-2 px-2 px-sm-3 px-xxl-4 pb-6">

            <div class="container container--max--xl">
                <div class="py-5">
                    <div class="row g-4 align-items-center">
                        <div class="col">
                            <h1 class="h3 m-0">Edit Portfolio</h1>
                        </div>

                    </div>
                </div>
                <div class="sa-entity-layout" data-sa-container-query="{&quot;920&quot;:&quot;sa-entity-layout--size--md&quot;,&quot;1100&quot;:&quot;sa-entity-layout--size--lg&quot;}">
                    <div class="sa-entity-layout__body">
                        <div class="sa-entity-layout__main">
                            <div class="card">
                                <div class="card-body p-5">

                                    <div class="row">
                                        <div class="mb-4 col">
                                            <input type="hidden" name="category_id" class="form-control" id="form-coupon/value" placeholder="Enter your category_id" value="<?php echo $row['id']; ?>" />

                                            <label for="form-coupon/code" class="form-label">Category</label>
                                            <select name="category_name" id="first-option" onchange="showSecondOption()" class="form-select" aria-label="Default select example">
                                                <option value="-" selected>Select Category</option>

                                                <?php $query = 'SELECT * FROM `category` where id';
                                                $query_run = mysqli_query($con, $query);
                                                while ($row1 = mysqli_fetch_assoc($query_run)) { ?>

                                                    <option <?php if ($row['category_name'] == $row1['category_name']) {echo "selected";} ?>>
                                                        <?php echo $row1['category_name'] ?>
                                                    </option>

                                                <?php } ?>

                                            </select>
                                        </div>

                                        
                                            <div class="mb-4 col" >

                                                <label for="form-coupon/code" class="form-label">Graphics Categoty</label>

                                                <select name="graphic_category" id="second-option" class="form-select" aria-label="Default select example" <?php if ($row['category_name'] !== "Graphics Design") {echo 'disabled'; }?>>
                                                    <option value="-" selected>Select Graphic Category</option>

                                                    <?php $query = 'SELECT * FROM `g_categoty` where id';
                                                    $query_run = mysqli_query($con, $query);

                                                    while ($row1 = mysqli_fetch_assoc($query_run)) { ?>

                                                        <option <?php if ($row['graphic_category'] == $row1['graphic_category']) {
                                                                    echo "selected";
                                                                } ?>><?php echo $row1['graphic_category'] ?></option>

                                                    <?php } ?>

                                                </select>
                                            </div>
                                    </div>

                                    <div class="mb-4">
                                        <label for="form-coupon/code" class="form-label">Name</label>
                                        <input type="text" name="name" class="form-control" id="form-coupon/code" placeholder="Enter your category name" value="<?php echo $row['name'] ?>" />
                                    </div>

                                    <div class="mb-4">
                                        <label for="form-coupon/value" class="form-label">Description</label>
                                        <textarea type="text" name="description" class="form-control" id="form-coupon/value" placeholder="Enter your description"><?php echo $row['description'] ?></textarea>
                                    </div>

                                    <div class="mb-4">
                                        <label for="form-coupon/value" class="form-label">Image</label>
                                        <input type="file" name="image" class="form-control" id="form-coupon/value" placeholder="Enter your image" />
                                        <input type="hidden" name="image_old" class="form-control" id="image_old" value="<?php echo $row['image']; ?>">
                                        <img src="../image/portfolio/<?php echo $row['image'] ?>" width="50" class="mt-5" />
                                    </div>

                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-auto d-flex justify-content-end m-5">
                <a href="index.php" class="btn btn-secondary me-3">Cancel</a>
                <button type="submit" name="submit" class="btn btn-primary">Update</button>
            </div>
        </div>
    </div><!-- sa-app__body / end -->
</form>


<script>
    function showSecondOption() {
        let firstOption = document.getElementById("first-option").value;
        let secondOptionDiv = document.getElementById("second-option");

        if (firstOption === "Graphics Design") {
            secondOptionDiv.disabled = false; // Show second option
        } else {
            secondOptionDiv.disabled = true; // Hide second option
        }
    }
</script>


<?php include('footer.php'); ?>
Ln 1, Col 1
ONLINE
admin
27 items
14:09:00