Warning: include(../common/conn.php) [function.include]: failed to open stream: No such file or directory in D:\www\chinahotelsmap\admin\files\listrorders.php on line 161Warning: include() [function.include]: Failed opening '../common/conn.php' for inclusion (include_path='.;C:\php5\pear') in D:\www\chinahotelsmap\admin\files\listrorders.php on line 161Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\www\chinahotelsmap\admin\files\listrorders.php on line 163Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\www\chinahotelsmap\admin\files\listrorders.php on line 163Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\www\chinahotelsmap\admin\files\listrorders.php on line 164Notice: Undefined variable: pageSize in D:\www\chinahotelsmap\admin\files\listrorders.php on line 165Warning: Division by zero in D:\www\chinahotelsmap\admin\files\listrorders.php on line 165Notice: Undefined variable: pageSize in D:\www\chinahotelsmap\admin\files\listrorders.php on line 167Notice: Undefined variable: pageSize in D:\www\chinahotelsmap\admin\files\listrorders.php on line 169Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\www\chinahotelsmap\admin\files\listrorders.php on line 171Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\www\chinahotelsmap\admin\files\listrorders.php on line 171Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\www\chinahotelsmap\admin\files\listrorders.php on line 172
代码如下:
<?php
//当前页码
$pageNo=@$_REQUEST['pageNo'];
$pageNo=@trim($pageNo);
if(empty($pageNo)){
$pageNo=1;
}else{
$pageNo=(int)$pageNo;
if($pageNo<=0){
$pageNo=1;
}
}
//每页显示多少条数据
$pagesize=@$_REQUEST['pagesize'];
$pagesize=@trim($pagesize);
if(empty($pagesize)){
$pagesize=2;
}else{
$pagesize=(int)$pagesize;
if($pagesize<=0){
$pagesize=2;
}
}
include '../common/conn.php';
$sql_count="SELECT * FROM orders_hotel";
$result_count=mysql_query($sql_count);
$totalRecord=mysql_num_rows($result_count);//总记录数
$totalPage=ceil($totalRecord / $pageSize);//总页数
$currRe=($pageNo-1)*$pageSize;//计算当前启始的记录数 $sql=$sql_count." LIMIT $currRe,$pageSize";
//echo $sql;return;
$res=mysql_query($sql);
while($row=mysql_fetch_array($res,MYSQL_BOTH)){
?>
<tr>
<td><?php echo @empty($row['orders_hotel_id'])?'0':$row['orders_hotel_id']?></td>
<td><?php echo empty($row['linkmanName'])?0:$row['linkmanName']; ?></td>
<td><?php echo empty($row['HotelName'])?0:$row['HotelName']; ?></td>
<td><?php echo empty($row['email'])?0:$row['email']; ?></td>
<td><?php echo empty($row['orders_hotel_addtime'])?0:$row['userorders_hotel_addtimes_account']; ?></td>
谁给看看 谢谢了!
网站根目录/admin/files/listrorders.php 所以在 listrorders.php 中嵌入 conn.php 应为
include '../../common/conn.php';
看第一句就知道,在D盘找不到这个文件,你再代码的161行找下,先看下D盘是否有这个PHP页面,然后如果程序和页面在一个包里面就写相对路径,不要写绝对路径。