TERMINAL FM // admin

EDITOR
/home/u917864144/domains/humsafarholiday.com/public_html/admin/index_copy.php
<?php include 'header.php';
$id = $_GET['id'];
$query = "SELECT * FROM packages WHERE id = '$id' ";
$query_run = mysqli_query($con, $query);
$row = mysqli_fetch_array($query_run);


if (isset($_POST['submit'])) {
    $summer_id = $_POST['summer_id'];
    $monsoon_id = $_POST['monsoon_id'];
    $winter_id = $_POST['winter_id'];
    $dom_id = $_POST['dom_id'];
    $int_id = $_POST['int_id'];
    $farm_id = $_POST['farm_id'];
    $category_id = $_POST['category_name'];
    $home_id = $_POST['home_id'];
    $product_name = $_POST['product_name'];
    $offer_text = $_POST['offer_text'];
    $related_name = $_POST['related_name'];
    $trip_day = $_POST['trip_day'];
    $price = $_POST['price'];
    $itinerary = $_POST['itinerary'];
    $inclusions = $_POST['inclusions'];
    $exclusions = $_POST['exclusions'];

    $video_old = $_POST['video_old'];
    $video = $_FILES['video']['name'];
    $tmp_vid = $_FILES['video']['tmp_name'];
    $targetvid = '../image/video/' . $video;

    if ($video != '') {
        $update_video = $video;
    } else {
        $update_video = $video_old;
    }

    $cover_img_old = $_POST['cover_img_old'];
    $cover_img = $_FILES['cover_img']['name'];
    $tmp_file1 = $_FILES['cover_img']['tmp_name'];
    $targetPath1 = '../image/product/' . $cover_img;

    if ($cover_img != '') {
        $update_cover_img = $cover_img;
    } else {
        $update_cover_img = $cover_img_old;
    }

    $offer_img_old = $_POST['offer_img_old'];
    $offer_img = $_FILES['offer_img']['name'];
    $tmp_file_offer = $_FILES['offer_img']['tmp_name'];
    $targetPath_offer = '../image/offer_image/' . $offer_img;

    if ($offer_img != '') {
        $update_offer_img = $offer_img;
    } else {
        $update_offer_img = $offer_img_old;
    }

    $image_old = $_POST['image_old'];
    $image = $_FILES['image'];
    $file_name = $_FILES['image']['name'];
    $location = '../image/product/';
    $image_name = implode('-,-', $file_name);

    if ($image_name != '') {
        $update_img = $image_name;
    } else {
        $update_img = $image_old;
    }



    if (!empty($image_name)) {
        foreach ($file_name as $key => $val) {
            $targetPath = $location . $val;
            move_uploaded_file($_FILES['image']['tmp_name'][$key], $targetPath);
        }
    }


    $query = "INSERT INTO `packages` SET `product_name`='$product_name',`summer_id`='$summer_id',`monsoon_id`='$monsoon_id',`winter_id`='$winter_id',`dom_id`='$dom_id',`int_id`='$int_id',`farm_id`='$farm_id',`video`='$update_video',`related_name`='$related_name',`offer_text`='$offer_text',`offer_img`='$update_offer_img',`cover_img`='$update_cover_img',`image`='$update_img',`trip_day`='$trip_day',`price`='$price',`itinerary`='$itinerary',`inclusions`='$inclusions',`exclusions`='$exclusions',`category_id`='$category_id',`home_id`='$home_id'";

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



    if (move_uploaded_file($tmp_file1, $targetPath1)) {

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

    if (move_uploaded_file($tmp_file_offer, $targetPath_offer)) {

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

    if (move_uploaded_file($tmp_vid, $targetvid)) {

        echo "<script> 
                alert('Successfully Data Send');
                
            </script>";
    } else {

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


?>



<!-- Search Modal -->
<div class="modal fade" id="searchModal" tabindex="-1" aria-labelledby="searchModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content bg-transparent">
            <div class="card mb-1">
                <div class="px-3 py-2 d-flex flex-row align-items-center" id="top-search">
                    <i class="ti ti-search fs-22"></i>
                    <input type="search" class="form-control border-0" id="search-modal-input" placeholder="Search for actions, people,">
                    <button type="button" class="btn p-0" data-bs-dismiss="modal" aria-label="Close">[esc]</button>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- ============================================================== -->
<!-- Start Page Content here -->
<!-- ============================================================== -->
<div class="page-content">

    <!-- Start Content-->
    <div class="page-container">


        <div class="page-title-head d-flex align-items-sm-center flex-sm-row flex-column gap-2">
            <div class="flex-grow-1">
                <h4 class="fs-18 fw-semibold mb-0">Edit Products</h4>
            </div>

            <div class="text-end">
                <ol class="breadcrumb m-0 py-0">
                    <!-- <li class="breadcrumb-item"><a href="index.php?s_id=1">Dashboard</a></li> -->

                    <li class="breadcrumb-item"><a href="index.php?s_id=1">Products</a></li>

                    <li class="breadcrumb-item active">Edit Products</li>
                </ol>
            </div>
        </div>

        <form action="" method="POST" enctype="multipart/form-data">

            <div class="row">
                <div class="col-lg-7">
                    <div class="card">
                        <div class="card-header border-bottom border-dashed">
                            <h4 class="card-title mb-0">Product Details</h4>
                        </div>
                        <div class="card-body">
                            <div class="row">
                                <div class="col-lg-6">
                                    <div class="mb-3">

                                    <div style="display:none;">
                                            <input type="text" class="form-control" name="summer_id" id="summer_id" placeholder="Enter summer_id" value="<?php echo $row['summer_id']; ?>">
                                        </div>

                                        <div style="display:none;">
                                            <input type="text" class="form-control" name="monsoon_id" id="monsoon_id" placeholder="Enter monsoon_id" value="<?php echo $row['monsoon_id']; ?>">
                                        </div>

                                        <div style="display:none;">
                                            <input type="text" class="form-control" name="winter_id" id="winter_id" placeholder="Enter winter_id" value="<?php echo $row['winter_id']; ?>">
                                        </div>

                                        <div style="display:none;">
                                            <input type="text" class="form-control" name="dom_id" id="dom_id" placeholder="Enter dom_id" value="<?php echo $row['dom_id']; ?>">
                                        </div>

                                        <div style="display:none;">
                                            <input type="text" class="form-control" name="int_id" id="int_id" placeholder="Enter int_id" value="<?php echo $row['int_id']; ?>">
                                        </div>

                                        <div style="display:none;">
                                            <input type="text" class="form-control" name="farm_id" id="farm_id" placeholder="Enter farm_id" value="<?php echo $row['farm_id']; ?>">
                                        </div>

                                        <label for="category_name" class="form-label">Category</label>

                                        <select class="form-select my-1 my-md-0 me-sm-3"
                                            name="category_name" data-toggle="select2" id="category_name">

                                            <option value="0" <?php if ($row['category_id'] == '0') {
                                                                    echo "selected";
                                                                } ?>>Select Category</option>

                                            <option value="1" <?php if ($row['category_id'] == '1') {
                                                                    echo "selected";
                                                                } ?>>Domestic</option>

                                            <option value="2" <?php if ($row['category_id'] == '2') {
                                                                    echo "selected";
                                                                } ?>>International</option>

                                            <option value="3" <?php if ($row['category_id'] == '3') {
                                                                    echo "selected";
                                                                } ?>>Customize</option>

                                            <option value="4" <?php if ($row['category_id'] == '4') {
                                                                    echo "selected";
                                                                } ?>>Bus Tour</option>

                                            <option value="5" <?php if ($row['category_id'] == '5') {
                                                                    echo "selected";
                                                                } ?>>Car Rental</option>

                                            <option value="6" <?php if ($row['category_id'] == '6') {
                                                                    echo "selected";
                                                                } ?>>Farmhouse / Villa Rental</option>

                                            <option value="7" <?php if ($row['category_id'] == '7') {
                                                                    echo "selected";
                                                                } ?>>Visa Services</option>
                                                                
                                            <option value="8" <?php if ($row['category_id'] == '8') {
                                                                    echo "selected";
                                                                } ?>>Membership Card</option>

                                            <option value="9" <?php if ($row['category_id'] == '9') {
                                                                    echo "selected";
                                                                } ?>>Royal Caribbean</option>

                                            <option value="10" <?php if ($row['category_id'] == '10') {
                                                                    echo "selected";
                                                                } ?>>Norway Cruises</option>
                                                                
                                            <option value="11" <?php if ($row['category_id'] == '11') {
                                                                    echo "selected";
                                                                } ?>>Honeymoon Special</option> 
                                        </select>

                                    </div>
                                </div>
                                <div class="col-lg-6">
                                    <div class="mb-3">
                                        <label for="home_id" class="form-label">Popural Tour</label>

                                        <select class="form-select my-1 my-md-0 me-sm-3" name="home_id" data-toggle="select2" id="home_id">

                                            <option value="0" <?php if ($row['home_id'] == '0') {
                                                                    echo "selected";
                                                                } ?>>Select Popural Tour Line</option>

                                            <option value="1" <?php if ($row['home_id'] == '1') {
                                                                    echo "selected";
                                                                } ?>>Line 1</option>

                                            <option value="2" <?php if ($row['home_id'] == '2') {
                                                                    echo "selected";
                                                                } ?>>Line 2</option>

                                            <option value="3" <?php if ($row['home_id'] == '3') {
                                                                    echo "selected";
                                                                } ?>>Line 3</option>

                                            <option value="4" <?php if ($row['home_id'] == '4') {
                                                                    echo "selected";
                                                                } ?>>Line 4</option>

                                            <option value="5" <?php if ($row['home_id'] == '5') {
                                                                    echo "selected";
                                                                } ?>>Domestic</option>

                                            <option value="6" <?php if ($row['home_id'] == '6') {
                                                                    echo "selected";
                                                                } ?>>International</option>

                                            <option value="7" <?php if ($row['home_id'] == '7') {
                                                                    echo "selected";
                                                                } ?>>Honeymoon</option>

                                            <option value="8" <?php if ($row['home_id'] == '8') {
                                                                    echo "selected";
                                                                } ?>>Cruise</option>            
                                                                
                                            <option value="9" <?php if ($row['home_id'] == '9') {
                                                                    echo "selected";
                                                                } ?>>Bus Tour</option>

                                            <option value="10" <?php if ($row['home_id'] == '10') {
                                                                    echo "selected";
                                                                } ?>>Car Rental Services</option>

                                            <option value="11" <?php if ($row['home_id'] == '11') {
                                                                    echo "selected";
                                                                } ?>>Visa Services</option>

                                            <option value="12" <?php if ($row['home_id'] == '12') {
                                                                    echo "selected";
                                                                } ?>>Farmhouse/Villa</option>   
                                                                         
                                            <option value="13" <?php if ($row['home_id'] == '13') {
                                                                    echo "selected";
                                                                } ?>>Honeymoon Special</option>
                                                                
                                            <option value="14" <?php if ($row['home_id'] == '14') {
                                                                    echo "selected";
                                                                } ?>>Customize</option>
                                                                

                                        </select>

                                    </div>
                                </div>
                                <div class="col-lg-12">
                                    <div class="mb-3">
                                        <label for="product_name" class="form-label">Product Name</label>
                                        <input type="text" class="form-control" id="product_name" name="product_name" placeholder="Enter Product Name" value="<?php echo $row['product_name']; ?>">
                                    </div>
                                </div>

                                <div class="col-lg-6">
                                    <div class="mb-3">
                                        <label for="offer_text" class="form-label">Offer Text</label>
                                        <input type="text" class="form-control" name="offer_text" id="offer_text" placeholder="Enter Offer Text" value="<?php echo $row['offer_text']; ?>">
                                    </div>
                                </div>

                                <div class="col-lg-6">
                                    <div class="mb-3">
                                        <label for="related_name" class="form-label">Related Name</label>
                                        <input type="text" class="form-control" name="related_name" id="related_name" placeholder="Enter Related Name" value="<?php echo $row['related_name']; ?>">
                                    </div>
                                </div>

                                <div class="col-lg-6">
                                    <div class="mb-3">
                                        <label for="trip_day" class="form-label">Tour Days</label>
                                        <input type="text" class="form-control" name="trip_day" id="trip_day" placeholder="Enter Tour Days" value="<?php echo $row['trip_day']; ?>">
                                    </div>
                                </div>
                                <div class="col-lg-6">
                                    <div class="mb-3">
                                        <label for="price" class="form-label">Price</label>
                                        <input type="text" class="form-control" name="price" id="price" placeholder="Enter Price" value="<?php echo $row['price']; ?>">
                                    </div>
                                </div>
                                <div class="col-lg-12">
                                    <div class="mb-3">
                                        <label for="itinerary" class="form-label">Itinerary</label>
                                        <textarea class="form-control" id="itinerary" name="itinerary"
                                            rows="15" placeholder="Day wise itinerary"><?php echo $row['itinerary']; ?></textarea>
                                    </div>
                                </div>
                                <div class="col-lg-12">
                                    <div class="mb-3">
                                        <label for="inclusions" class="form-label">Inclusions</label>
                                        <textarea class="form-control" id="inclusions" name="inclusions"
                                            rows="8" placeholder="Enter inclusions"><?php echo $row['inclusions']; ?></textarea>
                                    </div>
                                </div>
                                <div class="col-lg-12">
                                    <div class="mb-3">
                                        <label for="exclusions" class="form-label">Exclusions</label>
                                        <textarea class="form-control" id="exclusions" name="exclusions"
                                            rows="8" placeholder="Enter exclusions"><?php echo $row['exclusions']; ?></textarea>
                                    </div>
                                </div>
                                
                            </div>
                        </div>

                    </div>
                </div>

                <div class="col-lg-5">

                    <div class="card">
                        <div class="card-header border-bottom border-dashed">
                            <h4 class="card-title mb-0">Upload Cover Photo</h4>
                        </div>
                        <div class="card-body">
                            <div class="col-12">

                                <div class="dropzone" id="myAwesomeDropzone" data-plugin="dropzone" data-previews-container="#file-previews" data-upload-preview-template="#uploadPreviewTemplate">
                                    <div class="fallback">
                                        <input type="file" name="cover_img" class="form-control" id="cover_img">
                                        <input type="hidden" name="cover_img_old" class="form-control" id="cover_img_old" value="<?php echo $row['cover_img']; ?>">
                                    </div>

                                    <div class="dz-message needsclick">
                                        <i class="h1 ti ti-cloud-upload mb-4"></i>
                                        <h4>Drop files here or click to upload.</h4>
                                        <span class="text-muted fs-13">(This is just a demo dropzone. Selected files are <strong>not</strong> actually uploaded.)</span>
                                    </div>
                                </div>
                                <img src="<?php echo "../image/product/" . $row['cover_img'] ?>" alt="" width="70">
                                <!-- Preview -->
                                <div class="dropzone-previews mt-3" id="file-previews"></div>

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

                    <div class="card">
                        <div class="card-header border-bottom border-dashed">
                            <h4 class="card-title mb-0">Upload Images</h4>
                        </div>

                        <div class="card-body">
                            <div class="col-12">

                                <div class="dropzone" id="myAwesomeDropzone1" data-plugin="dropzone" data-previews-container="#file-previews1" data-upload-preview-template="#uploadPreviewTemplate1">
                                    <div class="fallback">
                                        <input type="file" name="image[]" class="form-control" id="image" multiple="">
                                        <input type="hidden" name="image_old" class="form-control" id="image_old" value="<?php echo $row['image']; ?>">
                                    </div>

                                    <div class="dz-message needsclick uploadlabel" for="upload">
                                        <i class="h1 ti ti-cloud-upload mb-4"></i>
                                        <h4>Drop files here or click to upload.</h4>
                                        <span class="text-muted fs-13">(This is just a demo dropzone. Selected files are <strong>not</strong> actually uploaded.)</span>
                                    </div>
                                </div>

                                <?php

                                $image = explode("-,-", $row['image']);
                                foreach ($image as $img) {
                                ?>
                                    <img src="<?php echo "../image/product/" . $img ?>" alt="" width="70">
                                <?php } ?>
                                <!-- Preview -->
                                <div class="dropzone-previews mt-3" id="file-previews1"></div>

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

                    <div class="card">
                        <div class="card-header border-bottom border-dashed">
                            <h4 class="card-title mb-0">Upload Offer Image</h4>
                        </div>
                        <div class="card-body">
                            <div class="col-12">

                                <div class="dropzone" id="myAwesomeDropzone" data-plugin="dropzone" data-previews-container="#file-previews" data-upload-preview-template="#uploadPreviewTemplate">
                                    <div class="fallback">
                                        <input type="file" name="offer_img" class="form-control" id="offer_img">
                                        <input type="hidden" name="offer_img_old" class="form-control" id="offer_img_old" value="<?php echo $row['offer_img']; ?>">
                                    </div>

                                    <div class="dz-message needsclick">
                                        <i class="h1 ti ti-cloud-upload mb-4"></i>
                                        <h4>Drop files here or click to upload.</h4>
                                        <span class="text-muted fs-13">(This is just a demo dropzone. Selected files are <strong>not</strong> actually uploaded.)</span>
                                    </div>
                                </div>
                                <img src="<?php echo "../image/offer_image/" . $row['offer_img'] ?>" alt="" width="70">
                                <!-- Preview -->
                                <div class="dropzone-previews mt-3" id="file-previews"></div>

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

                    <div class="card">
                        <div class="card-header border-bottom border-dashed">
                            <h4 class="card-title mb-0">Upload Video</h4>
                        </div>
                        <div class="card-body">
                            <div class="col-12">

                                <div class="dropzone" id="myAwesomeDropzone" data-plugin="dropzone" data-previews-container="#file-previews" data-upload-preview-template="#uploadPreviewTemplate">
                                    <div class="fallback">
                                        <input type="file" name="video" class="form-control" id="video">
                                        <input type="hidden" name="video_old" class="form-control" id="video_old" value="<?php echo $row['video']; ?>">
                                    </div>

                                    <div class="dz-message needsclick">
                                        <i class="h1 ti ti-cloud-upload mb-4"></i>
                                        <h4>Drop files here or click to upload.</h4>
                                        <span class="text-muted fs-13">(This is just a demo dropzone. Selected files are <strong>not</strong> actually uploaded.)</span>
                                    </div>
                                </div>

                                <video src="<?php echo "../image/video/" . $row['video'] ?>" alt="" width="70"></video>
                                <!-- Preview -->
                                <div class="dropzone-previews mt-3" id="file-previews"></div>

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

                    <div class="text-end mb-3">
                        <button type="submit" name="submit" class="btn btn-primary">New Add Details</button>
                        <a href="index.php?s_id=1" class="btn btn-danger">Cancel</a>
                    </div>
                </div>
            </div>

        </form>

    </div> <!-- container -->



    <?php include 'footer.php'; ?>
Ln 1, Col 1
ONLINE
admin
31 items
09:50:17