One Hat Cyber Team

View File Name : add_library_images.php

<?php
		session_start();
?>


<?php include('../../connections.php'); ?>

    <?php
		$upload_status="";

        

        if(isset($_POST['image_submit'])){
        
            $target_dir = "images/";

            $url="";

            if(isset($_FILES["imagenew"]["name"])){

            $target_file = $target_dir.basename($_FILES["imagenew"]["name"]);

              echo $target_file;

    
            move_uploaded_file($_FILES["imagenew"]["tmp_name"], $target_file);

            $url = "https://thurukepakaru.com/App/New/admin/dashboard/images/".basename($_FILES["imagenew"]["name"]);

            }
            $plant_details_id = str_replace( array("'"), '', $_POST['plant_details_id']);
    
            $query="INSERT INTO `tree_library_images`(`tree_id`, `image_url`) VALUES ('$plant_details_id','$url')";     

            $result = mysqli_query($connect,$query) or die(mysqli_error($connect));

          if($result){

            $upload_status="success";


             }else{

               $upload_status="fail";

             }

           }if(isset($_GET['id'])){

            $id=$_GET['id'];


            $sql ="DELETE FROM `tree_library_images` WHERE  tree_library_img_id='$id'";
            $result = mysqli_query($connect,$sql) or die(mysqli_error($connect));
            

               if($result){

                $upload_status="success";
    
    
                 }else{
    
                   $upload_status="fail";
    
                 }

           }


    ?>

<!DOCTYPE html>

<html lang="en">

  <head>

    <meta charset="utf-8" />
    <link rel="apple-touch-icon" sizes="76x76" href="g">
    <link rel="icon" type="image/png" href="assets/img/favicon.png">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
    <title>Thuru</title>
    <meta content='width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0, shrink-to-fit=no' name='viewport' />
    <!--     Fonts and icons     -->
    <link href="https://fonts.googleapis.com/css?family=Montserrat:400,700,200" rel="stylesheet" />
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/latest/css/font-awesome.min.css" />
    <!-- CSS Files -->
    <link href="assets/css/bootstrap.min.css" rel="stylesheet" />
    <link href="assets/css/light-bootstrap-dashboard.css?v=2.0.1" rel="stylesheet" />
    <link href="https://cdn.jsdelivr.net/npm/select2@4.0.12/dist/css/select2.min.css" rel="stylesheet" />
    <link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.6-rc.0/css/select2.min.css" rel="stylesheet" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.6-rc.0/js/select2.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"></script>
    <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" rel="stylesheet" />
   <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" />
    <script src="https://cdn.tiny.cloud/1/2igvmvhno245qw3kilqkwmuc2atwu0w1unsi8xj4y87a9cpz/tinymce/5/tinymce.min.js" referrerpolicy="origin"></script>
    <link href="assets/css/demo.css" rel="stylesheet" />

<style>
	 .inline{

	 display: inline-block;

		 float: right;



		 margin: 20px 0px;



	 }



	 



	 input,button{



		 height: 34px;



	 }



	</style>



    



  </head>







<body>


        <?php include('header.php');?>

        <div class="main-panel">

        <?php include('side_bar.php');?>

            <div class="content">

                <div class="container-fluid">

                                <!-- End Navbar -->



                    <div class="container-fluid">


                    <div class="content pl-0 pr-0">



                <div class="container-fluid">


                        <div class="row">



                     <div class="row">



                        <div class="col-md-12">

                          <?php

								if($upload_status=="success"){

                                         echo '<div class="alert alert-success">

                                            <strong>Success!</strong> Successfully Uploaded

                                          </div>';


                                }else if( $upload_status=="fail"){

                                  		echo '<div class="alert alert-danger">

                                            <strong>False!</strong>Try Again Later</div>';
                            

                                }/**/



                          



                          $upload_status="";



                          ?>



<form id="RegisterValidation"  enctype="multipart/form-data" method="post">



<div class="card ">



     <div class="card-header ">



         <h4 class="card-title">Add Tree Info Images</h4>



     </div>



     <div class="card-body ">

        <div class="form-group has-label col-md-6">

                 <label class="pb-1">
 
                 Title

                 <star class="star">*</star>

                 </label>
   

                 <select class="form-control" name="plant_details_id" id="sel1">

                    <option>Select Name</option>

                    <?php

                    $query="SELECT * FROM `plant_details` ORDER BY plant_details_id DESC";	

                    $result = mysqli_query($connect,$query);


                    while($row = mysqli_fetch_assoc($result)){

                        
                        
                        
                        echo ' <option value='.$row['plant_details_id'].'>'.$row['title'].'</option>';



                    }



                    ?>


                    </select>


        </div>

         <div class="row">

             <div class="form-group has-label col-md-6">

                 <label class="pb-1">

                 Image
                     <star class="star">*</star>

                 </label>

                 <input type="file" class="form-control " name="imagenew"  />


             </div>

         </div>
         <div class="card-category form-category">
             <star class="star">*</star> Required fields</div>
     </div>

     <div class="card-footer text-right">



         <button type="submit" name="image_submit" class="btn btn-info btn-fill pull-right" id="button">SUBMIT</button>



         <div class="form-group pull-left">



             <div class="form-check">



             </div>



         </div>



         <div class="clearfix"></div>

     </div>

 </div>

