RE: [PHP] PDO fetch_obj - question
| From: | MEM | Date: | Thu, 16 Apr 2009 16:34:35 +0000 |
| Subject: | RE: [PHP] PDO fetch_obj - question | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-291568@lists.php.net to get a copy of this message | ||
Thanks. I will see. The script for my database was been generated so, I will
doublecheck this uppercase "issue"...
Regards,
Márcio
2009/4/15 Thodoris <tgol@kinetix.gr>
Hi there, Ive made a fetch_obj and, as stated on some sites, it returns a
anonymous
object where the properties will have the name of our columns database.
However, when I do this, I notice that instead of giving me the column names
as they are typed on the DB I get them uppercase. So, when my database field
is id_dog to retrieve the property properly I have to search for ID_DOG
Why is this? Is this a normal behavior?
Thanks a lot,
Márcio
I have just dumped an object using var_dump retrieved with pdo fetch object
method:
object(stdClass)#3 (4) {
["id"]=>
string(1) "1"
["cat"]=>
string(1) "1"
["cod_sin"]=>
string(6) "120014"
["cod_uis"]=>
string(2) "26"
}
and it seems quite normal to me. Try to see your table info using:
describe
tablename;
To see what are your table's fields .
Try to include more info about your system, php version etc in case you
reply. It will help us to help you.
--
Thodoris
Done. No problem at all. The scripts as generated the database columns with
uppercase.
;)
Thanks for the info Thodoris.
Regards,
Marcio