$result=ociparse($conn,$query);
if(ociexecute($result)) {
ocifetchinto($result,$row,OCI_ASSOC);
$message_count = $row["total"];//获取总的记录数
......
}
if(ociexecute($result)) {
ocifetchinto($result,$row,OCI_ASSOC);
$message_count = $row["total"];//获取总的记录数
......
}
$message_count = $row["total"];//获取总的记录数
var_dump($row["total"]);//为什么此处竟然输出NULL呢?在Oracle中执行的时候是有结果值得
$page_count=ceil($message_count/$page_size); //获取总的页数
就是这部分代码里面是红色的 但是不知道为什么 有color但是却不曾显示出来!
请帮忙看看!
我想利用分页技术来显示树形结构
$page_size=100; //每页显示100条记录
$query="select count(*) as total from XTDETAMSALL_DETAIL_2 "; //从数据库中读取数据
$result=ociparse($conn,$query);
ociexecute($result);
ocifetchinto($result,$row,OCI_ASSOC);
$message_count = $row["total"];//获取总的记录数
var_dump($row["total"]);//为什么此处竟然输出NULL呢?在Oracle中执行的时候是有结果值得
$page_count=ceil($message_count/$page_size); //获取总的页数
$offset=($page-1)*$page_size;
$query="select UPCODE,UPNAME,DCODE,DNAME,DITEM,PRODUCTDWGCODE from XTDETAMSALL_DETAIL_2 where ROWNUM <'$page_size' order by UPCODE,DITEM desc ";
$result=ociparse($conn,$query);
ociexecute($result);
while ($myrow=ocifetchinto($result,$row,OCI_ASSOC)){
?>
………………源程序可以看第一条
=>
$row = oci_fetch_array($result,OCI_ASSOC);
=>
$row = oci_fetch_array($result,OCI_ASSOC);
ocifetch也不可以!
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>查询结果的分页显示</title>
<style type="text/css">
<!--
.STYLE1 {font-size: 12px}
.STYLE2 {font-size: 13px}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
-->
</style>
</head>
<body>
<table width="450" border="1" cellpadding="0" cellspacing="0" bgcolor="#4DB1FD">
<tr>
<td width="200" height="25" align="center" class="STYLE2">父图号</td>
<td width="200" align="center" class="STYLE2">父图名</td>
<td width="200" align="center" class="STYLE2">图号</td>
<td width="200" align="center" class="STYLE2">图名</td>
<td width="200" align="center" class="STYLE2">键号</td>
<td width="200" align="center" class="STYLE2">所属产品</td>
</tr>
<?php
if($page){
$page_size=100; //每页显示100条记录
$query="select count(*) as total from XTDETAMSALL_DETAIL_2 ORDER by UPCODE,DITEM"; //从数据库中读取数据
$result=ociparse($conn,$query);
ociexecute($result);
$row = OCIFetch($result,OCI_ASSOC);
$message_count = OCIResult($result, OCI_ASSOC);
$page_count=ceil($message_count/$page_size); //获取总的页数
$offset=($page-1)*$page_size;
var_dump("$offset");
$query="select UPCODE,UPNAME,DCODE,DNAME,DITEM,PRODUCTDWGCODE from XTDETAMSALL_DETAIL_2 where ROWNUM > '$offset' and ROWNUM <'$page_size' order by UPCODE,DITEM desc ";
$result01=ociparse($conn,$query);
ociexecute($result01);
while (ocifetchinto($result01,$row01,OCI_ASSOC)){
?>
<tr>
<td height="25" align="center"><span class="STYLE2"><?php echo $row01["UPCODE"];?></span></td>
<td align="center"><span class="STYLE2"><?php echo $row01["UPNAME"];?></span></td>
<td align="center"><span class="STYLE2"><?php echo $row01["DCODE"];?></span></td>
<td align="center"><span class="STYLE2"><?php echo $row01["DNAME"];?></span></td>
<td align="center"><span class="STYLE2"><?php echo $row01["DITEM"];?></span></td>
<td align="center"><span class="STYLE2"><?php echo $row01["PRODUCTDWGCODE"];?></span></td>
</tr>
<?php }}?>
</table>
<table width="450" border="1" cellpadding="0" cellspacing="0" bgcolor="#4DB1FD">
<tr>
<td width="45%" align="center"><span class="STYLE1"> 页次:<?php echo $page;?>
/ <?php echo $page_count;?> 页 记录:<?php echo $message_count;?> 条 </span></td>
<td width="55%" height="22" align="center"><span class="STYLE1"> 分页:
<?php
var_dump("$page");
if($page!=1)
{
echo "<a href=index.php?page=1>首页</a> ";
echo "<a href=index.php?page=".($page-1).">上一页</a> ";
}
if($page<$page_count)
{
echo "<a href=index.php?page=".($page+1).">下一页</a> ";
echo "<a href=index.php?page=".$page_count.">尾页</a>";
}
?>
</span></td>
</tr>
</table>
</body>
</html>
为什么上述代码中当var_dump(("$page");时,它输出的结果值为1,所以应该执行下述代码
if($page<$page_count)
{
echo "<a href=index.php?page=".($page+1).">下一页</a> ";
echo "<a href=index.php?page=".$page_count.">尾页</a>";
}
但对变量进行输出时却没有显示,这是为何?
应该为var_dump($page);吧.输出两个值看看吧.
echo $page . "<br/>" . $page_count;
if ($page=="") {$page=1;};