Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2015
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 7.22 KB | None | 0 0
  1. <?php session_start();
  2. $uid=$_SESSION["userId"];
  3.  
  4. include("config.php");
  5.  
  6. ?>
  7. <!DOCTYPE html>
  8. <!-- saved from url=(0032)http://localhost/hoh/booked.php# -->
  9. <html lang="en"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  10. <meta charset="UTF-8">
  11. <title>Example of Bootstrap 3 Linked List Groups</title>
  12. <link href="assets/css/bootstrap.min.css" rel="stylesheet" />
  13.  
  14.  
  15. <style type="text/css">
  16.     .bs-example{
  17.         margin: 20px;
  18.     }
  19.     .panel-body {
  20.         margin: 0;
  21.         padding: 0;
  22.     }
  23.  
  24.     .list-group {
  25.         margin:0px;
  26.     }
  27.     .list-group-item {
  28.         background: rgb(246,248,249); /* Old browsers */
  29.         background: -moz-linear-gradient(top, rgba(246,248,249,1) 0%, rgba(229,235,238,1) 50%, rgba(245,247,249,1) 100%); /* FF3.6+ */
  30.         background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,rgba(246,248,249,1)), color-stop(50%,rgba(229,235,238,1)), color-stop(100%,rgba(245,247,249,1))); /* Chrome,Safari4+ */
  31.         background: -webkit-linear-gradient(top, rgba(246,248,249,1) 0%,rgba(229,235,238,1) 50%,rgba(245,247,249,1) 100%); /* Chrome10+,Safari5.1+ */
  32.         background: -o-linear-gradient(top, rgba(246,248,249,1) 0%,rgba(229,235,238,1) 50%,rgba(245,247,249,1) 100%); /* Opera 11.10+ */
  33.         background: -ms-linear-gradient(top, rgba(246,248,249,1) 0%,rgba(229,235,238,1) 50%,rgba(245,247,249,1) 100%); /* IE10+ */
  34.         background: linear-gradient(to bottom, rgba(246,248,249,1) 0%,rgba(229,235,238,1) 50%,rgba(245,247,249,1) 100%); /* W3C */
  35.         filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#f6f8f9', endColorstr='#f5f7f9',GradientType=0 ); /* IE6-9 */
  36.     }
  37.  
  38.     .list-group-item:first-child {
  39.         border-radius: 0px;
  40.     }
  41.  
  42.     .list-group-item time{
  43.         font-weight: bold;
  44.     }
  45.  
  46.     .list-group-item .button {
  47.         border-radius: 100%;
  48.         width: 24px;
  49.         height: 24px;
  50.         padding: 12px;
  51.         float: right;
  52.     }
  53.  
  54.     .list-group-item .button a{
  55.         border-radius: 100%;
  56.         background-color: #999999;
  57.         font-size: 12px;
  58.         width: 24px;
  59.         height: 24px;
  60.         line-height: 24px;
  61.         text-align: center;
  62.         color: #ffffff;
  63.     }
  64.  
  65.     .panel.panel-primary {
  66.         border: none;
  67.     }
  68.  
  69.     .panel.panel-primary .panel-heading.first {
  70.         border-radius: 10px 10px 0px 0px;
  71.     }
  72.  
  73.  
  74.     .panel.panel-primary .panel-body{
  75.         margin: 0;
  76.     }
  77.  
  78.  
  79.     a, a:hover {
  80.         color: #000000;
  81.         text-decoration: none;
  82.     }
  83.     .panel-title a{
  84.         color:#FFF;
  85.         background-color:#FFF;
  86.        
  87.         }
  88. </style>
  89. </head>
  90. <body>
  91. <?php
  92.     $sql="SELECT * FROM `events` JOIN bookedevents using(Eventid) WHERE UserId='$uid'";
  93.     $qr=mysqli_query($connection, $sql);
  94.     while($row=mysqli_fetch_assoc($qr)){
  95.         $starttime=$row['StartingTime'];
  96.        
  97.         $rawdate=$row['StartingDate'];
  98.         $ending=$row['EndingDate'];
  99.         $st=substr($rawdate,0,11);
  100.         $day=date('l',strtotime($rawdate));
  101.         $stime=substr($starttime,12,19);
  102.         $etime=substr($ending,12,19);
  103.    
  104.        
  105.         ?>
  106. <div class="bs-example">
  107. <div class="panel panel-primary">
  108.    
  109.         <div class="panel-heading first">
  110.             <h2 class="panel-title"><time datetime="2015-10-18"><?php $rawdate; echo $day.' '.$st ;?></time></h2>
  111.         </div>
  112.         <?php
  113.        
  114.         $sql1="SELECT * FROM `events` JOIN bookedevents using(Eventid) WHERE UserId='$uid' AND StartingDate='$rawdate'";
  115.         $qr2=mysqli_query($connection, $sql1);
  116.         while($row2=mysqli_fetch_array($qr2)){
  117.            
  118.            
  119.         ?>
  120.        
  121.         <div class="panel-body">
  122.             <ul class="list-group">
  123.                 <li href="#" class="list-group-item">
  124.                     <div class="row">
  125.                         <div class="col-xs-11">
  126.                             <a href="#">
  127.                                 <time datetime="2011-01-12 17:00"><?php echo $row2['StartingTime']; ?></time> - <time datetime="2011-01-12 18:50"><?php echo $row2['EndingTime'] ;?></time>
  128.                                 <h4 class="list-group-item-heading"><?php echo $row2['EventDescription'];?></h4>
  129.                             </a>
  130.                         </div>
  131.                         <div class="col-xs-1 button">
  132.                             <a href="#" class="pull-right"><span class="glyphicon glyphicon-chevron-right"> </span></a>
  133.                         </div>
  134.                     </div>
  135.                 </li>
  136.             </ul>
  137.         </div>
  138.         </div>
  139.         </div>
  140.        
  141.      <?php } } ?>
  142.            
  143.                     <div class="panel panel-primary navbar-fixed-bottom ">
  144.     <div class="panel-heading">
  145.    
  146.         <a href="#">    <h2 class="panel-title  text-center">Back</h2></a>
  147.         </div></div>
  148.        
  149.    
  150. </div>
  151.         </div>
  152.  
  153.     </div>
  154.     <script src="js/jquery.js"></script>
  155.     <script src="js/bootstrap.js"></script>
  156.     <script src="js/fullcalendar.js"></script>
  157.     <script src="js/gcal.js"></script>
  158.     <script src="js/jquery-ui.js"></script>
  159.     <script src="js/jquery.calendar.js"></script>
  160.     <script src="lib/colorpicker/bootstrap-colorpicker.js"></script>
  161.     <script src="lib/validation/jquery.validationEngine.js"></script>
  162.     <script src="lib/validation/jquery.validationEngine-en.js"></script>
  163.    
  164.     <script src="lib/timepicker/jquery-ui-sliderAccess.js"></script>
  165.     <script src="lib/timepicker/jquery-ui-timepicker-addon.min.js"></script>
  166.    
  167.   <script type="text/javascript" src="assets/js/color.js"></script>
  168.      <script type="text/javascript" src="assets/js/lib/jquery-1.11.min.js"></script>
  169.      <script type="text/javascript" src="assets/js/bootstrap.min.js"></script>
  170.      <script type="text/javascript" src="assets/js/multipleAccordion.js"></script>
  171.  
  172.      <!--easing Library Script Start -->
  173.      <script src="assets/js/lib/jquery.easing.js"></script>
  174.      <!--easing Library Script End -->
  175.  
  176.      <!--Nano Scroll Script Start -->
  177.      <script src="assets/js/jquery.nanoscroller.min.js"></script>
  178.      <!--Nano Scroll Script End -->
  179.  
  180.      <!--switchery Script Start -->
  181.      <script src="assets/js/switchery.min.js"></script>
  182.      <!--switchery Script End -->
  183.  
  184.      <!--bootstrap switch Button Script Start-->
  185.      <script src="assets/js/bootstrap-switch.js"></script>
  186.      <!--bootstrap switch Button Script End-->
  187.  
  188.      <!--easypie Library Script Start -->
  189.      <script src="assets/js/jquery.easypiechart.min.js"></script>
  190.      <!--easypie Library Script Start -->
  191.  
  192.      <!--bootstrap-progressbar Library script Start-->
  193.      <script src="assets/js/bootstrap-progressbar.min.js"></script>
  194.      <!--bootstrap-progressbar Library script End-->
  195.  
  196.      <script type="text/javascript" src="assets/js/pages/layout.js"></script>
  197.      <!--Layout Script End -->
  198.  
  199.      <!--Profile Plugin Start-->
  200.      <script src="assets/js/chart/jquery.sparkline.js"></script>
  201.      <script src="assets/js/chart/morris.min.js"></script>
  202.      <script src="assets/js/chart/raphael-min.js"></script>
  203.      <script src="assets/js/selectize.min.js"></script>
  204.      <script src="assets/js/jquery.circliful.min.js"></script>
  205.  
  206.      <!--Tab Library Script Start -->
  207.      <script type="text/javascript" src="../maps.google.com/maps/api/js_3deadd9e.js"></script>
  208.      <script type="text/javascript" src="assets/js/jquery.gomap-1.3.2.min.js"></script>
  209.  
  210.      <!--Tab Library Script End -->
  211.      <!--Note Library Script Start-->
  212.      <script src="assets/js/slip.js"></script>
  213.      <!--Note Library Script End-->
  214.  
  215.      <!--Profile Plugin Finish-->
  216.      <script type="text/javascript" src="assets/js/lightGallery.js"></script>
  217.      <!--Profile Plugin Call Start-->
  218.      <script src="assets/js/pages/demo.profile.js"></script>
  219. </body>
  220. </html
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement