Странициране на каpтинки

S

spaidur

Registered
Някои ще може ли да сложе странициване на ето този код за изкарване на картинки

Код: 
<?php
require "config.php";
require "functions.php";

echo "<center><font size=\"5\" color=\"red\">Файлове</font></center><hr color=\"red\">";

$query = mysql_query("SELECT * FROM `files` ORDER BY `id` DESC LIMIT 40");


if (mysql_num_rows($query) > 0)
{
$y=0;
echo "<table border=\"0\" align=\"center\" valign=\"top\"><tr>\n";
while ($row = mysql_fetch_array($query))
{
$size = resize($row['pic']);
if($y%4==0)
{
if($y!=0)
{
echo "</tr>";
}
echo "

<tr><td>
<a href=\"".$row['pic']."\" target=\"_blank\">
<img src=\"".$row['pic']."\" width=\"".$size['width']."\" height=\"".$size['height']."\" border=\"0\">
</a>
</td>

";
}
else
{
echo "<td><a href=\"".$row['pic']."\" target=\"_blank\">
<img src=\"".$row['pic']."\" width=\"".$size['width']."\" height=\"".$size['height']."\" border=\"0\">
</a></td>";
}
$y++;
}
echo "</table>";
}
else
{
echo "<b>Все още няма файлове!</b>";
}
?>
 
Код: 
<?php
require "config.php";
require "functions.php";


$broinastranica = 30;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;

$query = "SELECT COUNT(id) AS numrows FROM `lyrics`";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];


$maxPage = ceil($numrows/$broinastranica);

$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';

for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}

if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <font color=orange><a href=\"$self?page=$page\"> [<] </a></font> ";

$parva = " <font color=orange><a href=\"$self?page=1\">[първа]</a></font> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}

echo "<center><font size=\"5\" color=\"red\">Файлове</font></center><hr color=\"red\">";

$query = mysql_query("SELECT * FROM `files` ORDER BY `id` DESC LIMIT 40, $redove, $broinastranica");


if (mysql_num_rows($query) > 0)
{
$y=0;
echo "<table border=\"0\" align=\"center\" valign=\"top\"><tr>\n";
while ($row = mysql_fetch_array($query))
{
$size = resize($row['pic']);
if($y%4==0)
{
if($y!=0)
{
echo "</tr>";
}
echo "

<tr><td>
<a href=\"".$row['pic']."\" target=\"_blank\">
<img src=\"".$row['pic']."\" width=\"".$size['width']."\" height=\"".$size['height']."\" border=\"0\">
</a>
</td>

";
}
else
{
echo "<td><a href=\"".$row['pic']."\" target=\"_blank\">
<img src=\"".$row['pic']."\" width=\"".$size['width']."\" height=\"".$size['height']."\" border=\"0\">
</a></td>";
}
$y++;
}
echo "</table>";
}
else
{
echo "<b>Все още няма файлове!</b>";
}
echo "<font color = '#000' />Страница: </font>";
echo "<font color = '#000' />$nomeranastranici</font>";
?>
 
дава ето тази грешка
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\saitove\uplowd\pic.php on line 55
Âñå îùå íÿìà ôàéëîâå!Ñòðàíèöà: 1
Увеличете...
на този ред
Код: 
if (mysql_num_rows($query) > 0)
{
 
Код: 
	<?php
require "config.php";
require "functions.php";


$broinastranica = 30;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;

$query = "SELECT COUNT(id) AS numrows FROM `lyrics`";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];


$maxPage = ceil($numrows/$broinastranica);

$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';

for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}

if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <font color=orange><a href=\"$self?page=$page\"> [<] </a></font> ";

$parva = " <font color=orange><a href=\"$self?page=1\">[първа]</a></font> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}

echo "<center><font size=\"5\" color=\"red\">Файлове</font></center><hr color=\"red\">";

$query = mysql_query("SELECT * FROM `files` ORDER BY `id` DESC LIMIT $redove, $broinastranica");


if (mysql_num_rows($query) > 0)
{
$y=0;
echo "<table border=\"0\" align=\"center\" valign=\"top\"><tr>\n";
while ($row = mysql_fetch_array($query))
{
$size = resize($row['pic']);
if($y%4==0)
{
if($y!=0)
{
echo "</tr>";
}
echo "

<tr><td>
<a href=\"".$row['pic']."\" target=\"_blank\">
<img src=\"".$row['pic']."\" width=\"".$size['width']."\" height=\"".$size['height']."\" border=\"0\">
</a>
</td>

";
}
else
{
echo "<td><a href=\"".$row['pic']."\" target=\"_blank\">
<img src=\"".$row['pic']."\" width=\"".$size['width']."\" height=\"".$size['height']."\" border=\"0\">
</a></td>";
}
$y++;
}
echo "</table>";
}
else
{
echo "<b>Все още няма файлове!</b>";
}
echo "<font color = '#000' />Страница: </font>";
echo "<font color = '#000' />$nomeranastranici</font>";
?>
 
spaidur каза:
<?php
require "config.php";
require "functions.php";

echo "<center><font size="5" color="red">Файлове</font></center><hr color="red">";

$pp = 12; // по колко снимки да показва на страница
echo "<center><font size="5" color="red">Файлове</font></center><hr color="red">";
$page = (!isset($_GET['page']) || !is_numeric($_GET['page']) ? 1 : htmlspecialchars(addslashes($_GET['page'])));
$limit = ($page * $pp) - $pp;
echo $page ."=". $limit."<br />";
$query = mysql_query("SELECT * FROM `files` ORDER BY `id` DESC LIMIT $limit,12");


if (mysql_num_rows($query) > 0)
{
$y=0;
echo "<table border="0" align="center" valign="top"><tr>\n";
while ($row = mysql_fetch_array($query))
{
$size = resize($row['pic']);
if($y%4==0)
{
if($y!=0)
{
echo "</tr>";
}
echo "

<tr><td>
<a href="".$row['pic']."" target="_blank">
<img src="".$row['pic']."" width="".$size['width']."" height="".$size['height']."" border="0">
</a>
</td>

";
}
else
{
echo "<td><a href="".$row['pic']."" target="_blank">
<img src="".$row['pic']."" width="".$size['width']."" height="".$size['height']."" border="0">
</a></td>";
}
$y++;
}
$all = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `files`"),0,0)or die(mysql_error());
$all = round($all/$pp);
if ($all > 1) { echo "<tr><td>"; for($i = 1;$i <= $all;$i++) { echo "<a href="".$_SERVER['PHP_SELF']."?page=".$i."">".$i."</a> "; } echo "</td></tr>"; }
echo "</table>";
}
else
{
echo "<b>Все още няма файлове!</b>";
}
?>
Увеличете...
Пробвай
 
Ето ти едно странициране от @jooorooo , правиш си една функцийка
function pagination($page,$total) {
if ($total < 10) {
for($i=1 ; $i<=$total ; $i++) {
if ( ($page)==$i ) {
echo "<b>$i</b> ";
}
else {
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($page)==$i ) {
echo "<b>$i</b> ";
}
else {
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
}

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

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

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

if ( $page > ($total - 5) ) {
echo "... ";
for ($i=$total-5; $i<=$total; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
}
}
}
Увеличете...
и отдолу вместо моя код
Код: 
if ($all > 1) { echo "<tr><td>"; for($i = 1;$i <= $all;$i++) { echo "<a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">".$i."</a> "; } echo "</td></tr>"; }
го направи на
if ($all > 1) { echo "<tr><td>"; pagination($page,$all); echo "</td></tr>"; }
Увеличете...
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе