Which part isn't true?
1. I created a new php page in Dreamweaver CS5.5
2. I created two new recordsets
a. Here is the code:
<?php require_once('Connections/Rani.php'); ?>
<?php
$Section_find = $Rani->newFindCommand('CATEGORY');
$Section_findCriterions = array('cat_ID'=>'*',);
foreach($Section_findCriterions as $key=>$value) {
$Section_find->AddFindCriterion($key,$value);
}
$Item_find = $Rani->newFindCommand('ITEM');
$Item_findCriterions = array('cat_ID'=>'=='.fmsEscape($_REQUEST['cat_ID']),);
foreach($Item_findCriterions as $key=>$value) {
$Item_find->AddFindCriterion($key,$value);
}
fmsSetPage($found_records_find,'found_records',10);
fmsSetPage($Section_find,'Section',10);
fmsSetPage($Item_find,'Item',10);
fmsSetPage($Sections_find,'Sections',10);
$Item_result = $Item_find->execute();
$Section_result = $Section_find->execute();
if(FileMaker::isError($found_records_result)) fmsTrapError($found_records_result,"error.php");
if(FileMaker::isError($Section_result)) fmsTrapError($Section_result,"error.php");
if(FileMaker::isError($Item_result)) fmsTrapError($Item_result,"error.php");
if(FileMaker::isError($Sections_result)) fmsTrapError($Sections_result,"error.php");
fmsSetLastPage($found_records_result,'found_records',10);
fmsSetLastPage($Section_result,'Section',10);
fmsSetLastPage($Item_result,'Item',10);
fmsSetLastPage($Sections_result,'Sections',10);
$Item_row = current($Item_result->getRecords());
$Section_row = current($Section_result->getRecords());
$found_records_row = current($found_records_result->getRecords());
// FMStudio Pro - do not remove comment, needed for DreamWeaver support ?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>
<body>
<table name="Menu_table" style="background-color: #000000; " cellspacing="1" width="400">
<tr bgcolor="#EEEEEE">
<th>Section</th>
</tr>
<?php foreach($Section_result->getRecords() as $Section_row){ ?>
<tr bgcolor="#FFFFFF">
<td><?php echo $Section_row->getField('name'); ?></td>
</tr>
<?php } ?>
</table>
</body>
</html>
3. I uploaded the file and tried to preview.
a. Here is the error message:
Parse error: syntax error, unexpected T_VARIABLE in /home8/thrpsdes/public_html/rani2011/Testing.php on line 1
4. I went to the remote server and downloaded the page.
a. here is the code:
<?php require_once('Connections/Rani.php'); ?><?php$Section_find = $Rani->newFindCommand('CATEGORY');$Section_findCriterions = array('cat_ID'=>'*',);foreach($Section_findCriterions as $key=>$value) { $Section_find->AddFindCriterion($key,$value);}$Item_find = $Rani->newFindCommand('ITEM');$Item_findCriterions = array('cat_ID'=>'=='.fmsEscape($_REQUEST['cat_ID']),);foreach($Item_findCriterions as $key=>$value) { $Item_find->AddFindCriterion($key,$value);}fmsSetPage($found_records_find,'found_records',10); fmsSetPage($Section_find,'Section',10); fmsSetPage($Item_find,'Item',10); fmsSetPage($Sections_find,'Sections',10); $Item_result = $Item_find->execute(); $Section_result = $Section_find->execute(); if(FileMaker::isError($found_records_result)) fmsTrapError($found_records_result,"error.php"); if(FileMaker::isError($Section_result)) fmsTrapError($Section_result,"error.php"); if(FileMaker::isError($Item_result)) fmsTrapError($Item_result,"error.php"); if(FileMaker::isError($Sections_result)) fmsTrapError($Sections_result,"error.php"); fmsSetLastPage($found_records_result,'found_records',10); fmsSetLastPage($Section_result,'Section',10); fmsSetLastPage($Item_result,'Item',10); fmsSetLastPage($Sections_result,'Sections',10); $Item_row = current($Item_result->getRecords()); $Section_row = current($Section_result->getRecords()); $found_records_row = current($found_records_result->getRecords()); // FMStudio Pro - do not remove comment, needed for DreamWeaver support ?><!DOCTYPE HTML><html><head><meta charset="UTF-8"><title>Untitled Document</title></head><body><table name="Menu_table" style="background-color: #000000; " cellspacing="1" width="400"> <tr bgcolor="#EEEEEE"> <th>Section</th> </tr> <?php foreach($Section_result->getRecords() as $Section_row){ ?> <tr bgcolor="#FFFFFF"> <td><?php echo $Section_row->getField('name'); ?></td> </tr> <?php } ?></table></body></html>
So what isn't true?
John Vellela
3rd Planet Studio
358 Chestnut Hill Ave
Suite 204b
Brighton, MA 02135
617.739.2306 fax: 617.566.3141
www.3rdplanetstudio.com
18
Replies
AdChoices