fetchNum() method about aura.sql HOT 6 CLOSED

You mean PDO::FETCH_NUM ?

from aura.sql.

Not sure what you mean here @gholol -- can you expand a bit?

from aura.sql.

Well, sure guys.

Aura.Sql provides fetchAssoc() method.

We can use it like this

$result = $pdo->fetchAssoc($stm, $bind);

Now, this of course retrieves an ASSOCIATIVE array (where the key is the
first column, and the row arrays are keyed on the column names), and so, I cannot use it with list() function, because list() works only with numeric arrays.

I can do a workaround around this, and write something like:

$result = $pdo->fetchAssoc($stm, $bind);
list($value1, 
     $value2,
     $value3
) = array_keys($result);

But isn't it a bit impractical? Do you have any plans of implementing a function that returns a result as numeric array? (PDO:FETCH_NUM

from aura.sql.

This particular case ...

$result = $pdo->fetchAssoc($stm, $bind);
list($value1, 
     $value2,
     $value3
) = array_keys($result);

... might be addressed by:

$values = $pdo->fetchCol($stm, $bind);

That will populate $values with the first column of all rows in the result set. (Note that fetchAssoc() uses the first column as the array key.)

Is that sufficient, or is there another case that needs to be addressed?

from aura.sql.

@gholol Any further thoughts?

from aura.sql.

Hi!

Sorry for not responding, i was at work.

Your suggestion to use fetchCol() was right, it works perfectly ;) So i don't have anything else to rant about.

Have a nice day guys!

from aura.sql.