За музикална система

A

AbvTube

Registered
1. Искам д направя така, всеки потребител да може да добавя песни като любими. И съответно тези песни да се се показват в любими.

2. Също така на страницата където песните се преслушват примерно:
play.php?id=12 имам player през който песните се преслушват, но понякога добавям и код на embed плейър, но така и 2-та се показвам искам да направя така че, когато: $embed тага е сетнат, т.е. не е празен да не показва другия плеър, знам че трябва да стане нещо от сорта на:

<?php

if $embed isset

echo"row.$embed"
else
echo"обикновенния плеър"

?>
Не се смейте :) просто не разбирам php

И още нещо има ли някакъв начин да сложа ръчно писан форум не искам да е накакъв супер функционален, просто искам форумче. Много благодаря. :lol:
 
Код: 
if (empty($embed))
{
// ako $embed e prazno
}else
{
//ako $embed e setnat
}

$_GET
взима информация от URL-то

Код: 
<?php

$id = $_GET['id'];

echo $id;

?>

ако отвориш страницата така
stranica.php?id=12
тогава страницата ще пощаже числото 12

можеш да направиш и проверка дали реално това което потребителя дава като id e число

Код: 
<?php

$id = $_GET['id'];

if (is_numeric($id))
{
echo $id;
}else
{
echo 'vuvedenoto id ne e chislo';
}


?>
 
Не мога да <?php echo $row['path']; ?> линка за сваляне след
if tag
а също и
<?php echo ($row['embed']); ?>

излиза ми грешка, трябва да мога да изведа пътя до файла, и самия ембед

ако е сетнат да излиза ембед-а, ако не да не се показва воубще и да показва примерно това:

<object data='player.swf' type='application/x-shockwave-flash' width='360' height='64'>
<param name='movie' value='webplayer.swf'>
<param name='menu' value='false'>
<param name='scale' value='noscale'>
<param name='bgcolor' value='#FFFFFF'>
<param name='flashvars' value='src=<?php echo $row['path']; ?>&autostart=no&loop=yes'>
</object>


грешка::

Parse error: syntax error, unexpected '<' in /public_html/site.org/play.php on line 130
 
<?php
include("conn.php");
$id = $_GET['id'];
$sql = mysql_query("SELECT * FROM `songs` WHERE `id`='$id'");
$row = mysql_fetch_array($sql);
$path = $row['path'];
if (isset($_GET['id'])) {
$read = $row['prochetena'] + 1;
$update = mysql_query("Update songs set prochetena = '$read' where id = '$_GET[id]'") or die(mysql_error());
}
?>
<table width="395" border="0" align="center" cellpadding="1" cellspacing="1" class="table">
<tr>
<td colspan="2" class="borderc2"><img src="images/lastmp3.png" border="0" /><?php echo "$row[artist] - $row[title]"; ?>
<?php
if ($logged[username]=="admin")
echo "<a href='/sadm.php?dei=edit&id=$id'><font color = 'red'><b> Редактирай</b></font><br /> ";
?>

</td>
</tr>
<tr>
<td width="100"class = "borderc2" >Категория :</td>
<td width="200"class = "borderc2" ><?php
$cat = mysql_query("SELECT * FROM `songs_cat` WHERE `id`='$row[cat]'");
$raw = mysql_fetch_array($cat);
$genername = $raw['value'];
echo "<a href=\"/cat:$row[cat]\" title=\"Песни в стил $genername\">$genername</a>";
?></td>
</tr>
<tr>
<td class = "borderc2" >Добавена :</td>
<td class = "borderc2" ><?php echo $row['date']; ?></td>
</tr>
<tr>
<td class = "borderc2">Качил:</td>
<td class = "borderc2"><a href = "/user:<?php echo $row['author']; ?>" /> <?php echo $row['author']; ?></a> още.. песни от <a href = "/dobaveni-ot:<?php echo $row['author']; ?>" />мен!</a></td>
</tr>
<tr>
<tr>
<td class = "borderc2">Свалена :</td>
<td align="left" class = "borderc2">1<?php echo stripslashes($row['downs']); ?></td>
</tr>
<tr>
<td class = "borderc2">Слушана :</td>
<td align="left" class = "borderc2">1<?php echo ($row['prochetena']); ?></td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center">Алтернативен player:<br \><?php echo stripslashes($row['embed']); ?></td>
</tr>

