Страниране(странициране)

lyki · 21 Февруари 2011

Някои може ли да ми странира този код:

PHP:

<?php

$but="Прочети";


$connect = mysql_connect("localhost", "root", ""); 
$select_db = mysql_select_db("haznata_lyrics"); 
mysql_query('set names cp1251',$connect); 
if($_GET['id']){ 
$lyricid = $_GET['id']; 
$query1 = "SELECT * FROM `lyrics` where id = '$lyricid'"; 
$result1=mysql_query($query1); 
while($r = mysql_fetch_array($result1)) { 
extract($r); 
$text2 = nl2br("$text"); 
echo "<tr><td>Заглавие--$izpulnitel</td></tr>
<tr><td>Автор--$pesen</td></tr>
<tr><td>Урок--$text
</a><a href='view.php'>Назад</a></td></tr>";
} 
} 
else { 
$query = "SELECT * FROM `lyrics` ORDER BY id DESC"; 
$result=mysql_query($query); 
while($r = mysql_fetch_array($result)) { 
extract($r); 
echo "<tr><tr>
<td rowspan='3' background='img/soft.png' WIDTH='90' HEIGHT='90'></td>
<td colspan='3'>$izpulnitel</td>
</tr>
<tr>
<td colspan='3'>$link</td>
</tr>
<tr>
<td colspan='3'><a href='view.php?id=$id'>$but</td>
</tr></tr> ";

} 
}
?>

Цял ден гледам уроци и кодове но нищо не стана,ще съм ви много благодарен ако помогнете.

eddy · 21 Февруари 2011

PHP:

<?php



$but="Прочети";





$connect = mysql_connect("localhost", "root", ""); 

$select_db = mysql_select_db("haznata_lyrics"); 

mysql_query('set names cp1251',$connect); 

if($_GET['id']){ 

$lyricid = $_GET['id']; 

$query1 = "SELECT * FROM `lyrics` where id = '$lyricid'"; 

$result1=mysql_query($query1); 

while($r = mysql_fetch_array($result1)) { 

extract($r); 

$text2 = nl2br("$text"); 

$i=0; 
while ($i < $num) { 
echo "<tr><td>Заглавие--$izpulnitel</td></tr>

<tr><td>Автор--$pesen</td></tr>

<tr><td>Урок--$text

</a><a href='view.php'>Назад</a></td></tr>";

} 

} 

else { 

$query = "SELECT * FROM `lyrics` ORDER BY id DESC"; 

$result=mysql_query($query); 

while($r = mysql_fetch_array($result)) { 

extract($r); 

echo "<tr><tr>

<td rowspan='3' background='img/soft.png' WIDTH='90' HEIGHT='90'></td>

<td colspan='3'>$izpulnitel</td>

</tr>

<tr>

<td colspan='3'>$link</td>

</tr>

<tr>

<td colspan='3'><a href='view.php?id=$id'>$but</td>

</tr></tr> ";

} 

}

$i++; 
 

}

echo "<br><br><br><br>"; 
//от тук започва кода за показването на страниците 
if ($page > 1) { 
$prev = ($page - 1); 
echo "<a href=\"?ppage=$prev\"><font face=\"Trebuchet MS\" size='3'> << </font></a> "; 
} 
else echo "<font face=\"Trebuchet MS\" size='3'> << </font> "; 

if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<font size='3'>$i</font>"; 
} 
else { 
echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<font size='3'>$i</font> "; 
} 
else { 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo "<a href=\"?ppage=4\">4</a> "; 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> "; 
} 
if ($page == 5) $parva.= "<a href=\"?ppage=4\">4</a> "; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> ";
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo "... "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> ";
} 

if ( $page > ($total - 5) ) { 
echo "... "; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<a href=\"?ppage=$next\"><font face=\"Trebuchet MS\" size='3'> >> </font></a> "; 
} 
else echo "<font face=\"Trebuchet MS\" size='3'> >> </font>"; 
?>

lyki · 21 Февруари 2011

Parse error: syntax error, unexpected T_ELSE in D:\wamp\www\pesni\view.php on line 45
Мисля че е нещо в else и къдравите скоби.

eddy · 21 Февруари 2011

PHP:

<?php

$but="Прочети";


