PDO query statement

[terryds]

I found this in someone's code

 

$query = $this->db->query($string, PDO::FETCH_BOTH);

 

 

The query statement there is using PDO::FETCH_BOTH...

 

What i know that we use PDO::FETCH_BOTH in fetch statement only....

 

Can you tell me the use of it?

 

Does it fetch the queried string directly ?

 

But, i do a test, then i see nothing's special

 

try {

$sql = 'SELECT * from author WHERE 1';

$s = $pdo->query($sql, PDO::FETCH_BOTH);

}

catch (PDOException $e) {

echo "Error";

exit();

}

var_dump($s);

It shows up like this :

object(PDOStatement)[3]public 'queryString' => string 'SELECT * from author WHERE 1' (length=28)

So, what's the deal of using PDO::FETCH_BOTH in a query statement ?

[Ingolme]

It seems to be a mistake in the person's code. Try removing the PDO::FETCH_BOTH to see if the result is the same.

[terryds]

That's the same result ! i've tested it !

 

Yay ! I get the deal!

 

The PDO::FETCH_BOTH sets the pdo fetch method... so when we fetch the queried sql, it will use PDO::FETCH_BOTH

Edited October 12, 2013 by terryds