[FX.php List] Passing Data 101

Sun Jun 12 01:59:27 MDT 2005

Jonathan,

I've sent you a sample db and searchPage off list...

Cheers
Steve 

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jonathan Schwartz
Sent: Sunday, 12 June 2005 9:40 a.m.
To: FX.php Discussion List
Subject: RE: [FX.php List] Passing Data 101

At 5:44 PM +1000 6/11/05, Steve Winter wrote:
>Hey Jonathan,
>
>You didn't seem to get much concrete help to this question on the list, 
>and I've been away so am only reading the last week's worth of 
>posts...did you get your troubles sorted...?
>
>Cheers
>Steve
>

Well...not really. Thanks for asking.

Here is the code for the search_result.php I have so far, with all
extraneous items removed. The preceding page is a simple form with a dozen
fields. Assume for the sake of simplicity that there only the two fields:
first and last. On this search_result page below, there is a link attached
to the "last" header label which is intended to re-present the original
query, but sorted by 'first', on "page search_result_first.php".  That page
is identical, except for the sort field.

I just don't know which statements accomplish capturing the original query
from the form page so that it can be repeated on future pages. 
Here you go... Thanks for your help.

Jonathan

search_result.php........

<html>
<head>

<?php
include_once('FX/FX.php');
include_once('FX/FMErrors.php');
include_once('FX/server_data.php');

$first=$_POST['first'];
$last=$_POST['last'];
$query=$_POST['query'];

$search=new FX($serverIP,$webCompanionPort);
$search->SetDBData('parents.fp5','main');
$search->AddDBParam('first',$first);
$search->AddDBParam('last',$last);
$search->AddDBParam('query',$query);
$search->AddSortParam('last','ascend');
$searchResult=$search->FMFind();

?>
</head>

<body>
show query: <?php echo $searchResult['$query']; ?> <?php
include_once("includes/header.php");
?>

<span class="ver12">Found Count:</span> <?php echo
$searchResult['foundCount']; ?> <br> <br> <table width="100%" border="0">
   <tr class="ver12">
  	 <td></td>
     <td nowrap>Last</td>
      <td nowrap><a href="search_result_first.php?<?php echo $query;
?>">First</a></td>

<?php
foreach($searchResult['data'] as $key=>$searchData){ ?>
   <tr class="ver12">
     <td nowrap><a href="detail.php?recid=<?php
$recordDetails=explode('.',$key); $currentRecord=$recordDetails[0]; echo
$currentRecord;
  ?>"><img src="images/detail.gif" width="47" height="17"
border="0"></a></td>
	<td><?php echo $searchData['last'][0]; ?></td>
     <td nowrap width=""><?php echo $searchData['first'][0]; ?></td>
     </tr>
<?php
}
?>
</table>
</body>
</html>
-- 

Jonathan Schwartz
Schwartz & Company
817 Marin Drive
Mill Valley, CA 94941
Phone: 415-381-1852
jonathan at eschwartz.com - http://www.eschwartz.com

There's *always* a logical answer....most of the time.
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list