~NAXC~

File Content: `editadd.php`

<?php 
ob_start();
?>
<?php 
	session_start(); 

	if (!isset($_SESSION['username'])) {
		$_SESSION['msg'] = "You must log in first";
		header('location: login.php');
	}

	if (isset($_GET['logout'])) {
		session_destroy();
		unset($_SESSION['username']);
		header("location: login.php");
	}

?>

<?php include "assets/includes/functions.php";?>


<?php include "assets/includes/header.php";?>

<!-- Page content start -->
<div class="page-contentbar">

<!--left navigation start-->
<?php include "assets/includes/sidebar.php";?>
<!--left navigation end-->

<!-- START PAGE CONTENT -->

<div id="page-right-content">
<div class="container">
<div class="row">
<br><br><br>
        <div class="panel panel-color panel-primary">
            <div class="panel-heading">
                <h3 class="panel-title">Edit Adds</h3>

            </div>

 <div class="panel-body" >
<div class="container" id="addmember">


 <p class="statusMsg"></p>
<form  enctype="multipart/form-data"  id="add_name" method="post">

<?php 
if (isset($_GET['edit'])) {
$the_cat_id = $_GET['edit'];

$query = "select * from adds WHERE id = {$the_cat_id}";
$select_edits = mysqli_query($connection,$query);
    
while($row1 = mysqli_fetch_assoc($select_edits))
{
$post_rid = $row1['id'];
$post_pos = $row1['position'];
$post_sub = $row1['status'];
$post_image = $row1['image'];
$post_link = $row1['link'];
$post_name = $row1['name'];
  
?>   

<div class="form-group">
   <div class="row">
    <div class="col-md-12">
            <label for="ImagePosition<spanClass=required>*</span>" class="col-md-3 control-label">Position<span Class=required> * </span></label>
           <select name="ImagePosition" class="form-control" id="ImagePosition">
                     <option  value="<?php if(isset($post_pos )){echo $post_pos ;} ?>"> <?php if(isset($post_pos )){echo $post_pos;} ?> </option>
            <option value="top_main">Top Menu</option>
            <option value="left_top">Left Top</option>
            <option value="left_middle">Left Middle</option>
            <option value="left_bottom">Left Bottom</option>
            <option value="right_square">Right Square</option>
            <option value="live_streaming_banner">Live Streaming Banner</option>
            </select>      
    
    
   </div> 

    </div>
    </div>
   <div class="form-group">
   <div class="row">
    <div class="col-md-6">
 <label for="PostImage<spanClass=required></span>" class="col-md-3 control-label">Image<span Class=required> * </span></label>  
        <input type="file" name="file" class="form-control" id="PostImage"  onchange="readURL(this);"/>


    </div>
<div class="col-md-6" style="max-height: 350px;height:200px;border: 1px dotted;">
<img id="blah" src="../admin/assets/images/adds/<?php if(isset($post_image)){echo $post_image ;} ?>" alt="" class="img-thumbnail" style="max-height: 300px;height:200px;width:500px">
</div>
  </div>


  </div>
   <div class="form-group">
   <div class="row">
    <div class="col-md-6">
<label for="ImageLink<spanClass=required></span>" class="col-md-3 control-label">Link<span Class=required>  </span></label> 
     <input name="ImageLink" class="form-control" Placeholder="Eg: https://www.google.com/" maxlength="500" type="text" value="<?php if(isset($post_link)){echo $post_link ;} ?>" id="ImageLink"/>

    </div>
<div class="col-md-6">
  <label for="ImageName<spanClass=required></span>" class="col-md-3 control-label">Name<span Class=required>  </span></label>
<input name="ImageName" class="form-control" maxlength="256" type="text" value="<?php if(isset($post_name)){echo $post_name ;} ?>" id="ImageName"/>
</div>
  </div>


  </div>
<div class="form-group">
   <div class="row">
    <div class="col-md-12">
<label for="userName">Status<span class="text-danger">*</span></label>
              <select class="form-control select2" name="istatus" id="istatus" style="font-family:inherit;width:100%; height:50px; float:left; padding:5px; line-height:40px; text-align:left;">
                 <option  value="<?php if(isset($post_sub )){echo $post_sub ;} ?>"> <?php if(isset($post_sub )){echo $post_sub;} ?> </option>
                     <option value="Active">Active</option>
                    <option value="Inactive">Inactive</option>
                </select> 
    </div>

  </div>


  </div>

    <div class="form-group text-right m-b-0">

   <input type="submit" name="submit" class="btn btn-primary submitBtn" value="Submit"/>
    <button type="submit" name="cancel" class="btn btn-default waves-effect m-l-5">
    Cancel
    </button>
    </div>
   <?php
if(isset($_POST['submit']))
{
 $post_image1=$_FILES['file']['name'];
    $post_image_temp1=$_FILES['file']['tmp_name'];
    if ($post_image1 == "" || empty($post_image1))
        {
             $post_image1 = $post_image;
        } {
            $target = "../admin/assets/images/adds/".basename($post_image1);
            move_uploaded_file($_FILES['file']['tmp_name'], $target);   
       }

$post_pos = $_POST["ImagePosition"];
$post_sub = $_POST["istatus"];
$post_link = $_POST["ImageLink"];
$post_name = $_POST["ImageName"];




 $sql="update adds set position='". mysqli_real_escape_string($connection,$post_pos)."',status='" . mysqli_real_escape_string($connection,$post_sub)."',image='" . mysqli_real_escape_string($connection,$post_image1)."' ,link='" . mysqli_real_escape_string($connection,$post_link)."' ,name='" . mysqli_real_escape_string($connection,$post_name)."'  WHERE id = {$the_cat_id}";
 

if ($connection->query($sql) === TRUE) {
    echo "New record created successfully";
        header("Location: advertisements.php");
} else {
    echo "Error: " . $sql . "<br>" . $connection->error;
}



} 
else
if (isset($_POST['cancel']))
{
 header("Location: advertisements.php");
}

?>   
    
    
 <?php
 }
 }
 ?>   

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

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

    
   
                    <div class="footer">
                        <div class="pull-right hidden-xs">
                            Project Completed <strong class="text-custom">99%</strong>.
                        </div>
                        <div>
                         <strong>C Media</strong> - Copyright &copy; 2021
                        </div>
                    </div> <!-- end footer -->

                </div>
                <!-- End #page-right-content -->

            </div>
            <!-- end .page-contentbar -->
        </div>
        <!-- End #page-wrapper -->



        <!-- js placed at the end of the document so the pages load faster -->
        <script src="assets/js/jquery-2.1.4.min.js"></script>
        <script src="assets/js/bootstrap.min.js"></script>
        <script src="assets/js/metisMenu.min.js"></script>
        <script src="assets/js/jquery.slimscroll.min.js"></script>

        <script src="assets/plugins/bootstrap-tagsinput/js/bootstrap-tagsinput.min.js"></script>
        <script src="assets/plugins/select2/js/select2.min.js" type="text/javascript"></script>
        <script src="assets/plugins/bootstrap-filestyle/js/bootstrap-filestyle.min.js" type="text/javascript"></script>
        <script src="assets/plugins/switchery/switchery.min.js"></script>
        <script type="text/javascript" src="assets/plugins/parsleyjs/parsley.min.js"></script>

        <script src="assets/plugins/moment/moment.js"></script>
     	<script src="assets/plugins/timepicker/bootstrap-timepicker.js"></script>
     	<script src="assets/plugins/bootstrap-colorpicker/js/bootstrap-colorpicker.min.js"></script>
     	<script src="assets/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js"></script>
     	<script src="assets/plugins/clockpicker/js/bootstrap-clockpicker.min.js"></script>
     	<script src="assets/plugins/bootstrap-daterangepicker/daterangepicker.js"></script>
        <script src="assets/plugins/summernote/summernote.min.js"></script>

        <!-- form advanced init js -->
        <script src="assets/pages/jquery.form-advanced.init.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
        <!-- App Js -->
        <!-- <script src="assets/js/jquery.app.js"></script> -->

<!--         <script type="text/javascript">
            $(document).ready(function() {
                $('.form-validation').parsley();
                $('.summernote').summernote({
                    height: 350,                 // set editor height
                    minHeight: null,             // set minimum height of editor
                    maxHeight: null,             // set maximum height of editor
                    focus: false                 // set focus to editable area after initializing summernote
                });
            });
        </script> -->
        <script>
function myFunction(e) {
  $rre=$( "#packtype option:selected" ).text();
  // alert($rre);
    document.getElementById("pname").value = e.target.value;
     document.getElementById("pid").value =   $rre;
     // $('#pname').val(product_id);
}




        </script>
  <script>
$(document).ready(function(e){
    $('#cancel').delegate('','click change',function(){
    window.location = "category.php";
    return false;
});
});




</script>   
 <script type="text/javascript">
   
   function readURL(input) {
  
            if (input.files && input.files[0]) {
                var reader = new FileReader();

                reader.onload = function (e) {
                    $('#blah')
                        .attr('src', e.target.result)
                        .width(500)
                        .height(200);
                                               
                };

                reader.readAsDataURL(input.files[0]);
            }
        }
 </script>   
 


    </body>
</html> 
    
    
   <?php 
ob_end_flush();
?>
File Content: editadd.php

File Content: `editadd.php`
