use php variable within postgresql query

[email protected] (e-letter) Fri, 9 Jun 2023 10:05:57 +0100
Newsgroups php.db
Message-ID <CAET1fe7+M1HNKW7eRWTdw6U1cw8TJnSxxuguzXoMGLeea=aKsg@mail.gmail.com>
Readers,

Suppose:

$query=$_GET['databasecolumn'[;

$anotherquery=pg_query($databaseconnection, 'SELECT * FROM
databasename WHERE databasecolumnname="'.$query.';"');

Two errors are reported:

PHP Notice:  Undefined index: databasecolumnname

PHP Warning:  pg_query(): Query failed: ERROR:  column ";" does not exist

Any advice please?