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

[Nick Trenary]

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