springer 6 linier ned før den viser kode....
Hej eksperten jeg har et lille problem,,,min kode starter ikke før linie 6 når jeg kigger kildekoden fra en browser??
Det er en af de filer jeg includer men kan ikke lige se hvad det skulle være ?
Første include:
<?php
mysql_connect("localhost", "*******", "******") or die(mysql_error());
mysql_select_db("*******") or die(mysql_error());
?>
andet include:
<?php
function set($video)
{
$query = mysql_query("SELECT * FROM videos WHERE file='$video' LIMIT 1");
$row = mysql_fetch_assoc($query);
echo"<fieldset>";
echo"<legend>Visninger</legend>\n";
echo"<div id=''beskrivelse><div id='indhold'>";
$set = $row['vives'];
echo "$set";
echo"</div></div>";
echo"</fieldset>";
}
function vis_filer_admin()
{
$dirname = "/var/www/ipadvideo.dk/htdocs/admin/"; //Hvor skal den lede efter filer?
$dirhandle = opendir($dirname); //Åben mappen
while($file = readdir($dirhandle)) //Loop gennem mappen
{
if ($file != "." && $file != "..") //Fjern . og ..
{
if (is_file($dirname.$file)) //Find ud af om det er en fil eller en mappe
{
echo "<a href=\"" . $file . "\"> " . $file . "</a><br>";
}
}
}
}
function set_tags($video)
{
$query = mysql_query("SELECT * FROM videos WHERE file='$video' ORDER BY id DESC LIMIT 1");
$row = mysql_fetch_assoc($query);
$id = $row['id'];
$title = $row['title'];
$file = $row['file'];
$player = $row['file'];
if($_POST['tag'])
{
$query = mysql_query("SELECT * FROM tags WHERE tag='$_POST[tag]' ");
$row = mysql_fetch_assoc($query);
$tag = $row['tag'];
$tagid1 = $row['id'];
$tag2 = $_POST['tag'];
if($tag == $tag2)
{
$query5 = mysql_query("SELECT * FROM videos_tags WHERE videos_id='$id' AND tags_id='$tagid1' ");
$row5 = mysql_fetch_assoc($query5);
$videos_id = $row5['videos_id'];
$tags_id = $row5['tags_id'];
if($videos_id == $id && $tags_id == $tagid1)
{
//gør ikke noget den er allerede tilføjet
}
else
{
$query2 = "INSERT INTO videos_tags (videos_id, tags_id) VALUES ('$id', '$tagid1')";
mysql_query($query2) or die(mysql_error());
}
}
else
{
$query = "INSERT INTO tags (id, tag) VALUES ('', '$tag2')";
mysql_query($query) or die(mysql_error());
$tagid = mysql_insert_id();
$query3 = "INSERT INTO videos_tags (videos_id, tags_id) VALUES ('$id', '$tagid')";
mysql_query($query3) or die(mysql_error());
}
}
}
function player_admin($video)
{
$query = mysql_query("SELECT * FROM videos WHERE file='$video' ORDER BY id DESC LIMIT 1");
$row = mysql_fetch_assoc($query);
$id = $row['id'];
$title = $row['title'];
$file = $row['file'];
$player = $row['file'];
echo"<video src=\"../files/film/$file.mp4\" controls=\"controls\" width=\"500\" height=\"250\" poster=\"../files/billeder/$file.jpg\" autobuffer=\"autobuffer\"></video>";
}
function tag_admin($video)
{
$query = mysql_query("SELECT * FROM videos INNER JOIN videos_tags on videos.id = videos_tags.videos_id INNER JOIN tags on videos_tags.tags_id = tags.id WHERE file='$video' ");
while($row = mysql_fetch_assoc($query)) //Lav en while der kører alle rækker igennem
{
$ret = $row['tag'];
$ret = strtolower($ret);
echo "$ret, ";
}
}
function player($player)
{
$query = mysql_query("SELECT * FROM videos WHERE file='$player'");
$row = mysql_fetch_assoc($query);
$file = $row['file'];
$title = $row['title'];
echo"<video src=\"files/film/$file.mp4\" controls=\"controls\" width=\"500\" height=\"400\" autoplay=\"autoplay\" poster=\"files/billeder/$file.jpg\" autobuffer=\"autobuffer\">
</video>";
}
function player_big($player)
{
$query = mysql_query("SELECT * FROM videos WHERE file='$player'");
$row = mysql_fetch_assoc($query);
$file = $row['file'];
$title = $row['title'];
echo"<video src=\"files/film/$file.mp4\" controls=\"controls\" width=\"825\" height=\"500\" autoplay=\"autoplay\" poster=\"files/billeder/$file.jpg\" autobuffer=\"autobuffer\">
</video>";
}
function video_title($player)
{
$query = mysql_query("SELECT * FROM videos WHERE file='$player'");
$row = mysql_fetch_assoc($query);
$title = $row['title'];
$title = substr($title, 0, 45);
echo"$title";
}
function video_title_hedder($player)
{
$query = mysql_query("SELECT * FROM videos WHERE file='$player'");
$row = mysql_fetch_assoc($query);
$title = $row['title'];
echo"$title";
}
function video_des($player)
{
$query = mysql_query("SELECT * FROM videos WHERE file='$player'");
$row = mysql_fetch_assoc($query);
$des = $row['des'];
echo"<fieldset>";
echo"<legend>Beskrivelse</legend>\n";
echo "<div id='beskrivelse'><div id='indhold'>";
echo"$des";
echo"</div></div>";
echo"</fieldset>";
}
function video_des_hedder($player)
{
$query = mysql_query("SELECT * FROM videos WHERE file='$player'");
$row = mysql_fetch_assoc($query);
$des = $row['des'];
echo"$des";
}
function video_tags_hedder($player)
{
// $PLAYER INDHOLDER FILE
$query = mysql_query("SELECT * FROM videos INNER JOIN videos_tags on videos.id = videos_tags.videos_id INNER JOIN tags on videos_tags.tags_id = tags.id WHERE file='$player' ");
while($row = mysql_fetch_assoc($query)) //Lav en while der kører alle rækker igennem
{
$ret = $row['tag'];
$ret = strtolower($ret);
echo "$ret, ";
}
}
function top_10_film()
{
$query = mysql_query("SELECT * FROM videos WHERE status='1' ORDER BY vives DESC LIMIT 9");
$counter = 1;
echo "<table width='260' border='0' cellpadding='5' cellspacing='5'>\n<tr>\n";
while($row = mysql_fetch_array($query))
{
echo"<td><a href='v.php?v=".$row['file']."'><img src='files/billeder/".$row['file'].".jpg' width='75' height='60' border='0'></a></td>";
if(($counter % 3) == 0)
{
echo "</tr>\n<tr>\n";
}
$counter++;
}
echo "</tr>\n</table>";
}
function video_tags($player)
{
// $PLAYER INDHOLDER FILE
$query = mysql_query("SELECT * FROM videos INNER JOIN videos_tags on videos.id = videos_tags.videos_id INNER JOIN tags on videos_tags.tags_id = tags.id WHERE file='$player' ");
echo"<fieldset>";
echo"<legend>Tags</legend>\n";
echo"<div id=''beskrivelse><div id='indhold'>";
while($row = mysql_fetch_assoc($query)) //Lav en while der kører alle rækker igennem
{
$ret = $row['tag'];
$ret = strtolower($ret);
echo "<a href='search.php?q=$ret'>$ret</a>, ";
}
echo"</div></div>";
echo"</fieldset>";
}
function login_boks()
{
session_start();
if (!isset($_SESSION['user']))
{
echo"<fieldset>";
echo"<legend > Bruger login</legend>\n";
echo"<br/>\n";
echo"<form name=\"form1\" method=\"post\" action=\"/login/login.php\">\n";
echo"<table width=\"250\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n";
echo"<tr>\n";
echo"<td>Email:</td>\n<td><input name=\"email\" type=\"text\" id=\"email\"></td>\n";
echo"</tr>\n";
echo"<tr>\n";
echo"<td>Kodeord:</td>\n<td><input name=\"pwd\" type=\"password\" id=\"pwd\"></td>\n";
echo"</tr>\n";
echo"<tr>\n";
echo"<td></td><td><div id\"search\"><input type=\"submit\" name=\"Submit\" id\"search-submit\" value=\"Login\"></div></td>\n";
echo"</tr>\n";
echo"</table>\n";
echo"</form>\n";
echo"<br />";
echo"</fieldset>";
}
else
{
echo"<fieldset>";
echo"<legend > Bruger Info</legend>\n";
echo"<br />";
echo"<table width=\"250\" border=\"0\" align=\"center\" cellpadding=\"1\" cellspacing=\"5\">\n";
echo"<tr>\n";
echo"<td>Velkommen</td><td>".$_SESSION['user']."</td>";
echo"</tr>";
echo"<tr>";
echo"<td><a href=\"login/logout.php\">Log af</a></td> ";
if($_SESSION['admin'] == "1")
{
echo"<td>";
echo"<a href='/admin/index.php'>Admin</a>";
echo"</tr>\n";
}
echo"</tr>";
echo"</table>\n";
echo"<br />";
echo"</fieldset>";
}
}
function search_boks()
{
echo"<fieldset>";
echo"<legend > Søgning</legend>\n";
echo"<form method='get' name='search' action='search.php'>\n";
echo"<table width=\"250\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n";
echo"<tr>\n";
echo"<td><INPUT name=\"q\" value=\"\" type=\"text\"></td><td><INPUT name=\"search\" value=\"Søg\" type=\"submit\"></td>\n";
echo"</tr>\n";
echo"</table>\n";
echo"</form>\n";
echo"<br />";
echo"</fieldset>";
}
function search_boks_big()
{
echo"<FORM method=\"get\" name=\"search\" action=\"search.php\">\n";
echo"<table width=\"450\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n";
echo"<tr>\n";
echo"<td><INPUT name=\"q\" value=\"\" size=\"40\" type=\"text\"></td><td><INPUT name=\"search\" id=\"search-submit\" value=\" Søg her og nu \" type=\"submit\"></td>\n";
echo"</tr>\n";
echo"</table>\n";
echo"</form>\n";
}
function vis_nye_film_2()
{
//Antal pr. side (Kan også laves til noget brugeren kan bestemme
$eachSide = 16;
//Antal pr. side (Kan også laves til noget brugeren kan bestemme
$side = (isset($_GET['side']) && is_numeric($_GET['side']) && $_GET['side'] > 0) ? intval($_GET['side']) : 0;
$query = mysql_query("SELECT * FROM videos WHERE status='1' ORDER BY id DESC LIMIT ".$side.", ".$eachSide);
$counter = 1;
echo"<div class='container'>\n";
while($row = mysql_fetch_array($query))
{
$title = $row['title'];
//$title = substr($title, 0, 40);
//Create Function: cut long string
$string = substr($title, 0, 35) . "...";
echo"<div class='item'><a href='v.php?v=".$row['file']."'><img src='files/billeder/".$row['file'].".jpg' border='0' width='113' height='90'></a><br><p><a href='v.php?v=".$row['file']."' >$string</a></p></div>";
}
echo"<div style='clear:both'></div>
</div>\n";
}
function count_vives()
{
$query = "SELECT SUM(vives) FROM videos GROUP BY status";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
echo $row['SUM(vives)'];
}
}
function vis_nye_film_3()
{
//Antal pr. side (Kan også laves til noget brugeren kan bestemme
$eachSide = 16;
$side = (isset($_GET['side']) && is_numeric($_GET['side']) && $_GET['side'] > 0) ? intval($_GET['side']) : 0;
$sql = "SELECT * FROM videos WHERE status='1' ORDER BY id ASC LIMIT ".$side.", ".$eachSide;
/* Tæller antal i databasen */
$count_sql = "SELECT COUNT(*) as cnt FROM videos WHERE status='1' ";
$count_query = mysql_query($count_sql) or die(mysql_error());
$count_row = mysql_fetch_array($count_query);
/* Regner ud hvor mange der er tilbage */
$left = $count_row['cnt'] - $side;
$antal =$count_row['cnt'];
//Sidens adresse
$this_url = "videos.php?side=";
if($side > 0)
{
echo "<a href='".$this_url.($side-$eachSide)."'><img src='images/tilbage.jpg' border='0' height='25'></a> ";
}
else
{
}
if(($side+$eachSide) < $count_row['cnt'])
{
echo "<a href='".$this_url.($side+$eachSide)."'><img src='images/frem.jpg' border='0' height='25'></a>";
}
else
{
//echo " <a title=\"De næste ".$eachSide."\" ></a>";
}
echo '<br />';
echo '<br />';
echo '<br />';
echo '<br />';
echo "\n";
//Antal pr. side (Kan også laves til noget brugeren kan bestemme
$side = (isset($_GET['side']) && is_numeric($_GET['side']) && $_GET['side'] > 0) ? intval($_GET['side']) : 0;
$query = mysql_query("SELECT * FROM videos WHERE status='1' ORDER BY id DESC LIMIT ".$side.", ".$eachSide);
$counter = 1;
echo"<div class='container'>\n";
while($row = mysql_fetch_array($query))
{
$title = $row['title'];
$title = substr($title, 0, 40);
echo"<div class='item'><a href='v.php?v=".$row['file']."'><img src='files/billeder/".$row['file'].".jpg' border='0' width='113' height='90'></a><br><p><a href='v.php?v=".$row['file']."' >$title</a></p></div>";
}
echo"<div style='clear:both'></div>
</div>\n";
}
?>
