PDO::pgsqlCopyToArray
(PHP 5 >= 5.3.3, PHP 7)
PDO::pgsqlCopyToArray — Copy data from database table into PHP array
Описание
public array PDO::pgsqlCopyToArray
( string
$table_name
, array $rows
[, string $delimiter = '\t'
[, string $null_as = "\\\\N"
[, string $fields
]]] )
Copies data from table into array using delimiter as fields delimiter and fields list
Список параметров
-
table_name -
String containing table name
-
delimiter -
Delimiter used in
rowsarray -
null_as -
How to interpret null values
-
fields -
List of fields to export
Возвращаемые значения
Returns an array of rows, или FALSE в случае возникновения ошибки.
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Уровни абстракции
- Объекты данных PHP
- PDO Драйверы
- Функция PDO_PGSQL DSN() - Connecting to PostgreSQL databases
- PDO::pgsqlCopyFromArray
- PDO::pgsqlCopyFromFile
- PDO::pgsqlCopyToArray
- PDO::pgsqlCopyToFile
- PDO::pgsqlGetNotify
- PDO::pgsqlGetPid
- Функция PDO::pgsqlLOBCreate() - Creates a new large object
- Функция PDO::pgsqlLOBOpen() - Opens an existing large object stream
- Функция PDO::pgsqlLOBUnlink() - Deletes the large object
Коментарии
The "rows" returned are strings, (hence the delimiter parameters for separating fields). They're not parsed into PHP arrays, so this isn't a substitute for $connection->query('SELECT * FROM table_name')->fetchAll().
Only the first character of $delimiter is used. Characters that may be used are those <32 except "\r", "\n" and NUL (chr(0)); anything from !"#$%&'()*+,-./:;<=>?@ABCDEFGHIJKMOPQRSTVWXYZ[]^_`{|}~, and DEL (chr(127)) (yes, upper-case letters are allowed, but lower-case ones are not).
Also, the $fields argument is a comma-separated list of the desired columns.