Stronicowanie, Wiem że było ale mam problem Opcje

[djgarsi]

Witam. Ze skryptem stronicowania "użeram się" już długo. Próbowałem w js - nie wyszło, w ajax'ie - to samo.
Moja wiedza na temat php dopiero raczkuje.(IMG:style_emoticons/default/sad.gif) Dlatego chciałbym, aby ktoś pomógł mi przerobić skrypt download'u, aby co określoną liczbę plików rozpoczynała się nowa strona.

Oto mój plik download.php

[PHP] pobierz, plaintext 
$download_start = get_template('download_start.tpl');
echo $download_start;
 
if($_GET['cat'] >= 1)
{
 
//---
 
$Query_cat="SELECT * FROM kategorie WHERE id='".mysql_real_escape_string($_GET['cat'])."' ORDER BY name ASC";
$result_cat = mysql_query($Query_cat) or die (mysql_error());
while ( $row_cat = mysql_fetch_array($result_cat))
{
 
$download_info_cat = get_template('download_info_cat.tpl');
$download_info_cat = str_replace("{cat}", $row_cat['name'], $download_info_cat);
$download_info_cat = str_replace("{l_cat}", $lang['cat'], $download_info_cat);
echo $download_info_cat;
 
$Query_pcat="SELECT * FROM kategorie WHERE pod='".$row_cat['id']."' ORDER BY name ASC";
$result_pcat = mysql_query($Query_pcat) or die (mysql_error());
while ( $row_pcat = mysql_fetch_array($result_pcat))
{
 
  $res = mysql_query("SELECT * FROM file WHERE cat='".$row_pcat["id"]."' and active='1'");
  $ile2 = mysql_num_rows($res);
 
echo'&nbsp;&nbsp;<a href="podkategoria,'.$row_pcat['id'].','.namen($row_pcat['name']).'.html"></a>';
 
}
 
  $res = mysql_query("SELECT * FROM file WHERE cat='".mysql_real_escape_string($_GET['cat'])."' and active='1'");
  $ile2 = mysql_num_rows($res);
 
if($ile2 >= 1)
{
echo'';
}
 
$Query_file="SELECT * FROM file WHERE cat='".mysql_real_escape_string($_GET['cat'])."' ORDER BY id DESC";
$result_file = mysql_query($Query_file) or die (mysql_error());
while ( $row_file = mysql_fetch_array($result_file))
{
 
$download_info_file = get_template('download_info_file.tpl');
 
$download_info_file = str_replace("{id}", $row_file['id'], $download_info_file);
$download_info_file = str_replace("{name}", $row_file['name'], $download_info_file);
$download_info_file = str_replace("{name_n}", namen($row_file['name']), $download_info_file);
$download_info_file = str_replace("{data}", $row_file['data'], $download_info_file);
$download_info_file = str_replace("{pobran}", $row_file['pobran'], $download_info_file);
$download_info_file = str_replace("{licencja}", $row_file['licencja'], $download_info_file);
$download_info_file = str_replace("{opis}", $row_file['opis'], $download_info_file);
$download_info_file = str_replace("{l_data}", $lang['dodano'], $download_info_file);
$download_info_file = str_replace("{l_pobran}", $lang['pobran'], $download_info_file);
$download_info_file = str_replace("{l_licencja}", $lang['licencja'], $download_info_file);
 
if($row_file["img"] == "")
{
$download_info_file = str_replace("{img}", "", $download_info_file);
}
else
{
$download_info_file = str_replace("{img}", $row_file['img'], $download_info_file);
}
 
echo $download_info_file;
 
}
 
}
 
//---
 
}
else if($_GET['pcat'] >= 1)
{
 
//---
 
$Query_catt="SELECT * FROM kategorie WHERE id='".mysql_real_escape_string($_GET['pcat'])."'";
$result_catt = mysql_query($Query_catt) or die (mysql_error());
while ( $row_catt = mysql_fetch_array($result_catt))
{
 
$download_info_cat = get_template('download_info_cat.tpl');
$download_info_cat = str_replace("{cat}", $row_catt['name'], $download_info_cat);
$download_info_cat = str_replace("{l_cat}", $lang['cat'], $download_info_cat);
echo $download_info_cat;
 
}
 
$Query_file="SELECT * FROM file WHERE cat='".mysql_real_escape_string($_GET['pcat'])."' ORDER BY id DESC";
$result_file = mysql_query($Query_file) or die (mysql_error());
while ( $row_file = mysql_fetch_array($result_file))
{
 
$download_info_file = get_template('download_info_file.tpl');
 
$download_info_file = str_replace("{id}", $row_file['id'], $download_info_file);
$download_info_file = str_replace("{name}", $row_file['name'], $download_info_file);
$download_info_file = str_replace("{name_n}", namen($row_file['name']), $download_info_file);
$download_info_file = str_replace("{data}", $row_file['data'], $download_info_file);
$download_info_file = str_replace("{pobran}", $row_file['pobran'], $download_info_file);
$download_info_file = str_replace("{licencja}", $row_file['licencja'], $download_info_file);
$download_info_file = str_replace("{opis}", substr($row_file['opis'], 0, 200), $download_info_file);
$download_info_file = str_replace("{l_data}", $lang['dodano'], $download_info_file);
$download_info_file = str_replace("{l_pobran}", $lang['pobran'], $download_info_file);
$download_info_file = str_replace("{l_licencja}", $lang['licencja'], $download_info_file);
 
if($row_file["img"] == "")
{
$download_info_file = str_replace("{img}", "", $download_info_file);
}
else
{
$download_info_file = str_replace("{img}", $row_file['img'], $download_info_file);
}
 
echo $download_info_file;
 
}
 
//---
 
}
else
{
 
//---
 
$Query_cat="SELECT * FROM kategorie WHERE pod='0' ORDER BY name ASC";
$result_cat = mysql_query($Query_cat) or die (mysql_error());
while ( $row_cat = mysql_fetch_array($result_cat))
{
echo'<b><a href="kategoria,'.$row_cat['id'].','.namen($row_cat['name']).'">'.$row_cat['name'].'</a></b><br>';
 
$Query_pcat="SELECT * FROM kategorie WHERE pod='".$row_cat['id']."' ORDER BY name ASC";
$result_pcat = mysql_query($Query_pcat) or die (mysql_error());
while ( $row_pcat = mysql_fetch_array($result_pcat))
{
 
  $res = mysql_query("SELECT * FROM file WHERE cat='".$row_pcat["id"]."' and active='1'");
  $ile2 = mysql_num_rows($res);
 
echo'&nbsp;&nbsp;<a href="podkategoria,'.$row_pcat['id'].','.namen($row_pcat['name']).'.html">'.$row_pcat['name'].' ['.$ile2.']</a><br>';
 
}
 
}
 
//---
}
 