<tr>
<td colspan="2" class = "borderc2" align="center">
<object data="webplayer.swf" type="application/x-shockwave-flash" width="360" height="64">
<param name="movie" value="webplayer.swf">
<param name="menu" value="false">
<param name="scale" value="noscale">
<param name="bgcolor" value="#FFFFFF">
<param name="flashvars" value="src=<?php echo $row['path']; ?>&autostart=no&loop=yes">
</object>
</td>
</tr>
<tr>
<td class = "borderc2">Гласуване :</td>
<td class = "borderc2"><?php include "votes.php"; ?></td>
</tr>
<tr>
<td class = "borderc2">Сподели :</td>
<td class = "borderc2"><a name="fb_share" type="button_count" share_url="<?php echo curPageURL(); ?>" href="http://www.facebook.com/sharer.php">Сподели</a><script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script> </td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center"><a href="broken.php?id=<?php echo $id ?>" title="Докладвайте за песента <?php echo "$row[artist] - $row[title]"; ?>"><img src = "images/nowork.png" /></a>

<?php
if (empty($logged))
echo "<a href='register.php'><img src='images/download.png' border='0'></a></td>";
else
echo "<a href='download.php?id=$id' target='_blank'><img src='images/download.png' border='0'></a></td>";
?>

<tr>
<td align="left" class="borderc2" colspan="2" style="padding:4px;"><b><font size="1" color="#666666">Внимание: Ако дадената песен е добавена от сайтове като <a href="http://4storing.com" target="_blank">4storing.com</a>, <a href="http://rapidshare.com" target="_blank">rapidshare.com</a> или друг подобен сайт, няма да можете да слушате песента през Уеб player-а. Това не значи, че линка не работи!</font></b></tr>


</tr>
</table>
 
AbvTube каза:
че не ви е нужен целия това е което не работи
Увеличете...
на ред 130 имаш грешка
как та ти оправя грешката след като незнам какво има на този ред и около него
 
<?php
define("IN_GLOBAL", "1");
include "conn.php";
$id = $_GET['id'];
$query = sprintf("SELECT `artist`, `title` FROM `songs` WHERE `id` = '%d'", max($id, 1));
$sql = mysql_query($query);
$row = mysql_fetch_array($sql);
$name = stripslashes($row['title']);
$artist = stripslashes($row['artist']);
$title = "$artist - $name";
include "header.php";
?>

<?php
function curPageURL() {
$pageURL = 'http';
if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
$pageURL .= "://";
if ($_SERVER["SERVER_PORT"] != "80") {
$pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
} else {
$pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
}
return $pageURL;
}
?>

<body>
<table width="85%" id="cont" border="0" cellspacing="2" cellpadding="2">
<?php
include "logo.php";
include "navbar.php";
?>
<tr>
<?php
include "left_column1.php";
?>
<td width="60%" valign="top">
<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Реклама</td>
</tr>
<tr>
<td class="menubrd" align="center">

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "gornareklama.php" ?>
</td>
</tr>
</table>

<br />


<div style="margin:0 auto; width:600px; overflow:hidden;">
<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>

<td class="menubg">Музика</td>
</tr>
<tr>
<td class="menubrd">



<div align="left"></div>
<center>
<?php
include("conn.php");
$id = $_GET['id'];
$sql = mysql_query("SELECT * FROM `songs` WHERE `id`='$id'");
$row = mysql_fetch_array($sql);
$path = $row['path'];
if (isset($_GET['id'])) {
$read = $row['prochetena'] + 1;
$update = mysql_query("Update songs set prochetena = '$read' where id = '$_GET[id]'") or die(mysql_error());
}
?>
<table width="395" border="0" align="center" cellpadding="1" cellspacing="1" class="table">
<tr>
<td colspan="2" class="borderc2"><img src="images/lastmp3.png" border="0" /><?php echo "$row[artist] - $row[title]"; ?>
<?php
if ($logged[username]=="admin")
echo "<a href='/sadm.php?dei=edit&id=$id'><font color = 'red'><b> Редактирай</b></font><br /> ";
?>

