Re: use php variable within postgresql query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



My friends,

Would not the syntax of "$query=$_GET['databasecolumn'[;" be part of the
issue?

I believe the brackets should be closed like this, no?
"$query=$_GET['databasecolumn'];"

~G.



On Fri, 9 Jun 2023 at 10:53, Aziz Saleh <azizsaleh@xxxxxxxxx> wrote:

> Read and understand these, should help you:
>
> https://www.php.net/manual/en/language.types.array.php
>
> Basically its databasecolumnname get param is not defined (set) causing the
> query to fail also.
>
> On Fri, Jun 9, 2023 at 5:06 AM e-letter <inpost@xxxxxxxxx> wrote:
>
> > 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?
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux