php - php限制查询pdo与按钮next
问题描述
我的代码出了什么问题..我尝试单击下一步按钮以显示数据库中的下一条记录..但是当我单击时没有任何反应。
这是我获取记录的功能
public function getBooks()
{
$limit = 1;
$start=0;
//SELECT loginUser.username, Library.nameOfBook FROM loginUser JOIN userBook JOIN Library ON userBook.user_id = loginUser.id AND userBook.book_id = Library.id WHERE loginUser.username="loay";
$query = "SELECT Library.nameOfBook FROM loginUser JOIN userBook JOIN Library ON userBook.user_id = loginUser.id AND userBook.book_id = Library.id WHERE loginUser.username=:username LIMIT $start, $limit";
$statment = $this->db->prepare($query);
$statment->execute([
':username' => $this->username
//,':start' => $start, ':limit' => $limit
]);
$result = $statment->fetchAll();
echo "<table border='1'>
<tr>
<th>Books</th>
</tr>";
foreach($result as $row){
echo "<tr>";
echo "<td>" . $row['nameOfBook'] . "</td>";
echo "</tr>";
}
echo "</table>";
}
这是我在 index.php 中的代码
$object->getBooks();
if( isset($_POST['next'])){
$start +=1;
}
这是我的表单代码
<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
Name: <input type="text" name="user" value="<?php echo $user;?>">
<span class="error">* <?php echo $nameErr;?></span>
<br><br>
password: <input type="password" name="pass" value="<?php echo $password;?>" >
<span class="error">* <?php echo $passwordErr;?></span>
<br><br>
<input type="submit" name="submit" value="Login">
<br><br>
<button type="button" name="button" onclick="window.location.href='/ooRigester.php'">SignUp</button>
<br><br>
<input type='submit' name='next' value='next' method="post"><br>
</form>
表单后的此代码
<?php
include_once('User.php');
if(isset($_POST['submit'])){
$username = $_POST["user"];
$password = $_POST["pass"];
$object = new User();
$object->username= $username;
$object->Password=$password;
if( $object->isAuthenticated() ){
echo "User Verified . <br><br>";
$object->getBooks();
if( isset($_POST['next'])){
$start +=1;
$object->getBooks($start);
}
}
else{
echo "Wrong User Name Or Password . <br>";
}}
?>
这在形式之前
<!DOCTYPE HTML>
<html>
<head>
<style>
.error {color: #FF0000;}
</style>
<title>Login Form</title>
</head>
<body>
<?php
/*$str = "Hello";
echo password_hash($str,1);*/
// define variables and set to empty values
$nameErr = "";
$passwordErr = "";
$user = "";
$password = "";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (empty($_POST["user"])) {
$nameErr = "Name is required";
} else {
$user = test_input($_POST["user"]);
// check if name only contains letters and whitespace
if (!preg_match("/^[a-zA-Z ]*$/",$user)) {
$nameErr = "Only letters and white space allowed";
}
}
if (empty($_POST["pass"])) {
$passwordErr = "Password is required";
} else {
$password = test_input($_POST["pass"]);
}
}
function test_input($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
?>
解决方案
控制器中的代码:
function getBooks($start = 0)
{
$limit = 1;
//SELECT loginUser.username, Library.nameOfBook FROM loginUser JOIN userBook JOIN Library ON userBook.user_id = loginUser.id AND userBook.book_id = Library.id WHERE loginUser.username="loay";
$query = "SELECT Library.nameOfBook FROM loginUser JOIN userBook JOIN Library ON userBook.user_id = loginUser.id AND userBook.book_id = Library.id WHERE loginUser.username=:username LIMIT $start, $limit";
$statment = $this->db->prepare($query);
$statment->execute([
':username' => $this->username,
//,':start' => $start, ':limit' => $limit
]);
$result = $statment->fetchAll();
echo "<table border='1'>
<tr>
<th>Books</th>
</tr>";
foreach ($result as $row) {
echo "<tr>";
echo "<td>" . $row['nameOfBook'] . "</td>";
echo "</tr>";
}
echo "</table>";
}
index.php 中的代码。
$object->getBooks();
if( isset($_POST['next']))
{
$start +=1;
$object->getBooks($start);
}
推荐阅读
- python - Pyplot 将 X 比例轴除以数字
- json - Wiremock BodyPattern 匹配包含这个或那个
- python - 如何拆分 JSON 列
- javascript - 如何用 gulp 替换 css 文件中的 url?
- c# - 绑定到 Materialdesign Flipper BackContent 和 ItemsControl DataTemplate 内的视图模型的问题
- electron - 安装电子应用程序后创建桌面快捷方式
- c - 是否可以使用 C 更改 Linux 终端文本和背景颜色?
- vba - 提取邮件评论 - 找不到方法
- nativescript - 基于标签的导航路由困难
- oauth-2.0 - 在 Keycloak 中禁用刷新令牌