</form>


<div class="col-md-12">

                                <div class="card bootstrap-table">
                        
                                  <div class="card-body table-full-width">

                                        <div class="toolbar">

                                        

                                        </div>



                                        <table id="bootstrap-table" class="table">



                                            <thead>



                                             <th data-field="id" class="text-center">ID</th>



                                            <th data-field="name" data-sortable="true">Title</th>

                            
                                            <th data-field="a" data-sortable="true">Image</th>



                                            <th data-field="action" data-sortable="true">Action</th>



                                            </thead>



                                            <tbody>


                                                <?php



                                                    //LIMIT 10 



                                                    //$query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id  ORDER BY newuser_plants.created_time DESC ";



                                                $query="SELECT * FROM `plant_details` inner join tree_library_images WHERE tree_library_images.tree_id =plant_details.plant_details_id  ORDER BY plant_details.plant_details_id DESC";	

                                                                                
                                                $result = mysqli_query($connect,$query) or die(mysqli_error($connect));

                                                $i;



                                               while($row=mysqli_fetch_assoc($result)){

                                                $id = $row['plant_details_id'];



                                                 $i++; 



                                                        echo ' <tr>



                                                <td>'.$i.'</td>



                                                <td>'.$row['title'].'</td>                                                                                                                     

                                                <td><img src="'.$row['image_url'].'" width="150"></td>      

                                                   <td>

                               <a href="add_library_images.php?id='.$row['tree_library_img_id'].'" rel="tooltip" title="Delete" class="btn btn-link btn-danger table-action info text-right" ><i class="fa fa-trash"></i></a>

                         



                                                </td>            

                                            </tr>';

                                        }



                                                



                                                ?>



                                           



                                            </tbody>



                                        </table>



                                    </div>



                                </div>



                            </div>



                        </div>



                       







                    </div>



                </div>



            </div>



                      



                        <script>



    tinymce.init({



      selector: 'textarea',



      plugins: 'advlist autolink lists link image charmap print preview hr anchor pagebreak',



      toolbar_mode: 'floating',



   });



  </script>



            <!-- End Navbar -->



            <footer class="footer">



                <div class="container">



                    <nav>



                        <p class="copyright text-center">



                            ©



                            <script>



                                document.write(new Date().getFullYear())



                            </script>



                            <a href="https://inoxzasolutions.com/">Inoxza Solutions</a>Innovations Forever



                        </p>



                    </nav>



                </div>



            </footer>



        </div>



    </div>



</body>



<!--   Core JS Files   -->



<script src="assets/js/core/jquery.3.2.1.min.js" type="text/javascript"></script>



<script src="assets/js/core/popper.min.js" type="text/javascript"></script>



<script src="assets/js/core/bootstrap.min.js" type="text/javascript"></script>



<!--  Plugin for Switches, full documentation here: http://www.jque.re/plugins/version3/bootstrap.switch/ -->



<script src="assets/js/plugins/bootstrap-switch.js"></script>



<!--  Google Maps Plugin    -->



<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?YOUR_KEY_HERE"></script>



<!--  Chartist Plugin  -->



<script src="assets/js/plugins/chartist.min.js"></script>



<!--  Notifications Plugin    -->



<script src="assets/js/plugins/bootstrap-notify.js"></script>



<!--  jVector Map  -->



<script src="assets/js/plugins/jquery-jvectormap.js" type="text/javascript"></script>



<!--  Plugin for Date Time Picker and Full Calendar Plugin-->



<script src="assets/js/plugins/moment.min.js"></script>



<!--  DatetimePicker   -->



<script src="assets/js/plugins/bootstrap-datetimepicker.js"></script>



<!--  Sweet Alert  -->



<script src="assets/js/plugins/sweetalert2.min.js" type="text/javascript"></script>



<!--  Tags Input  -->



<script src="assets/js/plugins/bootstrap-tagsinput.js" type="text/javascript"></script>



<!--  Sliders  -->



<script src="assets/js/plugins/nouislider.js" type="text/javascript"></script>



<!--  Bootstrap Select  -->



<script src="assets/js/plugins/bootstrap-selectpicker.js" type="text/javascript"></script>



<!--  jQueryValidate  -->



<script src="assets/js/plugins/jquery.validate.min.js" type="text/javascript"></script>



