One Hat Cyber Team

Your IP : 172.16.0.254

Server IP : 58.26.163.33

Server : Windows NT DGPENSV2LPKMN 10.0 build 14393 (Windows Server 2016) AMD64

Server Software : Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25

PHP Version : 7.3.25

Buat File | Buat Folder

Dir : C:/xampp7/htdocs/edgpens_220704/

Edit File: imp_data.php

<?php

require 'extension/PhpSpreadsheet-master/src/PhpSpreadsheet/Spreadsheet.php';
	require 'extension/PhpSpreadsheet-master/src/PhpSpreadsheet/Reader/BaseReader.php';
	require 'extension/PhpSpreadsheet-master/src/PhpSpreadsheet/Reader/Csv.php';
	require 'extension/PhpSpreadsheet-master/src/PhpSpreadsheet/Reader/Xls.php';
	
	use PhpOffice\PhpSpreadsheet\Spreadsheet;
	use PhpOffice\PhpSpreadsheet\Reader\BaseReader;
	use PhpOffice\PhpSpreadsheet\Reader\Csv;
	use PhpOffice\PhpSpreadsheet\Reader\Xls;

$conn = mysqli_connect("localhost","root","","mbsgn");

$conn = new mysqli("127.0.0.1:3307", "root", "12qwaszx", "dbedgpens");
	if ($mysqli->connect_errno) {
		echo "Failed to connect to MySQL: (" . $mysqli_link->connect_errno . ") " . $mysqli_link->connect_error;
		exit();
	}
	
	// if (isset($_POST['submit'])) {
	
		$file_mimes = array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'application/x-csv', 'text/x-csv', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel', 'text/plain', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
		
		// if(isset($_FILES['file']['name']) && in_array($_FILES['file']['type'], $file_mimes)) {
		
			$arr_file = explode('.', $_FILES['file']['name']);
			$extension = end($arr_file);
		
			if('csv' == $extension) {
				$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
			} else {
				$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xls();
			}
	
			$spreadsheet = $reader->load("dgweb.xls");
	
			$sheetData = $spreadsheet->getSheetByName('Vessel')->toArray();
			
			if (!empty($sheetData)) {
				for ($i=1; $i<count($sheetData); $i++) {
					$name = $sheetData[$i][0];
					$email = $sheetData[$i][1];
	$sql = "INSERT INTO USERS(name, email) VALUES('$name', '$email')";

// if (mysqli_query($conn, $sql)) {
	// echo "New record created successfully";
	// } else {
	// echo "Error: " . $sql . "<br>" . mysqli_error($conn);
	// }
				}
			}
		// }
	// }
?>