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?