Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <head>
- $( document ).ready(function() {
- (function showscreen() {
- $.ajax({
- url: 'screen.php',
- success: function(data) {
- $('#screen').html(data);
- },
- complete: function() {
- setTimeout(showscreen, 5000);
- }
- });
- })();
- });
- </head>
- <body>
- <div id="screen"></div>
- <?php
- require '../dbauth/videos.inc.php';
- //This handles my db connections.
- $videosdbhandle = mysql_connect(
- $videoshostname,
- $videosusername,
- $videospassword
- ) or die("INVALID USERNAME OR PASSWORD");
- $videosselected = mysql_select_db($videosdbname, $videosdbhandle);
- $checkvideosql = "SELECT * FROM videos ORDER BY votes DESC";
- $checkvideoquery = mysql_query($checkvideosql, $videosdbhandle);
- $checkvideocount = mysql_num_rows($checkvideoquery);
- if ($checkvideocount > 0) {
- $count = 0;
- while ($checkvideocount > $count) {
- $thevideoname = mysql_result($checkvideoquery, $count, "name");
- $thevideovideo = mysql_result($checkvideoquery, $count, "video");
- $thevideoid = mysql_result($checkvideoquery, $count, "id");
- $thevideoimage = mysql_result($checkvideoquery, $count, "image");
- echo '<div class="screen" id="video';
- echo $thevideoid;
- echo '" style="display: none; background-image: url(';
- echo "'http://backcurrents.com/videos/";
- echo $thevideoname;
- echo '/';
- echo $thevideoimage;
- echo "'";
- echo ');">';
- echo '<video loop muted autoplay
- poster="http://backcurrents.com/videos/';
- echo $thevideoname;
- echo '/';
- echo $thevideovideo;
- echo '" class="videobg">
- <source src="http://backcurrents.com/videos/';
- echo $thevideoname;
- echo '/';
- echo $thevideovideo;
- echo '" type="video/mp4">
- </video>';
- echo '</div>';
- $count++;
- }
- }else{
- echo 'NO VIDEOS!';
- }
- ?>
- </body>
- $videosusername = "theusername";
- $videospassword = "thepassword";
- $videoshostname = "localhost";
- $videosdbname = "thedbname";
- $videosdbhandle = mysql_connect(
- $videoshostname,
- $videosusername,
- $videospassword
- ) or die("INVALID SHOW NAME OR PASSWORD");
- $videosselected = mysql_select_db($videosdbname, $videosdbhandle);
- $checkhighestvideosql = "SELECT * FROM videos ORDER BY votes DESC";
- $checkhighestvideoquery = mysql_query($checkhighestvideosql,
- $videosdbhandle);
- $checkhighestvideocount = mysql_num_rows($checkhighestvideoquery);
- if ($checkhighestvideocount > 0) {
- $x=0;
- while ($checkhighestvideocount > $x) {
- $checkhighestvideoid = mysql_result($checkhighestvideoquery, $x, "id");
- if ($x=0) {
- echo '<script type="text/javascript">';
- echo '$(".screen").hide();
- $("#video';
- echo $checkhighestvideoid;
- echo '").show(); ';
- echo '</script>';
- }else{
- echo '<script type="text/javascript">';
- echo '$(".screen").hide();
- ';
- echo '</script>';
- }
- $x++;
- }
- }else{
- echo "NO VIDEOS!";
- }
Add Comment
Please, Sign In to add comment