PDO returns erroneous columns from within pdt
Posted on
16th Feb 2014 07:03 pm by
admin
Hi All,
This is a truly weird behavior:
When using a simple pdo fetch, erroneous columns are returned!
Steps to reproduce:
------------------------------------------------------------ -----------
1.create a table with 4 columns, such as:
CREATE TABLE `t1` (
`col1` int(11) DEFAULT NULL,
`col2` varchar(20) DEFAULT NULL,
`col3` int(11) DEFAULT NULL,
`col4` int(11) DEFAULT NULL
)
2. Insert some data:
INSERT INTO t1 VALUES (1, 'test', 2, 3);
3. Try the following code:
$pdo = new PDO("mysql:host=localhost;dbname=test", 'usr', 'pwd');
$pdoStatement = $pdo->query('select * from t1');
$dbResult = $pdoStatement->fetchAll(PDO::FETCH_ASSOC);
var_dump($dbResult);
------------------------------------------------------------ -------
This produces the results:
array(1) {
=>array(3) {
["col1"]=>
string(1) "1"
["col2"]=>
string(4) "test"
["t1"]=>
string(1) "2"
}
That is, instead of returning 4 columns named col1,col2,col3,col4,
only 3 columns are returned, col1, col2 and t1!
While t1 is the name of the table!!!!
What's going on here (This drove me crazy at first )??
By the way, when running directly from under Apache this code produces the correct results. Is this some kind of a version issue? I'm running this from the latest release of eclipse pdt: PDT 2.1-SR1, Eclipse 3.5-SR1
Is there a latter one?
Many Thanks!
Vitaliy
Many Thanks!
Vitaliy
No comments posted yet
Your Answer:
Login to answer
112 
5 
Other forums
Registration
ok so i have a site where people can register and login which works now thanks to someone on here th
big pagination problem in php
<?php
$connect = mysql_connect("localhost", "root", "")
Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What
frame help
on the bottom frame is menu.html
Code: <body><form action='link.php' met
upload form file types....
Hey all, I am learning PHP and I am writing a script from the W3C Schools tutorials for uploading fi
Problem with HTML form
Hello,
I made a HTML form with some fields and check box.
Everything works fine except whe
help with contest script
I would like to code a contest script to my site but i don't know how. Could someone just give me pu
Change snippet to use CURDATE
I am using time() in the snippet below, I would like to use CURDATE() and have the database setup fo
cstdatomic (c++0x std::atomic) / g++ 4.4
Hello,
I'm trying to use cstdatomic (std::atomic in the upcoming c++0x standard) in g++
values in array being escaped
I would like to submit some values - back to the same form for checking before processing...
