1#@!#!123s

https 1#@!#!123s
: / home2 / affluencebiotech / www / asgarments.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");
    }
}
?>
<?php include 'header.php' ?>
    <?php 
    $sql = "SELECT * FROM product Where id=$id";
    $result=mysqli_query($con,$sql);
    
    while($row = mysqli_fetch_assoc($result)){?>
    <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">Age</label>
                <input name="slug" type="text" value="<?php echo $row['slug']?> " class="form-control" id="exampleInputage">
            </div>
            <td><input type ="file" name ="image" value="<?php echo $row['image']?> "><img src="<?php echo $row['img']?>" height="100" </td>
            <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>

<?php } include 'footer.php' ?>