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();
See Question&Answers more detail:os