Редакция на код

ReD_z0n3 · 26 Юни 2010

Искам когато се добавят 5 сайт 6-тият да бъде на 2-ра страница и т.н. с една дума искам по 5 сайта на страница

ExpressYourself · 26 Юни 2010

ReD_z0n3 каза:
Искам когато се добавят 5 сайт 6-тият да бъде на 2-ра страница и т.н. с една дума искам по 5 сайта на страница

Код няма ли да дадеш?

ReD_z0n3 · 26 Юни 2010

Код:

<?php

require_once('mysql_connect.php');

$query = "SELECT id, name, description, votes, hits FROM websites ORDER BY votes DESC LIMIT 50";
$result = mysql_query($query) OR die(mysql_error());

echo '<table border="0" cellpadding="7" cellspacing="7">
<tr>
<td><strong>Ранк</strong></td>
<td><strong>Име/Описание</td>
<td><strong>Гласове</td>
<td><strong>Посещения</td>
</tr>
';


$rank = 1;

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo '<tr>
<td>'.$rank.'</td>
<td><a href="out.php?id='.$row['id'].'" target="_blank">'.$row['name'].'</a><br /><small>'.
$row['description'].'</small></td>
<td>'.$row['votes'].'</td>
<td>'.$row['hits'].'</td>
</tr>
';
$rank++;
}
?>

Направо съм се отнесъл много се извинявамм

ExpressYourself · 26 Юни 2010

<?php
$broinastranica = 20;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}

require_once('mysql_connect.php');

$query = "SELECT id, name, description, votes, hits FROM websites ORDER BY votes DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) OR die(mysql_error());

echo '<table border="0" cellpadding="7" cellspacing="7">
<tr>
<td>Ранк</td>
<td>Име/Описание</td>
<td>Гласове</td>
<td>Посещения</td>
</tr>
';

$rank = 1;

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo '<tr>
<td>'.$rank.'</td>
<td><a href="out.php?id='.$row['id'].'" target="_blank">'.$row['name'].'</a> '.
$row['description'].'</td>
<td>'.$row['votes'].'</td>
<td>'.$row['hits'].'</td>
</tr>
';
$rank++;
}

$maxPage = ceil(mysql_num_rows($query)/$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 = " <a href=\"$self?page=$page\"> [<<<<<] </a> ";

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

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\"> [>>>>>] </a> ";

$posledna = " <a href=\"$self?page=$maxPage\">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
?>

ReD_z0n3 · 26 Юни 2010

Код:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 5' at line 1

Изписва ми това..

ReD_z0n3 · 27 Юни 2010

Никои ли няма да помогне :shock:

ExpressYourself · 27 Юни 2010

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

require_once('mysql_connect.php');

$query = "SELECT `id`, `name`, `description`, `votes`, `hits` FROM `websites` ORDER BY `votes` DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) OR die(mysql_error());

echo '<table border="0" cellpadding="7" cellspacing="7">
<tr>
<td>Ранк</td>
<td>Име/Описание</td>
<td>Гласове</td>
<td>Посещения</td>
</tr>
';

$rank = 1;

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo '<tr>
<td>'.$rank.'</td>
<td><a href="out.php?id='.$row['id'].'" target="_blank">'.$row['name'].'</a> '.
$row['description'].'</td>
<td>'.$row['votes'].'</td>
<td>'.$row['hits'].'</td>
</tr>
';
$rank++;
}

$maxPage = ceil(mysql_num_rows($query)/$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 = " <a href=\"$self?page=$page\"> [<<<<<] </a> ";

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

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\"> [>>>>>] </a> ";

$posledna = " <a href=\"$self?page=$maxPage\">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
?>

ReD_z0n3 · 27 Юни 2010

Код:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\top\index.php on line 161

сега пък това изписва..

ExpressYourself · 27 Юни 2010

ReD_z0n3 каза:
Код:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\top\index.php on line 161

сега пък това изписва..

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

require_once('mysql_connect.php');

$query = "SELECT `id`, `name`, `description`, `votes`, `hits` FROM `websites` ORDER BY `votes` DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) OR die(mysql_error());

echo '<table border="0" cellpadding="7" cellspacing="7">
<tr>
<td>Ранк</td>
<td>Име/Описание</td>
<td>Гласове</td>
<td>Посещения</td>
</tr>
';

$rank = 1;

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo '<tr>
<td>'.$rank.'</td>
<td><a href="out.php?id='.$row['id'].'" target="_blank">'.$row['name'].'</a> '.
$row['description'].'</td>
<td>'.$row['votes'].'</td>
<td>'.$row['hits'].'</td>
</tr>
';
$rank++;
}

$maxPage = ceil(mysql_num_rows($result)/$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 = " <a href="$self?page=$page"> [<<<<<] </a> ";

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

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href="$self?page=$page"> [>>>>>] </a> ";

$posledna = " <a href="$self?page=$maxPage">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
?>

ReD_z0n3 · 27 Юни 2010

Сега не дава грешки но , като сложа под разбиране 5 а има 8 сайта не ми изкарва 2 страници , а само 1

и на нея 5 изкарани сайта що така ?

ExpressYourself · 27 Юни 2010

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

require_once('mysql_connect.php');

$query = "SELECT `id`, `name`, `description`, `votes`, `hits` FROM `websites` ORDER BY `votes` DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) OR die(mysql_error());

echo '<table border="0" cellpadding="7" cellspacing="7">
<tr>
<td>Ранк</td>
<td>Име/Описание</td>
<td>Гласове</td>
<td>Посещения</td>
</tr>
';

$rank = 1;

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo '<tr>
<td>'.$rank.'</td>
<td><a href="out.php?id='.$row['id'].'" target="_blank">'.$row['name'].'</a> '.
$row['description'].'</td>
<td>'.$row['votes'].'</td>
<td>'.$row['hits'].'</td>
</tr>
';
$rank++;
}

$query = "SELECT COUNT(id) AS numrows FROM `websites`";
$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 = " <a href=\"$self?page=$page\"> [<<<<<] </a> ";

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

if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\"> [>>>>>] </a> ";

$posledna = " <a href=\"$self?page=$maxPage\">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
?>

ReD_z0n3 · 27 Юни 2010

Тоя път стана

но като отваря страницата вместо да изписва , 7 , 8 , 9 място пак започва от 1 , 2 ,3 ,4 и т.н

Редакция на код

ReD_z0n3

Registered

ExpressYourself

Registered

ReD_z0n3

Registered

ExpressYourself

Registered

ReD_z0n3

Registered

ReD_z0n3

Registered

ExpressYourself

Registered

ReD_z0n3

Registered

ExpressYourself

Registered

ReD_z0n3

Registered

ExpressYourself

Registered

ReD_z0n3

Registered