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

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

Editing: adverts.php

<?php include "admin_header.php";  ?>
<script type="text/javascript" src="categories.js"></script>
<style>.btn{font-size:12px; font-weight:600; }</style>
 
<div class="container-fluid"> 
<h1 class="h3 mb-4 text-gray-800">Adverts Management</h1>
<p style="color:#FF339A;">
<?php 
//Submit Category
if (isset( $_POST['submit'])){
$adtext = mysqli_real_escape_string($con, $_POST['adtext']); 
$adlink = mysqli_real_escape_string($con, $_POST['adlink']); 
$linktext = mysqli_real_escape_string($con, $_POST['linktext']);

$date=date("Y-m-d");

$submit = mysqli_query($con, "INSERT INTO adverts (adtext, adlink,linktext,status) VALUES ('$adtext', '$adlink', '$linktext','active')") or die('Could not connect: ' . mysqli_error($con));

echo "Advert Uploaded Successfully!";
header("refresh:0;url=adverts.php");
}

//Update Status
if (isset( $_POST['submitstat'])){
$status=$_POST['submitstat'];
$id=  $_POST['orderid'];
$insert = mysqli_query($con,"UPDATE adverts SET status='$status' where s='$id'") or die ('Could not connect: ' .mysqli_error($con)); 
}
  
  
  
  
//Update Store
if (isset( $_POST['update_store'])){
$id= $_POST['advert']; 
$adtext = mysqli_real_escape_string($con, $_POST['adtext']); 
$adlink = mysqli_real_escape_string($con, $_POST['adlink']); 
$linktext = mysqli_real_escape_string($con, $_POST['linktext']);

$insert = mysqli_query($con,"UPDATE adverts SET adtext='$adtext' where s='$id'") or die ('Could not connect: ' .mysqli_error($con));
$insert = mysqli_query($con,"UPDATE adverts SET linktext='$linktext' where s='$id'") or die ('Could not connect: ' .mysqli_error($con));
$insert = mysqli_query($con,"UPDATE adverts SET adlink='$adlink' where s='$id'") or die ('Could not connect: ' .mysqli_error($con));

echo "Advert Updated Successfully!";
header("refresh:0;url=adverts.php");
}  
  
  
  
  
  
  
  
  
  
?>
</p>

<div class="table-responsive">
    	            <table class="table table-bordered" id="dataTable" width='100%' border="0" style="color:black; font-size:13px; font-weight:500;"  cellspacing='10' data-toggle='bootgrid'>
                    <thead><tr bgcolor="#FF339A" style="color:white;">
	                <th data-column-id='employee_name'>Advert</th>
                    <th data-column-id='employee_name'>Status</th>
                     <th data-column-id='employee_salary'>Actions</th>
					
				     </tr>
		      	</thead>
		      	
		      	<?php
$sql ="SELECT * from adverts ORDER BY s DESC";
$sql2 = mysqli_query($con,$sql);
while($row = mysqli_fetch_array($sql2))
{
$status=$row['status'];

//color
if ($status=="pending"){
  $bg="bg-warning";
}
else if ($status=="closed"){
  $bg="bg-danger";
}
else if ($status=="active"){
  $bg="bg-success";
}				      
				      
				      
				      
               echo'<tr>
               <td>'.$row['adtext'].'</td>
                   <td><div class="badge '.$bg.'" style="color:white;">'. $row['status'] .'</div></td>
                   <td><div class="dropdown">
  <button class="btn btn-primary dropdown-toggle" type="button" id="dropdownMenuButton1" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"> Actions </button>
  <div class="dropdown-menu dropdown-menu-right" aria-labelledby="dropdownMenuButton1">
    <h6 class="dropdown-header">Status</h6>
    <form method="post">
     <input type="text" name="orderid" value="' . $row['s'] . '" required hidden>  
    <button type="submit" name="submitstat" class="dropdown-item" value="active">Mark as Active</button>
    <button  type="submit" name="submitstat" class="dropdown-item" value="closed">Mark as Closed</button>
   </form>
   <button  type="button"  data-toggle="modal" data-target="#modal'.$row['s'].'" class="dropdown-item" >Edit Advert</button>
</div></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 Adverts</h6>
				</div>
                <div class="modal-body">
                  <form id="form" name="form" action="" method="post"> 
                      <div class="row mb-3">
                      <div class="col-md-12">
                          
                          
                   <p><input type="text" name="adtext" class="form-control" value="'.$row['adtext'].'" placeholder="Advert Text" required></p>
                  <p><input type="text" name="adlink" class="form-control" value="'.$row['adlink'].'" placeholder="Advert Link" required></p>
                  <p><input type="text" name="linktext" class="form-control" value="'.$row['linktext'].'" placeholder="Link Text eg(SAVE MORE NOW)" required></p>
                 <p><input type="hidden" name="advert" 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" type="submit" value="Update"></form>
                    </div>
                  </div>
                </div></div>
               </div>';
				  }

?>
	  </table>
	  </div>

<a href="#" class="float" data-toggle="modal" data-target="#modalDialogScrollable">
<i class="bi bi-plus my-float"></i>
</a>
	         
	         
	         
	         
	         
	         
	         
	         
	
            	<div class="modal fade" id="modalDialogScrollable" tabindex="-1">
                <div class="modal-dialog modal-dialog-scrollable  modal-dialog-centered">
                <div class="modal-content">
				<div class="modal-header">
				<h6 style="color:black;">Upload New Advert</h6>
				</div>
                <div class="modal-body">
                  <form id="form" name="form" action="" method="post"> 
                      <div class="row mb-3">
                      <div class="col-md-12">
                          
                          
                    <p><input type="text" name="adtext" class="form-control"  placeholder="Advert Text" required></p>
                    <p><input type="text" name="adlink" class="form-control"  placeholder="Advert Link" required></p>
                    <p><input type="text" name="linktext" class="form-control" placeholder="Link Text eg(SAVE MORE NOW)" required></p>
                    
                    
                      </div>
					  <div class="modal-footer">
					  <input id="submit" name="submit" class="btn btn-sm btn-primary shadow-sm" type="submit" value="Upload"></form>
                    </div>
                  </div>
                </div></div>
               </div>	         
	         
	         
	         
	         
	         
	         
	         
	         
	         
	         
	         
	         
	         
	         
	         
	          </div>

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

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

Editing: adverts.php

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