PDO::pgsqlCopyToArray()
(PHP 5 >= 5.3.3, PHP 7)
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$tableinto array using$delimiteras fields delimiter and$fieldslist
参数
- $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.
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.