xref: /PHP-8.1/ext/pgsql/tests/15pg_delete.phpt (revision e378968c)
1--TEST--
2PostgreSQL pg_delete()
3--EXTENSIONS--
4pgsql
5--SKIPIF--
6<?php include("skipif.inc"); ?>
7--FILE--
8<?php
9error_reporting(E_ALL);
10
11include 'config.inc';
12
13$db = pg_connect($conn_str);
14
15$fields = array('num'=>'1234', 'str'=>'XXX', 'bin'=>'YYY');
16$ids = array('num'=>'1234');
17echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING)."\n";
18echo pg_delete($db, $table_name, $ids, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
19if (!pg_delete($db, $table_name, $ids)) {
20    echo "Error\n";
21}
22else {
23    echo "Ok\n";
24}
25?>
26--EXPECT--
27DELETE FROM "php_pgsql_test" WHERE "num"=1234;
28DELETE FROM "php_pgsql_test" WHERE "num"='1234';
29Ok
30