導(dǎo)不出數(shù)據(jù)庫(kù)的數(shù)據(jù)
<?php
include("conn.php");?
//傳入頁(yè)碼
?$page=$_POST[p];
?//設(shè)置數(shù)據(jù)庫(kù)編碼格式
?mysql_query("SET NAMES UTF8");
?$sql="SELECT * FROM chengji LIMIT".($page-1)*3 . ",3";
?//把sql語(yǔ)句傳送數(shù)據(jù)中
?$result=mysql_query($sql);
?echo" <table border=1 cellspacing=0? >";
?echo"<tr><td>學(xué)號(hào)</td><td>課程號(hào)</td><td>課程名</td><td>成績(jī)</td><td>學(xué)分</td></tr>";
?while($row=mysql_fetch_assoc($result)){
?echo "<tr>";
?echo "<td>{$row['sno']}</td>";
?echo "<td>{$row['cno']}</td>";
?echo "<td>{$row['cname']}</td>";
?echo "<td>{$row['xuefen']}</td>";
?echo "</tr>";
?}
?echo "</table>";
?mysql_free_result($result);
?mysql_close($link);
?$page_banner="<a href='".$_SERVER['PHP_SELF']."?p=".($page-1) ."'>上一頁(yè)</a>";
?$page_banner="<a href='".$_SERVER['PHP_SELF']."?p=".($page+1) ."'>下一頁(yè)</a>";
?echo $page_banner;
?>
導(dǎo)不出數(shù)據(jù)庫(kù)的數(shù)據(jù),請(qǐng)問(wèn)是為什么呢?謝謝
2017-05-23
先看下有沒(méi)有成功連接數(shù)據(jù)庫(kù)再找問(wèn)題