Pdo\Pgsql::copyToArray
(PHP 8 >= 8.4.0)
Pdo\Pgsql::copyToArray — Copy data from database table into PHP array
说明
string
$tableName,string
$separator = "\t",string
$nullAs = "\\\\N",?string
$fields = null): array|false
Copies data from tableName into array using separator as fields delimiter and fields list
参数
tableName
String containing table name.
separator
Delimiter used to separate fields in an entry of the
rows array.
nullAs
How to interpret SQL NULL values.
fields
List of fields to export.
返回值
Returns an array of rows, 或者在失败时返回 false.
示例
示例 #1 Pdo\Pgsql::copyToArray() example
Each returned element is one record, with fields joined by
separator and a trailing newline.
<?php
$db = new Pdo\Pgsql('pgsql:dbname=test host=localhost', $user, $pass);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->exec('CREATE TABLE fruits (id int, name text, qty int)');
$db->exec("INSERT INTO fruits VALUES (1, 'apple', 10), (2, 'banana', 20)");
$rows = $db->copyToArray('fruits');
var_export($rows);
?>以上示例会输出:
array ( 0 => '1 apple 10 ', 1 => '2 banana 20 ', )
参见
- Pdo\Pgsql::copyFromArray() - Copy data from a PHP array into a table
- Pdo\Pgsql::copyFromFile() - Copy data from file into table
- Pdo\Pgsql::copyToFile() - Copy data from table into file
来源:PHP Documentation Group · 作者与贡献记录 · CC BY 3.0。离线整理了版式、链接和媒体显示。
