Pdo\Pgsql::copyToArray
Copy data from database table into PHP array
Description
public arrayfalse Pdo\Pgsql::copyToArray(
string $tableName,
string $separator = "\t",
string $nullAs = "\\\\N",
stringnull $fields = null
)
Copies data from tableName into array using separator as fields delimiter and fields list
Parameters
-
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.
Return Values
Returns an array of rows, or false on failure.
Examples
Example #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);
?>
The above example will output:
array (
0 => '1 apple 10
',
1 => '2 banana 20
',
)
See Also
- Pdo\Pgsql::copyFromArray
- Pdo\Pgsql::copyFromFile
- Pdo\Pgsql::copyToFile