SELECT erroneous concatenation

[Former user]

SELECT "1","1","1"

yields: "1" not "1","1","1" as expected.

See screenshot.

phpLiteAdmin running on Synology php7.

Haven't been able to check whether this is a Synology problem.

Same result for php7 and php5.6

[phpLiteAdmin]

SELECT statements that produce multiple columns with the same column name now get displayed as expected. This fixes issue #358 https://bitbucket.org/phpliteadmin/public/issues/358/select-erroneous-concatenation

→ <<cset 05967c8ddfb8>>

[phpLiteAdmin]

Thank you for your report. The problem was that fetching an associative array would only give one column, as all columns have the same column name. Fetching a numeric array does not give column names, so they have to be fetched separately. This is now done using $result->getColumnMeta($colNum)['name'] for PDO, $result->columnName($colNum) for SQLite3 and $result->fieldName($colNum) for SQliteDatabase.

This now also alows queries like SELECT colA, colA FROM mytable that before displayed only one column colA in the result and now will display two columns colA.