问题描述
老师，分页那部分，我提示Warning: mysqli::mysqli(): (HY000/1045): Access denied for user ''@'localhost' (using password: NO) in E:yifengcoreDb.php on line 19
connect failed:Access denied for user ''@'localhost' (using password: NO)
public static function pagination($table, $where = '', $page = 1, $pagesize = 10, $order = ''){ $conn = self::db_connect(); $totals = self::totals($table, $where); // 总条数 $totalpage = ceil($totals / $pagesize); // 总页数 $page = max(1, $page); // 当前页 $offset = ($page - 1) * $pagesize; // 分页查询的开始位置 // 拼接sql $sql = "select * from {$table}"; if ($where) { $sql .= " WHERE ".$where; } if ($order) { $sql .= " ORDER BY " . $order; } $sql .= " limit ".$offset.','.$pagesize; $result = $conn->query($sql); // 执行sql if ($result->num_rows > 0) { // 返回数据的条数 while ($row = $result->fetch_assoc()) { // 返回的一条条数据 $rows[] = $row; } $result->free_result(); // 释放结果内存 } $conn->close(); return array( 'total' => $totals, 'page' => $page, 'pagesize' => $pagesize, 'list' => $rows );}
问题解答
回答1：调用了两次db_connect, 一次是直接调用的db_connect ， 第二次是total的，不知道为什么老师的没有出错，
一种办法， 在分页方法里面重新写一遍获取总数的方法赋值给变量
/** * @param $table * @param $where * @param $page * @param $num * @param string $order * @return array */ public static function pagination($table, $where, $page, $num, $order=''){ $conn =self::db_connect(); $count=0; $count_sql = "SELECT count(*) as count FROM {$table}"; if($where){ $count_sql .=" WHERE ".self::getwhere($where); }// exit($count_sql); if($count_result = $conn->query($count_sql)){ $row = $count_result->fetch_assoc(); $count = $row['count']; } $total_page = ceil($count/$num);//总页数 $page=max(1,$page); // 处理$page,max(min,max) 返回最大数 $offset = ($page-1)*$num;// 每页的起始数 // 拼接查询的SQL $sql = "SELECT * FROM {$table}"; if($where){ $sql .=' WHERE '.self::getwhere($where); } if($order){ $sql .= " ORDER BY {$order}"; } $sql .=" LIMIT {$offset} , {$num}"; $rows=[]; if($result = $conn->query($sql)){ while($row = $result->fetch_assoc()){ $rows[]=$row; } mysqli_free_result($result); } $conn->close(); return array('total'=>$count,'page'=>$page,'num'=>$num,'total_page'=>$total_page,'lists'=>$rows); }
回答2：跟我的一样的问题Notice: Undefined variable: db in D:xuexicoredb.php on line 18Notice: Undefined variable: db in D:xuexicoredb.php on line 18Notice: Undefined variable: db in D:xuexicoredb.php on line 18Notice: Undefined variable: db in D:xuexicoredb.php on line 18Warning: mysqli_connect(): (HY000/1045): Access denied for user ''@'localhost' (using password: NO) in D:xuexicoredb.php on line 18Connection failed:Access denied for user ''@'localhost' (using password: NO)
回答3：吞吞吐吐
回答4：数据库密码错了。
