ID: 49521
Updated by: [email protected]
Reported By: waps at pisem dot net
-Status: Verified
+Status: Assigned
Bug Type: PDO related
Operating System: Ubuntu 8.10 x64
PHP Version: 5.2.10
-Assigned To:
+Assigned To: pierrick
Previous Comments:
------------------------------------------------------------------------
[2009-11-06 17:07:46] caferrari at gmail dot com
Thats evil!...
My code with an Ugly solution!
<?php
class TestObject {
public function __construct($id=0, $name='', $mail=''){
// if (isset($this->id)) return; // Ugly solution necessary atm
to
bypass the problem!.
$this->id = $id;
$this->name = $nome;
$this->mail = $mail;
}
}
$dbh = new PDO('sqlite:'.dirname(__FILE__).'/foo.db');
$qr = $dbh->query("SELECT 1 as id, 'test' as name, '[email protected]' as
mail");
$x = $qr->fetchObject('TestObject');
print_r($x);
Expected:
TestObject Object ( [id] => 1 [name] => test [mail] => [email protected] )
Actual Result:
TestObject Object ( [id] => 0 [name] => [mail] => )
------------------------------------------------------------------------
[2009-09-22 07:06:38] waps at pisem dot net
sjoerd, yes!
Im my php5 framework phpDays (http://phpdays.sf.net) I faced with this
problem. Pleae, fix it in php 5.2.x and 5.3.x and 6.x.x. Thnanks!
P.S. Maybe this problem exists in other php components. Need to code
review to find this problem in all components.
P.P.S. Please, tell me about fix this problem in future. Thanks!
------------------------------------------------------------------------
[2009-09-21 18:45:30] [email protected]
Confirmed. If the constructor sets default values for some fields, as
is typical, the constructor will overwrite the values just retrieved
from the database.
<?php
class Book {
function __construct() {
$this->title = "Default";
}
}
$pdo = new PDO('mysql:dbname=books', 'root');
$statement = $pdo->prepare('SELECT * FROM book WHERE
title=\'Peopleware\'');
$statement->execute();
$obj = $statement->fetchObject('Book');
echo $obj->title; // Expected: Peopleware. Actual: Default
?>
------------------------------------------------------------------------
[2009-09-10 11:45:31] waps at pisem dot net
Description:
------------
Incorrect creating user object: set data before call constructor
method.
Reproduce code:
---------------
---
>From manual page: pdostatement.fetchobject
---
class Product {
public function __construct() {
echo 'create object, ';
}
public function __set($offset, $value) {
echo 'set value, ';
}
}
// fetch object
$stmt->fetchObject('Product', array());
Expected result:
----------------
Expected result: create object, set value,
Actual result:
--------------
Actual result: set value, create object,
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=49521&edit=1
