$scriptname = Split (' [/] ', $_server[' script_name ']);
$filename = End ($scriptname);
$MM _conn_string= "Driver={microsoft Access DRIVER (*.mdb)}; Dbq= ". Realpath ("Www.111cn.net/a.mdb"). ";D efaultdir=". Realpath (".");
$Conn =new COM ("ADODB. Connection ");
$RS =new COM ("ADODB. Recordset ");//DataSet
$Conn->open ($MM _conn_string);//link Open Data source
$query = "Select * From Doubt";
$RS->open ($query, $Conn, 1, 1);//EXECUTE statement, return recordset
$pagesize = $RS->pagesize=3;//Sets the number of display bars per page
if ($RS->pagecount<>0) {//Prevent database tutorial from being empty
if (!empty ($_get[' page ')) {
if ($_get[' page ']<=0) {
$RS->absolutepage=1;
$nowpage = 1;
}elseif ($_get[' page ']> $RS->pagecount) {
$RS->absolutepage= $RS->pagecount;
$nowpage = $RS->pagecount;
}else{
$RS->absolutepage=$_get[' page '];
$nowpage =$_get[' page '];
}
}else{
$RS->absolutepage=1;
$nowpage = 1;
}
}else{
$nowpage = 1;
$pagesize = 0;
}
echo "currently displays the first". $nowpage. " Page ";
echo "Every page". $pagesize. ' article ';
echo "Shared". $RS->recordcount. " Record ";
echo "Shared". $RS->pagecount. " Page <br> ";
for ($m =1; $m <= $pagesize; $m + +)
{
echo "
<table width=548 height=76 border=0 align=center cellpadding=0 cellspacing=1 bgcolor= #ededed
<tr>
<TD width=100 rowspan=2 align=center valign=middle bgcolor= #FFFFFF > Name: ". $RS->fields[" username "]->value." </td>
<TD width=307 height=25 align=left bgcolor= #FFFFFF > Q: ". $RS->fields[" Biaoti "]->value." </td>
<TD width=137 align=left bgcolor= #FFFFFF > ". $RS->fields[" Wendate "]->value." </td>
</tr>
<tr>
<TD height=50 colspan=2 align=left valign=top bgcolor= #FFFFFF > Issues: ". $RS->fields[" Neirong "]->value." Reply </td>
</tr>
</table>
";
$RS->movenext ();
if ($RS->pagecount==0) {
echo "No data";
}
if ($RS->pagecount<>0) {//Prevent database from being empty
echo "<a href= $filename?page=1> home </a>";
if (!) ( $nowpage <=1)) {
echo "<a href= $filename page=". ($nowpage-1). " > Prev </a> ";
}
if (!) ( $nowpage >= $RS->pagecount)) {
echo "<a href= $filename page=". ($nowpage + 1). " > next page </a> ";
}
echo "<a href= $filename page=". $RS->pagecount. " > Last </a> ";
}
Releasing resources
$Conn->close ();
$RS =null;
$Conn =null;