[FX.php List] Findall problem

Tue Apr 22 03:24:30 MDT 2008

replace this line: $view->setDBData('NRForum.fp7','Posts') ;
with this: $view->setDBData( 'NRForum.fp7', 'Posts', 'all' ) ;

ggt

2008/4/21, Kathy Mohr <kmohr at ncoesc.org>:
> Hello,
>
>  I am new to the group and have been attempting to learn how to use FX and
>  PHP to connect Filemaker databases to the web.  I've been successful with
>  many trials and errors.  My most recent challenge is setting up a blog
>  site for an area school.  I've tried to get all posts to shows on a page
>  with comments from the portal on a layout.  I'm sending the code to see if
>  anyone can tell me what I am doing wrong that only one record shows. I can
>  change the Findall to Findany and I get one record at a time but can
>  refresh the browser to toggle through all the posts, but I can't get all
>  posts to show up on a page.  Your advice would be greatly appreciated.
>
>  <?php
>
>
>  include_once ('FX/FX.php');
>  include_once ('FX/server_data.php');
>  include_once ('FX/FX_Error.php');
>
>
>  $view=new FX($serverIP,$webCompanionPort,'FMPro7');
>  $view->setDBData('NRForum.fp7','Posts');
>  $view->SetDBPassword('password','webuser');
>  $viewResult=$view->FMFindall();
>  foreach($viewResult['data'] as $key=>$viewData);
>
>  $comments=new FX($serverIP,$webCompanionPort,'FMPro7');
>  $comments->setDBData('NRForum.fp7','Comments');
>  $comments->SetDBPassword('nrforum','webuser');
>  $comments->AddDBParam('postId',$viewData['postId'][0]);
>  $commentsResult=$comments->FMFind();
>
>  ?>
>
>  <html>
>  <head>
>  <title>New Riegel Forum</title>
>  <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
>  "http://www.w3.org/TR/html4/strict.dtd">
>  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
>  <link href="nrforum.css" rel="stylesheet" type="text/css">
>  </head>
>  <body>
>
>  <center>
>  <?php
>  include_once('includes/header.php');
>  ?>
>  <table width="700" border="0" align="center" cellpadding="0">
>   <tr>
>     <td height="18"><div align="right"><font color="#000000" size="2"
>  face="Arial, Helvetica, sans-serif"> <a href="newCommenter.php">Request
>  User Account&nbsp;</a>&nbsp; -&nbsp; <a
>  href="commenterLogin.php?action=logout">Current Users
>  Login</a></font></div></td>
>   </tr>
>  </table>
>  <br>
>  </center>
>  <center>
>  </center>
>  <table width="700" border="0" align="center" cellpadding="0"
>  cellspacing="0">
>   <tr>
>     <td><table width="700" border="0" align="center" cellpadding="0"
>  cellspacing="0">
>   <tr>
>     <td colspan="2" bgcolor="#CCCCCC"><font color="#000000" size="2"
>  face="Verdana, Arial, Helvetica, sans-serif"><?php echo
>  $viewData['title'][0]; ?></font><font color="#000000" size="2"
>  face="Verdana, Arial, Helvetica, sans-serif">&nbsp; </font>- <font
>  color="#000000" size="2" face="Verdana, Arial, Helvetica,
>  sans-serif"><?php echo $viewData['timestamp'][0]; ?> <?php echo
>  $viewData['postId'][0]; ?></font></td>
>   </tr>
>   <tr>
>     <td width="19">&nbsp;</td>
>     <td width="675"><font color="#000000" size="2" face="Verdana, Arial,
>  Helvetica, sans-serif"><?php echo nl2br ($viewData['body'][0]);
>  ?></font></td>
>   </tr>
>  </table>
>  Found Records:<?php echo $commentsResult['foundCount']; ?>
>  <table width="600" border="0" align="center" cellpadding="0"
>  cellspacing="0">
>   <?php foreach($commentsResult['data'] as $key=>$commentsData) { ?>
>   <tr>
>     <td colspan="2" bgcolor="#FFCC34"><font color="#000000" size="2"
>  face="Verdana, Arial, Helvetica, sans-serif"><?php echo
>  $commentsData['timestamp'][0]; ?> <?php echo $commentsData['postId'][0];
>  ?></font></td>
>   </tr>
>   <tr>
>     <td width="33">&nbsp;</td>
>     <td width="567"><font color="#000000" size="2" face="Verdana, Arial,
>  Helvetica, sans-serif"><?php echo $commentsData['comment'][0]; ?>
>       <?php
>   }
>   ?>
>     </font></td>
>   </tr>
>  </table>
>  </td>
>   </tr>
>  </table>
>
>  <br>
>  <center>
>   <br><?php
>  include_once('includes/footer.php');
>  ?>
>  </center>
>  </body>
>  </html>
>
>  Kathleen Mohr
>  Educational Technologist/Professional Development
>  North Central Ohio Educational Service Center
>  Tiffin Center
>  65 St. Francis Avenue
>  Tiffin, Ohio  44883
>  419-447-2929
>  kmohr at ncoesc.org
>
>
>  _______________________________________________
>  FX.php_List mailing list
>  FX.php_List at mail.iviking.org
>  http://www.iviking.org/mailman/listinfo/fx.php_list
>