µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
PHP
» Ãö©ó mysql_fetch_assoc()
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
Ãö©ó mysql_fetch_assoc()
pix756
µoµu®ø®§
¥[¬°¦n¤Í
pix756
·í«eÂ÷½u
UID
8574
©«¤l
46
¥DÃD
8
ºëµØ
0
¿n¤À
60
ª÷¿ú
60
ÂI¦W
0
§@·~¨t²Î
windows 7 64bit
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW®ç¶é
¦b½u®É¶¡
57 ¤p®É
µù¥U®É¶¡
2012-3-14
³Ì«áµn¿ý
2018-11-27
¤¤¾Ç¥Í
©«¤l
46
¥DÃD
8
ºëµØ
0
¿n¤À
60
ÂI¦W
0
§@·~¨t²Î
windows 7 64bit
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW®ç¶é
µù¥U®É¶¡
2012-3-14
³Ì«áµn¿ý
2018-11-27
1
#
¸õÂà¨ì
»
¥¿§Ç¬Ý©«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2012-7-25 14:20
|
¥u¬Ý¸Ó§@ªÌ
Ãö©ó mysql_fetch_assoc()
ª©¤Wªº¦U¦ì¤j¤j§A̦n¡G
¤pªº§Ú³Ìªñ½m²ßphp¡A¹J¨ì¤F¥H¤U°ÝÃD¡G
³sµ²mysql§Ún¿é¥X¾Ç¥Íªº¸ê®Æ¥[¤À¶¡Aµ²ªG·|¥X²{¥H¤U¿ù»~¡A¦p¤U¹Ï¡G
¤U¸ü
(31.02 KB)
2012-7-25 14:17
¥H¤U¬O§Úªºµ{¦¡¤º®e¡G
·Q½Ðª©¤Wªº¤j¤jÌÀ°§Ú¬Ý¤@¤U§Úþ¸Ì¥X¿ù¤F¡A§Ú¬O«ö·Ó®Ñ¤W¥´¡A¬°¤°»ò¿é¥X«á·|¥X²{¿ù»~¡C
¸ê®Æ®w¦³³s¤W¡A¶¦¸ªº¥\¯à¤]¦³¥¿±`¡A¦ý¾Ç¥Í¦¨ÁZªíªº³¡¥÷´N¬O¥X¤£¨Ó...:'(
===================================================================================
<!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">
<?
include("connMysql.php");
?>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<link href="style.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<?
$seldb=@mysql_select_db("class");
if(!$seldb) die("¸ê®Æ®w¿ï¾Ü¥¢±Ñ");
$sql_query="SELECT * FROM `student`";
$pageRow_records=3; //¨C¶Åã¥Üµ§¼Æ
$num_pages=1; //¹w³]¿Ã¹õ©Ò¦b¶¼Æ
if(isset($_GET['page'])){
$num_pages=$_GET['page'];
}
//¶}©l°O¿ýµ§¼Æ
$startRow_records = ($num_pages -1) * $pageRow_records;
$sql_query_limit=$sql_query. "LIMIT". $startRow_records. ",". $pageRow_records;
$result=mysql_query($sql_query_limit);
$all_result=mysql_query($sql_query);
$total_records=mysql_num_rows($all_result);
$total_pages=ceil($total_records/$pageRow_records);
?>
<p>¥Ø«e¾Ç¥ÍÁ`¤H¼Æ¬°¡G<? echo $total_records; ?></p>
<p><a href="add.php">[·s¼W¾Ç¥Í¸ê®Æ]</a></p>
<div class="listbox">
<div class="list">®y¸¹</div>
<div class="list">©m¦W</div>
<div class="list">©Ê§O</div>
<div class="list">¥Í¤é</div>
<div class="list1">email</div>
<div class="list">¹q¸Ü</div>
<div class="list">¦í§}</div>
<div class="list">קï</div>
<div class="list">§R°£</div>
</div>
<?
while($row_result=mysql_fetch_assoc($result)){
echo "<div class='listbox'>";
echo "<div class='list'>". $row_result['cID']. "</div>";
echo "<div class='list'>". $row_result['cName']. "</div>";
echo "<div class='list'>". $row_result['cSex']. "</div>";
echo "<div class='list'>". $row_result['cBirthday']. "</div>";
echo "<div class='list1'>". $row_result['cEmail']. "</div>";
echo "<div class='list'>". $row_result['cPhone']. "</div>";
echo "<div class='list'>". $row_result['cAddr']. "</div>";
echo "<div class='list'><a href='delete.php?id=". $row_result['cID']. "'>§R°£</a></div>";
echo "<div class='list'><a href='update.php?id=". $row_result['cID']. "'>קï</a></div>";
echo "</div>";
}
?>
<? echo "<div class='listbox'>"; ?>
<? if($num_pages>1){ ?>
<div class="list"><a href="index.php?page=1">²Ä¤@¶</a></div>
<div class="list"><a href="index.php?page=<? echo $num_pages-1; ?>">¤W¤@¶</a></div>
<? } ?>
<? if (num_pages<$total_pages){ ?>
<div class="list"><a href="index.php?page=<? echo $num_pages+1; ?>">¤U¤@¶</a></div>
<div class="list"><a href="index.php?page=<? echo $total_pages; ?>">³Ì«á¶</a></div>
<? } ?>
<? echo "</div>";?>
</body>
</html>
¼Ó¥D¼ö©«
Ãö©óPHPµ{¦¡°õ¦æ¡C
¤°»ò¬O"return"¦^¶ÇÈ
php+mysqlªº°ÊºA¿ï³æ
css ¶ê¨¤³]©w
Ãö©ó·Q¶RÅã¥Ü¥d
php Ãö©ó¸ê®Æ§ó·s
css ³z©ú«×³]©w
¦¬ÂÃ
¤À¨É
Learn Learn Learn
pix756
µoµu®ø®§
¥[¬°¦n¤Í
pix756
·í«eÂ÷½u
UID
8574
©«¤l
46
¥DÃD
8
ºëµØ
0
¿n¤À
60
ª÷¿ú
60
ÂI¦W
0
§@·~¨t²Î
windows 7 64bit
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW®ç¶é
¦b½u®É¶¡
57 ¤p®É
µù¥U®É¶¡
2012-3-14
³Ì«áµn¿ý
2018-11-27
¤¤¾Ç¥Í
©«¤l
46
¥DÃD
8
ºëµØ
0
¿n¤À
60
ÂI¦W
0
§@·~¨t²Î
windows 7 64bit
³nÅ骩¥»
office2003
¾\ŪÅv
20
©Ê§O
¨k
¨Ó¦Û
¥xÆW®ç¶é
µù¥U®É¶¡
2012-3-14
³Ì«áµn¿ý
2018-11-27
3
#
µoªí©ó 2012-7-27 23:31
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
2#
¤p»x
¤p»x¤j¡A§Ú«á¨Ó¨Ï¥Î¥L®Ñªþªº¥úºÐ¡A
¤]¬O¦P¼Ëªº±¡§Î¡C
ÃhºÃ¬O®Ñ¤¤ªº¤º¤å¦³»~¡A
§Ú¤w¥tÁÊ¥t¤@¥Xª©ªÀªº®Ñ¡A
¦A°Ñ¦Ò¤p»x¤j¦b½×¾Â¼gªºPHP±Ð¾Ç¡C
§Æ±æ¦³´Â¤@¤é¯à¿Ä·|PHP¡C
ÁÂÁ¤p»x¤j²Ó¤ßªº«ü¾É¡C
:D
Learn Learn Learn
TOP
¤p»x
µoµu®ø®§
¥[¬°¦n¤Í
¤p»x
(¤p»x)
·í«e¦b½u
´¿¸g¤]¬O¤ô¹q¤u
UID
9
©«¤l
1188
¥DÃD
394
ºëµØ
113
¿n¤À
1747
ª÷¿ú
1747
ÂI¦W
1
§@·~¨t²Î
Vista
³nÅ骩¥»
Office 2003
¾\ŪÅv
200
©Ê§O
¨k
¨Ó¦Û
¥xÆW
¦b½u®É¶¡
490 ¤p®É
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2024-11-22
¡@¼ÊºÙ:
¤p»x
¡@ÀY»Î:
´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
©«¤l
1188
¥DÃD
394
ºëµØ
113
¿n¤À
1747
ÂI¦W
1
§@·~¨t²Î
Vista
³nÅ骩¥»
Office 2003
¾\ŪÅv
200
©Ê§O
¨k
¨Ó¦Û
¥xÆW
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2024-11-22
2
#
µoªí©ó 2012-7-27 01:55
|
¥u¬Ý¸Ó§@ªÌ
$sql_query="SELECT * FROM `student`";
$sql_query_limit=$sql_query. "LIMIT". $startRow_records. ",". $pageRow_records;
½Æ»s¥N½X
À°§A¬D¥X¨Ó,$sql_query_limit·|¬O¬Æ»ò©O?
"SELECT * FROM
`student`LIMIT
". $startRow_records. ",". $pageRow_records;
¬O¤£¬O¤Ö¤FªÅ®æ??
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
TOP
ÀR«ä¦Û¦b :
¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·