[FX.php List] "previous" and "next" links for large array
Alex Gates
alex at gandrpublishing.com
Mon Sep 18 13:03:53 MDT 2006
Hi everyone-
Jonathan has graciously helped me with this question earlier today- and
I appreciate all the help he has given me. I'm still quite confused
here, so I thought I would turn to all of you for help.
I understand this is not so much a specific fx.php question, but (I
could be wrong) I think it involves enough fx that it would just confuse
people on regular php forums.
I have a page that displays a container image, a chunk of css, email,
web address, and some pricing info.
I have some php code that puts my returned records into a table.
Here is a link:
http://www.gandrpub.com/cookbooks_for_sale/cookbooks_for_sale.php
As you can see, if you hold your mouse over the image, a tooltip of a
larger version will pop up.
However, with IE, these tooltips wont pop up until all the images have
loaded. I think there are about 93 of them on this page.
(as a side note, this uses a solution that will automatically place
these cookbooks online once they ship- and it will keep them up for 90
days)
I got to thinking that many people are still using dialup, and having
93+ cookbooks on one page is a little much. In fact, I'd like to
display 9 per page and have "next" and "previous" links.
Does anyone have any thoughts or recommendations on the best way to
break this up?
This is what I am using as my query:
<?php
$lookup=new FX($serverIP,$webCompanionPort,'FMPro7');
$lookup->SetDBData('CookbookSale.fp7','ToWeb', 'all');
$lookup->SetDBPassword('admin','admin');
$lookup->AddDBParam('Status', 'Online');
$lookup->AddSortParam('DateOrderShipped', 'descend');
$lookupResult=$lookup->FMFind();
$foundResult=$lookupResult['foundCount'];
//echo $foundResult;
//echo '<br>';
//echo $lookupResult['errorCode'];
?>
And this is how I am displaying it in the table:
<?php
$http = "http://";
$i = 0;
foreach( $lookupResult['data'] as $key => $searchData ){
$booktitle = $searchData['returnreplacesettitle'][0];
$fixedtitle = str_replace("'", "\'", $booktitle);
?>
<?php
if ($i == 0) {
print "<tr>\n";
}
?>
<td width="574" height="186" valign="top" class="phpcontent">
<center><img src="FX/image_proxy.php?FXimage=<?php echo
vignereEncryptURL($searchData['Cover'][0]); ?>" height="160" border="1"
onMouseOver="this.T_DELAY=300;this.T_WIDTH=200;this.T_LEFT
=true;this.T_TITLE='<?php echo
$fixedtitle;?>';this.T_BORDERCOLOR='#6a7d40';return escape('<img
src=\'FX/image_proxy.php?FXimage=<?php echo
vignereEncryptURL($searchData['Cover'][0]); ?>\'
height=\'350\'>')"/></center>
<?php
echo '<br><center>' . $searchData['CSSWebViewforCSS'][0] .
'</center>';
if($searchData['setEmail'][0] != "")
{ echo '<br><center>' .'Email: <br> <a href=mailto:' .
$searchData['setEmail'][0] . '>' . $searchData['setEmail'][0] .
'</a></center>'; }
if($searchData['setWebAddress'][0] != "")
{ echo '<br><center>' .'Web: <a href=' . $http .
$searchData['setWebAddress'][0] . '>' . $searchData['setWebAddress'][0]
. '</a></center>'; }
if($searchData['PriceInfo'][0] != "")
{ echo '<br><center>' . $searchData['PriceInfo'][0] .
'</center>';}
?><br></td>
<?php
$i = ($i + 1) % 3;
if ($i == 0) {
print "</tr>\n";
}
?>
<?php
}
?>
I've spent some time searching and reading about arrays, but I'm not
even to the point where I even have an idea of how to start.
Please- can anyone provide some insight?
Thanks-
Alex P. Gates
More information about the FX.php_List
mailing list