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

[Nick Trenary]

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