問題描述

我正在嘗試使用 PHP PDO 創(chuàng)建一個 Setting 對象的新實例調用 __construct() 方法并約束 PDO::FETCH_PROPS_LATE.不幸的是，我收到了這個警告(并且綁定不起作用).

如何將列值傳遞給構造函數(shù)方法?

警告:pdo.php 中的 Setting::__construct() 缺少參數(shù) 1.

注意:未定義變量:pdo.php 中的鍵.

類設置{受保護的 $key, $value, $displayable;公共函數(shù) __construct($key, $value = null, $displayable = 1){$this->key = $key;$this->value = $value;$this->displayable = $displayable >0;}}while($mashup = current($mashup)){$stmt = $dbh->prepare('SELECT `key`, value, displayable從設置 WHERE mashup_id = :id');$stmt->bindParam(':id', $mashup->id, PDO::PARAM_INT);$stmt->execute();$settings = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,'環(huán)境');}$stmt->closeCursor();

您的構造函數(shù)中有一個非默認參數(shù) $key:

public function __construct($key, $value = null, $displayable = 1)

所以，當你這樣做時:

$settings = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,'Setting');

錯誤:warning: Missing argument 1 for Setting::__construct() in pdo.php 僅針對參數(shù) $key 拋出，因為它不是默認值.>

正確使用fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,...是這樣的:

$variable = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,'班級名稱'，<構造函數(shù)中使用的參數(shù)名稱數(shù)組(按順序)>);

所以，就你而言:

$variable = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,'環(huán)境'，array('key', 'value', 'displayable');

I'm trying to create a new instance of Setting object calling __construct() method with PHP PDO and constrain PDO::FETCH_PROPS_LATE. Unfortunatly i'm getting this warning (and binding doesn't work).

How can pass column values to the constructor method?

Warning: Missing argument 1 for Setting::__construct() in pdo.php.

Notice: Undefined variable: key in pdo.php.

class Setting
{

    protected $key, $value, $displayable;

    public function __construct($key, $value = null, $displayable = 1)
    {
        $this->key         = $key;
        $this->value       = $value;
        $this->displayable = $displayable > 0;
    }

}

while($mashup = current($mashups))
{
    $stmt = $dbh->prepare('SELECT `key`, value, displayable
        FROM setting WHERE mashup_id = :id');

    $stmt->bindParam(':id', $mashup->id, PDO::PARAM_INT);
    $stmt->execute();

    $settings = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,
       'Setting');
}

$stmt->closeCursor();

You have a non defaulted parameter $key in your constructor:

public function __construct($key, $value = null, $displayable = 1)

So, when you are doing this:

$settings = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,'Setting');

Error: warning: Missing argument 1 for Setting::__construct() in pdo.php is thrown only for parameter $key because it is not defaulted.

The correct use of fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,... is like this:

$variable = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,
                           'classname', 
                            <array of parameter names(in order) used in constructor>);

So, in your case:

$variable = $stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE,
                            'Setting', 
                             array('key', 'value', 'displayable');

這篇關于PDO 使用 PDO::FETCH_PROPS_LATE 和 __construct() 調用?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！