��ҹ��Ǣ�͡�͹˹�� :: ��ҹ��Ǣ�ͶѴ� |
����� |
��ͤ��� |
ryuozero Site Admin
�������: 13 Jul 2005 �ͺ: 1145
|
�ͺ�����: Wed Apr 15, 2009 12:28 am ����ͧ: php ��˹�� |
|
|
http://www.webthaidd.com/php/webthaidd_article_90_.html
1.copy function ��������˹�����
function LinkPage($totalRows , $rowsPerPage , $nowPage , $link)
{
$totalPage = ceil($totalRows/$rowsPerPage);
if ($nowPage != 1)
echo ' <a href="'. $link .'&page='. ($nowPage - 1) . '"><</a> | ';
else
echo ' < | ';
for ($i=0;$i<$totalPage;$i++)
{
if ($i>0)
echo ' | ';
if (($i+1) != $nowPage)
echo '<a href="'. $link .'&page=' . ($i+1) . '">'. ($i+1) . '</a>';
else
echo ($i+1);
}
if ($nowPage != $totalPage)
echo ' | <a href="'. $link .'&page='. ($nowPage + 1) . '">'. '>' . '</a> ';
else
echo ' | > ';
}
2. ��ͻ⤴����������ǹ���ͧ���
$rowsPerPage = 20; // �ӹǹ��������ʴ�� 1 ˹��
$nowPage = $page;
if ($nowPage == '')
$nowPage = 1;
$limit = (($page - 1) * $limitPerPage) . ','.$limitPerPage;
3. ������������㹤���� SELECT �á�Է������������
SQL_CALC_FOUND_ROWS *
�� ����
$sql = 'SELECT * FROM table WHERE ab=c AND dd=3 ORDER BY aa';
�������
$sql = 'SELECT SQL_CALC_FOUND_ROWS * FROM table WHERE ab=c';
���� $sql = 'SELECT field1 , field2 FROM table WHERE ab=c AND dd=3 ORDER BY aa';
������� $sql = 'SELECT SQL_CALC_FOUND_ROWS * , field1 , field2 FROM table WHERE ab=c AND dd=3 ORDER BY aa';
4. ��������� limit ŧ�� sql �á��
' LIMIT '.$limit �蹻á����
$sql = 'SELECT * FROM table WHERE ab=c AND dd=3 ORDER BY aa';
�������
$sql = 'SELECT * FROM table WHERE ab=c AND dd=3 ORDER BY aa LIMIT'.$limit;
������������Ҥ���� sql ����������㹵���� sql ����
$sql .= ' LIMIT '.$limit;
5. ��������� ��ѧ�ҡ����ա�� query �����ŵ���á������
$c_res = mysql_query('SELECT FOUND_ROWS()');
$row = mysql_fetch_array($c_res);
$totalRows = $row[0];
�蹻á����
$result = mysql_query($sql);
while ($data = mysql_fetch_array($result)) {
����
$result = mysql_query($sql);
$c_res = mysql_query('SELECT FOUND_ROWS()');
$row = mysql_fetch_array($c_res);
$totalRows = $row[0];
while ($data = mysql_fetch_array($result)) {
6. ���ҧ����� link ��Ͷ���ա�á�����˹�ҷ�� 2-3 ������觤������仴��º�ҧ ��
$link = 'show.php?cat=game&order=byname&stattus=1';
(����ͧ�к� page ����� function ���������ͧ)
7.������� LinkPage ���㹺���dz����ͧ�������ʴ������˹��
LinkPage($totalRows , $rowsPerPage , $nowPage , $link);
�������ش�� ryuozero ����� Wed Apr 15, 2009 12:30 am, ������ 1 ���� |
|
���仢�ҧ�� |
|
|
ryuozero Site Admin
�������: 13 Jul 2005 �ͺ: 1145
|
�ͺ�����: Wed Apr 15, 2009 12:29 am ����ͧ: |
|
|
��:
<?
$pagesize = 20;
// ��˹���ʴ���
$sql = "SELECT count(id) as countid FROM table";
$cre = mysql_query($sql);
$crow = mysql_fetch_row($cre);
$totalrecord = $crow[0];
$totalpage = ceil($totalrecord / $pagesize);
if (isset($_GET['pageid'])) {
$start = $pagesize * ($_GET['pageid'] - 1);
}
else {
$pageid = 1;
$start = 0;
}
$sql = "SELECT * FROM table LIMIT $start, $pagesize;";
$result = mysql_query($sql) or die ( mysql_error());
while ($row = mysql_fetch_assoc($result) ) {
$adata[] = $row;
}
// ������ ����ͧ��� ���ŧ�˹��
for ($i=1; $i<=$totalpage; $i++) {
if ($i == $_GET['pageid']) {
echo $i . " ";
} else {
echo "����ԧ�� ";
}
}
���� ����ա ����� ��� �Ф�Ѻ
include 'library/config.php';
include 'library/opendb.php';
// how many rows to show per page
$rowsPerPage = 20;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
$query = " SELECT val FROM randoms " .
" LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');
// print the random numbers
while($row = mysql_fetch_array($result))
{
echo $row['val'] . '
';
}
// ... more code here
/*Connect �ҹ������ */
mysql_connect('localhost','root',''); // connect mysql
mysql_select_db('topic'); // select database
/* check ����� ��ҵ���� $start ������� ��������������� 0
��. �ѹ����ͧ��Ѻ����觹� ��������͡*/
if(!isset($start)){
$start = 0;
}
$limit = '10'; // �ʴ���˹���С����Ǣ��
/* �Ҩӹǹ record ������
��. �ѹ����ͧ��Ѻ����觹� ��������͡*/
$Qtotal = mysql_query("select * from topic"); //������ �����
$total = mysql_num_rows($Qtotal); // �Ҩӹǹ record
/* ������������͡�������ʴ��� */
$Query = mysql_query("SELECT * FROM topic ORDER BY id DESC LIMIT $start,$limit"); //����������
$totalp = mysql_num_rows($Query); // �Ҩӹǹ record ������¡�͡��
/* �ѹ��� ������������͡�� */
printf("����Ǣ�ͷ����� %d ��Ǣ�� / ",$total);
printf("�ʴ�˹���� %d ��Ǣ��<br />",$totalp);
echo "<hr />";
/* ǹ�ٻ������ */
while($arr = mysql_fetch_array($Query)){
echo sprintf("<B>%03d</B>",$arr[id])." - $arr[title]<br />"; // �ʴ���
}
echo "<hr>";
/* �����˹�� */
$page = ceil($total/$limit); // ��� record ������ ��ô��� �ӹǹ�����ʴ��ͧ����˹��
/* ��Ҽ���� ��ǹ �繵���Ţ ���§�ѹ �� ���ص��������� 3 ������š���� 1 2 3 */
for($i=1;$i<=$page;$i++){
if($_GET['page']==$i){ //��ҵ���� page �ç �Ѻ �Ţ���ǹ��
echo "[<a href='?start=".$limit*($i-1)."&page=$i'><B>$i</B></A>]"; //��駤� ��˹�� ���͹䢷�� 1
}else{
echo "[<a href='?start=".$limit*($i-1)."&page=$i'>$i</A>]"; //��駤� ��˹�� ���͹䢷�� 2
}
}
?> |
|
���仢�ҧ�� |
|
|
ryuozero Site Admin
�������: 13 Jul 2005 �ͺ: 1145
|
�ͺ�����: Sun Mar 13, 2011 6:35 pm ����ͧ: |
|
|
��ҧ�ԧ�ҡ: |
<?php
include_once('Connections/conect_in.php');
/* check ����� ��ҵ���� $start ������� ��������������� 0
��. �ѹ����ͧ��Ѻ����觹� ��������͡*/
if(!isset($start)){
$start = 0;
}
$limit = '100'; // �ʴ���˹���С����Ǣ��
/* �Ҩӹǹ record ������
��. �ѹ����ͧ��Ѻ����觹� ��������͡*/
$Qtotal = mysql_query("SELECT * FROM data_com"); //������ �����
$total = mysql_num_rows($Qtotal); // �Ҩӹǹ record
/* ������������͡�������ʴ��� */
$result = mysql_query("SELECT * FROM data_com ORDER BY IDC DESC LIMIT $start,$limit"); //����������
$totalp = mysql_num_rows($result); // �Ҩӹǹ record ������¡�͡��
?>
<table width="97%" border="1" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr bgcolor="#FFFFCC">
<td><div align="center">�Ţ������ͧ</div></td>
<td><div align="center">�ѹ����Ѻ</div></td>
<td><div align="center">�ҡ</div></td>
<td><div align="center">����ͧ</div></td>
<td><div align="center">˹��§ҹ</div></td>
<td><div align="center">ʶҹ�</div></td>
</tr>
<?
while($row = mysql_fetch_array($result))
{
$re_g = $row[id_group];
$group = mysql_query("SELECT * FROM data_group where id_group = $re_g");
$groupID = mysql_fetch_array($group);
//��ǹ���¡�����Ũҡ���ҧʶҹ��ҵ�Ǩ�ͺ��ҵç�ѹ�������
//$re_st = $row[ID_ST];
//$statust = mysql_query("SELECT * FROM data_statust where ID_ST = $re_st");
//$statustID = mysql_fetch_array($statust);
?>
<tr>
<td><div align="center"><? echo $row['ID_IN'] ?></div></td>
<td><div align="center"><? echo $row['DATE'] ?></div></td>
<td><div align="center"><? echo $row['ID_FROM'] ?></div></td>
<td><div align="center"><? echo $row['ID_STORY'] ?></div></td>
<td><div align="center"><? echo $groupID['group_description'] ?></div></td>
<td><div align="center">
<?
//����Ե��ʶҹС�÷ӧҹ���ٻ�Ҿ
$pic=$row['ID_ST'];
if($pic==2)
{
echo "<img src='images/Icon11.gif' width='16' height='16' />";
}
else
{
echo "<img src='images/Icon12.gif' width='16' height='16' />";
}
?>
</div></td>
</tr>
<? } ?>
</table>
<div align="center">
<!-- =========================================== -->
<br />
<?
/* �����˹�� */
$page = ceil($total/$limit); // ��� record ������ ��ô��� �ӹǹ�����ʴ��ͧ����˹��
/* ��Ҽ���� ��ǹ �繵���Ţ ���§�ѹ �� ���ص��������� 3 ������š���� 1 2 3 */
for($i=1;$i<=$page;$i++){
if($_GET['page']==$i){ //��ҵ���� page �ç �Ѻ �Ţ���ǹ��
echo "[<a href='?start=".$limit*($i-1)."&page=$i'><B>$i</B></A>]"; //��駤� ��˹�� ���͹䢷�� 1
}else{
echo "[<a href='?start=".$limit*($i-1)."&page=$i'>$i</A>]"; //��駤� ��˹�� ���͹䢷�� 2
}
}
?>
<?
mysql_close($con);
?>
</div> |
|
|
���仢�ҧ�� |
|
|
|