Re: [PHP-DB] Problem with PDO Mysql and FETCH::ASSOC

> Hello,
>
> I am using the following code to perform queries on a MySQL database:
>
> $dbh = new 
> PDO($GLOBALS['database'],$GLOBALS['username'],$GLOBALS['password']);
> $dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
> $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
> $query = $dbh->prepare("SELECT * FROM log");
> $query->execute();
> $results = $query->fetchALL(PDO::FETCH_ASSOC);
> $dbh = null;
>
> If I perform this query in MySQL, I get:
>
> mysql> select * from log;
> +---------+------------+-------------------------------+----------+----------------+----------------------------+ 
>
> | type    | date       | client_id                     | model_id | 
> request        | message                    |
> +---------+------------+-------------------------------+----------+----------------+----------------------------+ 
>
> | message | 1.2375e+09 | domain.18052                  |          | 
> client_start   | started client             |
>
> However, if I perform this query with the PHP code above, I get:
>
> Array ( [type] => error [date] => 1.2375e+09 [log] => [distributed] => 
> client_start [def] => started client) )
>
> which is clearly wrong. 'distributed' is actually the name of the 
> database, so I don't really know what it is doing as a key in the 
> above result.
>
> If I use PDO::FETCH_BOTH instead of PDO::FETCH_ASSOC, I get
>
> Array ( [type] => message [0] => message [date] => 1.2375e+09 [1] => 
> 1.2375e+09 [log] => [2] => domain.18052 [3] => [distributed] => 
> client_start [4] => client_start [def] => started client [5] => 
> started client )
>
> which *does* contain the correct values with the numerical keys. 
> Before using MySQL, I was using SQLite, and this problem did not occur.
>
> The description of the table is:
>
> mysql> describe log;
> +-----------+----------+------+-----+---------+-------+
> | Field     | Type     | Null | Key | Default | Extra |
> +-----------+----------+------+-----+---------+-------+
> | type      | char(10) | YES  |     | NULL    |       |
> | date      | float    | YES  |     | NULL    |       |
> | client_id | char(50) | YES  |     | NULL    |       |
> | model_id  | char(50) | YES  |     | NULL    |       |
> | request   | char(20) | YES  |     | NULL    |       |
> | message   | char(50) | YES  |     | NULL    |       |
> +-----------+----------+------+-----+---------+-------+
> 6 rows in set (0.00 sec)
>
> Does anyone have any ideas as to what I might be doing wrong?
>
> Thanks for any help!
>
> Thomas
>

First of all check if you are actually connecting to the same database 
both times.

Start with printing $GLOBALS['database'] and see if it connects where 
you really want.

You mentioned a field "def" while printing the query's output which 
obviously is not included in the table's description. Have you changed 
the schema in the meantime?

-- 
Thodoris