<?php
define('BOOK_WEB','books');
require_once 'common.php';
require_once 'page.php';
$sql="select * from books";
$book_name=isset($_GET['book_name'])?trim($_GET['book_name']):'';
$page=isset($_GET['page'])?$_GET['page']:1;
$pagesize=5;
if($book_name){
    $sql="select * from books where name like '%".$book_name."%'";
}
if($page){
    $sql.=make_page($page,$pagesize);
}

try {
    $result=$pdo->query($sql);
}catch (Exception $e){
    echo '连接错误'.$e->getMessage();
}
$number=$pdo->query('select * from books')->rowCount();
$books=$result->fetchAll();
$maxpage=ceil($number/$pagesize);

$sql="select * from user ;";
$result=$pdo->query($sql);
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {  
    // 获取特定列的值  
    $name = $row['name'];  
}
include_once 'list.html';