</td>
</tr>
<tr>
<td width="100"class = "borderc2" >Категория :</td>
<td width="200"class = "borderc2" ><?php
$cat = mysql_query("SELECT * FROM `songs_cat` WHERE `id`='$row[cat]'");
$raw = mysql_fetch_array($cat);
$genername = $raw['value'];
echo "<a href=\"/cat:$row[cat]\" title=\"Песни в стил $genername\">$genername</a>";
?></td>
</tr>
<tr>
<td class = "borderc2" >Добавена :</td>
<td class = "borderc2" ><?php echo $row['date']; ?></td>
</tr>
<tr>
<td class = "borderc2">Качил:</td>
<td class = "borderc2"><a href = "/user:<?php echo $row['author']; ?>" /> <?php echo $row['author']; ?></a> още.. песни от <a href = "/dobaveni-ot:<?php echo $row['author']; ?>" />мен!</a></td>
</tr>
<tr>
<tr>
<td class = "borderc2">Свалена :</td>
<td align="left" class = "borderc2">1<?php echo stripslashes($row['downs']); ?></td>
</tr>
<tr>
<td class = "borderc2">Слушана :</td>
<td align="left" class = "borderc2">1<?php echo ($row['prochetena']); ?></td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center">Алтернативен player:<br \><?php echo stripslashes($row['embed']); ?></td>
</tr>

<tr>
<td colspan="2" class = "borderc2" align="center">
<object data="webplayer.swf" type="application/x-shockwave-flash" width="360" height="64">
<param name="movie" value="webplayer.swf">
<param name="menu" value="false">
<param name="scale" value="noscale">
<param name="bgcolor" value="#FFFFFF">
<param name="flashvars" value="src=<?php echo $row['path']; ?>&autostart=no&loop=yes">
</object>
</td>
</tr>
<tr>
<td class = "borderc2">Гласуване :</td>
<td class = "borderc2"><?php include "votes.php"; ?></td>
</tr>
<tr>
<td class = "borderc2">Сподели :</td>
<td class = "borderc2"><a name="fb_share" type="button_count" share_url="<?php echo curPageURL(); ?>" href="http://www.facebook.com/sharer.php">Сподели</a><script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script> </td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center"><a href="broken.php?id=<?php echo $id ?>" title="Докладвайте за песента <?php echo "$row[artist] - $row[title]"; ?>"><img src = "images/nowork.png" /></a>

<?php
if (empty($logged))
echo "<a href='register.php'><img src='images/download.png' border='0'></a></td>";
else
echo "<a href='download.php?id=$id' target='_blank'><img src='images/download.png' border='0'></a></td>";
?>

<tr>
<td align="left" class="borderc2" colspan="2" style="padding:4px;"><b><font size="1" color="#666666">Внимание: Ако дадената песен е добавена от сайтове като <a href="http://4storing.com" target="_blank">4storing.com</a>, <a href="http://rapidshare.com" target="_blank">rapidshare.com</a> или друг подобен сайт, няма да можете да слушате песента през Уеб player-а. Това не значи, че линка не работи!</font></b></tr>


</tr>
</table>

<tr>
<td class="menubg">Коментари</td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center">Внимание:<br \>
<?php if (empty($logged))
{ echo "<font size='4'>Съжаляваме, но ако искате да пишете коментари: <strong><a href='/register.php'>Регистрирайте се!</a></strong></font>"; }
?>
<? include "comments.php"; ?>
</td>
</tr>



</td>
</tr>

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>

<td class="menubg"><a href = "songs.php" /><font color = "white" />Препоръчани за вас</td></a></font>
</tr>
<tr>
<td class="menubrd">

<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="5%" align="center" class="text1"><h1>#</h1></td>
<td width="65%" align="center" class="text1"><h1>Изпълнител - песен</h1></td>
<td width="15%" align="center" class="text1"><h1>Слушана</h1></td>
<td width="15%" align="center" class="text1"><h1>Изтегли</h1></td>
</tr>


<div id="index">

<?php

