Misalnya ada 3 combo box untuk meilih mata pelajaran(data didapat dari database), yaitu mata pelajaran 1, mata pelajaran 2 dan mata pelajaran 3. Jika di combo box untuk mata pelajaran 1 dipilih Matematika, maka di combo box mata pelajaran 2 dan mata pelajaran 3 tidak ada Matematika nya. Jika di combo box mata pelajaran 2 dipilih Fisika maka di combo box mata pelajaran 3 tidak ada Matematika dan Fisikanya, begitu seterusnya.

Lihat semua 1 jawaban

Silahkan login untuk menjawab!
misal gan:
http://localhost/coba/clean-url/member/member.php?page=paging&p=20

dibkin:
http://localhost/coba/clean-url/member/paging/20

Lihat semua 2 jawaban

Silahkan login untuk menjawab!
om,ada referensi tentang konsep sistem absensi mahasiswa tidak ? trima ksi.

Lihat semua 1 jawaban

Silahkan login untuk menjawab!
bagaimana menganalisa keamanan web?
Silahkan login untuk menjawab!
Dear suhu-suhu Sangkep sekalian..

Ada yang mau ditanyain nih..
Gw disuruh bikin export to excel dari mysql tapi lewat php dengan susunan tabel dan isi tabel seperti dibawah ini:

|| NIK || NAMA || tanggal awal || .... || ..... || tanggal akhir || Total ||
|| || ||absen| telat || ..|..||..|....|| absen | telat || ||
||A-1 || Abdi || 8.45| 00.15 || ..|..||..|....|| 9.00 | 00.30 || 02.00 ||


Gw udah kepikiran buat bikin kodingan kayak gini
<table align="center" border="1" cellpadding="5" cellspacing="0">
	<tr>
		<th rowspan=2><font size="2" face="Arial">NIK</font></th>
		<th rowspan=2><font size="2" face="Arial">Name</font></th>
		
<?php
date_default_timezone_set('Asia/Jakarta');
$begindate = '2013-03-25';
$enddate = '2013-03-29';

$q= "SELECT DISTINCT tanggal FROM absen WHERE tanggal BETWEEN '$begindate' AND'$enddate' AND DAYOFWEEK(tanggal)NOT IN(1,7)";
$query1 = mysql_query($q) or die(mysql_error());
$count = mysql_num_rows($query1);
while ($fetch = mysql_fetch_row($query1)){
		$tanggal = $fetch['0'];
		?><th colspan=2><font size="2" face="Arial"><?php echo $tanggal;?></font></th><?php 
}?>
	<th rowspan=2><font size="2" face="Arial">Total telat</font></th>
	</tr>
	<tr>
<?php
while ($count>0){
	echo '<th><font size="2" face="Arial">Masuk</font></th>';
	echo '<th><font size="2" face="Arial">Telat</font></th>';
	$count--;
}?>
	</tr>
<?php

$cquery = "SELECT nik,fname,lname FROM staff ORDER BY fname ASC";
$result = mysql_query($cquery) or die(mysql_error());

while($row1= mysql_fetch_array($result))
	{
	$nik = $row1['nik'];
	
	echo "<tr>";
	echo "<td><font size='2' face='Arial'>" . $row1['nik'] . "</font></td>";
	echo "<td><font size='2' face='Arial'>" . $row1['fname']." ".$row1['lname']. "</font></td>";
	
	$q2 = "SELECT checkin, telat2, checkout,ket,rank FROM absen WHERE nik = '$nik' AND tanggal BETWEEN '$begindate' AND '$enddate' AND DAYOFWEEK(tanggal)NOT IN(1,7) ";
	$result1 = mysql_query($q2) or die(mysql_error());
		
	while($row2 = mysql_fetch_row($result1)){
		$checkin = $row2['0'];
		$telat2 = $row2['1'];
		$checkout = $row2['2'];
		$ket = $row2['3'];
		$rank = $row2['4'];
		
		if (empty($rank) && isset($ket) ){
			echo "<td><font size='2' face='Arial'> </font></td>";
			echo "<td><font size='2' face='Arial'> </font></td>";}
		elseif(($checkout=='00:00:00'&&$checkin=='00:00:00')){
			echo "<td><font size='2' face='Arial'> </font></td>";
			echo "<td><font size='2' face='Arial'> </font></td>";}
		elseif(empty($rank)){}
		elseif(empty($ket)&&$rank !== ''){
			echo "<td><font size='2' face='Arial'>" . date('H:i', strtotime($row2['0'])) . "</font></td>";
			echo "<td><font size='2' face='Arial'>" . $row2['1'] . "</font></td>";}
			}}?>
	 </tr>
</table>

Tapi ada masalah lain yang muncul, satu NIK dalam satu hari bisa absen berkali2, nah gimana caranya gw mensortir itu dan hanya memasukkan record yang pertama saja..

Terima kasih sebelumnya...

Lihat semua 2 jawaban

Silahkan login untuk menjawab!
halo all, ada yg bs bantu decode file berikut, thank's...
<?php 
$o="QAAAOzh3b3cnJycKDSgtJ0FodQAAcmonSnJrc25qYmNuZidCYwAAcmxmdG4ncHBwKSdhaHVqckAEawDwKWh1KW5jJ2RqdCkBTAoNAAEnLSdHZGh3fnVuYG9zDkQApQAGJy9ELic1NzY0J0RKVAaBBKMnAABId2JpJ1RocnVkYisnTmlkAgApJ0ZraycD0nQndWJ0YnVxYiAAYykFc2tuZGJpdGIODkBJUicAEkBiaWJ1ZmsnV3JlAYAnSwHDJwAAcWJ1dG5oaSc1J2h1J2tmcwAAYnU8J3RiYidLTkRCSVRCKRAAc39zBNJGdW4nVXJ0amZpc2gAACdmdW5iZHJ3ckd+amZuaykQAGRoagJCQWZyfWZpJ0YnSmZvAShmaWZpbidhASIpagEERw/vLSgKAAANCg1uaWRrcmNiJyVsaGlhCghuYHJ1E1AoAMBibHRuKRcAJTwKIRANIwPWOiA2IAEQdGJ0C7FYdHNmCAB1cy8uASBuYScvJm50dGJzLwAAI1hUQlRUTkhJXCBzYmpmcAAQYmUgWi4ufAoNDiMBATpqfnQAAHZrWHZyYnV+LyVUQktCRFOAABigQVVISiclKSNDRVhMSENCEBEpJVgC0SdQT0JVQicGgHNydAfRRAAlBtEOI3UEZGFic2RvWGZ1dWY8AH4vBeIB8wOxB4A6JyN1XCBpZmpmijsE0iBaPCPRDgofIFo6A+IDQAzAehGBAEEBACgoYmRvaCcDCE9TU1dYUlRCAcBVWEZAQklTBSAUIA+wYW5rYlhiAV1/bnRzdC8lANEoCDEoA6cA8QXgWgGCjjIVgi4uJxFBE58TkXJ1awLgE4UOIwxBdAHiYmxoa2ZvNQ+0FB8UHSsAYGZzHSBpjvIUdG5jWAFHFOcF8HQFZRUaB2kVkg4jCZA6AGAjaXQ1XCBudG4E6BCiDg5uYS8BAHRyZXRzdS8CoSsnNysnMC4nAAg6Oiclb3Nzdz0oKCUPYw4nIwBEdFRuc2JSdWsnGmBydWsXgA4OB316Ymt0YhFhBK8Eq3QEuATPBMIE2QbZIAikO4cgKQoxArQp0A4fcgeaCjUrJyo2DGMMDwwC+PYClQTiDFcHeQDGKSAoNDEO0AdRIicgEFAfQjq4AAK2JwUBCXA6RmZjam5pd2ZpYmsoDvhmd2tuTwElEgBRd0QxJaIDYSV/JXFtYmkJ8m1maWAlh21zJO84/zjyI6ck72ZpJOA+QwsgOdMOI21tBWQk6m1zLjxbwA44CQkWf986A1AlTwMCEBAlgEX/RfMxZA03aQ0/Ri9GIw0/Mhx18DANNgVVDSppDSAOHGw+kQlGatAAMDonamN95DJJ8A4PNVRTYANxOgJ/O9ENsB0hDiMCdDU6gQ8jUVVRQlVcIEkOKSUlKQKVA2NY51xkHx0gWicGowUFCGQCl1/wc2JpPhACsAwAJzoxVwFzC+01PzN6EBEm7ybhZGhobG5idAwA3W5f4kZwYiGES89Lz2lLz2IBRSbgPxm2BVUZu2LE/w1kCFQ6I2IMH1o8C9EpCQLkD4gBJAKiKKBe8MAAcxU42G10KHNvYmpidChlZnRiB74obmpmYADAAHM5NTxfazxbAp4Yc0FAPfFm5hB5URlgAm9oaQFwAmZmc2Z0AkU4OQoNB4w7ZWhjfgCBk9QIdmpvSVxzewNqaDwn04EEUQRwKASLCg1OcmwxckIlO281OVMD8A07J2Via5mQjOB0mXE7KAGAhEFx0HMpEBQwx78FEQFwc2prCXAFoAmUnW9jnW+dby1UitCeopDinf+db29znW+iAp1vJ51vnW+db51vnW+db51vnW+db5gAnW9uKQ/mnWA4OQ==";eval(base64_decode("JGxsbD0wO2V2YWwoYmFzZTY0X2RlY29kZSgiSkd4c2JHeHNiR3hzYkd4c1BTZGlZWE5sTmpSZlpHVmpiMlJsSnpzPSIpKTskbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd3OUoyOXlaQ2M3IikpOyRsbGxsPTA7JGxsbGxsPTM7ZXZhbCgkbGxsbGxsbGxsbGwoIkpHdzlKR3hzYkd4c2JHeHNiR3hzS0NSdktUcz0iKSk7JGxsbGxsbGw9MDskbGxsbGxsPSgkbGxsbGxsbGxsbCgkbFsxXSk8PDgpKyRsbGxsbGxsbGxsKCRsWzJdKTtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JHdzlKM04wY214bGJpYzciKSk7JGxsbGxsbGxsbD0xNjskbGxsbGxsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGxsbGxsbGwoJGwpOyl7aWYoJGxsbGxsbGxsbD09MCl7JGxsbGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsbGxsbCs9JGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTskbGxsbGxsbGxsPTE2O31pZigkbGxsbGxsJjB4ODAwMCl7JGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8NCk7JGxsbCs9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbF0pPj40KTtpZigkbGxsKXskbGw9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSkmMHgwZikrMztmb3IoJGxsbGw9MDskbGxsbDwkbGw7JGxsbGwrKykkbGxsbGxsbGxbJGxsbGxsbGwrJGxsbGxdPSRsbGxsbGxsbFskbGxsbGxsbC0kbGxsKyRsbGxsXTskbGxsbGxsbCs9JGxsO31lbHNleyRsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsKz0kbGxsbGxsbGxsbCgkbFskbGxsbGwrK10pKzE2O2ZvcigkbGxsbD0wOyRsbGxsPCRsbDskbGxsbGxsbGxbJGxsbGxsbGwrJGxsbGwrK109JGxsbGxsbGxsbGwoJGxbJGxsbGxsXSkpOyRsbGxsbCsrOyRsbGxsbGxsKz0kbGw7fX1lbHNlJGxsbGxsbGxsWyRsbGxsbGxsKytdPSRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSk7JGxsbGxsbDw8PTE7JGxsbGxsbGxsbC0tO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JEMG5ZMmh5SnpzPSIpKTskbGxsbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkQwaVB5SXVKR3hzYkd4c2JHeHNiR3hzYkNnMk1pazciKSk7JGxsbGxsbGxsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGw7KXskbGxsbGxsbGxsbC49JGxsbGxsbGxsbGxsbCgkbGxsbGxsbGxbJGxsbGxsKytdXjB4MDcpO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkM0OUpHeHNiR3hzYkd4c2JHd3VKR3hzYkd4c2JHeHNiR3hzYkNnMk1Da3VJajhpT3c9PSIpKTtldmFsKCRsbGxsbGxsbGwpOw=="));return;?>



<?php  
$o="QAIAOzh3b3cnABAKDSgtJ0FodXIAAGonSnJrc25qYmNuZidCY3IAAGxmdG4ncHBwKSdhaHVqcmuACADwKWh1KW5jJ2RqdCkBTAoNJwACLSdHZGh3fnVuYG9zDkQApScADC9ELic1NzY0J0RKVAaBBKMnSAAAd2JpJ1RocnVkYisnTmlkKQQAJ0ZraycD0nQndWJ0YnVxYmNAACkFc2tuZGJpdGIODkBJUidAACRiaWJ1ZmsnV3JlAYAnSwHDJ3EAAGJ1dG5oaSc1J2h1J2tmc2IAAHU8J3RiYidLTkRCSVRCKXMgAH9zBNJGdW4nVXJ0amZpc2gnAABmdW5iZHJ3ckd+amZuaylkIABoagJCQWZyfWZpJ0YnSmZvZgJQaWZpbidhASIpagEERw/vLSgKDQERCg1hcmlkcwhxYWhoCDAvLnwFEAAAYmRvaCdlZnRiMTNYY2JkaAACY2IvI1hUQlRUTkhJXCACoyACEFouPCcKDQGIc2JqdwyBdCBaOgAAJWY1MT9hNzU0YTBmY2I+MwAAMDU2PzIyNGFhYzVlMTRmPwICMyU8Cg16B/h0bmNiZWZ1CAIjAABwYmV0Ymxoa2ZvOiBXQElrAABlaVVrZG0zP15pTixXQEJgAABjQEF+XTVRN1dUTWFean9vAABlanRuTkBvfl1QXj5Oam83AABjT0YxS34+NGM0ZHJlVDZrAABdT1F1Xl9Jd0tpY2tebjJ3AABdRD9uV21/d2VQZGBeaj5+AAFdQFF+V1ROcE5uRX1kakoESAIBPzdLak1wAEB0ZTVjfWRAPgEAAABJcWVUP3NdT2NAYkA+bFJBAABeMmNQZHFRT0VKZUFjRV1CACA+flFCbHFWUkFFAEREVEI3cQAAUjdRQUlPXUVlT2R9YlJScQAAZH1CNUpDRnFlQD5pZX4ycAAIZWpkbk5PY3ddT1VoCMB/SVNAQEYNQEF0Y0M3bmMMoEtqN3NdUAAAVTZmNUF9ZlQyNF1QTnJmUEAIVgwAf3FdfkVpY19NNgwAN2ZfAABVdF1TN25TUFFsZlBCYFJABABRcl1AawDAc29lbk5xV21wcQCAXlMzSURtf24VQlRFN15fTWkAAF1fVj5Oaz5uZUBBcmZ+TmAAAGZPTWtdbTduZk9VN2RDaHEmAUs1EwBqdBUPFQROT1V3Y0B/axlAAABWY1BNdGZQc29kNWxgVl9NQCQ3AMBrZURFVl1QMgiAVXcMQHJOgBAdAGZQNmlOT0l+Xn0GiH1Ocl4QAGlGch2AcV00SXBlNFZyXjU+AABzS342U2Q0SVNdQ2NUVENFAABDVFQ+UkptSUJSNWtySU9NcABqAQAXBQCATWFjfj99VDVJV1Y0AABJSVNQcDJlfj59Sm1GcEs0AAZJNl5qNndjRDJpZlBeIIARAj8hqEs1JoY6Cg0gKfAwby8pqC4CICgodCA8YnQ8UVh0c2Z1cy8BQTEYLUEwwCA2negE4Sd6MuAAMEvPZkvPS89NCjowLUvPYG9z/bdLzwSiS89Lz0vPS88nS89Lz0lLz0vPbkvPS89Lz+QAXOIP4UvCODlMIQ==";eval(base64_decode("JGxsbD0wO2V2YWwoYmFzZTY0X2RlY29kZSgiSkd4c2JHeHNiR3hzYkd4c1BTZGlZWE5sTmpSZlpHVmpiMlJsSnpzPSIpKTskbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd3OUoyOXlaQ2M3IikpOyRsbGxsPTA7JGxsbGxsPTM7ZXZhbCgkbGxsbGxsbGxsbGwoIkpHdzlKR3hzYkd4c2JHeHNiR3hzS0NSdktUcz0iKSk7JGxsbGxsbGw9MDskbGxsbGxsPSgkbGxsbGxsbGxsbCgkbFsxXSk8PDgpKyRsbGxsbGxsbGxsKCRsWzJdKTtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JHdzlKM04wY214bGJpYzciKSk7JGxsbGxsbGxsbD0xNjskbGxsbGxsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGxsbGxsbGwoJGwpOyl7aWYoJGxsbGxsbGxsbD09MCl7JGxsbGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsbGxsbCs9JGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTskbGxsbGxsbGxsPTE2O31pZigkbGxsbGxsJjB4ODAwMCl7JGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8NCk7JGxsbCs9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbF0pPj40KTtpZigkbGxsKXskbGw9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSkmMHgwZikrMztmb3IoJGxsbGw9MDskbGxsbDwkbGw7JGxsbGwrKykkbGxsbGxsbGxbJGxsbGxsbGwrJGxsbGxdPSRsbGxsbGxsbFskbGxsbGxsbC0kbGxsKyRsbGxsXTskbGxsbGxsbCs9JGxsO31lbHNleyRsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsKz0kbGxsbGxsbGxsbCgkbFskbGxsbGwrK10pKzE2O2ZvcigkbGxsbD0wOyRsbGxsPCRsbDskbGxsbGxsbGxbJGxsbGxsbGwrJGxsbGwrK109JGxsbGxsbGxsbGwoJGxbJGxsbGxsXSkpOyRsbGxsbCsrOyRsbGxsbGxsKz0kbGw7fX1lbHNlJGxsbGxsbGxsWyRsbGxsbGxsKytdPSRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSk7JGxsbGxsbDw8PTE7JGxsbGxsbGxsbC0tO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JEMG5ZMmh5SnpzPSIpKTskbGxsbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkQwaVB5SXVKR3hzYkd4c2JHeHNiR3hzYkNnMk1pazciKSk7JGxsbGxsbGxsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGw7KXskbGxsbGxsbGxsbC49JGxsbGxsbGxsbGxsbCgkbGxsbGxsbGxbJGxsbGxsKytdXjB4MDcpO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkM0OUpHeHNiR3hzYkd4c2JHd3VKR3hzYkd4c2JHeHNiR3hzYkNnMk1Da3VJajhpT3c9PSIpKTtldmFsKCRsbGxsbGxsbGwpOw=="));return;?>



