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-

Code Editor : readtext.php

<?php

include 'odbc.php';
	$fp  	= fopen($_GET['txt'], "r+");
	$bil 	= 1;
	$tot 	= 0;
	$arr 	= array();
	$arr_t 	= array();
	$arr_n 	= array();
	$t_line = "";
	$arr_l 	= array();
	$comp 	= 0;
	$indnow = 0;

if($_GET['typ']=='companies'){
		while (($line = stream_get_line($fp, 1024 * 1024, "\n")) !== false) {
			$rdline 	= preg_split('/ +/', $line, null, PREG_SPLIT_NO_EMPTY);
			if($bil==1)
				$tot 	= count($rdline);

if($bil==2){
				for ($i=0; $i < $tot ; $i++) { 
					array_push($arr, strlen($rdline[$i])-1);
				}
			}

if($bil>2){
				$tox 	= 0;
				$arr_d 	= array();
				for ($i=0; $i < $tot ; $i++) { 
					array_push($arr_d, substr($line,$tox,$arr[$i]));
					$tox+=$arr[$i];
				}
				$id 	= trim(substr($line,0,11));
				$int_id = (int)$id;
				if(is_numeric($id)){
		  			$xline=$line;
		  			$arr_l[$indnow]=$xline;
					$comp 	= $indnow;
				}else{
					$xline.=$line;
		  			$arr_l[$comp]=$xline;
				}	
				$indnow++;
			}
		  	$bil++;
		}
		fclose($fp);

$sql 	= "INSERT INTO kod_syarikat (nama,alamat,noTel,noFax,idJenisSyarikat,oldid,flagAktif,flagApprove) VALUES ";
		$arx 	= [];
		foreach ($arr_l as $key => $value) {
			$tox 	= 0;
			$arr_d 	= array();
			for ($i=0; $i < $tot ; $i++) { 
				$val 	= strtoupper(substr($value,$tox,$arr[$i]));
				array_push($arr_d, $val);
				$tox+=$arr[$i];
			}

$sql .= "(?,?,?,?,?,?,'Y','Y'),";
				array_push($arx,trim($arr_d[1]));
				array_push($arx,trim($arr_d[2]));
				array_push($arx,trim($arr_d[4]));
				array_push($arx,trim($arr_d[5]));
				array_push($arx,trim($arr_d[6]));
				array_push($arx,trim($arr_d[0]));
		}
	}else if($_GET['typ']=='vessels'){

$sql 	= "INSERT INTO kod_kapal_test (nama,IMO,idSyarikat,Flag,CallSign,idJenisKapal,GT,flagAktif,flagApprove) VALUES ";
		$arx 	= [];
		$fp 	= fopen("vessel2.txt", "r+");
       	// $fp 	= mb_convert_encoding($fp, "UTF-8");
// print_r($fp);
		// mb_convert_encoding($line, "UTF-8");
		while (($line = stream_get_line($fp, 1024 * 1024, "\n")) !== false) {
			// $rdline 	= preg_split("/[|]/i",utf8_decode($line));
			$rdline 	= preg_split("/[|]/i",$line);
// str_split(string)
       // echo ;
			// print_r($rdline);
			// echo "<br>";
			// print_r($rdline);
			if($bil==1)
				$tot 	= count($rdline);

// if($bil>2){
			// 	$tox 	= 0;
			// 	$arr_d 	= array();
			// 	for ($i=0; $i < $tot ; $i++) { 
			// 		array_push($arr_d, substr($line,$tox,$arr[$i]));
			// 		$tox+=$arr[$i];
			// 	}
			// }
			// $arr_d == $rdline;
			print_r($rdline);
			$id 	= trim($rdline[0]);
			if($bil>2 && $id != ''){
				echo $id."<br>";
				$sql .= "(?,?,?,?,?,?,?,'Y','Y'),";
				array_push($arx,trim($rdline[1]));
				array_push($arx,trim($rdline[2]));
				array_push($arx,trim($rdline[3]));
				array_push($arx,trim($rdline[4]));
				array_push($arx,trim($rdline[5]));
				array_push($arx,trim($rdline[6]));
				array_push($arx,trim($rdline[7]));
			}

$bil++;
		}
       // echo mb_detect_encoding(feof($fp));
       // $fp = mb_convert_encoding($fp, "UTF-8");
		    // while(!feof($fp)) {
        // $line = fgets($fp);
       // echo utf8_decode($line);
       // echo $line;
       // echo 'xyz';
       // echo utf8_decode(html_entity_decode($line, ENT_QUOTES, 'UTF-8'));
       // echo html_entity_decode($line, ENT_QUOTES, 'UTF-8');
       // echo "<br>xxxx";
       // echo "<br>";
    // }
		fclose($fp);

}else if($_GET['typ']=='dg'){
		while (($line = stream_get_line($fp, 1024 * 1024, "\n")) !== false) {
			$rdline 	= preg_split('/ +/', $line, null, PREG_SPLIT_NO_EMPTY);
			if($bil==1)
				$tot 	= count($rdline);

if($bil==2){
				for ($i=0; $i < $tot ; $i++) { 
					array_push($arr, strlen($rdline[$i])-1);
				}
			}

$sql 	= "INSERT INTO kod_dg (UNNumber,IMOClass,nama,KPAGroup,properties,flagAktif) VALUES ";
		$arx 	= [];
		foreach ($arr_l as $key => $value) {
			$tox 	= 0;
			$arr_d 	= array();
			for ($i=0; $i < $tot ; $i++) { 
				$val 	= strtoupper(substr($value,$tox,$arr[$i]));
				array_push($arr_d, $val);
				$tox+=$arr[$i];
			}

$sql .= "(?,?,?,?,?,'Y'),";
				array_push($arx,(trim($arr_d[3])=='NULL') ? '' : trim($arr_d[3]));
				array_push($arx,(trim($arr_d[2])=='NULL') ? '' : trim($arr_d[2]));
				array_push($arx,(trim($arr_d[1])=='NULL') ? '' : trim($arr_d[1]));
				array_push($arx,(trim($arr_d[4])=='NULL') ? '' : trim($arr_d[4]));
				array_push($arx,(trim($arr_d[5])=='NULL') ? '' : trim($arr_d[5]));
				// array_push($arx,trim($arr_d[0]));
		}

}else if($_GET['typ']=='vtype'){
		while (($line = stream_get_line($fp, 1024 * 1024, "\n")) !== false) {
			$rdline 	= preg_split('/ +/', $line, null, PREG_SPLIT_NO_EMPTY);
			if($bil==1)
				$tot 	= count($rdline);

if($bil==2){
				for ($i=0; $i < $tot ; $i++) { 
					array_push($arr, strlen($rdline[$i])-1);
				}
			}

$sql 	= "INSERT INTO kod_jenis_kapal (nama,flagAktif,oldid) VALUES ";
		$arx 	= [];
		foreach ($arr_l as $key => $value) {
			$tox 	= 0;
			$arr_d 	= array();
			for ($i=0; $i < $tot ; $i++) { 
				$val 	= strtoupper(substr($value,$tox,$arr[$i]));
				array_push($arr_d, $val);
				$tox+=$arr[$i];
			}

$sql .= "(?,'Y',?),";
				array_push($arx,(trim($arr_d[1])=='NULL') ? '' : trim($arr_d[1]));
				array_push($arx,(trim($arr_d[0])=='NULL') ? '' : trim($arr_d[0]));
		}

print_r($arx);
	}else if($_GET['typ']=='port'){
		while (($line = stream_get_line($fp, 1024 * 1024, "\n")) !== false) {
			$rdline 	= preg_split('/ +/', $line, null, PREG_SPLIT_NO_EMPTY);
			if($bil==1)
				$tot 	= count($rdline);

if($bil==2){
				for ($i=0; $i < $tot ; $i++) { 
					array_push($arr, strlen($rdline[$i])-1);
				}
			}

$sql 	= "INSERT INTO kod_pelabuhan_imp (nama,hadMasa,flagAktif,namaNegara,oldid) VALUES ";
		$arx 	= [];
		foreach ($arr_l as $key => $value) {
			$tox 	= 0;
			$arr_d 	= array();
			for ($i=0; $i < $tot ; $i++) { 
				$val 	= strtoupper(substr($value,$tox,$arr[$i]));
				array_push($arr_d, $val);
				$tox+=$arr[$i];
			}

$sql .= "(?,?,'Y',?,?),";
				array_push($arx,(trim($arr_d[1])=='NULL') ? '' : trim($arr_d[1]));
				array_push($arx,(trim($arr_d[3])=='NULL') ? '' : trim($arr_d[3]));
				array_push($arx,(trim($arr_d[2])=='NULL') ? '' : trim($arr_d[2]));
				array_push($arx,(trim($arr_d[0])=='NULL') ? '' : trim($arr_d[0]));
		}

}

$mysqli->set_charset("utf8");
	$sql 	= substr($sql, 0, -1);
	$types 	= str_repeat('s', count($arx));
	$stmt  			= $mysqli->stmt_init();
	$stmt->prepare($sql);
	$stmt->bind_param($types, ...$arx);
	$stmt->execute() or die(mysqli_error($mysqli));
	$stmt->close();
	echo "DONE!";

${this.title}

Code Editor : readtext.php