PHP MVC开发:基于已实现登录模块的商品关联模糊搜索求助
商品搜索功能开发需求与现有代码
我正在尝试开发搜索表单,用于从商品数据库中检索并展示匹配结果。
数据库结构
数据库共包含3张表:
users:存储所有与登录、登出流程相关的信息lots:商品表,包含lotid、title、desc、photo字段,以及外键a_id,通过a_id关联拍卖表以标识商品卖家auction:拍卖表,存储卖家相关信息,包含a_id、name、address、date字段
现有功能基础
目前网站已可正常实现用户注册、登录、登出功能,现计划在页面新增搜索功能,支持用户搜索已上架的商品。
搜索功能要求
- 返回结果需展示
lots表的全部字段,同时展示对应auction表的关联数据 - 搜索规则为模糊匹配商品title字段:例如搜索“phone”时,需返回所有标题包含“phone”的商品(如iPhone、red phone等)
- 后续将录入约500条lot记录、50条auction记录,搜索功能需支持全量数据检索,仅返回匹配结果
当前开发问题
目前开发过程中遇到大量报错,刚接触MVC架构,不确定是否存在视图、模型等文件使用不当的问题,但现有登录系统可正常运行。
当前尝试为将搜索表单添加到auction.php页面,复用users.php控制器实现逻辑,不确定是否需要为该搜索功能新建独立控制器。
现有代码片段
auction.php视图页面代码
<?php require APPROOT . '/views/includes/head.php'; ?> <div class="navbar"> <?php require APPROOT . '/views/includes/navigation.php'; ?> </div> <form action="search.php" method="GET"> <input type="text" name="search" placeholder="Search"> <button type="submit" name="submit-search"></button> </form> <h1> this is Auction Page </h1> <h2>All products</h2> <div class="product-container"> <?php $this->db->query("SELECT * FROM article"); ?> </div>
User模型代码
<?php class User{ private $db; public function __construct(){ $this->db = new Database; } public function getUsers(){ $this->db->query("SELECT * FROM users"); $result = $this->db->resultSet(); return $result; } public function register($data){ $this->db->query('INSERT INTO users (username, email, password) VALUES (:username, :email, :password)'); //绑定参数 $this->db->bind(':username', $data['username']); $this->db->bind(':email', $data['email']); $this->db->bind(':password', $data['password']); //执行查询 if ($this->db->execute()){ return true; }else{ return false; } } public function login($username, $password){ $this->db->query('SELECT * FROM users WHERE username = :username'); //绑定参数 $this->db->bind(':username', $username); $row = $this->db->single(); $hashedPassword = $row->password; if (password_verify($password, $hashedPassword)){ return $row; }else{ return false; } } // 通过邮箱查找用户,邮箱由控制器作为参数传入 public function findUserByEmail($email){ $this->db->query('SELECT * FROM users WHERE email = :email'); //邮箱参数绑定 $this->db->bind(':email', $email); //检查邮箱是否已注册 if ($this->db->rowCount() > 0){ return true; }else{ return false; } } }
Users控制器代码
<?php class Users extends Controller { public function __construct(){ $this->userModel = $this->model('User'); } public function register(){ $data = [ 'username' => '', 'email' => '', 'password' => '', 'confirmPassword' => '', 'usernameError' => '', 'emailError' => '', 'passwordError' => '', 'confirmPasswordError' => '' ]; if ($_SERVER['REQUEST_METHOD'] == 'POST') { // 过滤POST提交的数据 $_POST = filter_input_array(INPUT_POST, FILTER_SANITIZE_STRING); $data = [ 'username' => trim($_POST['username']), 'email' => trim($_POST['email']), 'password' => trim($_POST['password']), 'confirmPassword' => trim($_POST['confirmPassword']), 'usernameError' => '', 'emailError' => '', 'passwordError' => '', 'confirmPasswordError' => '' ]; $nameValidation = "/^[a-zA-Z0-9]*$/"; $passwordValidation = "/^(.{0,7}|[^a-z]*|[^\d]*)£/i"; // 校验用户名仅允许字母和数字 if (empty($data['username'])) { $data['usernameError'] = '请输入用户名'; } elseif (!preg_match($nameValidation, $data['username'])) { $data['usernameError'] = '用户名仅可包含字母和数字'; } if (empty($data['email'])) { $data['emailError'] = '请输入邮箱地址'; }elseif (!filter_var($data['email'], FILTER_VALIDATE_EMAIL)){ $data['emailError'] = '请输入有效邮箱地址'; }else{ // 检查邮箱是否已注册 if ($this->userModel->findUserByEmail($data['email'])){ $data['emailError'] = '该邮箱已注册账号'; } } // 校验密码长度及数字要求 if (empty($data['password'])){ $data['passwordError'] = '请输入密码'; }elseif(strlen($data['password']) < 6){ $data['passwordError'] = '密码长度需大于6位'; } elseif (preg_match($passwordValidation, $data['password'])) { $data['passwordError'] = '密码必须至少包含一位数字'; } // 校验确认密码与密码是否一致 if (empty($data['confirmPassword'])) { $data['confirmPasswordError'] = '请确认密码'; }else{ if ($data['password'] != $data['confirmPassword']){ $data['confirmPasswordError'] = '两次输入的密码不一致'; } } // 确认所有错误项为空 if (empty($data['usernameError']) && empty($data['emailError']) && empty($data['passwordError']) && empty($data['confirmPasswordError'])){ // 密码哈希处理 $data['password'] = password_hash($data['password'], PASSWORD_DEFAULT); // 调用模型完成注册 if ($this->userModel->register($data)){ // 注册成功后跳转登录页 header('location: ' . URLROOT . '/users/login'); }else{ die('系统错误,请稍后重试'); } } } $this->view('users/register', $data); } public function login(){ $data = [ 'title' => '登录页', 'username' => '', 'password' => '', 'usernameError' =>'', 'passwordError' =>'' ]; // 校验请求方式是否为POST if ($_SERVER['REQUEST_METHOD'] == 'POST'){ // 过滤POST数据,防止前端篡改 $_POST = filter_input_array(INPUT_POST, FILTER_SANITIZE_STRING ); $data = [ 'username' => trim($_POST['username']), 'password' => trim($_POST['password']), 'usernameError' => '', 'passwordError' => '', ]; // 校验用户名 if (empty($data['username'])){ $data['usernameError'] = '请输入用户名'; } // 校验密码 if (empty($data['password'])){ $data['passwordError'] = '请输入密码'; } // 确认所有错误项为空 if (empty($data['usernameError']) && empty($data['passwordError'])){ $loggedInUser = $this->userModel->login($data['username'], $data['password']); if ($loggedInUser){ $this->createUserSession($loggedInUser); } }else{ $data['passwordError'] = '用户名或密码错误,请重试'; $this->view('users/login', $data); } }else{ $data = [ 'username' => '', 'password' => '', 'usernameError' =>'', 'passwordError' =>'' ]; } $this->view('users/login', $data); } public function createUserSession($user){ $_SESSION['user_id'] = $user->id; $_SESSION['username'] = $user->username; $_SESSION['email'] = $user->email; header('location:' . URLROOT . '/pages/index'); } public function logout(){ unset($_SESSION['user_id']); unset($_SESSION['username']); unset($_SESSION['email']); header('location:' . URLROOT . '/users/login'); } public function Search(){ } }
内容的提问来源于stack exchange,提问作者tester346585
相关产品推荐
相关产品推荐

