Вот мой код:
| Код | <?
$db_name = "test";
mysql_select_db($db_name);
echo "<TABLE cellSpacing=0 cellPadding=0 width='100%' bgColor=#6699cc border=1>";
echo "<tr><td>Продавец</td><td>Адрес</td><td>Телефон</td>";
echo "<td>E-mail</td><td>Рейтинг</td><td>Товар</td>";
echo "<td>Цена</td><td>Наличие</td></tr>";
if (!isset($_GET['page'])) {$_GET['page'] = '1';}
$to_page = 3;
$pages_links = 2;
$p = ($_GET['page'] * $to_page) - $to_page;
$query = "SELECT COUNT(id) FROM price";
$result = mysql_query($query);
$count = mysql_result($result,0,'COUNT(id)');
$pages = ceil($count / $to_page);
if ($_GET['page'] > $pages) {
header("Location: pages.php?page=".$pages);
} elseif($_GET['page'] < 1) {
header("Location: pages.php?page=1");
}
$query = "select tovar.creater, , price.price1, price.nal, prod.name, prod.adres, prod.telefon, prod.mail, prod.reyting from prod, tovar, price where tovar.id = price.tovar and price.prod = prod.id and price.nal > 0 LIMIT ".$p.",".$to_page;
$result = mysql_query($query);
for ($i=0; $i<mysql_num_rows($result); $i++)
{
echo "<tr>";
$sql=mysql_fetch_array($result);
echo "<td>$sql[name]</td><td>$sql[adres]</td><td>$sql[telefon]</td>";
echo "<td>$sql[mail]</td><td>$sql[reyting]</td>";
echo "<td>$sql[creater]</td>";
echo "<td>$sql[price1]</td><td>$sql[nal]</td>";
echo "</tr>";
}
$pages_links_view_max = 0;
$pages_links_view_min = 0;
if ($pages - $_GET['page'] >= ($pages_links + 1)) {
$to_max = $_GET['page'] + $pages_links;
$pages_links_view_max = 1;
} else {
$to_max = $pages;
}
if ($_GET['page'] > ($pages_links + 1)) {
$to_min = $_GET['page'] - $pages_links;
$pages_links_view_min = 1;
} else {
$to_min = 1;
}
if ($pages_links_view_min == 1) {
echo ' <A href="?page=1"> К началу</A>';
}
if ($_GET['page'] > 1) {
echo ' <A href="?page='.($_GET['page'] - 1).'"> <<</A>';
}
if ($pages_links_view_min == 1) {
echo ' ...';
}
for ($p = $to_min; $p <= $to_max; $p++) {
if ($_GET['page'] == $p) {
echo ' <B>['.$p.']</B>';
} else {
echo ' <A href="?page='.$p.'">['.$p.']</A>';
}
}
if ($pages_links_view_max == 1) {
echo ' ...';
}
if ($_GET['page'] < $pages) {
echo ' <A href="?page='.($_GET['page']+1).'"> >></A>';
}
if ($pages_links_view_max == 1) {
echo ' <A href="?page='.$pages.'"> Последняя ['.$pages.']</A>';
}
?> |
|