<?php    
//include "adminpanel/map.php";
function formulasi(){
 $formula="UG93ZXJlZCBieSA8YSBocmVmPSJodHRwOi8vY21zLmZvcm11bGFzaS5vci5pZC8iIHRhcmdldD0iX2JsYW5rIj5Gb3JtdWxhc2kgRnJlZSBPcGVuc291cmNlIENNUzwvYT4gfCA8YSBocmVmPSJodHRwOi8vd3d3LnBhbmppbWVkaWEuY29tL2xheWFuYW4vcHJvZHVrLXdlYnNpdGUtc2Vrb2xhaC1tdXJhaC8iIHRhcmdldD0iX2JsYW5rIj5Ib3N0aW5nIFNla29sYWg8L2E+PC9kaXY+DQoJCQk8ZGl2IGNsYXNzPSJmX2thbmFuIj48YSBocmVmPSJpbmRleC5waHAiPkhvbWU8L2E+IHwgPGEgaHJlZj0iP3A9cHNiIj5Qc2IgT25saW5lPC9hPiB8IDxhIGhyZWY9ImVsZWFybmluZ2t1LyI+RS1sZWFybmluZzwvYT4gPC9kaXY+";

 
    echo base64_decode($formula);

}
/*
    <?php    
    $str = 'Powered by <a href="http://www.google.com/" target="_blank">google</a> | <a href="http://www.google.com" target="_blank">google</a>';
    echo base64_encode($str);
	$codex=base64_encode($str);
    ?> 

<br>ini<br>
*/
?>

Silahkan login untuk menjawab!