$id = $_GET['id'];
include "conn.php";
$a = mysql_query("SELECT * from songs WHERE feautured = 1 order by id DESC LIMIT 10");
while($b=mysql_fetch_array($a))
{
$id=$b['id'];
$title=stripslashes($b['title']);
$artist=stripslashes($b['artist']);
$size=$b['size'];
$author=$b['author'];
$path=$b['path'];
$prochetena=$b['prochetena'];
echo '<tr>
<td align="center" class="playsong1">
<img src="images/addsong.png" border="0" />
</td>
<td class="playsong1">
<a href="http://xmp3.org/play:'.$id.'">
<strong>
<font color = "#000" />
'.$artist.' - '.$title.'
</font>
</strong>
</a>
</td>
<td align="center" class="playsong1"><font color = "#000" />1'.$prochetena.' пъти</font></td>

<td align="center" class="playsong1"><a href="/play:'.$id.'""><b><img src = "images/down.jpg" /></b></a></td>

' ;

}
?>


</tr><tr>

</table>

</td>
</tr>
</table>

<br />

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Реклама</td>
</tr>
<tr>

<td class="menubrd" align="center">

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "dolnareklama.php"; ?>
</td>
</tr>
</table>

</td>
<td width="20%" valign="top">



<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Реклама</td>
</tr>
<tr>
<td class="menubrd" align="center">


<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "dqsnareklama.php" ?>
</td>
</tr>
</table>

<br />

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<?php
include_once "conn.php";
$a=mysql_query("SELECT * FROM songs ORDER by id");
$aresult=mysql_num_rows($a);
$b=mysql_query("SELECT * FROM lyrics ORDER by id");
$bresult=mysql_num_rows($b);
?>
<td class="menubg">Статистика</td>

</tr>
<tr>
<td class="menubrd">

<? include "statistic.php" ?>
<IMG SRC="images/xmp3.png" WIDTH="1" HEIGHT="1" ALT="Starflower">
</td>
</tr>
</table>

<br />

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Приятели</td>

</tr>
<tr>
<td class="menubrd">

<div id="friends">
<ul>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "friends.php"; ?>
</div>


</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="3">
<?php include "footer.php"; ?>
</td>
</tr>
</table>

</body>
</html>
 
Код: 
<?php
define("IN_GLOBAL", "1");
include "conn.php";
$id = (int)$_GET['id'];
$query = sprintf("SELECT `artist`, `title` FROM `songs` WHERE `id` = '%d'", max($id, 1));
$sql = mysql_query($query);
$row = mysql_fetch_array($sql);
$name = stripslashes($row['title']);
$artist = stripslashes($row['artist']);
$title = "$artist - $name";
include "header.php";
?>

<?php
function curPageURL() {
$pageURL = 'http';
if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
$pageURL .= "://";
if ($_SERVER["SERVER_PORT"] != "80") {
$pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
} else {
$pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
}
return $pageURL;
}
?>

<body>
<table width="85%" id="cont" border="0" cellspacing="2" cellpadding="2">
<?php
include "logo.php";
include "navbar.php";
?>
<tr>
<?php
include "left_column1.php";
?>
<td width="60%" valign="top">
<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Реклама</td>
</tr>
<tr>
<td class="menubrd" align="center">

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "gornareklama.php" ?>
</td>
</tr>
</table>

<br />


<div style="margin:0 auto; width:600px; overflow:hidden;">
<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>

<td class="menubg">Музика</td>
</tr>
<tr>
<td class="menubrd">



<div align="left"></div>
<center>
<?php
include("conn.php");
$id = $_GET['id'];
$sql = mysql_query("SELECT * FROM `songs` WHERE `id`='$id'");
$row = mysql_fetch_array($sql);
$path = $row['path'];
if (isset($_GET['id'])) {
$read = $row['prochetena'] + 1;
$update = mysql_query("Update songs set prochetena = '$read' where id = '$_GET[id]'") or die(mysql_error());
}
?>
<table width="395" border="0" align="center" cellpadding="1" cellspacing="1" class="table">
<tr>
<td colspan="2" class="borderc2"><img src="images/lastmp3.png" border="0" /><?php echo "$row[artist] - $row[title]"; ?>
<?php
if ($logged[username]=="admin")
echo "<a href='/sadm.php?dei=edit&id=$id'><font color = 'red'><b> Редактирай</b></font><br /> ";
?>