$connect = mysql_connect("localhost", "root", ""); 
$select_db = mysql_select_db("haznata_lyrics"); 
mysql_query('set names cp1251',$connect); 
if($_GET['id']){ 
$lyricid = $_GET['id']; 
$query1 = "SELECT * FROM `lyrics` where id = '$lyricid'"; 
$result1=mysql_query($query1); 
while($r = mysql_fetch_array($result1)) { 
extract($r); 
$text2 = nl2br("$text"); 



$i=0; 
while ($i < $num) { 

echo "<tr><td>Заглавие--$izpulnitel</td></tr>

<tr><td>Автор--$pesen</td></tr>

<tr><td>Урок--$text

</a><a href='view.php'>Назад</a></td></tr>";
$i++;
} 



} 
} 
else { 
$query = "SELECT * FROM `lyrics` ORDER BY id DESC"; 
$result=mysql_query($query); 
while($r = mysql_fetch_array($result)) { 
extract($r); 

$i=0; 
while ($i < $num) { 

echo "<tr><tr>
<td rowspan='3' background='img/soft.png' WIDTH='90' HEIGHT='90'></td>
<td colspan='3'>$izpulnitel</td>
</tr>
<tr>
<td colspan='3'>$link</td>
</tr>
<tr>
<td colspan='3'><a href='view.php?id=$id'>$but</td>
</tr></tr> ";
$i++;
} 
} 
}

echo "<br><br><br><br>"; 
//от тук започва кода за показването на страниците 
if ($page > 1) { 
$prev = ($page - 1); 
echo "<a href=\"?ppage=$prev\"><font face=\"Trebuchet MS\" size='3'> << </font></a> "; 
} 
else echo "<font face=\"Trebuchet MS\" size='3'> << </font> "; 

if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<font size='3'>$i</font>"; 
} 
else { 
echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<font size='3'>$i</font> "; 
} 
else { 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo "<a href=\"?ppage=4\">4</a> "; 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> "; 
} 
if ($page == 5) $parva.= "<a href=\"?ppage=4\">4</a> "; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> ";
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo "... "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> ";
} 

if ( $page > ($total - 5) ) { 
echo "... "; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<a href=\"?ppage=$next\"><font face=\"Trebuchet MS\" size='3'> >> </font></a> "; 
} 
else echo "<font face=\"Trebuchet MS\" size='3'> >> </font>"; 
?>

lyki · 21 Февруари 2011

Няма грешка но не извежда абсолютно нищо.

eddy · 21 Февруари 2011

Пробвай това:

PHP:

<?php

$but="Прочети";


$connect = mysql_connect("localhost", "root", ""); 
$select_db = mysql_select_db("haznata_lyrics"); 
mysql_query('set names cp1251',$connect); 
if($_GET['id']){ 
$lyricid = $_GET['id']; 
$query1 = "SELECT * FROM `lyrics` where id = '$lyricid'"; 
$result1=mysql_query($query1); 
while($r = mysql_fetch_array($result1)) { 
extract($r); 
$text2 = nl2br("$text"); 



$i=0; 
while ($i < $num) { 

echo "<tr><td>Заглавие--$izpulnitel</td></tr>

<tr><td>Автор--$pesen</td></tr>

<tr><td>Урок--$text

</a><a href='view.php'>Назад</a></td></tr>";
$i++;
} 



} 
} 
else { 
$query = "SELECT * FROM `lyrics` ORDER BY id DESC"; 
$result=mysql_query($query); 
while($r = mysql_fetch_array($result)) { 
extract($r); 

 

echo "<tr><tr>
<td rowspan='3' background='img/soft.png' WIDTH='90' HEIGHT='90'></td>
<td colspan='3'>$izpulnitel</td>
</tr>
<tr>
<td colspan='3'>$link</td>
</tr>
<tr>
<td colspan='3'><a href='view.php?id=$id'>$but</td>
</tr></tr> ";
 
} 
}

echo "<br><br><br><br>"; 
//от тук започва кода за показването на страниците 
if ($page > 1) { 
$prev = ($page - 1); 
echo "<a href=\"?ppage=$prev\"><font face=\"Trebuchet MS\" size='3'> << </font></a> "; 
} 
else echo "<font face=\"Trebuchet MS\" size='3'> << </font> "; 

if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<font size='3'>$i</font>"; 
} 
else { 
echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<font size='3'>$i</font> "; 
} 
else { 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo "<a href=\"?ppage=4\">4</a> "; 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> "; 
} 
if ($page == 5) $parva.= "<a href=\"?ppage=4\">4</a> "; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> ";
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo "... "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"?ppage=".$i."\"><font size='3'>".$i."</font></a> ";
} 

