<?php
$servername = "localhost";
$username = "root";
$password = "0202";
$dbname = "mydb";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>搜索</title>
<link rel = "stylesheet" type = "test/css" href = "sql_php.css"/>
</head>
<body>
<form>
<input type="text" id="txt_uname" name="uname"/>
<br/>
<input type="submit"/>
<p>
<?php
$num_rec_per_page=10;
if (isset($_GET["page"])){
$page = $_GET["page"];
}else{
$page=1;
}
$start_from = ($page-1) * $num_rec_per_page;
if (isset($_GET['uname'])) {
//连上数据库
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
//查找
$sql = "SELECT * FROM content WHERE title LIKE '%".$_GET['uname']."%' LIMIT $start_from, $num_rec_per_page";
//执行
$result = $conn->query($sql);
$total_records = mysqli_num_rows($result); // 统计总共的记录条数
$total_pages = ceil($total_records / $num_rec_per_page); // 计算总页数
//输出值
if ($result->num_rows > 0){
// 输出每行数据
while($row = $result->fetch_assoc()){
echo '<p>' . ' <li><a href=" ' . $row['url'] . '"> '. $row['url'] . '</a></li> '. PHP_EOL . PHP_EOL . $row['title'] . '</p>';
}
}else{
echo "没数据";
}
echo "<a href='search-page.php?page=1'>".'|<'."</a> "; // 第一页
for ($i=1; $i<=$total_pages; $i++) {
echo "<a href='search-page.php?page=".$i."'>".$i."</a> ";
};
echo "<a href='search-page.php?page=$total_pages'>".'>|'."</a> "; // 最后一页，注意把网址改到当前页
//关闭数据库连接，释放资源
$conn->close();
}
?>
</p>
</form>
</body>
</html>
谢谢大家了。给点小提示。。
