php教程

php手册

PDO::pgsqlCopyToArray

(PHP 5 >= 5.3.3, PHP 7)

PDO::pgsqlCopyToArray — Copy data from database table into PHP array

说明

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

Copies data from table into array using delimiter as fields delimiter and fields list

参数

table_name: String containing table name
delimiter: Delimiter used in rows
null_as: How to interpret null values
fields: List of fields to export

返回值

Returns an array of rows, 或者在失败时返回 FALSE.

User Contributed Notes

Hayley Watson 06-Sep-2018 04:23


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.

php教程 php手册 php手册

PDO::pgsqlCopyToArray

说明

参数

返回值

User Contributed Notes

php教程

php手册