Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
backup	[ DIR ]	drwxrwxrwx
css	[ DIR ]	drwxrwxrwx
dashboard	[ DIR ]	drwxrwxrwx
edg	[ DIR ]	drwxrwxrwx
extension	[ DIR ]	drwxrwxrwx
img	[ DIR ]	drwxrwxrwx
inc	[ DIR ]	drwxrwxrwx
js	[ DIR ]	drwxrwxrwx
kod	[ DIR ]	drwxrwxrwx
patch	[ DIR ]	drwxrwxrwx
pdf	[ DIR ]	drwxrwxrwx
reports	[ DIR ]	drwxrwxrwx
upload	[ DIR ]	drwxrwxrwx
utility	[ DIR ]	drwxrwxrwx
vendor	[ DIR ]	drwxrwxrwx
.htaccess.backup	1.24 KB	-rw-rw-rw-
!test.php	17 B	-rw-rw-rw-
MalaysiaBooks.php	3.67 KB	-rw-rw-rw-
Nota14102020.docx	22.8 KB	-rw-rw-rw-
access.php	268 B	-rw-rw-rw-
access2.php	245 B	-rw-rw-rw-
account_recovery.php	8.4 KB	-rw-rw-rw-
account_recovery_test.php	6.3 KB	-rw-rw-rw-
ajax.php	4.02 KB	-rw-rw-rw-
banner.php	73.61 KB	-rw-rw-rw-
company_search.php	8.38 KB	-rw-rw-rw-
composer.json	1.5 KB	-rw-rw-rw-
composer.lock	173.77 KB	-rw-rw-rw-
ctype.txt	266 B	-rw-rw-rw-
custom.css	3.7 KB	-rw-rw-rw-
custom.js	9.88 KB	-rw-rw-rw-
custom200630.js	6.46 KB	-rw-rw-rw-
custom_200630.css	1.04 KB	-rw-rw-rw-
custom_200705.js	6.82 KB	-rw-rw-rw-
dashboard.php	5.71 KB	-rw-rw-rw-
dashboard_old.php	51 B	-rw-rw-rw-
dbedgpens.sql	3.85 MB	-rw-rw-rw-
dglist.php	3.97 KB	-rw-rw-rw-
dgweb-dg.txt	2.65 MB	-rw-rw-rw-
dgweb.xls	297.5 KB	-rw-rw-rw-
err_404.php	75 B	-rw-rw-rw-
f_declaration.php	515 B	-rw-rw-rw-
frame.php	1.46 KB	-rw-rw-rw-
gip.php	1.51 KB	-rw-rw-rw-
gip1.php	7 B	-rw-rw-rw-
imp_data.php	2.03 KB	-rw-rw-rw-
index_footer.php	138 B	-rw-rw-rw-
index_head.php	663 B	-rw-rw-rw-
index_search.php	667 B	-rw-rw-rw-
ins_composer.php	417 B	-rw-rw-rw-
ktn-pens-companies.txt	330.12 KB	-rw-rw-rw-
ktn-pens-port.txt	602.81 KB	-rw-rw-rw-
ktn-pens-vessel.txt	6.12 MB	-rw-rw-rw-
ktn-pens-vtype.txt	353 B	-rw-rw-rw-
login.php	12.14 KB	-rw-rw-rw-
login_200704.php	9.81 KB	-rw-rw-rw-
main.php	644 B	-rw-rw-rw-
nota.txt	120 B	-rw-rw-rw-
odbc.php	24.03 KB	-rw-rw-rw-
odbc_test.php	15.24 KB	-rw-rw-rw-
readtext.php	7.99 KB	-rw-rw-rw-
recover_msg.php	806 B	-rw-rw-rw-
registration.php	27.31 KB	-rw-rw-rw-
registration_2.php	12.94 KB	-rw-rw-rw-
registration_submit.php	6.85 KB	-rw-rw-rw-
reset_password.php	9.55 KB	-rw-rw-rw-
self_register.php	14.58 KB	-rw-rw-rw-
self_register_230312.php	14.57 KB	-rw-rw-rw-
sessions.php	2.78 KB	-rw-rw-rw-
sessions_200705.php	1.4 KB	-rw-rw-rw-
sessions_200721.php	1.75 KB	-rw-rw-rw-
test.php	11.8 KB	-rw-rw-rw-
test_sess.php	1.35 KB	-rw-rw-rw-
testedg.txt	7 B	-rw-rw-rw-
testing.txt	7 B	-rw-rw-rw-
testinput.php	6.7 KB	-rw-rw-rw-
testx.php	4 B	-rw-rw-rw-
user.php	160.56 KB	-r--r--r--
vessel.txt	498.07 KB	-rw-rw-rw-
vessel2.txt	249.04 KB	-rw-rw-rw-
zzz	11 B	-rw-rw-rw-
zzz.txt	249.04 KB	-rw-rw-rw-
~$ta14102020.docx	162 B	-rw-rw-rw-
~WRL0738.tmp	23.29 KB	-rw-rw-rw-

Name

Size

Permission

Action

backup

[ DIR ]

