Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
app_download.php	1.6 KB	-rw-rw-rw-
app_print.php	22.28 KB	-rw-rw-rw-
app_print_230312.php	21.87 KB	-rw-rw-rw-
app_report.php	7 B	-rw-rw-rw-
application.php	13.23 KB	-rw-rw-rw-
application_1.php	5.59 KB	-rw-rw-rw-
audit_trail_1.php	4.23 KB	-rw-rw-rw-
bill.pdf	1.78 KB	-rw-rw-rw-
declaration.php	13.92 KB	-rw-rw-rw-
declaration_1.php	2.35 KB	-rw-rw-rw-
declaration_2.php	2.34 KB	-rw-rw-rw-
declaration_3.php	2.06 KB	-rw-rw-rw-
declaration_4.php	1.93 KB	-rw-rw-rw-
declaration_5.php	2 KB	-rw-rw-rw-
declaration_6.php	2.05 KB	-rw-rw-rw-
declaration_7.php	2.25 KB	-rw-rw-rw-
declaration_8.php	2.57 KB	-rw-rw-rw-
declaration_9.php	123.3 KB	-rw-rw-rw-
declaration_f.php	515 B	-rw-rw-rw-
declaration_prt.php	1.49 KB	-rw-rw-rw-
print_report.php	3.21 KB	-rw-rw-rw-
site_1.php	3 KB	-rw-rw-rw-
site_2.php	3.5 KB	-rw-rw-rw-
user.php	5.95 KB	-rw-rw-rw-
user_1.php	2.38 KB	-rw-rw-rw-

Code Editor : site_2.php

<?php 
	
	$path 			= $_POST['idu'];

$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT *,DATE_FORMAT(tarikhVisit,'%d-%m-%Y') AS tarikhVisit FROM visit_main WHERE idVisitMain=?");
		$stmt->bind_param("s",$visit_main = $path);
		$stmt->execute();
		$result 		= $stmt->get_result();
		$stmt->close();

$session 	= array();
		$row=$result->fetch_assoc();

$idMarineFacility 	= $row['idMarineFacility'];
		$flagStatus 		= $row['flagStatus'];
		$tarikhVisit 		= $row['tarikhVisit'];

?>
<?php echo "<h4 style='color:#454e;margin-bottom:0px'><strong><i class='gi gi-user'></i>&nbsp;&nbsp;<span style='border-bottom:5px double #ccc'>Site Visit</span></strong></h4>"; ?>
<hr>
				<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover">
					<tbody>
						<tr>
							<td style="border:none">Terminal Name</td>
							<td style="border:none">:</td>
							<td style="border:none">
							<?php 
								$sqlx 	= "SELECT * FROM kod_marine_facility WHERE flagAktif = 'Y' AND idMarineFacility = '{$idMarineFacility}' ORDER BY nama";
								$rstx 	= $mysqli->query($sqlx) or die(mysqli_error($mysqli));
								$bb 	= $rstx->fetch_assoc();
								echo strtoupper($bb['nama']);
							?>
							</td>
						</tr>
						<tr>
							<td style="border:none">Date</td>
							<td style="border:none">:</td>
							<td style="border:none"><?php echo $tarikhVisit;?></td>
						</tr>
						<tr>
							<td style="border:none">Status</td>
							<td style="border:none">:</td>
							<td style="border:none"><?php echo $flagStatus;?></td>
						</tr>
					</tbody>
				</table>
<?php

$stmt  			= $mysqli->stmt_init();
		$stmt->prepare("SELECT 
							a.*
						FROM 
							visit_detail a 
						WHERE 
							a.idVisitMain=?
						");
		$stmt->bind_param("s",$idVisitMain = $path);
		$stmt->execute();

if ($stmt->error)
    		print_r('error executing statement: ' . $stmt->error);

$result2 		= $stmt->get_result();
		$stmt->close();

?>
<?php echo "<h4 style='color:#454e;margin-bottom:0px'><strong><i class='gi gi-user'></i>&nbsp;&nbsp;<span style='border-bottom:5px double #ccc'>Finding</span></strong></h4>"; ?>
<hr>

<table id="example-datatable" class="table table-striped table-bordered table-condensed table-vcenter table-hover">
					<thead>
						<tr>
							<th class="text-center" style="width: 5%;">NO</th>
							<th style="width: 50%;">FINDING</th>
							<th style="width: 45%;">RESPONSE</th>
						</tr>
					</thead>
					<tbody>
					<?php

$i=1;
						while($aa = $result2->fetch_assoc()){

$editdata = "finding#{$aa['finding']}|"
										."response#{$aa['response']}|"
										."val-id#{$aa['idVisitDetail']}";
					
							$stmt  			= $mysqli->stmt_init();
							$stmt->prepare("SELECT
												a.*
											FROM 
												visit_lampiran a 
											WHERE 
												a.idVisitDetail=?
											");
							$stmt->bind_param("s",$idVisitDetail = $aa['idVisitDetail']);
							$stmt->execute();

if ($stmt->error)
					    		print_r('error executing statement: ' . $stmt->error);

$result3 		= $stmt->get_result();
							$stmt->close();

?>
						<tr>
							<td class="align-top text-center"><?php echo $i++; ?></td>
							<td class="align-top"><?php echo $aa['finding']?></td>
							<td class="align-top"><?php echo $aa['response']?></td>
						</tr>
					<?php }mysqli_free_result($resKod); ?>
					</tbody>
				</table>

${this.title}

Code Editor : site_2.php