if ( $page > ($total - 5) ) { 
echo "... "; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href=\"?ppage=".$i."\">".$i."</a> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<a href=\"?ppage=$next\"><font face=\"Trebuchet MS\" size='3'> >> </font></a> "; 
} 
else echo "<font face=\"Trebuchet MS\" size='3'> >> </font>"; 
?>

lyki · 21 Февруари 2011

Да има напредък

извежда инфото но без да има страници,а има повече от 10 записа.Ако не ти се занимава повече недей.

eddy · 21 Февруари 2011

Код:

if($_GET['id']){ 
$lyricid = $_GET['id']; 
$query1 = "SELECT * FROM `lyrics` where id = '$lyricid'"; 
$result1=mysql_query($query1); 
while($r = mysql_fetch_array($result1)) { 
extract($r); 
$text2 = nl2br("$text"); 



$i=0; 
while ($i < $num) { 

echo "<tr><td>Заглавие--$izpulnitel</td></tr>

<tr><td>Автор--$pesen</td></tr>

<tr><td>Урок--$text

</a><a href='view.php'>Назад</a></td></tr>";
$i++;
} 



} 
} 
else { 
$query = "SELECT * FROM `lyrics` ORDER BY id DESC"; 
$result=mysql_query($query); 
while($r = mysql_fetch_array($result)) { 
extract($r); 

 

echo "<tr><tr>
<td rowspan='3' background='img/soft.png' WIDTH='90' HEIGHT='90'></td>
<td colspan='3'>$izpulnitel</td>
</tr>
<tr>
<td colspan='3'>$link</td>
</tr>
<tr>
<td colspan='3'><a href='view.php?id=$id'>$but</td>
</tr></tr> ";
 
} 
}

Виж този код кое искаш да се страницира " if " или "else" или и 2 те зависи от ситуацийте който са дадени.[/php]

lyki · 21 Февруари 2011

PHP:

else { 
$query = "SELECT * FROM `lyrics` ORDER BY id DESC"; 
$result=mysql_query($query); 
while($r = mysql_fetch_array($result)) { 
extract($r); 

 

echo "<tr><tr>
<td rowspan='3' background='img/soft.png' WIDTH='90' HEIGHT='90'></td>
<td colspan='3'>$izpulnitel</td>
</tr>
<tr>
<td colspan='3'>$link</td>
</tr>
<tr>
<td colspan='3'><a href='view.php?id=$id'>$but</td>
</tr></tr> ";
 
} 
}

Ето това ми трябва да се странира

eddy · 21 Февруари 2011

eddy каза:

PHP:

<?php



$but="Прочети";





$connect = mysql_connect("localhost", "root", ""); 

$select_db = mysql_select_db("haznata_lyrics"); 

mysql_query('set names cp1251',$connect); 

if($_GET['id']){ 

$lyricid = $_GET['id']; 

$query1 = "SELECT * FROM `lyrics` where id = '$lyricid'"; 

$result1=mysql_query($query1); 

while($r = mysql_fetch_array($result1)) { 

extract($r); 

$text2 = nl2br("$text"); 


echo "<tr><td>Заглавие--$izpulnitel</td></tr>

<tr><td>Автор--$pesen</td></tr>

<tr><td>Урок--$text

</a><a href='view.php'>Назад</a></td></tr>";

} 

} 

else { 

$query = "SELECT * FROM `lyrics` ORDER BY id DESC"; 

$result=mysql_query($query); 

while($r = mysql_fetch_array($result)) { 

extract($r); 

$i=0; 
while ($i < $num) { 

echo "<tr><tr>

<td rowspan='3' background='img/soft.png' WIDTH='90' HEIGHT='90'></td>

<td colspan='3'>$izpulnitel</td>

</tr>

<tr>

<td colspan='3'>$link</td>

</tr>

<tr>

<td colspan='3'><a href='view.php?id=$id'>$but</td>

</tr></tr> ";

$i++; 
 

}

} 

}



echo "<br><br><br><br>"; 
//от тук започва кода за показването на страниците 
if ($page > 1) { 
$prev = ($page - 1); 
echo "<a href="?ppage=$prev"><font face="Trebuchet MS" size='3'> << </font></a> "; 
} 
else echo "<font face="Trebuchet MS" size='3'> << </font> "; 

