PHP.nl

pg_affected_rows

pg_affected_rows

Returns number of affected records (tuples)

int **pg_affected_rows** PgSql\Result $result
returns the number of tuples

(instances/records/rows) affected by , , and queries. pg_affected_rows``INSERT``UPDATE``DELETE

The server also returns the number of SELECTed rows.

Opmerking: > This function used to be called . pg_cmdtuples

result

The number of rows affected by the query. If no tuple is affected, it will return . 0

Voorbeeld: example

<?php
$result = pg_query($conn, "INSERT INTO authors VALUES ('Orwell', 2002, 'Animal Farm')");

$cmdtuples = pg_affected_rows($result);

echo $cmdtuples . " tuples are affected.\n";
?>
1 tuples are affected.

pg_query``pg_query_params``pg_execute``pg_num_rows