One Hat Cyber Team

Your IP : 108.162.241.210

Server IP : 188.114.97.4

Server : Linux thuru 6.5.11-4-pve #1 SMP PREEMPT_DYNAMIC PMX 6.5.11-4 (2023-11-20T10:19Z) x86_64

Server Software : Apache/2.4.51 (Unix) OpenSSL/1.0.2k-fips

PHP Version : 7.3.33

Buat File | Buat Folder

Dir : ~/home/thuruk/public_html/App/New/admin/dashboard/

Edit File: create_csv_plant.php

<?php session_start();?>

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

<?php

$upload_status="";
	
	if(isset($_POST['submit'])) {
     
                // Define file details
          $fileName = $_FILES['file']['name'];
          $fileTmpName = $_FILES['file']['tmp_name'];
          $fileType = $_FILES['file']['type'];

// Check if file is a CSV
          if($fileType !== 'text/csv') {
            die("Error: Please upload a CSV file.");
          }

// Open file and read data
          $file = fopen($fileTmpName, "r");

// Skip the first row (header)
          fgetcsv($file);

// Loop through data and insert into database
          while (($data = fgetcsv($file, 1000, ",")) !== FALSE) {

if($data[0]!=""){
              
                    try {
                        
                        // Escape data to prevent SQL injection
                        $qr = mysqli_real_escape_string($connect, $data[0]);
                        $mobile = mysqli_real_escape_string($connect, $data[1]);
                        $name = mysqli_real_escape_string($connect, $data[2]);
                        $description = mysqli_real_escape_string($connect, $data[3]);
                        $created_date = mysqli_real_escape_string($connect, $data[4]);  
                      
                        $location = mysqli_real_escape_string($connect, $data[5]);
                        $lat = mysqli_real_escape_string($connect, $data[6]);  
                        $lng = mysqli_real_escape_string($connect, $data[7]);
                        $height = mysqli_real_escape_string($connect, $data[8]);
                         $image = mysqli_real_escape_string($connect, $data[9]);
                      
                       // $base64Image = mysqli_real_escape_string($connect, $data[9]);
                        
                      	$currentDate = date('Y-m-d');

$date = DateTime::createFromFormat('m/d/Y', $created_date);
	
                        // Format the date to the desired format 'Y-m-d'
                       	$formattedDate = $date->format('Y-m-d');

// Upload base64 image
                      /*  
                        // Remove the "data:image/png;base64," part from the base64 string
                        $base64Image = str_replace('data:image/png;base64,', '', $base64Image);

// Decode the base64 string
                        $imageData = base64_decode($base64Image);

$target_dir = "../../Images/Plant/";
                        
                        // Generate a unique filename for the image
                        $filename = uniqid() . '.jpg';

// Specify the file path where you want to save the image
                        $filepath = $target_dir . $filename;

// Save the image to the specified file path
                        file_put_contents($filepath, $imageData);

// Check if the image was saved successfully
                        if (file_exists($filepath)) {
                            echo 'Image uploaded successfully.';
                        } else {
                            echo 'Image upload failed.';
                        }

$url = "https://thurukepakaru.com/App/New/Images/Plant/".$filename;*/

// Query to check if user ID exists in database
                        $sql_count = "SELECT COUNT(*) as count FROM newuser_plants WHERE user_plant_id = '$qr'";
                        
                        $result_COUNT = mysqli_query($connect, $sql_count);

$row = mysqli_fetch_assoc($result_COUNT);
                        $count = $row['count'];
                        
                        if ($count == 0) {
                        
                                        // Insert data into database
                            $sql = "INSERT INTO `newuser_plants`(`user_plant_id`, `user_id`, `plant_name`, `plant_description`, `created_date`, `plant_image`, `location`, `height`, `lat`, `lng`, `created_type`,`rating`,`status`) VALUES ('$qr','$mobile','$name','$description','$formattedDate','$image','$location','$height','$lat','$lng','admin','','activate')";

if(mysqli_query($connect, $sql)) {

//  echo "Record added successfully.<br>";

$upload_status="success";

} else {

//  echo "Error: " . mysqli_error($connect) . "<br>";

$upload_status="fail";

}
                        
                        }

} catch (Exception $e) {
                        
                        $upload_status="fail";
                        }
            }

}

// Close file and database connection
          fclose($file);
          mysqli_close($connect);

}
?>

<!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' />
    <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" />
    
    <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>

</head>

<body>

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

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

<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>';

}

?>
					     <form id="RegisterValidation" enctype="multipart/form-data" method="post">
                              
                                  <div class="card ">
                                       <div class="card-header ">
										<h5 class="card-title">Add your plant CSV file</h5>
                                       </div>
                                       <div class="card-body ">
                                         <div class="row">
                                               <div class="form-group has-label col-md-6">
                                                   <label class="pb-1">
                                                   CSV
                                                   <star class="star">*</star>

</label>
                                                   <input type="file" class="form-control "  name="file" accept=".csv"  />
                                               </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="submit" class="btn btn-info btn-fill pull-right" id="button">SUBMIT</button>
                                           <div class="clearfix"></div>
                                       </div>

</div>

</form>

</div>

</div>
            </div>
            <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 Foreve
                        </p>
                    </nav>
                </div>
            </footer>
        </div>
    </div>
</body>

</html>

<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>
<script src="assets/js/plugins/bootstrap-switch.js"></script>

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

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

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

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

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

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

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

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

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

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