$sqlb = mysql_query("SELECT \r\n\tCOUNT(id_upload) as 'M',\r\n\tCOUNT(IF(jenis_rev=0,1,null)) as 'Q',\r\n COUNT(IF(jenis_rev=1,1,null)) as 'R',\r\n COUNT(IF(hasil='0',1,null)) as 'S',\r\n COUNT(IF(hasil=1,1,null)) as 'T' \r\n \tfrom upload_mhs, review_praoutline WHERE id=id_upload and id_upload='{$result['id_upload']}'"); $row = mysql_fetch_array($sqlb); $status = $result['status_review'] == "1" ? "Opened" : "Closed"; $tgl_indo = tgli($result['A']); $cetaknm = nama($result['NIM']); echo "\r\n <td align='center'><img src='../images/show.jpg'></td>\r\n <td><a href='recent1.php?mode=rep&id_jud={$result['id']}#bottom'>{$result['judul_praoutline']}</a></td>\r\n <td align='center'>{$row['M']}</td>\r\n <td align='center'>{$row['R']}<br><br>Y : <font color=#01016F><b>{$row['T']}</b></font> -- N : <font color=#FA0303><b>{$row['S']}</b></font></td>\r\n <td width='14%'>\r\n Oleh : <font color=#583000><b>{$result['NIM']}</b></font><br><font color=#072dba><b>{$cetaknm}</b></font><br>\r\n Tanggal : {$tgl_indo}<br>\r\n Waktu : {$result['B']}<br>\r\n Status : <font color=#7BC409><b>{$status}</b></font>\r\n </td>\r\n <td width='2%'><a name='{$no}'><a href='#'><img src='images/top.gif'></a></a></td>\r\n </tr>"; $no++; } echo "\r\n <tr colspan='6'>\r\n\r\n </tr>"; echo "</table>"; } else { $sqld = "SELECT DISTINCT(id_upload) as 'new', \r\n\tjudul_praoutline, \r\n\tNIM, status_review, \r\n upload_mhs.tanggal as 'A',\r\n upload_mhs.waktu as 'B', \r\n\tCOUNT(id_upload) as 'M',\r\n\tCOUNT(IF(jenis_rev=0,1,null)) as 'Q',\r\n COUNT(IF(jenis_rev=1,1,null)) as 'R',\r\n COUNT(IF(hasil='0',1,null)) as 'S',\r\n COUNT(IF(hasil=1,1,null)) as 'T'\r\n\tFROM review_praoutline, upload_mhs \r\n\tWHERE id_upload NOT IN (SELECT id_upload FROM review_praoutline, upload_mhs WHERE id=id_upload and jenis_rev='1' and reviewer='{$initid}' ORDER by id_upload) \r\n\tand id=id_upload \r\n\tand status_review='1' GROUP by new"; $hasild = mysql_query($sqld); //$jum = mysql_num_rows($hasil); $no = 1; while ($resultd = mysql_fetch_array($hasild)) { $status = $resultd['status_review'] == "1" ? "Opened" : "Closed"; $tgl_indo = tgli($resultd['A']); $cetaknm = nama($resultd['NIM']); echo "\r\n <td align='center'><img src='../images/show.jpg'></td>\r\n <td><a href='recent1.php?mode=nodes&id_jud={$resultd['new']}'>{$resultd['judul_praoutline']}</a></td>\r\n <td align='center'>{$resultd['M']}</td>\r\n <td align='center'>{$resultd['R']}<br><br>Y : <font color=#01016F><b>{$resultd['T']}</b></font> -- N : <font color=#FA0303><b>{$resultd['S']}</b></font></td>\r\n <td width='14%'>\r\n Oleh : <font color=#583000><b>{$resultd['NIM']}</b></font><br><font color=#072dba><b>{$cetaknm}</b></font><br>\r\n Tanggal : {$tgl_indo}<br>\r\n Waktu : {$resultd['B']}<br>\r\n Status : <font color=#7BC409><b>{$status}</b></font>\r\n </td>\r\n <td width='2%'><a name='{$no}'><a href='#'><img src='images/top.gif'></a></a></td>\r\n </tr>"; $no++; } echo "\r\n <tr colspan='6'>\r\n\r\n </tr>"; echo "</table>"; } } ?> </body> </html>
function perkalian($k1, $k2) { // ini fungsi tanpa return echo "hasil perkalian {$k1} x {$k2} = " . $k1 * $k2; } function nama($nama) { $ket = ""; if ($nama == "Dicky") { $ket = "Kamu Pasti Sedang Praktikum {$nama}"; } else { $ket = "Saya tidak kenal kamu {$nama}"; } return $ket; } $k1 = 2; $k2 = 5; perkalian($k1, $k2); echo "<br>"; echo "10 + 7 = " . penjumlahan(10, 7) . "<br>"; $nama = "Dicky"; echo nama($nama); echo "<br>"; echo 'hasil dari 5 - 3 = ' . pengurangan(); echo "<br>"; $b1 = 15; $b2 = 3; echo "hasil dari {$b1} : {$b2} = " . pembagian($b1, $b2); ?> </body> </html>