SHOW:
|
|
- or go back to the newest paste.
1 | <div class="content_right"> | |
2 | <h2>» Info Pekerjaan Terbaru</h2> | |
3 | <table border='0' width='700'> | |
4 | ||
5 | <?php | |
6 | ||
7 | $per_laman = 7; | |
8 | $laman_sekarang = 1; | |
9 | - | $laman_sekarang = 1; |
9 | + | |
10 | $laman_sekarang = $_GET['laman']; | |
11 | - | $laman_sekarang = $_GET['laman']; |
11 | + | $laman_sekarang = ($laman_sekarang > 1) ? $laman_sekarang : 1; |
12 | - | $laman_sekarang = ($laman_sekarang > 1) ? $laman_sekarang : 1; |
12 | + | |
13 | ||
14 | $total_data = mysql_num_rows(mysql_query("SELECT * FROM lowongan,perusahaan ORDER BY id_lowongan DESC")); | |
15 | ||
16 | $total_laman = ceil($total_data/$per_laman); | |
17 | $awal = ($laman_sekarang - 1) * $per_laman; | |
18 | $akhir= ($laman_sekarang ) * $per_laman; | |
19 | - | $tampil=mysql_query("SELECT * FROM lowongan,perusahaan where lowongan.id_perusahaan=perusahaan.id_perusahaan ORDER BY id_lowongan DESC limit $per_laman OFFSET $awal"); |
19 | + | $tampil=mysql_query("SELECT * FROM lowongan,perusahaan where lowongan.id_perusahaan=perusahaan.id_perusahaan ORDER BY id_lowongan DESC limit $awal, $per_laman ");//OFFSET $awal |
20 | $no=5; | |
21 | while ($r=mysql_fetch_array($tampil)){ | |
22 | $tgl=tgl_indo($r['tgl_lowongan']); | |
23 | ?> | |
24 | <tr><td> | |
25 | <img src="foto_lowongan/<? echo $r['foto'];?>" width='130' height='130' /> | |
26 | <div class='title_perusahaan1'><b><? echo $r['nama_p'];?></b></div> | |
27 | <? echo $tgl;?> - <? echo $r['alamat'];?> | |
28 | <p><? echo substr($r['deskripsi'],0,350);?> <a href='?page=detail_lowongan&id=<? echo$r['id_lowongan'];?>&idp=<?echo$r['id_perusahaan'];?>'> Lihat Selengkapnya >> </a></p> | |
29 | </td></tr> | |
30 | <? | |
31 | } | |
32 | ?> | |
33 | </table> | |
34 | </div> | |
35 | ||
36 | - | <?php if(isset($total_laman)) { ?> |
36 | + | <?php |
37 | - | <?php if($total_laman > 1) { ?> |
37 | + | echo "<p>star:$start => end : $end </p>"; |
38 | ||
39 | if(isset($total_laman)&&$total_laman > 1) { ?> | |
40 | <nav class="text-center"> | |
41 | <ul class="pagination"> | |
42 | - | <a href="index.php?laman=<?php echo $laman_sekarang - 1 ?>" aria-label="Sebelumnya"> |
42 | + | |
43 | <li> | |
44 | <a href="index.php?laman=<?php echo $laman_sekarang - $per_laman ?>" aria-label="Sebelumnya"> | |
45 | <span aria-hidden="true">Sebelumnya</span> | |
46 | </a> | |
47 | </li> | |
48 | <?php }else { ?> | |
49 | <li class="disabled"> | |
50 | <span aria-hidden="true">Sebelumnya</span> | |
51 | - | <?php if($laman_sekarang < $total_laman) {?> |
51 | + | |
52 | <?php } ?> | |
53 | - | <a href="index.php?laman=<?php echo $laman_sekarang + 1 ?>" aria-label="Selanjutnya"> |
53 | + | <?php if($akhir < $total_laman) {?> |
54 | <li> | |
55 | <a href="index.php?laman=<?php echo $laman_sekarang + 1 ?>&page=lowongan" aria-label="Selanjutnya"> | |
56 | <span aria-hidden="true">Selanjutnya</span> | |
57 | </a> | |
58 | </li> | |
59 | <?php }else {?> | |
60 | <li class="disabled"> | |
61 | <span aria-hidden="true">Selanjutnya</span> | |
62 | </li> | |
63 | <?php } ?> | |
64 | - | <?php } ?> |
64 | + | |
65 | - | <?php } ?> |
65 | + | |
66 | <?php } ?> |