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

[Andrew Denman]

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?
-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.  
-Is the field 'ProgramID' the same case as it is defined in FileMaker?
-Are you looking at the correct layout for the records you want to find?

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