API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 30th, 2016
136
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.18 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $servername = "localhost";
  3. $username = "taylor";
  4. $password = "t@Yl0r_G6Ng";
  5. $dbname = "firaga";
  6.  
  7.  
  8. // Create connection
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10. // Check connection
  11. if ($conn->connect_error) {
  12. die("Connection failed: " . $conn->connect_error);
  13. }
  14.  
  15. // Create connection
  16. $conn = new mysqli($servername, $username, $password, $dbname);
  17. // Check connection
  18. if ($conn->connect_error) {
  19. die("Connection failed: " . $conn->connect_error);
  20. }
  21.  
  22. $vshort = $_GET['v'];
  23.  
  24.  
  25. $sql = "SELECT id, title, docs, user, sub1, label1, sub2, label2, thumbnail, reg_date, description FROM Videos WHERE id='$vshort'";
  26.  
  27. $result = $conn->query($sql);
  28.  
  29. if ($result->num_rows > 0) {
  30. // output data of each row
  31. while($row = $result->fetch_assoc()) {
  32. $v = $row["id"];
  33. $docs = $row["docs"];
  34. $user = $row["user"];
  35. $title = $row["title"];
  36. $poster = $row["thumbnail"];
  37. $description = $row["description"];
  38. $uploadDate = $row["reg_date"];
  39. $sub1 = $row["sub1"];
  40. $label1 = $row["label1"];
  41. $sub2 = $row["sub2"];
  42. $label2 = $row["label2"];
  43.  
  44. }
  45. } else {
  46. echo "0 results";
  47. }
  48. $conn->close();
  49. ?>
  50.  
  51. <!DOCTYPE html>
  52. <html lang="en">
  53. <head>
  54. <meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
  55. <meta content="IE=edge" http-equiv="X-UA-Compatible" />
  56. <meta content="width=device-width, initial-scale=1" name="viewport" />
  57. <link rel="icon" href="http://i.imgur.com/Hm7oHfv.gif" type="image/gif" sizes="16x16">
  58. <title> <?php echo $title; ?> </title>
  59. <meta content="Source code generated using layoutit.com" name="description" />
  60. <meta content="LayoutIt!" name="author" />
  61. <link href="https://fonts.googleapis.com/css?family=Merriweather|Domine|Roboto|PT+Sans" rel="stylesheet" type="text/css" />
  62. <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet" />
  63. <link href="/css/fireshell.css" rel="stylesheet" />
  64. <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css" rel="stylesheet" />
  65. </head>
  66. <body>
  67. <div class="container-fluid">
  68. <div class="row">
  69. <div class="col-md-9">
  70. <nav class="navbar-inverse navbar-default navbar-fixed-top" role="navigation">
  71. <div class="navbar-header"><button class="navbar-toggle" data-target="#bs-example-navbar-collapse-1" data-toggle="collapse" type="button"><span class="sr-only">Toggle navigation</span><i class="fa fa-arrow-circle-down" aria-hidden="true"></i></button><a class="navbar-brand" href="#">Firaga</a></div>
  72.  
  73. <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
  74. <ul class="nav navbar-nav">
  75. <li class="dropdown"><a class="dropdown-toggle" data-toggle="dropdown" href="#"><i class="fa fa-home" aria-hidden="true"></i> Menu</a>
  76. <ul class="dropdown-menu">
  77. <li><a href="#"><i class="fa fa-home" aria-hidden="true"></i> Home</a></li>
  78. <li><a href="#"><i class="fa fa-user" aria-hidden="true"></i> My Channel</a></li>
  79. <li><a href="#"><i class="fa fa-history" aria-hidden="true"></i> History</a></li>
  80. <li class="divider"></li>
  81. <li><a href="#"><i class="fa fa-cog" aria-hidden="true"></i> Settings</a></li>
  82. <li><a href="#"><i class="fa fa-question-circle" aria-hidden="true"></i> Help</a></li>
  83. </ul>
  84. </li>
  85. </ul>
  86.  
  87. <form class="navbar-form navbar-left" role="search">
  88. <div class="form-group"><input class="form-control" placeholder="search" type="text" /></div>
  89. <button class="btn btn-default" type="submit"><i class="fa fa-search" aria-hidden="true"></i></button></form>
  90.  
  91. <ul class="nav navbar-nav navbar-right">
  92. <li><a href="/upload/">Upload</a></li>
  93. <li class="dropdown"><a class="dropdown-toggle accountDropdown" data-toggle="dropdown" href="#"><i class="fa fa-user" aria-hidden="true"></i> Account</a>
  94. <ul class="dropdown-menu">
  95. <li><a href="#">Bio</a></li>
  96. <li><a href="#">Video Manager</a></li>
  97. <li><a href="#">Notifications</a></li>
  98. <li class="divider"></li>
  99. <li><a href="#">Logout</a></li>
  100. </ul>
  101. </li>
  102. </ul>
  103. </div>
  104. </nav>
  105.  
  106. <h3 class="text-left"> <?php echo $title; ?> </h3>
  107.  
  108. <div class="wrapper">
  109. <div class="h_iframe"><!-- a transparent image is preferable --><img class="ratio" src="http://placehold.it/16x9" /><iframe allowfullscreen="true" id="videoPlayer" mozallowfullscreen="true"
  110.  
  111. <?php
  112.  
  113. echo 'src="/embed?v=' .$vshort. '&autoplay=true';
  114. ?>"
  115.  
  116. webkitallowfullscreen="true"></iframe></div>
  117.  
  118. </div>
  119. <img class="userthumb" src="http://i.imgur.com/WnPGKhY.png" style="
  120. max-width: 40px;
  121. " /> <label id="uploaderName"> Uploaded by <?php echo $user; ?> </label>
  122.  
  123. <div class="tabbable" id="tabs-405767">
  124. <ul class="nav nav-tabs">
  125. <li class="active"><a data-toggle="tab" href="#panel-705234">Description</a></li>
  126. <li><a data-toggle="tab" href="#panel-195991">Share</a></li>
  127. </ul>
  128.  
  129. <div class="tab-content">
  130. <div class="tab-pane active" id="panel-705234">
  131. <p class="uploadDate"> <?php echo $uploadDate; ?> <p>
  132. <p> <?php echo $description; ?> </p>
  133. </div>
  134.  
  135. <div class="tab-pane" id="panel-195991">
  136. <p>Embed Link: <a href="http://vidya.ga:8000/embed?v=<?php echo $vshort; ?>"> http://vidya.ga:8000/embed?v=<?php echo $vshort; ?> </a>
  137.  
  138. </p>
  139. </div>
  140. </div>
  141. </div>
  142. </div>
  143.  
  144. <div class="col-md-3 related-vids">
  145. <div class="related-video" style="
  146. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  147.  
  148. <div class="rel-info" style="
  149. display: inline;
  150. ">
  151. <span class="rel-title" style="">I Want You</span>
  152.  
  153. <span class="rel-by" style="
  154. ">by Savage Garden</span> </div>
  155. </div>
  156. <div class="related-video" style="
  157. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  158.  
  159. <div class="rel-info" style="
  160. display: inline;
  161. ">
  162. <span class="rel-title" style="">I Want You</span>
  163.  
  164. <span class="rel-by" style="
  165. ">by Savage Garden</span> </div>
  166. </div>
  167. <div class="related-video" style="
  168. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  169.  
  170. <div class="rel-info" style="
  171. display: inline;
  172. ">
  173. <span class="rel-title" style="">I Want You</span>
  174.  
  175. <span class="rel-by" style="
  176. ">by Savage Garden</span> </div>
  177. </div>
  178. <div class="related-video" style="
  179. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  180.  
  181. <div class="rel-info" style="
  182. display: inline;
  183. ">
  184. <span class="rel-title" style="">I Want You</span>
  185.  
  186. <span class="rel-by" style="
  187. ">by Savage Garden</span> </div>
  188. </div>
  189. <div class="related-video" style="
  190. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  191.  
  192. <div class="rel-info" style="
  193. display: inline;
  194. ">
  195. <span class="rel-title" style="">I Want You</span>
  196.  
  197. <span class="rel-by" style="
  198. ">by Savage Garden</span> </div>
  199. </div>
  200. <div class="related-video" style="
  201. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  202.  
  203. <div class="rel-info" style="
  204. display: inline;
  205. ">
  206. <span class="rel-title" style="">I Want You</span>
  207.  
  208. <span class="rel-by" style="
  209. ">by Savage Garden</span> </div>
  210. </div>
  211. <div class="related-video" style="
  212. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  213.  
  214. <div class="rel-info" style="
  215. display: inline;
  216. ">
  217. <span class="rel-title" style="">I Want You</span>
  218.  
  219. <span class="rel-by" style="
  220. ">by Savage Garden</span> </div>
  221. </div>
  222. <div class="related-video" style="
  223. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  224.  
  225. <div class="rel-info" style="
  226. display: inline;
  227. ">
  228. <span class="rel-title" style="">I Want You</span>
  229.  
  230. <span class="rel-by" style="
  231. ">by Savage Garden</span> </div>
  232. </div>
  233. <div class="related-video" style="
  234. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  235.  
  236. <div class="rel-info" style="
  237. display: inline;
  238. ">
  239. <span class="rel-title" style="">I Want You</span>
  240.  
  241. <span class="rel-by" style="
  242. ">by Savage Garden</span> </div>
  243. </div>
  244. <div class="related-video" style="
  245. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  246.  
  247. <div class="rel-info" style="
  248. display: inline;
  249. ">
  250. <span class="rel-title" style="">I Want You</span>
  251.  
  252. <span class="rel-by" style="
  253. ">by Savage Garden</span> </div>
  254. </div>
  255. <div class="related-video" style="
  256. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  257.  
  258. <div class="rel-info" style="
  259. display: inline;
  260. ">
  261. <span class="rel-title" style="">I Want You</span>
  262.  
  263. <span class="rel-by" style="
  264. ">by Savage Garden</span> </div>
  265. </div>
  266. <div class="related-video" style="
  267. "> <img aria-hidden="true" width="120" height="90" alt="" style="top: -12px" src="https://i.ytimg.com/vi/HQt6jIKNwgU/hqdefault.jpg?custom=true&amp;w=120&amp;h=90&amp;jpg444=true&amp;jpgq=90&amp;sp=68&amp;sigh=vU__ATL-or4Txrn5NfiCBb9zZbo">
  268.  
  269. <div class="rel-info" style="
  270. display: inline;
  271. ">
  272. <span class="rel-title" style="">I Want You</span>
  273.  
  274. <span class="rel-by" style="
  275. ">by Savage Garden</span> </div>
  276. </div>
  277.  
  278.  
  279. See more
  280. </div>
  281. </div>
  282. </div>
  283. <div id="disqus_thread"></div>
  284. <script>
  285. /**
  286. * RECOMMENDED CONFIGURATION VARIABLES: EDIT AND UNCOMMENT THE SECTION BELOW TO INSERT DYNAMIC VALUES FROM YOUR PLATFORM OR CMS.
  287. * LEARN WHY DEFINING THESE VARIABLES IS IMPORTANT: https://disqus.com/admin/universalcode/#configuration-variables
  288. */
  289. /*
  290. var disqus_config = function () {
  291. this.page.url = PAGE_URL; // Replace PAGE_URL with your page's canonical URL variable
  292. this.page.identifier = PAGE_IDENTIFIER; // Replace PAGE_IDENTIFIER with your page's unique identifier variable
  293. };
  294. */
  295. (function() { // DON'T EDIT BELOW THIS LINE
  296. var d = document, s = d.createElement('script');
  297.  
  298. s.src = '//firaga.disqus.com/embed.js';
  299.  
  300. s.setAttribute('data-timestamp', +new Date());
  301. (d.head || d.body).appendChild(s);
  302. })();
  303. </script>
  304. <noscript>Please enable JavaScript to view the <a href="https://disqus.com/?ref_noscript" rel="nofollow">comments powered by Disqus.</a></noscript>
  305. <script id="dsq-count-scr" src="//firaga.disqus.com/count.js" async></script>
  306.  
  307. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
  308. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script></body>
  309. </html>
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!