API tools faq
paste
Advertisement
H4T3D

index1.php

H4T3D
Mar 2nd, 2017
176
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.19 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. include 'header.php';
  3. include 'singleans.php';
  4. ?>
  5.  
  6. <!DOCTYPE html>
  7. <html lang="en">
  8.  
  9. <body>
  10.  
  11. <div id="wrapper">
  12.  
  13. <!-- Navigation -->
  14.  
  15. <div id="page-wrapper">
  16. <div class="row">
  17. <div class="col-lg-12">
  18. <h1 class="page-header">Dashboard</h1>
  19. </div>
  20. <!-- /.col-lg-12 -->
  21. </div>
  22. <!-- /.row -->
  23. <div class="row">
  24. <div class="col-lg-3 col-md-6">
  25. <div class="panel panel-primary">
  26. <div class="panel-heading">
  27. <div class="row">
  28. <div class="col-xs-3">
  29. <i class="fa fa-book fa-5x"></i>
  30. </div>
  31. <div class="col-xs-9 text-right">
  32. <div class="huge"><?php echo retun_single_ans("SELECT COUNT(*) FROM journal"); ?></div>
  33. <div>Total Journals</div>
  34. </div>
  35. </div>
  36. </div>
  37. <a href="#">
  38. <div class="panel-footer">
  39. <span class="pull-left">View Details</span>
  40. <span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
  41. <div class="clearfix"></div>
  42. </div>
  43. </a>
  44. </div>
  45. </div>
  46. <div class="col-lg-3 col-md-6">
  47. <div class="panel panel-green">
  48. <div class="panel-heading">
  49. <div class="row">
  50. <div class="col-xs-3">
  51. <i class="fa fa-tasks fa-5x"></i>
  52. </div>
  53. <div class="col-xs-9 text-right">
  54. <div class="huge"><?php echo retun_single_ans("SELECT COUNT(*) FROM volume"); ?></div>
  55. <div>Volume</div>
  56. </div>
  57. </div>
  58. </div>
  59. <a href="#">
  60. <div class="panel-footer">
  61. <span class="pull-left">View Details</span>
  62. <span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
  63. <div class="clearfix"></div>
  64. </div>
  65. </a>
  66. </div>
  67. </div>
  68. <div class="col-lg-3 col-md-6">
  69. <div class="panel panel-yellow">
  70. <div class="panel-heading">
  71. <div class="row">
  72. <div class="col-xs-3">
  73. <i class="fa fa-bookmark fa-5x"></i>
  74. </div>
  75. <div class="col-xs-9 text-right">
  76. <div class="huge"><?php echo retun_single_ans("SELECT COUNT(*) FROM issue"); ?></div>
  77. <div>Issue</div>
  78. </div>
  79. </div>
  80. </div>
  81. <a href="#">
  82. <div class="panel-footer">
  83. <span class="pull-left">View Details</span>
  84. <span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
  85. <div class="clearfix"></div>
  86. </div>
  87. </a>
  88. </div>
  89. </div>
  90. <div class="col-lg-3 col-md-6">
  91. <div class="panel panel-red">
  92. <div class="panel-heading">
  93. <div class="row">
  94. <div class="col-xs-3">
  95. <i class="fa fa-pencil-square-o fa-5x"></i>
  96. </div>
  97. <div class="col-xs-9 text-right">
  98. <div class="huge"><?php echo retun_single_ans("SELECT COUNT(*) FROM re_papers"); ?></div>
  99. <div>Research Paper</div>
  100. </div>
  101. </div>
  102. </div>
  103. <a href="#">
  104. <div class="panel-footer">
  105. <span class="pull-left">View Details</span>
  106. <span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
  107. <div class="clearfix"></div>
  108. </div>
  109. </a>
  110. </div>
  111. </div>
  112. </div>
  113. <!-- /.row -->
  114. <div class="row">
  115. <div class="col-lg-8">
  116. <div class="panel panel-default">
  117. <div class="panel-heading">
  118. <i class="fa fa-bar-chart-o fa-fw"></i> Live Visitors On Website
  119. </div>
  120. <!-- /.panel-heading -->
  121. <div class="panel panel-default">
  122. <!-- /.panel-heading -->
  123. <table width="100%" class="table table-striped table-bordered table-hover" id="dataTables-example">
  124. <thead>
  125. <tr>
  126. <th>Journal #</th>
  127. <th>Title</th>
  128. <th>Established</th>
  129. <th>Total Volumes</th>
  130. <th>Total Issues</th>
  131. <th>Add New Volume</th>
  132. <th>Option</th>
  133. </tr>
  134. </thead>
  135. <tbody>
  136. <?php
  137. $sql = "SELECT DISTINCT journal.jid,journal.j_title,journal.j_online_from,
  138. (SELECT COUNT(*) FROM volume
  139. WHERE volume.j_id = journal.jid) AS volumecount
  140. ,
  141. (SELECT COUNT(*) FROM issue
  142. WHERE issue.v_id = volume.vid) AS issueCount
  143. FROM journal
  144. INNER JOIN volume
  145. ON volume.j_id = journal.jid
  146. ";
  147. $result = $conn->query($sql);
  148.  
  149. if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { ?>
  150.  
  151. <tr class="odd gradeX">
  152. <td><?php echo $row["jid"];?></td>
  153. <td><?php echo $row["j_title"];?></td>
  154. <td><?php echo $row["j_online_from"];?></td>
  155. <td><?php echo $row["volumecount"];?></td>
  156. <td><?php echo $row["issueCount"];?></td>
  157. <td class="center">
  158. <a href="upload_volume_issue.php?jid=<?php echo $row["jid"];?>" data-placement="top" data-toggle="tooltip" title="Delete"><button class="btn btn-warning btn-md" data-title="Add New Article" data-toggle="modal" data-target="#Add new" title="Delete">Add New Article</button>
  159. </td>
  160. <td class="center">
  161. <a href="?delete=<?php echo $row["jid"];?>" data-placement="top" data-toggle="tooltip" title="Delete"><button class="btn btn-danger btn-xs" data-title="Delete" data-toggle="modal" data-target="#delete" title="Delete"><span class="fa fa-trash fa-2x"></span></button>
  162. </a>
  163. <a href="edit_journal.php?jid=<?php echo $row["jid"];?>" data-placement="top" data-toggle="tooltip" title="Delete"><button class="btn btn-info btn-xs" data-title="Edit" data-toggle="modal" data-target="#edit" title="Edit"><span class="fa fa-pencil fa-2x"></span></button>
  164. </a>
  165. </td>
  166. </tr>
  167.  
  168. <?php }}
  169. else{
  170.  
  171. echo '<div class="form-group has-success"><div class="alert alert-success alert-dismissable">
  172. <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Please Add Volume <a href="upload_volume_issue.php" class="alert-link">Add Volume</a>.
  173. </div></div>';
  174. }
  175.  
  176. ?>
  177. </tbody>
  178. </table>
  179. <!-- /.table-responsive -->
  180. <!-- /.panel-body -->
  181. </div>
  182. <!-- /.panel-body -->
  183. </div>
  184. <!-- /.panel -->
  185.  
  186. <!-- /.panel -->
  187.  
  188. <!-- /.panel -->
  189. </div>
  190. <!-- /.col-lg-8 -->
  191. <div class="col-lg-4">
  192. <div class="panel panel-default">
  193. <div class="panel-heading">
  194. <i class="fa fa-bell fa-fw"></i> Notifications Panel
  195. </div>
  196. <!-- /.panel-heading -->
  197. <div class="panel-body">
  198. <script type="text/javascript" src="//rf.revolvermaps.com/0/0/6.js?i=5bskymu1w6i&amp;m=7&amp;s=270&amp;c=e63100&amp;cr1=ffffff&amp;f=arial&amp;l=0&amp;bv=90&amp;lx=-420&amp;ly=420&amp;hi=20&amp;he=7&amp;hc=a8ddff&amp;rs=80" async="async"></script>
  199. <!-- /.list-group -->
  200. </div>
  201. <!-- /.panel-body -->
  202. </div>
  203. <!-- /.panel -->
  204. <!-- /.panel -->
  205. <!-- /.panel .chat-panel -->
  206. </div>
  207. <!-- /.col-lg-4 -->
  208. </div>
  209. <!-- /.row -->
  210.  
  211. <!-- /.col-lg-8 -->
  212. </div>
  213. <!-- /#page-wrapper -->
  214.  
  215. </div>
  216. <!-- /#wrapper -->
  217.  
  218. <!-- jQuery -->
  219.  
  220.  
  221. </body>
  222.  
  223. </html>
  224. <?php
  225. include "footer.php";
  226. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!