以下是PHP链接excel程序,如果我想设置分页怎么搞?select top 11 * from [Sheet1$];这样可以是次选择11条记录,但是我要从11条以后读取怎么搞?求高手帮个忙。
<?php
$conn=new com("adodb.connection");
$connstr="Driver={Microsoft Excel Driver (*.xls)};DBQ=".realpath("excel/book.xls");
$conn->open($connstr);
$sql="select top 11 * from [Sheet1$]";
$rs=$conn->execute($sql);
if($rs->eof || $rs->bof)
{
echo "<div align=center>暂无图书信息!</div>";
}
else
{
while(!$rs->eof)
{
?>
<tr>
<td height="25" align="center" bgcolor="#FFFFFF"><?php $fields=$rs->fields(number);echo $fields->value;?></td>
<td height="25" align="center" bgcolor="#FFFFFF"><?php $fields=$rs->fields(title);echo $fields->value;?></td>
<td height="25" align="center" bgcolor="#FFFFFF"><?php $fields=$rs->fields(datetime);echo $fields->value;?></td>
<td height="25" align="center" bgcolor="#FFFFFF"><?php $fields=$rs->fields(sale);echo $fields->value;?></td>
<td height="25" align="center" bgcolor="#FFFFFF"></td>
</tr>
<?php
$rs->movenext;
}
}
?>
<?php
$conn=new com("adodb.connection");
$connstr="Driver={Microsoft Excel Driver (*.xls)};DBQ=".realpath("excel/book.xls");
$conn->open($connstr);
$sql="select top 11 * from [Sheet1$]";
$rs=$conn->execute($sql);
if($rs->eof || $rs->bof)
{
echo "<div align=center>暂无图书信息!</div>";
}
else
{
while(!$rs->eof)
{
?>
<tr>
<td height="25" align="center" bgcolor="#FFFFFF"><?php $fields=$rs->fields(number);echo $fields->value;?></td>
<td height="25" align="center" bgcolor="#FFFFFF"><?php $fields=$rs->fields(title);echo $fields->value;?></td>
<td height="25" align="center" bgcolor="#FFFFFF"><?php $fields=$rs->fields(datetime);echo $fields->value;?></td>
<td height="25" align="center" bgcolor="#FFFFFF"><?php $fields=$rs->fields(sale);echo $fields->value;?></td>
<td height="25" align="center" bgcolor="#FFFFFF"></td>
</tr>
<?php
$rs->movenext;
}
}
?>
晕死,你以为这是mysql语法啊。