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 : user_1.php

<?php 
	
	$combx1 	= "";

if(!empty($idRoles)){ 
		$combx1 			.= " AND idRoles = '{$idRoles}' ";
		$param_data['p1'] 	= $idRoles;
	}else{
		$combx1 			.= " AND idRoles != '5' ";
		$param_data 		= array();
	}

$sqly 		= "	SELECT 
						* 
					FROM 
						user_roles
					WHERE 1=1 
					{$combx1}
				";
	$result3 	= mysqli_prepare_all($sqly,$param_type = "auto",$param_data);
	$y=1;
	while($bb = $result3->fetch_assoc()){
	if($y!=1)
		echo "<hr>";

$param_data2 	= array(
							"idRoles" 	=> $bb['idRoles']
						 	);

if(!empty($uname)){ 
			$combx2 			.= " AND a.nameUser LIKE ? ";
			$param_data2['p2'] 	= "%{$uname}%";
		}
		// print_r($param_data2);
		$sqlx 		= "	SELECT 
							a.*,
							b.nama AS nama_syarikat
						FROM 
							user_list a
						LEFT JOIN 
							kod_syarikat b ON b.idSyarikat = a.idSyarikat
						WHERE 1=1 
						AND a.idRoles = ? 
						{$combx2}
						ORDER BY a.nameUser ASC
					";
		$result2 	= mysqli_prepare_all($sqlx,$param_type = "auto",$param_data2);
	
	echo "<h3 style='color:#454e'><strong><i class='gi gi-user'></i>&nbsp;&nbsp;<span style='border-bottom:5px double #ccc'>".strtoupper($bb['nama'])."</span></strong></h3>";

?>


<table id="" class="table table-striped table-bordered table-condensed table-vcenter table-hover no_add_delete example-datatable">
	<thead>
		<tr>
			<th class="text-center no_sorting" style="width: 40px;width: 5%">No.</th>
			<th class="text-left" style="width: 30%">Name</th>
			<th class="text-left" style="width: 300px !important;width: 25%">Company</th>
			<th class="text-left" style="width: 150px !important;width: 25%">Email</th>
			<th class="text-left" style="width: 150px !important;width: 15%">Phone No.</th>
		</tr>
	</thead>
	<tbody>
	<?php

$i=1;
		while($aa = $result2->fetch_assoc()){
	?>
		<tr class="<?php echo $tr_class;?>">
			<td class="align-top text-right"><?php echo $i++; ?>.</td>
			<td class="align-top text-left"><?php echo strtoupper($aa['nameUser']);?></td>
			<td class="align-top text-left"><?php echo strtoupper($aa['nama_syarikat']);?></td>
			<td class="align-top text-left"><?php echo strtoupper($aa['emailUser']);?></td>
			<td class="align-top text-left"><?php echo strtoupper($aa['mobileNo']);?></td>
		</tr>
	<?php } ?>
	</tbody>
</table>
<?php $y++;} ?>

${this.title}

Code Editor : user_1.php