</td>
</tr>
<tr>
<td width="100"class = "borderc2" >Категория :</td>
<td width="200"class = "borderc2" ><?php
$cat = mysql_query("SELECT * FROM `songs_cat` WHERE `id`='$row[cat]'");
$raw = mysql_fetch_array($cat);
$genername = $raw['value'];
echo "<a href=\"/cat:$row[cat]\" title=\"Песни в стил $genername\">$genername</a>";
?></td>
</tr>
<tr>
<td class = "borderc2" >Добавена :</td>
<td class = "borderc2" ><?php echo $row['date']; ?></td>
</tr>
<tr>
<td class = "borderc2">Качил:</td>
<td class = "borderc2"><a href = "/user:<?php echo $row['author']; ?>" /> <?php echo $row['author']; ?></a> още.. песни от <a href = "/dobaveni-ot:<?php echo $row['author']; ?>" />мен!</a></td>
</tr>
<tr>
<tr>
<td class = "borderc2">Свалена :</td>
<td align="left" class = "borderc2">1<?php echo stripslashes($row['downs']); ?></td>
</tr>
<tr>
<td class = "borderc2">Слушана :</td>
<td align="left" class = "borderc2">1<?php echo ($row['prochetena']); ?></td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center">Алтернативен player:<br \>
<?php 
if (!empty($row['embed']))
echo stripslashes($row['embed']);
?>
</td>
</tr>

<tr>
<td colspan="2" class = "borderc2" align="center">
<?php if (empty($row['embed']))
echo '
<object data="webplayer.swf" type="application/x-shockwave-flash" width="360" height="64">
<param name="movie" value="webplayer.swf">
<param name="menu" value="false">
<param name="scale" value="noscale">
<param name="bgcolor" value="#FFFFFF">
<param name="flashvars" value="src='.$row['path'].'&autostart=no&loop=yes">
</object>';
?>
</td>
</tr>
<tr>
<td class = "borderc2">Гласуване :</td>
<td class = "borderc2"><?php include "votes.php"; ?></td>
</tr>
<tr>
<td class = "borderc2">Сподели :</td>
<td class = "borderc2"><a name="fb_share" type="button_count" share_url="<?php echo curPageURL(); ?>" href="http://www.facebook.com/sharer.php">Сподели</a><script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script> </td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center"><a href="broken.php?id=<?php echo $id ?>" title="Докладвайте за песента <?php echo "$row[artist] - $row[title]"; ?>"><img src = "images/nowork.png" /></a>

<?php
if (empty($logged))
echo "<a href='register.php'><img src='images/download.png' border='0'></a></td>";
else
echo "<a href='download.php?id=$id' target='_blank'><img src='images/download.png' border='0'></a></td>";
?>

<tr>
<td align="left" class="borderc2" colspan="2" style="padding:4px;"><b><font size="1" color="#666666">Внимание: Ако дадената песен е добавена от сайтове като <a href="http://4storing.com" target="_blank">4storing.com</a>, <a href="http://rapidshare.com" target="_blank">rapidshare.com</a> или друг подобен сайт, няма да можете да слушате песента през Уеб player-а. Това не значи, че линка не работи!</font></b></tr>


</tr>
</table>

<tr>
<td class="menubg">Коментари</td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center">Внимание:<br \>
<?php if (empty($logged))
{ echo "<font size='4'>Съжаляваме, но ако искате да пишете коментари: <strong><a href='/register.php'>Регистрирайте се!</a></strong></font>"; }
?>
<? include "comments.php"; ?>
</td>
</tr>



</td>
</tr>

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>

<td class="menubg"><a href = "songs.php" /><font color = "white" />Препоръчани за вас</td></a></font>
</tr>
<tr>
<td class="menubrd">

<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="5%" align="center" class="text1"><h1>#</h1></td>
<td width="65%" align="center" class="text1"><h1>Изпълнител - песен</h1></td>
<td width="15%" align="center" class="text1"><h1>Слушана</h1></td>
<td width="15%" align="center" class="text1"><h1>Изтегли</h1></td>
</tr>


<div id="index">

<?php

$id = $_GET['id'];
include "conn.php";
$a = mysql_query("SELECT * from songs WHERE feautured = 1 order by id DESC LIMIT 10");
while($b=mysql_fetch_array($a))
{
$id=$b['id'];
$title=stripslashes($b['title']);
$artist=stripslashes($b['artist']);
$size=$b['size'];
$author=$b['author'];
$path=$b['path'];
$prochetena=$b['prochetena'];
echo '<tr>
<td align="center" class="playsong1">
<img src="images/addsong.png" border="0" />
</td>
<td class="playsong1">
<a href="http://xmp3.org/play:'.$id.'">
<strong>
<font color = "#000" />
'.$artist.' - '.$title.'
</font>
</strong>
</a>
</td>
<td align="center" class="playsong1"><font color = "#000" />1'.$prochetena.' пъти</font></td>

<td align="center" class="playsong1"><a href="/play:'.$id.'""><b><img src = "images/down.jpg" /></b></a></td>

' ;

}
?>


</tr><tr>

</table>

</td>
</tr>
</table>

<br />

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Реклама</td>
</tr>
<tr>

<td class="menubrd" align="center">

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "dolnareklama.php"; ?>
</td>
</tr>
</table>

</td>
<td width="20%" valign="top">



<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Реклама</td>
</tr>
<tr>
<td class="menubrd" align="center">


<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "dqsnareklama.php" ?>
</td>
</tr>
</table>

<br />

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<?php
include_once "conn.php";
$a=mysql_query("SELECT * FROM songs ORDER by id");
$aresult=mysql_num_rows($a);
$b=mysql_query("SELECT * FROM lyrics ORDER by id");
$bresult=mysql_num_rows($b);
?>
<td class="menubg">Статистика</td>

</tr>
<tr>
<td class="menubrd">

<? include "statistic.php" ?>
<IMG SRC="images/xmp3.png" WIDTH="1" HEIGHT="1" ALT="Starflower">
</td>
</tr>
</table>

<br />

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Приятели</td>

</tr>
<tr>
<td class="menubrd">

<div id="friends">
<ul>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "friends.php"; ?>
</div>


</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="3">
<?php include "footer.php"; ?>
</td>
</tr>
</table>

</body>
</html>
 
много ти благодаря ще гласувам за теб, но не веднага щото няма да мога да пиша повече в темата.
Можеш ли също така да ми помогнеш да направя, когато потребителите влезнат на дадена песен да има бутон да добавят тази песен като любима, и после като натиснат примерно myfavorites.php да им искарва песните който са добавили като любими.
И още нещо когато копирам embed код за някоя песен от някой сайт големината на плеъра е много голяма искам да направя height винаги да е примерно 30px?
 
<?php
define("IN_GLOBAL", "1");
include "conn.php";
$id = (int)$_GET['id'];
$query = sprintf("SELECT `artist`, `title` FROM `songs` WHERE `id` = '%d'", max($id, 1));
$sql = mysql_query($query);
$row = mysql_fetch_array($sql);
$name = stripslashes($row['title']);
$artist = stripslashes($row['artist']);
$title = "$artist - $name";
include "header.php";
?>

<?php
function curPageURL() {
$pageURL = 'http';
if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
$pageURL .= "://";
if ($_SERVER["SERVER_PORT"] != "80") {
$pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
} else {
$pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
}
return $pageURL;
}
?>

<body>
<table width="85%" id="cont" border="0" cellspacing="2" cellpadding="2">
<?php
include "logo.php";
include "navbar.php";
?>
<tr>
<?php
include "left_column1.php";
?>
<td width="60%" valign="top">
<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Реклама</td>
</tr>
<tr>
<td class="menubrd" align="center">

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "gornareklama.php" ?>
</td>
</tr>
</table>

<br />


<div style="margin:0 auto; width:600px; overflow:hidden;">
<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>

<td class="menubg">Музика</td>
</tr>
<tr>
<td class="menubrd">



