开发者

help with making this mysql query into a PDO query

I have been using this for a while, but have since then upgraded to PDO instead of mysql queries. But I can't seem to get this particular snippet to work at all.

$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]
    );
}

I have tried this

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

and my PDO code is

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);

    }

The query function works, but I have introduced my fetch_row_assoc function in hopes that I can do that same thing with 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`";


Try this:

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;
    }
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