You need to enable JavaScript to run this app. PHP MVC开发:基于已实现登录模块的商品关联模糊搜索求助
优惠活动
大模型
产品
解决方案
定价
更多

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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.11.13 13:24:03