<div align="left"></div>
<center>
<?php
include("conn.php");
$id = $_GET['id'];
$sql = mysql_query("SELECT * FROM `songs` WHERE `id`='$id'");
$row = mysql_fetch_array($sql);
$path = $row['path'];
if (isset($_GET['id']))
{
$read = $row['prochetena'] + 1;
$update = mysql_query("Update songs set prochetena = '$read' where id = '$_GET[id]'") or die(mysql_error());
$fav = $_GET['fav'];
if (!empty($fav))
{
$userID = ; // v tazi promenliva trqbva da e id-to na potrebitelq
mysql_query("INSERT INTO `favorite` (`r_user` ,`r_song`) VALUES ('$userID', '$id');") or die(mysql_error());
}
}
?>
<table width="395" border="0" align="center" cellpadding="1" cellspacing="1" class="table">
<tr>
<td colspan="2" class="borderc2"><img src="images/lastmp3.png" border="0" /><?php echo "$row[artist] - $row[title]"; ?>
<?php
if ($logged[username]=="admin")
echo "<a href='/sadm.php?dei=edit&id=$id'><font color = 'red'><b> Редактирай</b></font><br /> ";
?>

</td>
</tr>
<tr>
<td width="100"class = "borderc2" >Категория :</td>
<td width="200"class = "borderc2" ><?php
$cat = mysql_query("SELECT * FROM `songs_cat` WHERE `id`='$row[cat]'");
$raw = mysql_fetch_array($cat);
$genername = $raw['value'];
echo "<a href=\"/cat:$row[cat]\" title=\"Песни в стил $genername\">$genername</a>";
?></td>
</tr>
<tr>
<td class = "borderc2" >Добавена :</td>
<td class = "borderc2" ><?php echo $row['date']; ?></td>
</tr>
<tr>
<td class = "borderc2">Качил:</td>
<td class = "borderc2"><a href = "/user:<?php echo $row['author']; ?>" /> <?php echo $row['author']; ?></a> още.. песни от <a href = "/dobaveni-ot:<?php echo $row['author']; ?>" />мен!</a></td>
</tr>
<tr>
<tr>
<td class = "borderc2">Свалена :</td>
<td align="left" class = "borderc2">1<?php echo stripslashes($row['downs']); ?></td>
</tr>
<tr>
<td class = "borderc2">Слушана :</td>
<td align="left" class = "borderc2">1<?php echo ($row['prochetena']); ?></td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center">Алтернативен player:<br \>
<?php
if (!empty($row['embed']))
echo stripslashes($row['embed']);
?>
</td>
</tr>

<tr>
<td colspan="2" class = "borderc2" align="center">
<?php if (empty($row['embed']))
echo '
<object data="webplayer.swf" type="application/x-shockwave-flash" width="360" height="64">
<param name="movie" value="webplayer.swf">
<param name="menu" value="false">
<param name="scale" value="noscale">
<param name="bgcolor" value="#FFFFFF">
<param name="flashvars" value="src='.$row['path'].'&autostart=no&loop=yes">
</object>';
?>
</td>
</tr>
<tr>
<td class = "borderc2">Гласуване :</td>
<td class = "borderc2"><?php include "votes.php"; ?></td>
</tr>
<tr>
<td class = "borderc2">Сподели :</td>
<td class = "borderc2"><a name="fb_share" type="button_count" share_url="<?php echo curPageURL(); ?>" href="http://www.facebook.com/sharer.php">Сподели</a><script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script> </td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center"><a href="broken.php?id=<?php echo $id ?>" title="Докладвайте за песента <?php echo "$row[artist] - $row[title]"; ?>"><img src = "images/nowork.png" /></a>

<?php
if (empty($logged))
echo "<a href='register.php'><img src='images/download.png' border='0'></a></td>";
else
echo "<a href='download.php?id=$id' target='_blank'><img src='images/download.png' border='0'></a></td>";
?>

<tr>
<td align="left" class="borderc2" colspan="2" style="padding:4px;"><b><font size="1" color="#666666">Внимание: Ако дадената песен е добавена от сайтове като <a href="http://4storing.com" target="_blank">4storing.com</a>, <a href="http://rapidshare.com" target="_blank">rapidshare.com</a> или друг подобен сайт, няма да можете да слушате песента през Уеб player-а. Това не значи, че линка не работи!</font></b></tr>


