1#@!#!123s

: / home / u384067285 / domains / cauldronsisterss.com / public_html / admin /
Filename : edit_reciepe.php
back
<?php session_start();

    error_reporting(0);

    include 'connection.php';

    if (strlen($_SESSION['bpmsaid'] == 0)) {
        header("Location: logout.php");
    }

if (isset($_POST['update'])) {
    /* Fetch Requests from input box */
   
    $reciepe_name = $_POST['reciepe_name'];
    $short_description = $_POST['short_description'];
    $ingredients = $_POST['ingredients'];
    
    $filename = $_FILES["image1"]["name"];
    $tempname = $_FILES["image1"]["tmp_name"];    
    $folder = "images/recipes/".$filename;

    $filename1 = $_FILES["image2"]["name"];
    $tempname1 = $_FILES["image2"]["tmp_name"];    
    $folder1 = "images/recipes/".$filename1;

    $filename2 = $_FILES["image3"]["name"];
    $tempname2 = $_FILES["image3"]["tmp_name"];    
    $folder2 = "images/recipes/".$filename2;

    /* Add Requests */
    $eid = $_GET['editid'];
      
	/* Update Requests */
	$sql = "UPDATE tblrecipes SET reciepe_name = '$reciepe_name', short_description = '$short_description', ingredients = '$ingredients', image1 = '$filename', image2 = '$filename1', image3 = '$filename2' WHERE reciepe_name = '$eid'";

    if ($conn->query($sql) === TRUE) {

        move_uploaded_file($tempname, $folder);
        move_uploaded_file($tempname1, $folder1);
        move_uploaded_file($tempname2, $folder2);

        $msg = "Reciepe Updated Successfully";
    } else {
        $msg = $conn->error;
    }
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <title>Cauldron Sisterss | Edit Recipe</title>
    <!-- plugins:css -->
    <link rel="stylesheet" href="vendors/feather/feather.css">
    <link rel="stylesheet" href="vendors/mdi/css/materialdesignicons.min.css">
    <link rel="stylesheet" href="vendors/ti-icons/css/themify-icons.css">
    <link rel="stylesheet" href="vendors/typicons/typicons.css">
    <link rel="stylesheet" href="vendors/simple-line-icons/css/simple-line-icons.css">
    <link rel="stylesheet" href="vendors/css/vendor.bundle.base.css">
    <!-- endinject -->
    <!-- Plugin css for this page -->
    <link rel="stylesheet" href="vendors/select2/select2.min.css">
    <link rel="stylesheet" href="vendors/select2-bootstrap-theme/select2-bootstrap.min.css">
    <!-- End plugin css for this page -->
    <!-- inject:css -->
    <link rel="stylesheet" href="css/vertical-layout-light/style.css">
    <!-- endinject -->
    <?php include 'favicon.php'; ?>
    <script src = "ckeditor/ckeditor.js"></script>
</head>

<body>
    <div class="container-scroller">
        <!-- partial:../../partials/_navbar.php -->
        <?php include 'header.php'; ?>
        <!-- partial -->

        <div class="container-fluid page-body-wrapper">
            <!-- partial:../../partials/_sidebar.html -->
            <?php include 'sidebar.php'; ?>
            <!-- partial -->

            <div class="main-panel">
                <div class="content-wrapper">
                    <div class="row">
                        <div class="col-md-12 grid-margin stretch-card">
                            <div class="card">
                                <div class="card-body">

                                    <h4 class="card-title">Edit Recipe
                                        <span style = "color:red;">
                                            <?php echo $msg; ?>
                                        </span>
                                    </h4>

                                    <form class="forms-sample" method="post" enctype="multipart/form-data">

                                        <?php
                                            $cid = $_GET['editid'];
                                            $sql = "SELECT * FROM tblrecipes WHERE reciepe_name = '$cid'";
                                            $result = $conn->query($sql);
                                            while ($row = mysqli_fetch_array($result)) {
                                        ?>

                                        <div class="form-group">
                                            <label for="category_name">Category Name</label>
                                            <input type="text" class="form-control" id="category_name" placeholder="Category Name" name="category_name" disabled value = "<?php echo $row['category_name']; ?>">
                                        </div>

                                        <div class="form-group">
                                            <label for="name">Reciepe Name</label>
                                            <input type="text" class="form-control" id="name" placeholder="Name" name="reciepe_name" required value = "<?php echo $row['reciepe_name']; ?>">
                                        </div>
                                       
                                        <div class="form-group">
                                            <label for="descripton">Short Description</label>
                                            <textarea class="form-control" id="descripton" placeholder="Descripton" name="short_description" required><?php echo $row['short_description']; ?></textarea>
                                        </div>

                                        <div class="form-group">
                                            <label for="Ingredients">Ingredients</label>
                                            <textarea class="form-control" id="Ingredients" placeholder="Ingredients" name="ingredients" required><?php echo $row['ingredients']; ?></textarea>
                                        </div>

                                        <div class="row">
                                            <div class="col-md-6">
                                                <div class="form-group row">
                                                    <label class="col-sm-3 col-form-label">Image1</label>
                                                    <div class="col-sm-9">
                                                        <input type="file" class="form-control" name = "image1" />
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="col-md-6">
                                                <div class="form-group row">
                                                    <label class="col-sm-3 pt-0 col-form-label">

                                                        <img height = "50" width = "50" src="images/recipes/<?php echo $row['image1']; ?>" alt="<?php echo $row['image1']; ?>">

                                                    </label>
                                                </div>
                                            </div>
                                        </div>

                                        <div class="row">
                                            <div class="col-md-6">
                                                <div class="form-group row">
                                                    <label class="col-sm-3 col-form-label">Image2</label>
                                                    <div class="col-sm-9">
                                                        <input type="file" class="form-control" name = "image2" />
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="col-md-6">
                                                <div class="form-group row">

                                                    <label class="col-sm-3 pt-0 col-form-label">

                                                        <img height = "50" width = "50" src="images/recipes/<?php echo $row['image2']; ?>" alt="<?php echo $row['image2']; ?>">

                                                    </label>

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

                                        <div class="row">
                                            <div class="col-md-6">
                                                <div class="form-group row">
                                                    <label class="col-sm-3 col-form-label">Image3</label>
                                                    <div class="col-sm-9">
                                                        <input type="file" class="form-control" name = "image3" />
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="col-md-6">
                                                <div class="form-group row">

                                                    <label class="col-sm-3 pt-0 col-form-label">

                                                        <img height = "50" width = "50" src="images/recipes/<?php echo $row['image3']; ?>" alt="<?php echo $row['image3']; ?>">

                                                    </label>

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

                                        <button type="submit" class="btn btn-primary me-2" name="update">Update</button>

                                        <a href = "recipes.php" class="btn btn-primary me-2" name="update">Cancel</a>

                                        <?php } ?>

                                    </form>

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

                    <!-- Manage Company Contact -->

                    <div class="row">

                        <div class="col-lg-12 grid-margin stretch-card">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="card-title">Manage Reciepes

                                    </h4>
                                    <div class="table-responsive">
                                        <table class="table table-hover">
                                            <thead>
                                                <tr>
                                                    <th>#</th>
                                                    <th>Category</th>
                                                    <th>Reciepe Name</th>
                                                    <th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>

                                                <?php
                                                $cid = $_GET['editid'];
                                                $sql = "SELECT * FROM tblrecipes WHERE reciepe_name = '$cid'";
                                                $result = $conn->query($sql);
                                                $cnt = 1;
                                                while ($row = mysqli_fetch_array($result)) {
                                                ?>

                                                    <tr>
                                                        <td><?php echo $cnt; ?></td>
                                                        <td><?php echo $row['category_name']; ?></td>
                                                        <td><?php echo $row['reciepe_name']; ?></td>

                                                        <td>
                                                            <label class="badge badge-warning">
                                                                <a href = "edit_reciepe.php?editid=<?php echo $row['reciepe_name']; ?>" style="text-decoration:none; color:black;">Edit</a>
                                                            </label>

                                                            <label class="badge badge-danger">
                                                                <a href = "delete_reciepe.php?id=<?php echo $row['reciepe_name']; ?>" style="text-decoration:none; color:black;">Delete</a>
                                                            </label>
                                                        </td>

                                                    </tr>

                                                <?php $cnt = $cnt + 1;
                                                }
                                                ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                </div>
                <!-- content-wrapper ends -->

                <!-- partial:../../partials/_footer.html -->
                <?php include 'footer.php'; ?>
                <!-- partial -->

            </div>
            <!-- main-panel ends -->
        </div>
        <!-- page-body-wrapper ends -->
    </div>
    <!-- container-scroller -->
    <!-- plugins:js -->
    <script src="vendors/js/vendor.bundle.base.js"></script>
    <!-- endinject -->
    <!-- Plugin js for this page -->
    <script src="vendors/typeahead.js/typeahead.bundle.min.js"></script>
    <script src="vendors/select2/select2.min.js"></script>
    <script src="vendors/bootstrap-datepicker/bootstrap-datepicker.min.js"></script>
    <!-- End plugin js for this page -->
    <!-- inject:js -->
    <script src="js/off-canvas.js"></script>
    <script src="js/hoverable-collapse.js"></script>
    <script src="js/template.js"></script>
    <script src="js/settings.js"></script>
    <script src="js/todolist.js"></script>
    <!-- endinject -->
    <!-- Custom js for this page-->
    <script src="js/file-upload.js"></script>
    <script src="js/typeahead.js"></script>
    <script src="js/select2.js"></script>
    <!-- End custom js for this page-->
    
    <script>
        /* var editor = */ CKEDITOR.replace('short_description');
        /* CKFinder.setupCKEditor( editor ); */
    </script>
    <script>
        /* var editor = */ CKEDITOR.replace('ingredients');
        /* CKFinder.setupCKEditor( editor ); */
    </script>
</body>

</html>