Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- in class.crud.php
- public function dataview($query,$userid)
- {
- $stmt = $this->db->prepare($query);
- $stmt->execute();
- if($stmt->rowCount()>0)
- {
- while($row=$stmt->fetch(PDO::FETCH_ASSOC))
- {
- ?>
- <!-- VIEW STARTS HERE-->
- <div class="panel panel-default">
- <div class="panel-heading">#<?php print($row['quote_id']); ?>
- <?php
- if ($userid==$row['quote_user_id']) {
- print(' <a class="editbutton" href="index.php?page=edit_quote&edit_id='.$row['quote_id'].'"><i class="glyphicon glyphicon-pencil"></i></a>');
- print(' <a class="deletebutton" href="index.php?page=delete_quote&delete_id='.$row['quote_id'].'>"><i class="glyphicon glyphicon-remove"></i></a>');
- }
- ?>
- </div>
- <div class="panel-body">
- <?php print( nl2br($row['quote_content']) ); ?>
- </div>
- <?php $username = $this->getUsername( $row['quote_user_id'] ); ?>
- <div class="panel-footer">
- <small>Posted by <a href="index.php?page=view_by_user&user=<?php print($row['quote_user_id']); ?>"><?php print($username); ?></a>, on <cite title="Source Title"><?php print($row['quote_date']); ?></cite></small>
- </div>
- </div>
- <?php
- }
- }
- else
- {
- ?>
- <p>Nothing here...</p>
- <?php
- }
- }
- En verder in de viewquote.php
- <div class="content-wrapper">
- <div class="container">
- <div class="row">
- <div class="col-md-12">
- <h4 class="page-head-line">Quotes!</h4>
- </div>
- </div>
- <div class="row">
- <div class="col-md-12">
- <?php
- $userid = $userRow['user_id'];
- $query = "SELECT * FROM tbl_quotes ORDER BY quote_id DESC";
- $records_per_page=10;
- $newquery = $crud->paging($query,$records_per_page);
- $crud->dataview($newquery,$userid);
- ?>
- </div>
- </div>
- <div class="row">
- <div class="col-md-12">
- <table class='table table-striped'>
- <tr>
- <td colspan="7" align="center">
- <div class="pagination-wrap">
- <?php $crud->paginglink($query,$records_per_page); ?>
- </div>
- </td>
- </tr>
- </table>
- </div>
- </div>
- </div>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment