Advertisement
qrioky

phploops

Jul 19th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.08 KB | None | 0 0
  1. $requestbooking = "SELECT * FROM requests INNER JOIN users ON requests.id = users.id WHERE requests.review=0 AND requests.booking=1";
  2. $requestbookingresults = mysqli_query($db,$requestbooking);                        
  3. <?php while($fetchrequests = mysqli_fetch_assoc($requestbookingresults)){
  4.                             $phpdate = strtotime( $fetchrequests['requeston'] );
  5.                             $fetchrequests['requeston'] = date( 'd-m-Y H:i:s', $phpdate );
  6.                             echo '<div class="row">
  7.                            <div class="card blue darken-1 hoverable">
  8.                            <div class="card-content white-text">
  9.                            <span class="card-title">Requested by: ' .$fetchrequests['name']. ' </span>
  10.                            <p>Request on: '.$fetchrequests['requeston'].'</p>
  11.                            <p>Description: '.$fetchrequests['subject'].'</p>
  12.                            <p>Capacity: '.$fetchrequests['capacity'].' ppl</p>
  13.                            <p>Most preferred: '.$fetchrequests['most'].' </p>
  14.                            <p>Least preffered: '.$fetchrequests['least'].'</p>
  15.                            <p>Date: '.$fetchrequests['dateofclass'].'</p>
  16.                            <p>From '.$fetchrequests['startfrom'].' to '.$fetchrequests['until'].'</p>
  17.                            <p id="'.$fetchrequests['ref'].'">Reference: '.$fetchrequests['ref'].' </p>
  18.                            </div>
  19.                            <form class="" action="adminpanel.php" method="post">
  20.                            <input type="hidden" name="ref" value="'.$fetchrequests['ref'].'">
  21.                            <div class="card-action blue-grey lighten-4 z-depth-2">
  22.                            <button type="submit" class="btn" name="approvereq">APPROVE</button>
  23.                            <button type="submit" class="btn" name="declinereq">DECLINE</button>
  24.                            </div>
  25.                            </form>
  26.                            </div>
  27.                            </div>';
  28.                         } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement