Да пооправите едно кодче?

gogato93 · 29 Декември 2007

http://onmusic.freehostia.com/Това е сайта аз го имам същия!ИСкам да оправите страницирането да показва песните 15 на страница!Влезте в Музика да видите как е!Кажете кой файл тряя да ви дам

AnF3taMin4o · 29 Декември 2007

http://web-tourist.net/forum/viewtopic.php?t=25847&highlight=%CF%EE%F1%EB%E5%E4%ED%E8
Виж тази тема !

Malfurion3 · 29 Декември 2007

Дай music.php...

@AnF3taMin4o, човек хубаво е да искаш да помогнеш, но като незнаеш какво даваш, защо го даваш?

gogato93 · 29 Декември 2007

Ето го кода:

Код:

<?php
session_start(); 

define('IN_PHPBB', true);
$phpbb_root_path ='forum/';
include($phpbb_root_path . 'config.php');
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_INDEX); 
		   
		   if ($_REQUEST[chlang]) {
if (file_exists($_REQUEST[chlang].'.php')) {
session_register("chlang");
$_SESSION['chlang']=$_REQUEST['chlang'];
}
}
if (!$_SESSION['chlang']) {
include ('bg.php'); // Това е езика по подразбиране
} else {
include ($_SESSION[chlang].'.php');
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<title>::МузИ4ка::</title>
<link rel="stylesheet" type="text/css" href="css.css" />
		
</style>
</head>
<body>
<div align="center">
<table bgcolor="#000000" border="0">

<tr>
<td colspan="4">
<div align="left">
<table class="t1" border="0">
<tr class="tt2">
<td>
a
</td>
</tr>
<td>
<div id="menu">
<a href="index.php"><b><font color="#CF0008" size="2px"><?php echo $lang[home]; ?></font>|</a>
<a href="/forum"><b><font color="#CF0008" size="2px"><?php echo $lang[forum]; ?></font>|</a>
<a href="music.php"><b><font color="#CF0008" size="2px"><?php echo $lang[music]; ?></font>|</a>
<a href="addsong.php"><b><font color="#CF0008" size="2px"><?php echo $lang[add]; ?></a>
</div>
</td>
</tr>
<tr class="tt1">
<td>

<a href="index.php?p=<?print $_REQUEST[p];?>&chlang=bg"><img  src="images/flag/bg.jpg" border=0 alt="Български"></a>
<a href="index.php?p=<?print $_REQUEST[p];?>&chlang=en"><img  src="images/flag/en.jpg" border=0 alt="English"></a>

<br>
</td>
</tr>
</table>
</div>
</td>
</tr>


<tr>
<td colspan="4">
<table class="t2">
<tr>
<td>
<div align="right" style="margin-right:200px">b</div>
</td>
</tr>
<tr>
<td>
<div align="right" style="margin-right:200px">b</div>
</td>
</tr>
<tr>
<td>
<div align="right" style="margin-right:200px">b</div>
</td>
</tr>
</table>
</td>
</tr>


<tr>
<td class="t3" colspan="4">

</td>
</tr>

<tr>
<center>
<td width="227px" valign="top" style="color:#FFFFFF; ">
<font size="2px"></font>
</center>
<div id="memberbar">
<?
if ($userdata['user_active']>0)
{

echo '

<table border="0" style="font-size:12px;" cellpadding="0" cellspacing="0" >
<tr>
<td style="font-size:12px;" height="40"><b>Потребител:</b>
</td>
</tr>
<tr>
<td style="font-size:12px;" height="40"><a
href="'.$phpbb_root_path.'profile.php?mode=viewprofile&u='.$userdata['username'].' ">'. $userdata['username'].'</a>
</td>
</tr>
<tr>
<td height="20" ><a 
class="user" href="'.$phpbb_root_path.'login.php?logout=true&sid='.$userdata['session_id'].'">Изход</a></td>
</tr>
<tr>
<td height="5">
</td>
</tr>
</table>

';
}
else
{

echo '

<form action="'.$phpbb_root_path.'login.php" method="post" style="margin: 0px;">
<input type="hidden" name="redirect" value="../index.php" />
<table border="0" style="font-size:12px;" width="130" cellspacing="0" cellpadding="0">
<tr>
<td class="center" height="25">
<b>Потребител:</b>
</td>
</tr>
<tr>
<td class="center" height="25">
<input type="text" name="username" size="10" maxlength="25">
</td>
</tr>
<tr>
<td class="center" height="25">
<b>Парола:</b>
</td>
</tr>
<tr>
<td class="center" height="25">
<input type="password" name="password" size="10" maxlength="25">
</td>
</tr>
<tr>
<td>
Запомни ме: <input type="checkbox" name="autologin" checked >
</td>
</tr>
<tr>
<td class="center" height="35">
<input type="submit" name="login" value="Вход">
</td>
</tr>
<tr>
<td class="center" height="20" >
<a href="'.$phpbb_root_path.'profile.php?mode=register">Регистрация</a>
</td>
</tr>
<tr>
<td class="center" height="20">
<a href="'.$phpbb_root_path.'profile.php?mode=sendpassword" >Забравена парола</a>
</td>
</tr>
</table>
</form>

';

}

?>
</div>
<br><br><center><b>
Искате песен пишете ни
</center>

<div align="center" id="cboxdiv">
<iframe frameborder="0" width="160" height="305" src="http://www5.cbox.ws/box/?boxid=26524&boxtag=5a8tv1&sec=main" marginheight="2" marginwidth="2" scrolling="auto" allowtransparency="yes" name="cboxmain" style="border:#000000 1px solid;" id="cboxmain"></iframe><br/>
<iframe frameborder="0" width="160" height="75" src="http://www5.cbox.ws/box/?boxid=26524&boxtag=5a8tv1&sec=form" marginheight="2" marginwidth="2" scrolling="no" allowtransparency="yes" name="cboxform" style="border:#000000 1px solid;border-top:0px" id="cboxform"></iframe>
</div>

</td>
</td>

<td class="t4b" valign="top" cellpadding="0px" cellspacing="0px">
<?php 
include("conn.php"); 
$gener = $_GET['gener']; 
$cat = mysql_query("SELECT * FROM `songs_cat`"); 
while($row = mysql_fetch_array($cat)){ 
$our = mysql_query("SELECT count(id) as total FROM songs WHERE cat=$row[id]"); 

} 

if($gener == ""){ 
echo ""; 
} else { 
$cat = mysql_query("SELECT * FROM `songs_cat` WHERE `id`='$gener'"); 
$category = mysql_fetch_array($cat); 
$id=$category['id']; 
$genername = $category['value']; 
echo "<font face=\"Arial\" color=\"FF0022\" size=\"2\"><b>Песни в стил</font> $genername "; 
} 


if($_GET['gener']){ 
// Отбележете по колко резултата да се показват на страница 
$pp = "15"; 
// изберета таблиза която искате да покажете 
$table = "songs"; 

$total = mysql_result(mysql_query("SELECT COUNT(*) FROM $table"),0); 
$numofpages = $total / $pp; 
if (!isset($_GET['page'])) { 
$page = 1; 
} 
else { 
$page = $_GET['page']; 
} 
$limitvalue = $page * $pp - ($pp); 

/* покажете записите, в този случай аз показвам само [username] */ 
$query = "SELECT * FROM `$table` WHERE `cat`='$gener' ORDER BY `id` DESC LIMIT $limitvalue, $pp"; 
$result = mysql_query($query); 
while($row=mysql_fetch_array($result)) 
{ 
echo "» <a href=\"playsong.php?id=$row[id]\">$row[artist] - $row[title]</a><br>"; 
} 
function per_page($link, $offset) { 
global $numofpages, $page; 
$numofpages = round($numofpages); 

$pagesstart = round($page-$offset); 
$pagesend = round($page+$offset); 

/* показване на стрелки « за предишна страница */ 
if ($page != "1" && round($numofpages) != "0") { 
echo str_replace("%page", round($page-1), '<a href="'.$link.'"><font face="Trebuchet MS">«</font></a> '); 
} 

for($i = 1; $i <= $numofpages; $i++) { 
if ($pagesstart <= $i && $pagesend >= $i) { 
if ($i == $page) { 
echo "<b>[$i]</b> "; 
} 
else { 
echo str_replace("%page", "$i", '<a href="'.$link.'">'.$i.'</a> '); //номерация на страниците 
} 
} 
} 
if (round($numofpages) == "0") { 
echo "[$i]"; 
} 
/* показване на стрелки » за следваща страница */ 
if ($page != round($numofpages) && round($numofpages) != "0") { 
echo str_replace("%page", round($page+1), '<a href="'.$link.'"><font face="Trebuchet MS">»</font></a>'); 
} 
} 

/* показване на общия брой страници и избор на страница */ 
echo '<br>'; 
echo 'Общо страници: '.round($numofpages).'<br>'; 

per_page("?page=%page", "5"); 
} 
?>
<center>
<br>

<div id="left">
<form action="music.php" method="post"> 
<?php echo $lang[songname]; ?>: <input type="text" name="find" size="30" /> 
<input type="submit" class="button" value="Търсене" /> 
 

</form>
<table width="375" border="0"  cellpadding="1" cellspacing="1" id="table"> 
<tr> 
<td> 
<?php 
include("conn.php"); 
$gener = $_GET['gener']; 
$cat = mysql_query("SELECT * FROM `songs_cat`"); 
while($row = mysql_fetch_array($cat)){ 
$our = mysql_query("SELECT count(id) as total FROM songs WHERE cat=$row[id]"); 

} 
?> 
<br></td> 
</tr> 
<tr> 
<td>
<div class="boxtext"> 
<?php if($gener == ""){ 
echo "<font face=\"Arial\" color=\"0B3CBF\" size=\"2\"><b>Всички песни</font>:"; 
} else { 
$cat = mysql_query("SELECT * FROM `songs_cat` WHERE `id`='$gener'"); 
$category = mysql_fetch_array($cat); 
$id=$category['id']; 
$genername = $category['value']; 
echo "Песни в стил $genername"; 
} 

?> 
</div> 
<br>
<?{
// Отбележете по колко резултата да се показват на страница 
$pp = "15"; 
// изберета таблиза която искате да покажете 
$table = "songs"; 

$total = mysql_result(mysql_query("SELECT COUNT(*) FROM $table"),0); 
$numofpages = $total / $pp; 
if (!isset($_GET['page'])) { 
$page = 1; 
} 
else { 
$page = $_GET['page']; 
} 
$limitvalue = $page * $pp - ($pp); 

/* покажете записите, в този случай аз показвам само [username] */ 
$sql = "SELECT * FROM `$table` ORDER BY id DESC LIMIT $limitvalue, $pp"; 
$result = mysql_query($sql); 
$item = $_REQUEST['find'];



$data = mysql_query("SELECT * FROM songs WHERE title LIKE '%$item%'");



while($row = mysql_fetch_array($data)){
echo "» <a href=\"playsong.php?id=$row[id]\"><font face=\"Arial\" color=\"FF0022\" size=\"2\"><b>$row[artist] - $row[title]</a></font><br>"; }

 
function per_page($link, $offset) { 
global $numofpages, $page; 
$numofpages = round($numofpages); 

$pagesstart = round($page-$offset); 
$pagesend = round($page+$offset); 

/* показване на стрелки « за предишна страница */ 
if ($page != "1" && round($numofpages) != "0") { 
echo str_replace("%page", round($page-1), '<a href="'.$link.'"><font face="Trebuchet MS">«</font></a> '); 
} 

for($i = 1; $i <= $numofpages; $i++) { 
if ($pagesstart <= $i && $pagesend >= $i) { 
if ($i == $page) { 
echo "<b>[$i]</b> "; 
} 
else { 
echo str_replace("%page", "$i", '<a href="'.$link.'">'.$i.'</a> '); //номерация на страниците 
} 
} 
} 
if (round($numofpages) == "0") { 
echo "[$i]"; 
} 
/* показване на стрелки » за следваща страница */ 
if ($page != round($numofpages) && round($numofpages) != "0") { 
echo str_replace("%page", round($page+1), '<a href="'.$link.'"><font face="Trebuchet MS">»</font></a>'); 
} 
} 

/* показване на общия брой страници и избор на страница */ 
echo '<br>'; 
echo 'Общо страници: '.round($numofpages).'<br>'; 

per_page("?page=%page", "5"); 
} 
?>
</td> 
</tr> 
</table> 

</diV>
</center></td>
<td width="199px" valign="top" style="color:#FFFFFF; ">
<center><font size="2px"><?php echo $lang[mcategory]; ?></font>
</center>
<br>
<center>
<div id="category"> 
<?php 
include("conn.php"); 
$gener = $_GET['gener']; 
$cat = mysql_query("SELECT * FROM `songs_cat`"); 
while($row = mysql_fetch_array($cat)){ 
$our = mysql_query("SELECT count(id) as total FROM songs WHERE cat=$row[id]"); 
while($raw=mysql_fetch_array($our)){ 
$total=$raw['total']; 
} 
echo  "<a style=\"color: #FFFFFF;\" href=\"cats.php?gener=$row[id]\">$row[value] ($total) </a>  ";} 
?> 
</center>
<div id="left">
</td>
</tr>
</table>

<font color="#ffffff"size="2px"><?php print $lang[copyright]; ?></font>

</body>
</html>

tu6o · 29 Декември 2007

Ползвай страницирането на този адрес например http://onmusic.freehostia.com/cats.php?gener=31
А като стана въпрос и то не е както трябва

Код:

$gener=$_GET[gener];

echo '<a href="cat.php?gener='.$gener.'&page='.$page.'">';//където $page е поредния номер страница

gogato93 · 29 Декември 2007

Код:

$gener=$_GET[gener];

echo '<a href="cat.php?gener='.$gener.'&page='.$page.'">';//където $page е поредния номер страница

Къде се слага?Моляте направи ми го в кода

gogato93 · 29 Декември 2007

Хайде де моля ви!

Да пооправите едно кодче?

gogato93

Registered

AnF3taMin4o

Registered

Malfurion3

Registered

gogato93

Registered

tu6o

Registered

gogato93

Registered

gogato93

Registered