CakeFest 2024: The Official CakePHP Conference

PDO::pgsqlCopyToArray

(PHP 5 >= 5.3.3, PHP 7, PHP 8)

PDO::pgsqlCopyToArrayCopiar datos de una tabla de una base de datos a un array de PHP

Descripción

public PDO::pgsqlCopyToArray(
    string $table_name,
    array $rows,
    string $delimiter = '\t',
    string $null_as = "\\\\N",
    string $fields = ?
): array

Copia los datos de la tabla dada por table a un array empleando delimiter como delimitador de campos y la lista de campos fields

Parámetros

table_name

Una cadena que contiene el nombre de la tabla

delimiter

El delimitador empleado en el array rows

null_as

Cómo interpretar valores nulos

fields

El listado de campos a exportar

Valores devueltos

Devuelve un array de filas o false en caso de error.

add a note

User Contributed Notes 1 note

up
-1
Hayley Watson
5 years ago
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.
To Top