Can't make work sample about acrud HOT 3 OPEN

I was able fix this but without htaccess... not sure why but with htaccess not work correctly.

I change new router init in this way: $router = new \ACRUD\Router('/acrud/acrud.php');

I would like to ask about method pairs... why you do:
while($row = $statement->fetch(\PDO::FETCH_NUM)) {
$data[$row[0]] = $row[1];
}
when you can use PDO $statement->fetch(\PDO::FETCH_ASSOC)? which return an associative array?

this is full method:

public function pairs($query, $params = NULL)
{
$data = array();

    if($statement = $this->query($query, $params)) {
        while($row = $statement->fetch(\PDO::FETCH_NUM)) {
            $data[$row[0]] = $row[1];
        }
    }

    return $data;
}

from acrud.

Glad to hear you got it working.

Because I don't know the name of the columns that will be queried, using the column numbers insures that I don't need to. It's based on DByte.

 $pairs = DB::pairs('SELECT `id`, `username` FROM `user`);
 // array(23 => 'bobsmith', 45 => 'jane23', ..)

You probably are thinking the pairs method is actually the fetch method which does do what you are wanting.

from acrud.

Because I don't know the name of the columns that will be queried

That make sense, thanks!!

from acrud.