if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<font size='3'>$i</font>"; 
} 
else { 
echo "<a href="?ppage=".$i."">".$i."</a> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<font size='3'>$i</font> "; 
} 
else { 
echo "<a href="?ppage=".$i.""><font size='3'>".$i."</font></a> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo "<a href="?ppage=4">4</a> "; 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href="?ppage=".$i.""><font size='3'>".$i."</font></a> "; 
} 
if ($page == 5) $parva.= "<a href="?ppage=4">4</a> "; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href="?ppage=".$i."">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href="?ppage=".$i.""><font size='3'>".$i."</font></a> ";
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo "... "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href="?ppage=".$i."">".$i."</a> "; 
} 
echo "... "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href="?ppage=".$i.""><font size='3'>".$i."</font></a> ";
} 

if ( $page > ($total - 5) ) { 
echo "... "; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<font size='3'>$i</font>"; 
else echo "<a href="?ppage=".$i."">".$i."</a> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<a href="?ppage=$next"><font face="Trebuchet MS" size='3'> >> </font></a> "; 
} 
else echo "<font face="Trebuchet MS" size='3'> >> </font>"; 
?>

lyki · 22 Февруари 2011

Ето ги файловете аз немога

изтегли

lyki · 22 Февруари 2011

Моля ви се :roll: :roll:

BoBySS · 22 Февруари 2011

Това винаги е работило (и ще работи при мен). Добавих го към твоя файл, само си го провери.

Поздрави!

class.pager.php

Код:

<?php
class Pager
{
function findStart($limit)
{
if ((!isset($_GET['page'])) || ($_GET['page'] == "1"))
{
$start = 0;
$_GET['page'] = 1;
}
else
{
$start = ($_GET['page']-1) * $limit;
}

return $start;
}

function findPages($count, $limit)
{
$pages = (($count % $limit) == 0) ? $count / $limit : floor($count / $limit) + 1;

return $pages;
}

function pageList($curpage, $pages)
{
$page_list = "";

if (($curpage != 1) && ($curpage))
{
$page_list .= " <a href=\"".$_SERVER['PHP_SELF']."?page=1\" title=\"Първа\">Първа</a> ";
}

if (($curpage-1) > 0)
{
$page_list .= "<a href=\"".$_SERVER['PHP_SELF']."?page=".($curpage-1)."\" title=\"Предишна\"><</a> ";
}

for ($i=1; $i<=$pages; $i++)
{
if ($i == $curpage)
{
$page_list .= "<b>".$i."</b>";
}
else
{
$page_list .= "<a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\" title=\"Страница ".$i."\">".$i."</a>";
}
$page_list .= " ";
}

if (($curpage+1) <= $pages)
{
$page_list .= "<a href=\"".$_SERVER['PHP_SELF']."?page=".($curpage+1)."\" title=\"Следваща\">></a> ";
}

if (($curpage != $pages) && ($pages != 0))
{
$page_list .= "<a href=\"".$_SERVER['PHP_SELF']."?page=".$pages."\" title=\"Последна\">Последна</a> ";
}
$page_list .= "</td>\n";

return $page_list;
}

function nextPrev($curpage, $pages)
{
$next_prev = "";

if (($curpage-1) <= 0)
{
$next_prev .= "Previous";
}
else
{
$next_prev .= "<a href=\"".$_SERVER['PHP_SELF']."?page=".($curpage-1)."\">Предишна</a>";
}

$next_prev .= " | ";

if (($curpage+1) > $pages)
{
$next_prev .= "Next";
}
else
{
$next_prev .= "<a href=\"".$_SERVER['PHP_SELF']."?page=".($curpage+1)."\">Следваща</a>";
}

return $next_prev;
}
}
?>

view.php

Код:

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="content='text/html; charset=windows-1251" />

<title>My PC</title>

</head>

    <body>
<table border="1">
   <?php error_reporting (E_ALL ^ E_NOTICE); ?>

<?php
require_once("class.pager.php");
$p = new Pager;
$limit = 100;
$start = $p->findStart($limit);
mysql_query("SET CHARACTER SET utf8");

$count = mysql_num_rows(mysql_query("SELECT * FROM lyrics ORDER BY id DESC"));
$pages = $p->findPages($count, $limit);
$result = mysql_query("SELECT * FROM lyrics ORDER BY id DESC LIMIT ".$start.", ".$limit);

$but="Прочети";


