📁 File Manager
Editing:
/home/wedigitalindia/public_html/admin/addpackages.php
<?php include("connection.php"); if (isset($_POST['submit'])) { // Main fields (single values) $title = mysqli_real_escape_string($con, $_POST['heading']); $price = mysqli_real_escape_string($con, $_POST['price']); $month = mysqli_real_escape_string($con, $_POST['month']); // Dynamic fields (arrays) $headings = isset($_POST['heading_arr']) ? $_POST['heading_arr'] : []; $paras = isset($_POST['para']) ? $_POST['para'] : []; $packages = []; // Loop through dynamic inputs for ($i = 0; $i < count($headings); $i++) { if (!empty($headings[$i]) && !empty($paras[$i])) { $packages[] = [ 'heading' => mysqli_real_escape_string($con, $headings[$i]), 'para' => mysqli_real_escape_string($con, $paras[$i]) ]; } } // Convert to JSON $packages_json = json_encode($packages, JSON_UNESCAPED_UNICODE); // Insert query $sql = "INSERT INTO `package` (`heading`,`price`,`month`,`packages`) VALUES ('$title','$price','$month','$packages_json')"; $query = mysqli_query($con, $sql); if ($query) { header("Location: viewpackages.php"); exit(); } else { echo "Database error: " . mysqli_error($con); } } ?> <?php include("header.php") ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <title>ADD Packages</title> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <meta content="Premium Multipurpose Admin & Dashboard Template" name="description" /> <meta content="Themesbrand" name="author" /> <!-- App favicon --> <link rel="shortcut icon" href="./assets/logo/fav.png" /> <!-- Plugins css --> <link href="assets/libs/dropzone/dropzone.css" rel="stylesheet" type="text/css" /> <link rel="stylesheet" type="text/css" href="https://use.fontawesome.com/releases/v5.8.1/css/all.css"> <!-- Bootstrap Css --> <link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" /> <!-- Icons Css --> <link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" /> <!-- App Css--> <link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" /> <!-- App js --> <!-- <script src="assets/js/plugin.js"></script> --> <style> .form .input { width: 100%; background: white; border: none; padding: 15px 20px; border-radius: 20px; margin-bottom: 9px; margin-top: 15px; box-shadow: rgba(0, 0, 0, 0.24) 0px 3px 8px; border-inline: 2px solid transparent; } input[name='Image'] { display: none; } div#upload { cursor: pointer; } ::-webkit-file-upload-button { /* width: 100%; height: 100%; */ display: none; /* color: transparent; */ } /* .form .input::-moz-placeholder { color: rgb(170, 170, 170); } .form .input::placeholder { color: rgb(170, 170, 170); } .form .input:focus { outline: none; border-inline: 2px solid #12b1d1; } */ .filepath { display: none; } img[alt="img"] { width: clamp(50px, 15%, 100px); aspect-ratio: 1/0.70; } </style> </head> <body data-sidebar="dark"> <!-- <body data-layout="horizontal" data-topbar="dark"> --> <!-- Begin page --> <div id="layout-wrapper"> <div class="w-80 "> <div class="page-content" style="width: 80%;margin-left: 260px;"> <div class="container"> <!-- start page title --> <div class="row"> <div class="col-12"> <div class="page-title-box d-sm-flex align-items-center justify-content-between"> <h4 class="mb-sm-0 font-size-18">ADD Packages</h4> </div> </div> </div> <!-- end page title --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body"> <div> <form class="form" action="" method="POST"> <div class="row mb-3"> <div class="col-lg-4"> <label class="form-label">Title</label> <input type="text" class="form-control" name="heading" required /> </div> <div class="col-lg-4"> <label class="form-label">Price</label> <input type="text" class="form-control" name="price" required /> </div> <div class="col-lg-4"> <label class="form-label">Per Month</label> <input type="text" class="form-control" name="month" required /> </div> </div> <div class="row mb-3"> <h4>Packages</h4> <div class="col-lg-5"> <input type="text" class="form-control" name="heading_arr[]" placeholder="Enter heading" /> </div> <div class="col-lg-5"> <input type="text" class="form-control" name="para[]" placeholder="Enter para" /> </div> <div class="col-lg-2"> <button type="button" class="btn btn-primary" onclick="addOption()">+ Add packages</button> </div> <div id="addOption"></div> </div> <div class="text-center"> <button type="submit" name="submit" class="btn btn-danger">Submit</button> <a href="viewpackages.php" class="btn btn-secondary">View Data</a> </div> </form> </div> </div> </div> </div> <!-- end col --> </div> <!-- end row --> </div> <!-- container-fluid --> </div> <!-- End Page-content --> </div> <!-- end main content--> </div> <!-- END layout-wrapper --> <style> .package-item { display: flex; align-items: center; gap: 10px; margin-bottom: 10px; } </style> <!-- JAVASCRIPT --> <script src="assets/libs/jquery/jquery.min.js"></script> <script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script> <script src="assets/libs/metismenu/metisMenu.min.js"></script> <script src="assets/libs/simplebar/simplebar.min.js"></script> <script src="assets/libs/node-waves/waves.min.js"></script> <!-- Plugins js --> <script src="assets/libs/dropzone/dropzone-min.js"></script> <!-- Form file upload init js --> <script src="assets/js/pages/form-file-upload.init.js"></script> <script src="assets/js/app.js"></script> <script src="./ck editor/ckeditor.js"></script> <script> function addOption() { const div = document.createElement('div'); div.classList.add('row', 'align-items-center', 'mb-2'); div.innerHTML = ` <div class="col-lg-5"> <input type="text" class="form-control" name="heading_arr[]" placeholder="Enter heading" required/> </div> <div class="col-lg-5"> <input type="text" class="form-control" name="para[]" placeholder="Enter para" required/> </div> <div class="col-lg-2"> <button type="button" class="btn btn-danger" onclick="this.parentElement.parentElement.remove()">Remove</button> </div> `; document.getElementById('addOption').appendChild(div); } </script> </body> </html>
Save
Cancel