SHOW:
|
|
- or go back to the newest paste.
| 1 | // MOdel | |
| 2 | public function getComenForum($id){
| |
| 3 | ||
| 4 | - | $query = self::getDB()->prepare("SELECT * FROM komentar WHERE id_forum='$id' ");
|
| 4 | + | $query = self::getDB()->prepare("select count(*) from komentar WHERE id_forum='$id' ");
|
| 5 | //("SELECT * FROM komentar WHERE id_forum='$id' ");
| |
| 6 | - | return $query->rowCount(); |
| 6 | + | |
| 7 | $row= $query->fetch(); | |
| 8 | return $row; | |
| 9 | } | |
| 10 | //Controller | |
| 11 | function forum(){
| |
| 12 | session_start(); | |
| 13 | if(isset($_SESSION['username'])){
| |
| 14 | if($_SESSION['hak_akses']=="user"){
| |
| 15 | @$viewModel['comen']= m_user::getComenDepan(); | |
| 16 | @$viewModel['pagging']= m_user::Pagging(); | |
| 17 | $halaman=$_GET['id']; | |
| 18 | @$viewModel['foto']= m_user::DataFoto(); | |
| 19 | @$viewModel['forum']= m_user::getForum($halaman); | |
| 20 | $this->RenderUser($viewModel); | |
| 21 | }else{
| |
| 22 | echo "admin tidak boleh mengakses user"; | |
| 23 | } | |
| 24 | }else{
| |
| 25 | echo "tidak boleh mengakses"; | |
| 26 | } | |
| 27 | } | |
| 28 | //View | |
| 29 | <div class="row"> | |
| 30 | <?php | |
| 31 | foreach($viewModel['forum'] as $row){ ?>
| |
| 32 | <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 forum-item radius-xs"> | |
| 33 | <div class="col-lg-12 forum-text"> | |
| 34 | <img src="<?php echo $row['file'];?>" width="200"class="img-responsive forum-photo" alt="" style='float: left;'> | |
| 35 | <div class="textcontent"> | |
| 36 | <a href="user/viewForum/<?php echo $row['id_forum'];?>" class="title"><?php echo $row['judul'];?></a><br/> | |
| 37 | <p class="mini-desc"> | |
| 38 | <?php echo $row['deskripsi'];?> | |
| 39 | </p> | |
| 40 | <div class="text-left"> | |
| 41 | <mark><?php echo $row['nama'];?></mark> | |
| 42 | <mark><i class="fa fa-eye fa-1x"></i> 12</mark> <mark><i class="fa fa-comments fa-1x"></i> <?php echo $viewModel['comen']; | |
| 43 | ?></mark> | |
| 44 | <mark class="user-info"><?php echo $row['username'];?>, <?php echo $row['tanggal'];?></mark> | |
| 45 | </div> | |
| 46 | </div> | |
| 47 | </div> | |
| 48 | </div> | |
| 49 | <?php } ?> |