</tr>
</table>

<tr>
<td class="menubg">Коментари</td>
</tr>
<tr>
<td colspan="2" class = "borderc2" align="center">Внимание:<br \>
<?php if (empty($logged))
{ echo "<font size='4'>Съжаляваме, но ако искате да пишете коментари: <strong><a href='/register.php'>Регистрирайте се!</a></strong></font>"; }
?>
<? include "comments.php"; ?>
</td>
</tr>



</td>
</tr>

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>

<td class="menubg"><a href = "songs.php" /><font color = "white" />Препоръчани за вас</td></a></font>
</tr>
<tr>
<td class="menubrd">

<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="5%" align="center" class="text1"><h1>#</h1></td>
<td width="65%" align="center" class="text1"><h1>Изпълнител - песен</h1></td>
<td width="15%" align="center" class="text1"><h1>Слушана</h1></td>
<td width="15%" align="center" class="text1"><h1>Изтегли</h1></td>
</tr>


<div id="index">

<?php

$id = $_GET['id'];
include "conn.php";
$a = mysql_query("SELECT * from songs WHERE feautured = 1 order by id DESC LIMIT 10");
while($b=mysql_fetch_array($a))
{
$id=$b['id'];
$title=stripslashes($b['title']);
$artist=stripslashes($b['artist']);
$size=$b['size'];
$author=$b['author'];
$path=$b['path'];
$prochetena=$b['prochetena'];
echo '<tr>
<td align="center" class="playsong1">
<img src="images/addsong.png" border="0" />
</td>
<td class="playsong1">
<a href="http://xmp3.org/play:'.$id.'">
<strong>
<font color = "#000" />
'.$artist.' - '.$title.'
</font>
</strong>
</a>
</td>
<td align="center" class="playsong1"><font color = "#000" />1'.$prochetena.' пъти</font></td>

<td align="center" class="playsong1"><a href="/play:'.$id.'""><b><img src = "images/down.jpg" /></b></a></td>

' ;

}
?>


</tr><tr>

</table>

</td>
</tr>
</table>

<br />

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Реклама</td>
</tr>
<tr>

<td class="menubrd" align="center">

<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "dolnareklama.php"; ?>
</td>
</tr>
</table>

</td>
<td width="20%" valign="top">



<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Реклама</td>
</tr>
<tr>
<td class="menubrd" align="center">


<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "dqsnareklama.php" ?>
</td>
</tr>
</table>

<br />

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<?php
include_once "conn.php";
$a=mysql_query("SELECT * FROM songs ORDER by id");
$aresult=mysql_num_rows($a);
$b=mysql_query("SELECT * FROM lyrics ORDER by id");
$bresult=mysql_num_rows($b);
?>
<td class="menubg">Статистика</td>

</tr>
<tr>
<td class="menubrd">

<? include "statistic.php" ?>
<IMG SRC="images/xmp3.png" WIDTH="1" HEIGHT="1" ALT="Starflower">
</td>
</tr>
</table>

<br />

<table width="100%" id="menuside" border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="menubg">Приятели</td>

</tr>
<tr>
<td class="menubrd">

<div id="friends">
<ul>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />

<? include "friends.php"; ?>
</div>


</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="3">
<?php include "footer.php"; ?>
</td>
</tr>
</table>

</body>
</html>

SQL
Код: 
CREATE TABLE IF NOT EXISTS `favorite` (
  `r_user` int(11) NOT NULL,
  `r_song` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

в html-а слагаш един линк
който да е play.php?id=12&fav=1
кадето 12 ти е id-то на пасента

а вече в favorite.php
само трябва да изведеш всички редове при който r_user е равно на id-то на потребинеля

SELECT `r_song` FROM `favorite` WHERE `r_user` = $UserID

edit: това за embed-а от др. сайтове не съм го правил ако до довечере никой не е дал код ще ти го напиша
 
А как да направя песента да не се добавя 2 пъти, в смисъл такъв че като натисна 2 пъти на добави в любими я добавя 2 пъти или 10 или 100 даже
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе