帮助将此 mysql 查询变成 PDO 查询

Question

我已经使用它有一段时间了，但从那时起我升级到 PDO 而不是 mysql 查询。但我似乎根本无法让这个特定的片段发挥作用。

$query = mysql_query ($sql) or die (mysql_error());
while ($records = @mysql_fetch_array ($query)) {
    $alpha[$records['alpha']] += 1;
    ${$records['alpha']}[$records['id_clients']] = array(
        $records['first_name'],       //item[0]
    );
}

我已经尝试过了

while ($records = $this->db->fetch_row_assoc($sql)) {
    $alpha[$records['alpha']] += 1;
    ${$records['alpha']}[$records['id_clients']] = array(
        $records['first_name'],       //item[0]
    );
}

，我的 PDO 代码是

public function query($statement)
    {
        return self::$PDO->query($statement);
    }
public function fetch_row_assoc($statement) {
    self::$PDO->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
        try
        {
            $stmt = self::$PDO->query($statement); 
            $result = $stmt->fetch();
            return $result;
        }catch(PDOException $e){
            echo $e->getMessage();
        }
        return false;
        //return self::$PDO->query($statement)->fetch(PDO::FETCH_ASSOC);

    }

查询函数有效，但我引入了 fetch_row_assoc 函数，希望我可以使用 mysql_fetch_asso 做同样的事情。

$sql = "SELECT 
                    SUBSTRING(`last_name`, 1, 1) AS alpha,
                    SUBSTRING(`middle_name`, 1, 1) AS subMiddleName,
                    `id_clients`,
                    `type`,
                    `first_name`,
                    `middle_name`,
                    `last_name`,
                    `address`,
                    `primary_number`,
                    `secondary_number`,
                    `home_number`,
                    `office_number`,
                    `cell_number`,
                    `fax_number`,
                    `ext_number`,
                    `other_number`,
                    `comments`
                FROM `clients`
                WHERE `user_id` = 1
                AND `is_sub` = 0
                AND `prospect` = 1
                ORDER BY `last_name`";

Answer 1

试试这个：

public function query($statement)
    {
        return self::$PDO->query($statement);
    }
public function fetch_row_assoc($statement) {
    self::$PDO->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
        try
        {
            $stmt = self::$PDO->query($statement); 
            $stmt->setFetchMode(PDO::FETCH_ASSOC);
            $result = $stmt->fetch();
            return $result;
        }catch(PDOException $e){
            echo $e->getMessage();
        }
        return false;
    }