主页 / 问题 / 1587547
Accepted
Ivan Chuzhmakov
Asked:2024-07-18 20:53:11 +0000 UTC2024-07-18 20:53:11 +0000 UTC

使用空字段复制 fetchAll 输出

  • 772

花了半天时间，发现一个奇怪的bug，如果字段为空，同一个条目会显示两次。

class SearchPeople{
    private $dsn = 'sqlsrv:Server=test\sql;Database=test;';
    private $user = 'test';
    private $password = 'test';
    private $options  = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC];
    private $con;
    public function __construct(){
        try {
            $this->con=new PDO($this->dsn, $this->user, $this->password, $this->options);                
        } catch (PDOException $e) {
            var_dump($e);
        }        
    }
    public function searchPeople(){                                                                              
        $sql="SELECT distinct id,sName,Name,pName,dateMan,typeDoc,serDoc,numDoc,dateDoc,contact FROM people WHERE sName = ? 
            AND Name = ? AND dateMan = ? AND typeDoc = ? AND numDoc = ? AND dateDoc = ?  AND (pName = ? OR pName IS NULL)  
            AND (serDoc = ? OR serDoc IS NULL)";
        $query = $this->con->prepare($sql);
        $tr=['testov', 'test', '10.12.2010', '24', '555333', '01.04.2011','',''];
        $query->execute($tr);
        $result=$query->fetchAll(PDO::FETCH_ASSOC);                
        return $result;
    }
}
    $db=new SearchPeople();    
    $result=$db->searchPeople();    
    var_dump($result);

PHP 版本 8.3.2，MSSQL 数据库（在数据库中相同的查询显示一条记录）谁知道原因是什么以及如何修复此行为？

PS我正在添加我正在做的事情的屏幕截图；数据库中的查询（刚刚创建了一条记录（甚至为了清晰起见删除了不同的记录） 在此输入图像描述 我正在执行的代码本身 在此输入图像描述

结论

在此输入图像描述

php

1 个回答

  1. Best Answer

    一般来说，我不知道这是什么类型的故障以及它到底为什么会发生，但是通过直接将空引号替换到请求代码中而不将空值替换到准备好的请求中，可以纠正双输出的消失，即：

      //конструкцию 
$sql="SELECT id,sName,Name,pName,dateMan,typeDoc,serDoc,numDoc,dateDoc,contact FROM people WHERE sName = ? 
            AND Name = ? AND dateMan = ? AND typeDoc = ? AND numDoc = ? AND dateDoc = ?  AND (pName = ? OR pName IS NULL)  
            AND (serDoc = ? OR serDoc IS NULL)";
        $query = $this->con->prepare($sql);
        $tr=['testov', 'test', '10.12.2010', '24', '555333', '01.04.2011','',''];
//заменяем на 
$sql="SELECT id,sName,Name,pName,dateMan,typeDoc,serDoc,numDoc,dateDoc,contact FROM people WHERE sName = ? 
            AND Name = ? AND dateMan = ? AND typeDoc = ? AND numDoc = ? AND dateDoc = ?  AND (pName = '' OR pName IS NULL)  
            AND (serDoc = '' OR serDoc IS NULL)";
        $query = $this->con->prepare($sql);
        $tr=['testov', 'test', '10.12.2010', '24', '555333', '01.04.2011'];

    也许有人会发现它有用

    • 0

相关问题