Pdo\Pgsql::copyToArray

    (PHP 8 >= 8.4.0)

    Pdo\Pgsql::copyToArray — Copy data from database table into PHP array

    Опис

    public function Pdo\Pgsql::copyToArray(
        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
',
)

    Прогляньте також

    Found A Problem?

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top