как да направя страницирането

lostbg · 16 Юли 2009

Код:

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
		<title>Radio FIX "Онлайн Поздрави"</title>
		<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
		<link type="text/css" rel="stylesheet" href="style.css" media="screen" />
	</head>
	<body>
		<div id='all'>
			<div id='logo'><a href='#'><img src='img/logo.gif' alt='Logo' /></a></div>
			<div id='menu'>
				<a href='index.php'>Начало</a>
				<a href='add.php'>Добави поздрав</a>
				<a href='staff.php'>Екип</a>
				<div class='clear'></div>
			</div>
			<table width="766" border="0" cellspacing="0" cellpadding="0" id='table'>
			  <tr>
				<td width="58" height="23" class="top_t">№</td>
				<td width="256" height="23" class="top_t">Име:</td>
				<td width="81" height="23" class="top_t">Заявка: </td>
				<td width="371" height="23" class="top_t" style="padding: 0 0 0 50px;">Поздрав:</td>
			  </tr>
			  <tr>
			  <?php
include("config.php");
$result = mysql_query("SELECT * FROM news ORDER BY newsid ASC",$connect);
while($myrow = mysql_fetch_array($result))
{
				echo "<tr><td width=58 height=28>"; echo $myrow['newsid']; echo "</td>";
				echo "<td width=256 height=28>"; echo $myrow['title']; echo "</td>";
				echo ($myrow['izpalnena'] == 1) ? "<td width=81 height=28 class=green>Изпълнена </td>" : "<td width=81 height=28 class=red>Неизпълнена </td>";
				echo "<td width=371 height=28 class=pad_t>"; echo $myrow['text2']; echo "</td></tr>";
}
?>
			  </tr>
			</table>
		<table width="766" border="0" cellspacing="1" cellpadding="0" id="numb">
		  <tr class="top_t">
			<td width="24" height="24" align="center" valign="middle"><a href="#">1</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">2</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">3</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">4</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">5</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">6</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">7</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">8</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">9</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">10</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">11</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">12</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">13</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">14</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">15</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">16</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">17</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">18</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">19</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">20</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">21</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">22</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">23</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">24</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">25</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">26</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">27</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">28</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">29</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">30</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">31</a></td>
		  </tr>
		  <tr class="top_t">
			<td width="24" height="24" align="center" valign="middle"><a href="#">33</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">34</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">35</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">36</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">37</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">38</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">39</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">40</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">41</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">42</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">43</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">44</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">45</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">46</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">47</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">48</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">49</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">50</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">51</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">52</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">53</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">54</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">55</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">56</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">57</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">58</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">59</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">60</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">61</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">62</a></td>
			<td width="24" height="24" align="center" valign="middle"><a href="#">63</a></td>
		  </tr>
		</table>
		<div id='ads'><a href='#'><img src='img/banner.gif' alt='Logo' /></a></div>
	</div>
	</body>
</html>

Това ми е целия код на страницата има и стила на страницирането, проблема ми е как да го направя примерно да се показват само по 25 поздрава и да ми дава страница 2 без да има такива първа, следваща и последна страница ми да си показва всички страници примерно както е широчината на таблицата, +1 ако някой помогне ще съм много благодарен

federer_11 · 16 Юли 2009

Код:

$rs=run_query('SELECT COUNT (*) FROM таблица');
        $row=mysql_fetch_assoc($rs);
        $max_count=$row['cnt'];
        $limit=5;
        if((int)$_GET['page']>0){
            $page=(int)$_GET['page']-1;
        }
        else
        {
            $page=0;
        }
        $max_pages=ceil($max_count/$limit);
            for($i=0;$i<$max_pages;$i++)
            {
                if($i=$page)
                {
                    echo ($i+1). ' | ';
                }
                else
                {
                    echo '<a href="файла.php?id='.$cat_id.'$page='.($i+1).'">.($i+1).</a>';
                }
            }
            if($page<($max_pages-1))
            {
                echo '<a href="файла.php?id='.$cat_id.'$page='.($page+2).'">'.($i+1).'</a>';
            }
            echo '<a href="файла.php?id='.$cat_id.'$page='.($page-2).'">Предишна</a> ';
            echo '<a href="файла.php?id='.$cat_id.'$page='.($page+2).'">Следваща</a> ';

Ето ти примерен код за странициране

lostbg · 16 Юли 2009

точно там е работата пробвах с какви ли не кодове но така и не можах и затова стигнах до тук

rosko · 16 Юли 2009

Гледаш този урок 2 пъти хубаво и ще си направиш, аз успях!

federer_11 · 16 Юли 2009

селектираш от таблицата всички резултати, след това с count ги преброяваш. Имаш променливите:

$max_count=$row['cnt'];
$limit=5;

Лимитът е колко записа ще излизат на страница. За функцията ceil прочети тук: http://bg2.php.net/manual/bg/function.ceil.php

как да направя страницирането

lostbg

Registered

federer_11

Registered

lostbg

Registered

rosko

Registered

federer_11

Registered