drwxrwxrwx

css

[ DIR ]

drwxrwxrwx

dashboard

[ DIR ]

drwxrwxrwx

edg

[ DIR ]

drwxrwxrwx

extension

[ DIR ]

drwxrwxrwx

img

[ DIR ]

drwxrwxrwx

inc

[ DIR ]

drwxrwxrwx

[ DIR ]

drwxrwxrwx

kod

[ DIR ]

drwxrwxrwx

patch

[ DIR ]

drwxrwxrwx

pdf

[ DIR ]

drwxrwxrwx

reports

[ DIR ]

drwxrwxrwx

upload

[ DIR ]

drwxrwxrwx

utility

[ DIR ]

drwxrwxrwx

vendor

[ DIR ]

drwxrwxrwx

.htaccess.backup

1.24 KB

-rw-rw-rw-

!test.php

17 B

-rw-rw-rw-

MalaysiaBooks.php

3.67 KB

-rw-rw-rw-

Nota14102020.docx

22.8 KB

-rw-rw-rw-

access.php

268 B

-rw-rw-rw-

access2.php

245 B

-rw-rw-rw-

account_recovery.php

8.4 KB

-rw-rw-rw-

account_recovery_test.php

6.3 KB

-rw-rw-rw-

ajax.php

4.02 KB

-rw-rw-rw-

banner.php

73.61 KB

-rw-rw-rw-

company_search.php

8.38 KB

-rw-rw-rw-

composer.json

1.5 KB

-rw-rw-rw-

composer.lock

173.77 KB

-rw-rw-rw-

ctype.txt

266 B

-rw-rw-rw-

custom.css

3.7 KB

-rw-rw-rw-

custom.js

9.88 KB

-rw-rw-rw-

custom200630.js

6.46 KB

-rw-rw-rw-

custom_200630.css

1.04 KB

-rw-rw-rw-

custom_200705.js

6.82 KB

-rw-rw-rw-

dashboard.php

5.71 KB

-rw-rw-rw-

dashboard_old.php

51 B

-rw-rw-rw-

dbedgpens.sql

3.85 MB

-rw-rw-rw-

dglist.php

3.97 KB

-rw-rw-rw-

dgweb-dg.txt

2.65 MB

-rw-rw-rw-

dgweb.xls

297.5 KB

-rw-rw-rw-

err_404.php

75 B

-rw-rw-rw-

f_declaration.php

515 B

-rw-rw-rw-

frame.php

1.46 KB

-rw-rw-rw-

gip.php

1.51 KB

-rw-rw-rw-

gip1.php

7 B

-rw-rw-rw-

imp_data.php

2.03 KB

-rw-rw-rw-

index_footer.php

138 B

-rw-rw-rw-

index_head.php

663 B

-rw-rw-rw-

index_search.php

667 B

-rw-rw-rw-

ins_composer.php

417 B

-rw-rw-rw-

ktn-pens-companies.txt

330.12 KB

-rw-rw-rw-

ktn-pens-port.txt

602.81 KB

-rw-rw-rw-

ktn-pens-vessel.txt

6.12 MB

-rw-rw-rw-

ktn-pens-vtype.txt

353 B

-rw-rw-rw-

12.14 KB

-rw-rw-rw-

login_200704.php

9.81 KB

-rw-rw-rw-

main.php

644 B

-rw-rw-rw-

nota.txt

120 B

-rw-rw-rw-

odbc.php

24.03 KB

-rw-rw-rw-

odbc_test.php

15.24 KB

-rw-rw-rw-

readtext.php

7.99 KB

-rw-rw-rw-

recover_msg.php

806 B

-rw-rw-rw-

registration.php

27.31 KB

-rw-rw-rw-

registration_2.php

12.94 KB

-rw-rw-rw-

registration_submit.php

6.85 KB

-rw-rw-rw-

reset_password.php

9.55 KB

-rw-rw-rw-

self_register.php

14.58 KB

-rw-rw-rw-

self_register_230312.php

14.57 KB

-rw-rw-rw-

sessions.php

2.78 KB

-rw-rw-rw-

sessions_200705.php

1.4 KB

-rw-rw-rw-

sessions_200721.php

1.75 KB

-rw-rw-rw-

test.php

11.8 KB

-rw-rw-rw-

test_sess.php

1.35 KB

-rw-rw-rw-

testedg.txt

7 B

-rw-rw-rw-

testing.txt

7 B

-rw-rw-rw-

testinput.php

6.7 KB

-rw-rw-rw-

testx.php

4 B

-rw-rw-rw-

user.php

160.56 KB

-r--r--r--

vessel.txt

498.07 KB

-rw-rw-rw-

vessel2.txt

249.04 KB

-rw-rw-rw-

zzz

11 B

-rw-rw-rw-

zzz.txt

249.04 KB

-rw-rw-rw-

~$ta14102020.docx

162 B

-rw-rw-rw-

~WRL0738.tmp

23.29 KB

-rw-rw-rw-

Code Editor : 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);
	// }
				}
			}
		// }
	// }
?>

${this.title}

Code Editor : imp_data.php