[FX.php List] Findall problem

Gjermund Gusland Thorsen ggt667 at gmail.com
Tue Apr 22 03:25:55 MDT 2008


And I believe you miss a foreach() in there...

2008/4/22, Gjermund Gusland Thorsen <ggt667 at gmail.com>:
> 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
>  >
>


More information about the FX.php_List mailing list