$connect = mysql_connect("localhost", "root", "");
$select_db = mysql_select_db("haznata_lyrics");
mysql_query('set names cp1251',$connect);
if($_GET['id']){
$lyricid = $_GET['id'];
$query1 = "SELECT * FROM `lyrics` where id = '$lyricid'";
$result1=mysql_query($query1);
while($r = mysql_fetch_array($result1)) {
extract($r);
$text2 = nl2br("$text");
echo "<tr><td>Заглавие--$izpulnitel</td></tr>
<tr><td>Автор--$pesen</td></tr>
<tr><td>Урок--$text
</a><a href='view.php'>Назад</a></td></tr>";
}
}
else {
$query = "SELECT * FROM `lyrics` ORDER BY id DESC";
$result=mysql_query($query);
while($r = mysql_fetch_array($result)) {
extract($r);
echo "<tr><tr>
<td rowspan='3' background='img/soft.png' WIDTH='90' HEIGHT='90'></td>
<td colspan='3'>$izpulnitel</td>
</tr>
<tr>
<td colspan='3'>$link</td>
</tr>
<tr>
<td colspan='3'><a href='view.php?id=$id'>$but</td>
</tr></tr> ";

}
$pagelist = $p->pageList($_GET['page'], $pages);
echo "<center> Страници: ";
echo $pagelist;
echo "</center>";
echo "<br/>";

/* Или можеш да ползваш "Previous | Next" ако не искаш номера с долните два израза */
//$next_prev = $p->nextPrev($_GET['page'], $pages);
//echo $next_prev;
}
?>

</table>
    </body>
</html>

lyki · 22 Февруари 2011

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\wamp\www\pesni\view.php on line 20

BoBySS · 23 Февруари 2011

lyki каза:
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\wamp\www\pesni\view.php on line 20

Подметнах да си провериш кода, защото тогава нямах времето...

Нормално е конекцията да е преди четенето на каквото и да било от Базата Данни.

Така си работи при мен без проблем, само си оправи маймуницата:

view.php

Код:

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="content='text/html; charset=windows-1251" />

<title>My PC</title>

</head>

    <body>
<table border="1">
   <?php error_reporting (E_ALL ^ E_NOTICE); ?>

<?php
require_once("class.pager.php");

$but="Прочети";
$connect = mysql_connect("localhost", "root", "");
$select_db = mysql_select_db("haznata_lyrics");
mysql_query('set names cp1251',$connect);


$p = new Pager;
$limit = 10; //Отбелязва колко резултата на страница да извежда!!!
$start = $p->findStart($limit);

$count = mysql_num_rows(mysql_query("SELECT * FROM lyrics ORDER BY id DESC"));
$pages = $p->findPages($count, $limit);
$result = mysql_query("SELECT * FROM lyrics ORDER BY id DESC LIMIT ".$start.", ".$limit);


if($_GET['id']){
$lyricid = $_GET['id'];
$query1 = "SELECT * FROM `lyrics` where id = '$lyricid'";
$result1=mysql_query($query1);
while($r = mysql_fetch_array($result1)) {
extract($r);
$text2 = nl2br("$text");
echo "<tr><td>Заглавие--$izpulnitel</td></tr>
<tr><td>Автор--$pesen</td></tr>
<tr><td>Урок--$text
</a><a href='view.php'>Назад</a></td></tr>";
}
}
else {
$query = "SELECT * FROM `lyrics` ORDER BY id DESC";
$result=mysql_query($query);
while($r = mysql_fetch_array($result)) {
extract($r);
echo "<tr><tr>
<td rowspan='3' background='img/soft.png' WIDTH='90' HEIGHT='90'></td>
<td colspan='3'>$izpulnitel</td>
</tr>
<tr>
<td colspan='3'>$link</td>
</tr>
<tr>
<td colspan='3'><a href='view.php?id=$id'>$but</td>
</tr></tr> ";

}
$pagelist = $p->pageList($_GET['page'], $pages);
echo "<center> Страници: ";
echo $pagelist;
echo "</center>";
echo "<br/>";

/* Или можеш да ползваш "Previous | Next" ако не искаш номера с долните два израза */
//$next_prev = $p->nextPrev($_GET['page'], $pages);
//echo $next_prev;
}
?>

</table>
    </body>
</html>

Поздрави!

Страниране(странициране)

lyki

Registered

eddy

Registered

lyki

Registered

eddy

Registered

lyki

Registered

eddy

Registered

lyki

Registered

eddy

Registered

lyki

Registered

eddy

Registered

lyki

Registered

lyki

Registered

BoBySS

Registered

lyki

Registered

BoBySS

Registered