sharky_design
Registered
Значи имам playsong.php с код :
Ще може ли да сложите в този код playsong.php коментарите от този код:
Който ми го направи +1
Код:
<?php
ob_start();
include "functions.php";
sitehead('PHP Уроци за начинаещи - Начало');
include "left_menus.php";
?>
<div class="menus_center">
<div class="menu_2">
<div class="menu_h">
<img src="img/profileico.png" alt="" />
<span class="mh_text"><center> Слушане </center></span>
</div>
<div class="menu_b" style="padding: 10px 10px 0 10px;">
<?php
include("config.php");
$id = $_GET['id'];
$sql = mysql_query("SELECT * FROM `songs` WHERE `id`='$id'");
$row = mysql_fetch_array($sql);
?>
<table width="395" border="0" align="center" cellpadding="1" cellspacing="1" class="table">
<tr>
<td colspan="2" class="lfhead"><?php echo "$row[artist] - $row[title]"; ?></td>
</tr>
<tr>
<td width="100">Стил :</td>
<td width="200"><?php
$cat = mysql_query("SELECT * FROM `songs_cat` WHERE `id`='$row[cat]'");
$raw = mysql_fetch_array($cat);
$genername = $raw['value'];
echo "<a href=\"songs.php?gener=$row[cat]\" title=\"Песни в стил $genername\">$genername</a>";
?></td>
</tr>
<tr>
<td>Добавена на :</td>
<td><?php echo $row['date']; ?></td>
</tr>
<tr>
<td>Добавена от:</td>
<td><?php echo $row['author']; ?></td>
</tr>
<tr>
<td>Албум :</td>
<td><?php echo $row['album']; ?></td>
</tr>
<tr>
<td>Размер :</td>
<td><?php echo $row['size']; ?></td>
</tr>
<tr>
<td>Година :</td>
<td align="left"><?php echo $row['year']; ?></td>
</tr>
<tr>
<td colspan="2" align="center"><object type="application/x-shockwave-flash" data="player.swf?son=<?php echo $row['path']; ?>" height="20" width="200">
<param name="movie" value="player.swf?son=<?php echo $row['path']; ?>">
</object></td></table>
</tr>
<tr>
<center><td colspan="2" align="center"><a href="broken.php?id=<?php echo $row['id']; ?>" title="Докладвайте за песента <?php echo "$row[artist] - $row[title]"; ?>">Неработещ линк</a> | <a href="<?php echo $row['path']; ?>" target="_blank" title="Изтеглете песента <?php echo "$row[artist] - $row[title]"; ?>">Изтегли</a></td></center>
</div>
<div class="mbottom"> </div>
</div>
<br />
</div>
<?
include "right_menus.php";
sitefooter();
?>Ще може ли да сложите в този код playsong.php коментарите от този код:
Код:
<?
if($_SESSION['logged']===true) {
?>
Коментирай ...
<form method="post" action="">
<textarea name="comment" style="width: 310px; height: 70px;"> </textarea> <br />
<input type="submit" name="post" value="Изпрати" />
</form>
<?
if($_POST['post']) {
$comment = htmlspecialchars($_POST['comment']);
$avtor = $_SESSION['userinfo']['username'];
$bbcode = array("[b]", "[/b]");
$html = array("<b>", "</b>");
$comment = str_replace($bbcode, $html, $comment);
$sql = "INSERT INTO `comments` (urok, comment, avtor) VALUES ('$view', '$comment', '$avtor')";
$rs = mysql_query($sql);
}
}
else {
echo "Регистрирайте се за да добавите коментар...";
}
$sql = "SELECT * FROM `comments` WHERE urok='$view' ORDER BY id DESC";
$rs = mysql_query($sql);
$broi = mysql_num_rows($rs);
$limit = 3;
if((int)$_GET['comment']>0) {
$page = (int)$_GET['comment'];
}
else {
$page = 0;
}
$maxpage = ceil($broi/$limit);
$sql = "SELECT * FROM `comments` WHERE urok='$view' ORDER BY id DESC LIMIT ".$limit*$page.",".$limit."";
$rs = mysql_query($sql);
echo "<div style='margin-top: 50px; padding: 5px;'>";
while($data = mysql_fetch_assoc($rs)) {
echo "<div style='border: 1px solid #BBB; width: 100%;'> <div style='background: #CCC; width: 97.8%; padding: 0 0 0 10px;'>";
if($_SESSION['userinfo']['rank']==3) {
echo " <a href='delete_comment.php?id=$data[id]'>x </a>";
}
echo "$data[avtor] каза:
</div> <div style='background: #eee; width: 97.8%; padding: 10px 0 10px 10px;'>$data[comment]</div> </div> <br />";
}
echo "</div></div>";
echo "Коментар страници: - ";
for($i=0;$i<$maxpage;$i++) {
echo "<a href='urok.php?view=$view&comment=$i'> ".($i+1)." </a>- ";
}
?>Който ми го направи +1