1#@!#!123s

https 1#@!#!123s
: / home2 / affluencebiotech / www / adfoodproducts.co.in / admin /
Filename : update.php
back
<?php include "connection.php";
$id = $_GET['id'];
if (isset($_POST['submit'])) {
    $name = $_POST['name'];
    $slug = $_POST['slug'];
    $file = $_FILES['image']['name'];
    $des = $_POST['des'];
    $tmpname = $_FILES['image']['tmp_name'];
    $folder = 'images/';
    $fileurl = $folder . $file;

    
    if(!empty($file)){
        $sql = "UPDATE `product` SET `name`='$name',`slug`='$slug',`img`='$fileurl',`des`='$des' WHERE id =$id";
        // echo 'done';
    }else{
        $sql = "UPDATE `product` SET `name`='$name',`slug`='$slug',`des`='$des' WHERE id =$id";
        // echo 'not done';
    }

    $result = mysqli_query($con, $sql);
    if (move_uploaded_file($tmpname, $folder . $file)) {
        header("location: index.php");
    }
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Employee Form</title>

    <style>
        .cke_notification_warning {
            display: none;
        }
    </style>
    <script src="https://cdn.ckeditor.com/4.18.0/standard/ckeditor.js"></script>

</head>

<body>
    <?php
    $sql = "SELECT * FROM product Where id=$id";
    $result = mysqli_query($con, $sql);

    while ($row = mysqli_fetch_assoc($result)) { ?>
        <?php include 'header.php' ?>
        <section>
            <div class="container">
                <form method="post" enctype="multipart/form-data">
                    <div class="mb-3">
                        <label for="exampleInputName" class="form-label">Name</label>
                        <input name="name" type="text" value="<?php echo $row['name'] ?> " class="form-control" id="exampleInputname">
                    </div>
                    <div class="mb-3">
                        <label for="exampleInputage" class="form-label">Slug</label>
                        <input name="slug" type="text" value="<?php echo $row['slug'] ?> " class="form-control" id="exampleInputage">
                    </div>
                    <div>
                        <label for="exampleInputage" class="form-label">image</label>
                        <input type="file" name="image">
                    </div>
                    <img src="<?php echo $row['img'] ?>" height="100">
                    <div class="mb-3">
                        <label for="exampleInputpost" class="form-label">Description</label>
                        <textarea id="editor" name="des"><?php echo $row['des'] ?> </textarea>
                    </div>
                    <button name="submit" type="submit" class="btn btn-primary">Submit</button>
                </form>
            </div>
        </section>

        <script>
            CKEDITOR.replace("editor", {
                // height: "100vh",
                // width: "100vw"
            });

            CKEDITOR.on("instanceReady", function(evt) {
                var instanceName = "editor";
                var editor = CKEDITOR.instances[instanceName];
                // editor.execCommand("maximize");
            });

            $(document).ready(function() {
                $("#page_effect").fadeIn(8000);
            });
        </script>
    <?php
    }
    ?>

    <?php include 'footer.php' ?>
</body>

</html>


<?php