[FX.php List] $_GET not working in links after upgrade from FM5.5 to 9

[Gjermund Gusland Thorsen]

I made a way to avoid most annoying errors when migrating
---
http://www.file-making.com/tutorial/
---
Play stupid, do it blindly, it's boring, I know, but it usually works.

ggt

2007/12/11, Nick Trenary <trenaryn at crlibrary.org>:
> Ok, a bit more here.
>
> My web server is sitting on my dmz, running OS X 10.3.9, Apache 1.3, php
> v4.4.4.  It appears for some reason I can't search for a specific record
> similar to what's suggested below.  But if I use the exact same test
> environment on the test web server on my computer my searches work.  My
> computer, running XP, Apache 1.3, php v.4.4.1,  is on the same network
> as my Filemaker server.  What the hell?
>
> Nick
>
> Andrew Denman wrote:
> > That is odd.  Is there any white space (extra returns, spaces) in the
> > ProgramID field in FileMaker that could be causing the search to not match?
> > Try explicitly stating the search type:
> >
> > $query->AddDBParam ('ProgramID', $_GET['id'], 'cn'); - if those numbers are
> > in the ProgramID field this search should return it, but you won't want to
> > use this search type on your live application.
> >
> > $query->AddDBParam ('ProgramID', $_GET['id'], 'eq'); - if the above search
> > works and this one doesn't there are probably extra characters in the field.
> >
> > Andrew Denman
> >
> > -----Original Message-----
> > From: fx.php_list-bounces at mail.iviking.org
> > [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Nick Trenary
> > Sent: Tuesday, December 11, 2007 11:14 AM
> > To: FX.php Discussion List
> > Subject: Re: [FX.php List] $_GET not working in links after upgrade from
> > FM5.5 to 9
> >
> >
> >
> > Andrew Denman wrote:
> >
> >> Nick,
> >>
> >> It looks like the ProgramID was passed (it is right before the '&-find' in
> >> the URL):
> >> [URL] =>
> >>
> >>
> > http://web:webuser@192.168.10.3:80/fmi/xml/FMPXMLRESULT.xml?-db=Events.fp7&-
> >
> >> lay=web&-max=50&ProgramID=2529&-find
> >>
> >> Now for some questions...
> >> -Is 2529 the correct ProgramID for that record?
> >>
> >>
> > Yes.
> >
> >> -Why are you using strtok() on the ProgramID when you pull it from the
> >> database?  If you have a period in your ProgramID then that function is
> >> cutting it short.
> >>
> >>
> > I don't recall, I made these pages a few years ago.  I tested removing
> > this code, same results.
> >
> >> -Is the field 'ProgramID' the same case as it is defined in FileMaker?
> >>
> >>
> > Yes.
> >
> >> -Are you looking at the correct layout for the records you want to find?
> >>
> >>
> >>
> > Yes.
> >
> >> Other than those possible issues I don't see in that code why it wouldn't
> >> work.
> >>
> >> Andrew Denman
> >>
> >>
> >> -----Original Message-----
> >> From: fx.php_list-bounces at mail.iviking.org
> >> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Nick Trenary
> >> Sent: Tuesday, December 11, 2007 9:59 AM
> >> To: FX.php Discussion List
> >> Subject: [FX.php List] $_GET not working in links after upgrade from FM5.5
> >> to 9
> >>
> >> I am working on upgrading from FM5.5 to 9 and I am finding a few quirks
> >> with my existing code.  I have several web pages where a user would see
> >> a list of records, they could click on a link for that record and see
> >> specific information about that record.  After the migration my _$GETs
> >> don't seem to be working.
> >>
> >> In page one which lists the records I create a variable for a ProgramID
> >> field like this:
> >> $recID = strtok($value['ProgramID'][0], '.');
> >>
> >> and then used $recID in my link:
> >> echo "<td class=\"$style2\"><a href=\"moreinfo2.php?id=$recID\">More
> >> info</a></td>\n";
> >>
> >> In my 'More info' page this is my initial code:
> >> $query = new FX ($serverIP, $webCompanionport, $DataType);
> >> $query->SetDBPassword ($dbPassword, $dbUser);
> >> $query->SetDBData ('Events.fp7', 'web');
> >> $query->AddDBParam ('ProgramID', $_GET['id']);
> >> $result = $query->FMFind();
> >>
> >> print_r($result); shows
> >>
> >> Array
> >> (
> >>     [data] => Array
> >>         (
> >>         )
> >>
> >>     [linkNext] =>
> >>     [linkPrevious] =>
> >>     [foundCount] => 0
> >>     [fields] => Array
> >>         (
> >>         )
> >>
> >>     [URL] =>
> >>
> >>
> > http://web:webuser@192.168.10.3:80/fmi/xml/FMPXMLRESULT.xml?-db=Events.fp7&-
> >
> >> lay=web&-max=50&ProgramID=2529&-find
> >>     [query] =>
> >>     [errorCode] => 401
> >>     [valueLists] => Array
> >>         (
> >>         )
> >>
> >> )
> >>
> >> It doesn't appear to be passing the value at all.  This code worked in
> >>
> > 5.5.
> >
> >>
> >>
> >
> >
>
> --
> --
>
> Nick Trenary
> Computer Information Systems Analyst
> Cedar Rapids Public Library
> Office: 319.398.5145 x267
> Cell: 319.310.7699
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>