$download_end = get_template('download_end.tpl');
echo $download_end;
[PHP] pobierz, plaintext 

Proszę o pomoc.(IMG:style_emoticons/default/sad.gif)

[R4D3K]

Witam, rozumiem, że chcesz paginację linków do pobrania (IMG:style_emoticons/default/questionmark.gif) Jeśli tak to musisz użyć słowa kluczowego LIMIT w zapytaniu MySQL. LIMIT pobiera 2 parametry rekord od którego czytać oraz ile rekordów czytać np. LIMIT 0,5 pobierze 5 pierwszych rekordów, LIMIT 10,5 pobierze 5 rekordów od 10 licząc itp. Czyli potrzebujesz jeszcze parametru page w skrypcie, który Ci powie na której podstronie się znajduje user. np.

[PHP] pobierz, plaintext 
If (isset($_GET['page'] {
  if (!is_int($_GET['page']) { $page=1; }
  else { $page=$_GET['page']; }
  $ile_na_stronie=5;
  $offset=$page*$ile_na_stronie;
  $sql='SELECT ........ WHERE LIMIT '.$offset.', '.$ile_na_stronie;
  // dalsza cześć aplikacji
}
[PHP] pobierz, plaintext 

W ten sposób sobie zorganizujesz wyświetlanie wyników dalej musisz zrobić linki do następnych podstron:

[PHP] pobierz, plaintext 
If ($page>1) { echo '<a href="skrypt.php?page='.($page+1).'DALEJ</a>';
If ($page<$max) { echo '<a href="skrypt.php?page='.($page-1).'POPRZEDNIA</a>';
[PHP] pobierz, plaintext 

Czy to w taki lub inny sposób, zmienna $max=$ilosc_rekordow_w_tabeli*$ile_na_stronie; to ilość rekordów w tabeli, które możesz policzyć COUNTem
Mam nadzieje, że pomogłem.. Kod pisany jest z głowy, także może coś nie działać.

Ten post edytował R4D3K 24.12.2009, 07:23:56

[djgarsi]

Niestety jest błąd.(IMG:style_emoticons/default/sad.gif)
Parse error: syntax error, unexpected T_IF in /home/djgarsi/domains/djgarsi.pl/public_html/stronicowanie.php on line 4

[Blame]

[PHP] pobierz, plaintext 
If ($page>1) { echo '<a href="skrypt.php?page='.($page+1).'DALEJ</a>';
If ($page<$max) { echo '<a href="skrypt.php?page='.($page-1).'POPRZEDNIA</a>';
[PHP] pobierz, plaintext 

Usuń stąd te dwie klamry otwierające.