<!--  Plugin for the Wizard, full documentation here: https://github.com/VinceG/twitter-bootstrap-wizard -->



<script src="assets/js/plugins/jquery.bootstrap-wizard.js"></script>



<!--  Bootstrap Table Plugin -->



<script src="assets/js/plugins/bootstrap-table.js"></script>



<!--  DataTable Plugin -->



<script src="assets/js/plugins/jquery.dataTables.min.js"></script>



<!--  Full Calendar   -->



<script src="assets/js/plugins/fullcalendar.min.js"></script>



<!-- Control Center for Now Ui Dashboard: parallax effects, scripts for the example pages etc -->



<script src="assets/js/light-bootstrap-dashboard.js?v=2.0.1" type="text/javascript"></script>



<script>



          



          



  $(function() {



	



	$(document).on({



		mouseover: function(event) {



			$(this).find('.far').addClass('star-over');



			$(this).prevAll().find('.far').addClass('star-over');



		},



		mouseleave: function(event) {



			$(this).find('.far').removeClass('star-over');



			$(this).prevAll().find('.far').removeClass('star-over');



		}



	}, '.rate');











	$(document).on('click', '.rate', function() {



		if ( !$(this).find('.star').hasClass('rate-active') ) {



			$(this).siblings().find('.star').addClass('far').removeClass('fas rate-active');



			$(this).find('.star').addClass('rate-active fas').removeClass('far star-over');



			$(this).prevAll().find('.star').addClass('fas').removeClass('far star-over');



		} else {



			console.log('has');



		}



	});



	



});











          </script>



<script type="text/javascript">







  function showOtherNmae(value){



    



  



    



    if(value =="Other"){



      



      document.getElementById('plantName').style.display = 'block';







      



      



    }else{



      



      document.getElementById('plantName').style.display = 'none';







      



    }



    



  }



    function validateMobileNumber(mobile_number){



        



         $.ajax({url: "validate_user.php", data:{mobile_number:mobile_number},method:"POST",success: function(result){



   



                   if(result == 0){



                       



                        document.getElementById("validationMessage").innerHTML="Mobile Number are Available";



                        



                        document.getElementById('validationMessage').style.color = 'green';



                        



                        document.getElementById("button").disabled = false;



                       



                   }else{



                          document.getElementById("validationMessage").innerHTML="Mobile Number are not Available";



                             document.getElementById('validationMessage').style.color = 'red';



                               document.getElementById("button").disabled = true;



                   }



   



          }});



        



    }







    function setFormValidation(id) {



        $(id).validate({



            highlight: function(element) {



                $(element).closest('.form-group').removeClass('has-success').addClass('has-error');



                $(element).closest('.form-check').removeClass('has-success').addClass('has-error');



            },



            success: function(element) {



                $(element).closest('.form-group').removeClass('has-error').addClass('has-success');



                $(element).closest('.form-check').removeClass('has-error').addClass('has-success');



            },



            errorPlacement: function(error, element) {



                $(element).closest('.form-group').append(error).addClass('has-error');



            },



        });



    }







    $(document).ready(function() {



        document.getElementById("otherName").disabled = true;



        setFormValidation('#RegisterValidation');



    });



</script>



<script type="text/javascript">



    var $table = $('#bootstrap-table');



        $table.bootstrapTable({



            toolbar: ".toolbar",



            clickToSelect: true,



            showRefresh: true,



            search: true,



            showToggle: true,



            showColumns: true,



            pagination: true,



            searchAlign: 'left',



            pageSize: 8,



            clickToSelect: false,



            pageList: [8, 10, 25, 50, 100],







            formatShowingRows: function(pageFrom, pageTo, totalRows) {



                //do nothing here, we don't want to show the text "showing x of y from..."



            },



            formatRecordsPerPage: function(pageNumber) {



                return pageNumber + " rows visible";



            },



            icons: {



                refresh: 'fa fa-refresh',



                toggle: 'fa fa-th-list',



                columns: 'fa fa-columns',



                detailOpen: 'fa fa-plus-circle',



                detailClose: 'fa fa-minus-circle'



            }



        });







        //activate the tooltips after the data table is initialized



        $('[rel="tooltip"]').tooltip();







        $(window).resize(function() {



            $table.bootstrapTable('resetView');



        });



</script>



<script>



    $('.datepicker').datetimepicker({



        format: 'YYYY-MM-DD',



        icons: {



            time: "fa fa-clock-o",



            date: "fa fa-calendar",



            up: "fa fa-chevron-up",



            down: "fa fa-chevron-down",



            previous: 'fa fa-chevron-left',



            next: 'fa fa-chevron-right',



            today: 'fa fa-screenshot',



            clear: 'fa fa-trash',



            close: 'fa fa-remove'



        }



    });



</script>







          



       



</html>