�����������֡��
A little text to describe your forum 
¤ÍÁ¾ÔÇàµÍÃìÈÖ¡ÉÒ  
 ÊÁѤÃÊÁÒªÔ¡(Register)��Ѥ���Ҫԡ(Register) 
 ªèÇÂàËÅ×Í���������   ¤é¹ËÒ����   ÃÒª×èÍÊÁҪԡ��ª�����Ҫԡ   ¡ÅØèÁ¼Ùéãªé���������� 
 ¢éÍÁÙÅÊèǹµÑÇ(Profile)��������ǹ���(Profile)   à¢éÒÊÙèÃкºà¾×èÍàªç¤¢éͤÇÒÁÊèǹµÑÇ�������к������礢�ͤ�����ǹ���   à¢éÒÊÙèÃкº(Log in)�������к�(Log in) 
php ��˹��

 
Forum ¹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöµÍº ËÃ×Íá¡éä¢ä´é   ËÑÇ¢é͹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöá¡éä¢ ËÃ×͵ͺä´é    ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½Ö¡ï¿½ï¿½ -> +�+WEB+�+
��ҹ��Ǣ�͡�͹˹�� :: ��ҹ��Ǣ�ͶѴ�  
����� ��ͤ���
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 ����
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
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
}
}
?>
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
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>
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
���§�ӴѺ��ͤ����ͺ�ҡ��͹˹��:   
Forum ¹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöµÍº ËÃ×Íá¡éä¢ä´é   ËÑÇ¢é͹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöá¡éä¢ ËÃ×͵ͺä´é    ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½Ö¡ï¿½ï¿½ -> +�+WEB+�+ ��Ѻ���� GMT
˹�� 1 �ҡ 1

 
价��:  
�س�������ö���ҧ��Ǣ������
�س�������ö�����ͺ
�س�������ö��䢢�ͤ����ͧ�س
�س�������öź��ͤ����ͧ�س
�س�������öŧ��ṹ


Powered by phpBB © 2001 phpBB Group
-- Template created by dav.bo=> PurpleStylus --


For Support - http://forums.BizHat.com

Free Web Hosting | Free Forum Hosting | FlashWebHost.com | Image Hosting | Photo Gallery | FreeMarriage.com

Powered by PhpBBweb.com, setup your forum now!