PostgreSQL version 14

I´m trying to capture the value of id by using the URL, but always while printing tha array for debug its null

I need to find a way (if possible) to make a PHP class accept a PgSqlResult object as an attribute. PHP 8.1+ has migrated the pgsql result resource to the PgSQLResult instance. In prior versions of PHP I could set the attribute like this:

I need to run a select which may have multiple rows, iterate through the rows and update two tables based on the select. I can’t get it working properly. The first 2 statements work fine, the third does nothing, the last one works. Variables and arrays echo OK

I have two tables related by foreign key.

I try to connect my PostgreSQL database to my website using PHP PDO, here my php code file(connnect.php):

I use the function pg_query_params (or pg_query).
For debugging purposes I would like to be able to get the lastly sent query (eventually having parameters replaced inside).
Is there a call for that ?

I have a php project in which I use postgresql and XAMPP.
The project itself is very small and it’s layout looks like this:

I have 1 database with 3 schemas,
one of the table from the schemas is primary_table (sample)
the primary table has a column primary_id (sample)