|
|
Posted by Captain Paralytic on 04/13/07 10:54
On 13 Apr, 11:52, "strawberry" <zac.ca...@gmail.com> wrote:
> On Apr 13, 11:10 am, "Captain Paralytic" <paul_laut...@yahoo.com>
> wrote:
>
>
>
>
>
> > On 13 Apr, 01:51, "strawberry" <zac.ca...@gmail.com> wrote:
>
> > > I'm trying to extend a class (written by others) and was wondering if
> > > there's a standard a way of passing a $_GET request to a class. Here's
> > > what I have (see below). If I hardcode $where, something like
>
> > > $where = " WHERE `firstname` = 'John' "
>
> > > and then pass it as an argument into the scope of a 'select' function
> > > then it works fine, but otherwise the query just appears to hang.
>
> > > I'm deliberately not including the class or class extender at this
> > > stage, but I'll add them to this thread later if required.
>
> > > foreach ($_GET as $condition_key => $condition_value) {
> > > $condition[] =" $condition_key = '$condition_value' ";
> > > }
> > > if(is_null($condition)){
> > > $where = " WHERE 1 ";
> > > }else{
> > > $conditionString = implode('AND', $condition);
> > > $where = " WHERE $conditionString ";
> > > }
>
> > echo the final query and pop it into phpmyadmin. One thing I notice is
> > that you are not puting backtics round the field name ($condition_key)
> > in your loop.
>
> You read my mind :-)- Hide quoted text -
>
> - Show quoted text -
I thought all developers had telepathy functionality. That's how we
manage to build things even though the users don't know what they want.
Navigation:
[Reply to this message]
|