Jonathan Stark

Why should one use the containerbrige.php / img.php from the API-examples ($fm->getcontainerdata) to show the contents of a container field? I was using

echo "<img src=".$record->getField($fieldName)." />";

and it works and it seems much simpler.

I'm presently using $fm->getcontainerdata to display .pdf files, but it is causing all kind of display problems with acrobat reader 6 and 8 (7 works fine...). I'm not sure if the problem comes from the getcontainerdata method or from a $_GET that is over 45 caracters. As unchecking the "display in browser" option of acrobat doesn't solve anything, I'm trying to create a temp .pdf file on the server and use a Javascript redirection. Is there a way with php to extract the data from a container field into a file, or would I need a script from the database?

I (and my users) like to use the mouse as little as possible and rather use the keyboard for input.

When using a regular FileMaker Pro client in Find mode, pressing the Return key (or Enter on the numeric keypad) will execute the Find with the given find criteria.

Using a Web client however, pressing Return or Enter will insert a newline into the field where the cursor is.
Is there any way to prevent this and make Return/Enter perform the find?
(I have only tried this with IWP)

Thanks,

Daniel SjÃstrand

In FMP, I've created a valuelist ['districts_vlist'] and set up a field ['districts_interested'] to display that valuelist as checkboxes.

I ran the PHP Site Assistant, and it created a series of pages.

While addrecord.php and editrecord.php display the empty checkboxes and value list items correctly, if the user checks 2 or more boxes, only the value checked last in the series is passed back to the database file when submitted.

And browserecord.php is set up to display just the text of only the checked value list items. I want to display the entire series as checkboxes, both checked and unchecked items, in the browse view as well.

In fmview.php, the following code is generated:

function getInputChoices($type, $valuelist, $fieldvalue, $fieldName) {
    $selected = "";
    foreach ($valuelist as $eachvalue) {
        if ($eachvalue == $fieldvalue)
            $selected = " checked";
        else
            $selected = "";

        echo "<input type='$type'name='$fieldName'value='$eachvalue'$selected>$eachvalue";
    }
}

and then the code to display the checkboxes in editrecord.php is:

getInputChoices("checkbox", $layout->getValueList('districts_vlist', $record->getRecordId()), $record->getField('districts_interested', 0) , getFieldFormName('districts_interested', 0, $record));

Can you see what code is missing to permit more than one checkbox to be checked and reported back to the database? And likewise to view more than one checked box in the webpage?

...or...

Based on the article you wrote:

http://filemaker.com/downloads/pdf/pr_php_part2.pdf

I came up with this work-around code and was able to at least get multiply-checked checkboxes to display correctly in browserecord.php [in place of using the getInputChoices function]:

$fieldName = getFieldFormName('districts_interested', 0, $record);
$fieldValue = $record->getField('districts_interested');
$values = $layout->getValueList('districts_vlist');
foreach($values as $value) {
    $checked = (strpos($fieldValue, $value) !== FALSE) ? ' checked="checked"' : '';
    echo "<input type=\"checkbox\" name=\"{$fieldName}[]\" value=\"{$value}\"{$checked} />{$value}<br />\n";
}

...BUT if I try to use that same code in the editrecord.php page as well, it's kicking back these 2 error messages:

Notice: Array to string conversion in .../fmview.php on line 386

Warning: urlencode() expects parameter 1 to be string, array given in .../FileMakerImpl.php on line 327

So how do I now send the data back to FMP via editrecord.php in a format that the PHP Site Assistant generated pages will accept?

Thanks.

jeff rouse

I am using php site assistant. I have a nice site based on a fm db that is basically a to do list. I have a field called done which is selected from a value list: done, in progress, not started, waiting. First of all the neq on the find page does not work if i am trying to see everything not 'done'. I need to use the greater than 'done' to see everything not done. Second, how can i set a default to find records that are not done without using the find page which some people find cumbersome?

switch ($action) {

    case "findnotdone": {

    // clear the recid

       $cgi->clear('recid');

    // create a find not done command

       $findCom = $fm->newFindCommand($layoutName);

       $findCom->addFindCriterion('Status', 'Done');

       $findCom->setLogicalOperator('-neq');

       ExitOnError($findCom);

    }

    case "findall": {

       $cgi->clear('skip');

       $findCom = & $fm->newFindAllCommand($layoutName);

       break;

    }

    case "find": {

    // clear the recid

       $cgi->clear('recid');

    // create a find command

       $findCommand = $fm->newFindCommand($layoutName);

       ExitOnError($findCommand);

    // get the posted record data from the findrecords page

       $findrequestdata = $cgi->get('storedfindrequest');

       if (isset($findrequestdata)) {

           $findCom = prepareFindRequest($findrequestdata, $findCommand, $cgi);

        // set the logical operator

           $logicalOperator = $cgi->get('-lop');

           if (isset($logicalOperator)) {

                   $findCom->setLogicalOperator($logicalOperator);

           }

       } else

           $findCom = $fm->newFindAllCommand($layoutName);

       break;

    }

    default: {

       $findCom = & $fm->newFindAllCommand($layoutName);

       break;

    }

}

<form action="recordlist.php" method="post">

    <input type="hidden" name="action" value="findnotdone" />

    <input type="submit" value="Find Not Done" />

</form>

I have a value list that contains approximately 100 values. The first field is numeric and links to a field in my table. It has no meaing to my users. The second field is descriptive and gives the users information that has meaning to them. Both fields are pulled from a lookup table. I can't figure out how to use getValueList() (assuming that's the method I should be using) to show the second field in my array. I have two pieces of code that generates the number. The first was created by Filemaker when I created my PHP code by using PHP Site Assistant.

<?php
getMenu(
    $layout->getValueList('Projects', $record->getRecordId()),
    $record->getField('Proj_Code_fk', 0),
    'Project',
    getFieldFormName('Proj_Code_fk', 0, $record)
);
?>

Proj_Code_fk is in my primary table and links to Code in my Value List. The code I'm posting below is what I created, but still only shows the first field.

<?php 
$valuesArray = $layout->getValueList('Projects', $record->getRecordId());
foreach($valuesArray as $field_object) {
    $field_names = $field_object->getName();
    print ($field_names);
}
?>

hello,
sorry-i posted to the contact page-please ignore.

You fm to ical is awesome!!!
I am in the process of designing a little database linking fm to ical, using your example.
I would like to include the "attendees" in the export but cannot figure out how to get the field to show up in ical. I tried to modify your applescript with no success. Any help would be greatly appreciated.

tell theEvent

    set start date to theStartDate

    set end date to theEndDate

    set summary to theSummary

    set description to theDescription

    set attendees to theAttendees

end tell

Not sure what I am missing here.

Thanks

Joe

tell theEvent

    set start date to theStartDate

    set end date to theEndDate

    set summary to theSummary

    set description to theDescription

    set attendees to theAttendees

    make new attendee at beginning of attendees with properties {display name:theAttendeeName, email:theAttendeeEmail}

end tell

Just generated a test search site using php site assistant, and the file fmview.php requires a file named "Date.php" that does not exist, anywhere. It's not in the API, and it's not among the new files generated by site assistant. Where is this file to be found? Site does not work without it, even commenting out the require statement doesn't do it. Thanks.

I have created several databases with the PHP FileMaker Site Assistant. When I do a find request and leave my search fields blank, it does a find all search and displays all records. What I want it to do, and what it did in FileMaker 4, was to say no results found. From looking at the code the findrecords.php page is set to just do a find and not find all.

Basically, I created a database and used the PHP site assistant. I have fields "a" and "b". I want people to fill in at least one of those fields to find a record. I removed the "find all" feature from the site as I want people to put a search term. (The people using the database know what to search for).

In Filemaker 4, using the Clairis site assistant to make a site, if I did a search leaving a and b blank I would get no records found. Which is what I want. In 9, leaving "a" and "b" blank and doing a search I get all the records.

An example would be customer number and order number. I want customers to search for their orders and not be able to see everyone else's order.

Thanks!

// get the posted record data from the findrecords page

$findrequestdata = $cgi->get('storedfindrequest');

if (isset($findrequestdata)) {

   $findCom = prepareFindRequest($findrequestdata, $findCommand, $cgi);

    // set the logical operator

   $logicalOperator = $cgi->get('-lop');

   if (isset($logicalOperator)) {

           $findCom->setLogicalOperator($logicalOperator);

   }

} else {

    $findCom = $fm->newFindAllCommand($layoutName);

}

// get the posted record data from the findrecords page

$findrequestdata = $cgi->get('storedfindrequest');

if (isset($findrequestdata)) {

   $findCom = prepareFindRequest($findrequestdata, $findCommand, $cgi);

    // set the logical operator

   $logicalOperator = $cgi->get('-lop');

   if (isset($logicalOperator)) {

           $findCom->setLogicalOperator($logicalOperator);

   }

} else {

    die ('You have to specify some search criteria. Please you your browsers back button to try again.');

}

I recently bought a copy of your book on PHP and FM9. I must said it was very well written. However, there is something that I wanted to know but I could not find it in the book.

My Filemaker database has users access login name and password. Each user is only allow to view certain portion of the database , depending on his or her Access Rights and Privileges. When I publish my database in PHP (Intranet), I want to have the same security access for the users. How do I do that in PHP ?

Thank you very much
Leong (Singapore)

[I posted this to the FileMaker TechTalk list, but got no replies...]

I have an edit page created with the PHP Site Assistant. All of my
FileMaker two field value lists to not work automatically on the web--
they only show the id or code, not the meaningful value text. I have
done some reading and understand I have to manually build the
option/value pairs to generate the list from the related table. It seems
like I have done this part, but do not know how to get the current
record's field value to display, or get the value selected (and
submitted) to be recorded.

In my database, an inventory item's 'Location_bldg_id' is related to
BUILDING via 'BLDG_NO'. In the database, I have created a two field
value list called Buildings which displays/records the
Location_bldg_id/BLDG_NO value, but displays the BLDG_NAME.

On the web I need to display a similar value list of buildings while
recording the BLDG_NO selected as the Location_bldg_id for the edited
record.

From the edit item php page, the original Site Assistant code:

<td class="field_data">
<select name="<?php echo getFieldFormName('Location_bldg_id', 0,
$record);?>">
<option value="">
Location_bldg_id
</option>
<?php getMenu($layout->getValueList('Buildings',
$record->getRecordId()), $record->getField('Location_bldg_id', 0) ,
'Location_bldg_id', getFieldFormName('Location_bldg_id', 0, $record));?>
</select>
</td>

This displays a value list of the BLDG_NOs from the database's Building
value list (001, 002, 003...), with the current field data the selected
item of the list (005).

I know next to nothing about PHP, so I am pretty excited that I've
gotten the list with building numbers and names to draw at all! My
custom value list displays all the buildings with the correct numbers
and names (<option value="001">Eddy Hall</option>...), but I cannot get
the current record's Location_bldg_id to be the selected item in the
value list (<option value="005" selected>Nicholson Hall</option>), nor
get the new selected value recorded when the record is submitted. Here's
my value list:

<td class="field_data">
<?php
$request = $fm->newFindAllCommand('BUILDING');
$result = $request->execute();
$records = $result->getRecords();
$values = '';
foreach ($records as $record){
$values .='<option
value="'.$record->getField('BLDG_NO').'">'.$record->getField('BLDG_NAME').'</option>';}
?>
<select name="Location_bldg_id">
<?php echo $values; ?>
</select>
</td>

Can you tell me what I need to do to modify my new value list to
work properly?

Thanks much,

Elleni

Hey Jonathan-

I've entered example 06 01 (pg 95) from the book and when I run the script I get:

Fatal error: Call to undefined method FileMaker_Error::getRecords() in /Library/WebServer/Documents/testB.php on line 13

Pages generated with the PHPSA all work fine, so I know the server is configured OK. The inlcude is definitely working, and I've tried this page with several different test databases and get the same results with each one. I know you said that your writing was based mostly on the API Beta...is it possible that the code wouldn't work with FMSA9?

NR

<?php

define ( 'FM_HOST', '192.168.1.2' );

define ( 'FM_FILE', 'CompanyDB' );

define ( 'FM_USER', 'esmith' );

define ( 'FM_PASS', 'm4rg0t' );

include ( 'Filemaker.php' );

$fm = new Filemaker (FM_FILE, FM_HOST, FM_USER, FM_PASS);

$request = $fm->newFindAllCommand('Company List');

$result = $request->execute();

$records = $result->getRecords();

$rows='';

foreach ($records as $record) {

    $rows .= '<tr>';

    $rows .= '<td>'.$record->getField('Company').'</td>';

    $rows .= '<td>'.$record->getField('Address').'</td>';

    $rows .= '<td>'.$record->getField('State').'</td>';

    $rows .= '</tr>';

}

?>

<html>

    <head>

        <title>06_01</title>

    </head>

    <body>

        <table border = "1">

            <tr>

                <th> Company </th>

                <th> Address </th>

                <th> State </th>

            </tr>

            <?php echo $rows; ?>

        </table>

    </body>

</html>

if (FileMaker::isError($result)) {

    die('<p>' . $result->getMessage() . ' (error ' . $result->code . ')</p>');

}

Two things:

1. We are going to try to produce a website with FileMaker to accept applications. It will need to be secure and allow individuals to enter data until they are complete and then lock them out.

2. I am using your custom function WordWrap and would like to maintain any existing carriage returns. Sometimes the existing return is required and I would like it to remain.

Can you help?

Thanks, Mike

Hi Jonathan Stark,

is there a possibility to get the result of a FileMaker-Script:

$newPerformScript =& $fm->newPerformScriptCommand('test', 'checkdata', '1234');
$result = $newPerformScript->execute();

The result is returned with the parameter of the FileMaker 'exit spript' command.

Kind regards

Uwe Holzer

Any pointers on how to get iCal data into FMP 9?

Thanks.

I know a similar question was posted (Q6) earlier, but looking for exact detail on how to do...

Many of my filemaker value lists have an id# and a descriptive name. Ex: Firm id is the value from the first field and firm name is the value from the 2nd field.

When Outputting my checkboxes or radio buttons to web with php I want to be able to get the value list items as php array(s), then....:

echo "
<label for = '(1st firm name here)'>
<input type = 'radio' name = 'firmchoices' value = '( 1st firm id# here)'/>(1st firm name here)
</label>"

php script loops thru an array of all the firm id#s and matching firm name pairs in my value list spitting out radio buttons for each firm...
How can I get that to work exactly? Thanks for any help. Much appreciated.

Good Day Sir,

I created a simple Satisfaction Survey and used the PHP Site Assistant to created Add New Record Site.

This worked fine until I moved the site to a new Web Server running the FileMaker Web Publishing Engine connected to a Server running FMSA 9.02. I edited the phpsa file to indicate the new IP address of the Web Server.

When I create a new record everything appears fine including a confirmation message after "Saving Record".

When I login to the database visa the network the new record is not in the database.

I must be missing an edit somewhere and would appreciate your suggestions.

Thanks in Advance

greg

My question is regarding files produced by FM PHP Site Assistant (FMServer 9). If the search field/s in the Search Page (findrecoreds.php) is empty, the program defaults to "Find All" and displays all records in the database. How do I configure the search command so that a blank field is a search criterion?

Thanks,

Yoshi

Dear Jonathan,

everytime I use the newPerformScriptCommand I get a error:

Notice: Only variable references should be returned by reference in C:\Programme\FileMaker\FileMaker Server\Web Publishing\publishing-engine\php\FileMaker\Command.php on line 126

.....
$newPerformScript =& $fm->newPerformScriptCommand('layout', 'script', $parameter);
$result = $newPerformScript->execute();
...

The script works fine

Kind regards

Uwe

UPDATE:

I found a solution in the FM technet.

That seems to be an issue with some depreciated PHP syntax used within the FileMaker internals (with incorrect assignment operators). However to avoid the issue in your case, add the error silencing "@" for the execute operation...

there is just one little problem, thank you very much for your help but i still have a problem please do help me, now my problem is after i click next it will not show records. i change the $max = 1. because i want to display one per page, can u help me to do this... so if there were 10 records the user will click 10 times on the next button. here is my code:


This is the link or the button:
<p class="recordlist_nav" style="text-align: center">
<span class="recordlist_nav_first"><?php echo $statusLinks['first'] ?></span>
<span class="recordlist_nav_prev"><?php echo $statusLinks['prev'] ?></span>
<span class="recordlist_nav_range">Records <?php echo $statusLinks['records']['rangestart'] ?> - <?php echo $statusLinks['records']['rangeend'] ?> of <?php echo $statusLinks['records']['foundcount'] ?></span>
<span class="recordlist_nav_next"><?php echo $statusLinks['next'] ?></span>
<span class="recordlist_nav_last"><?php echo $statusLinks['last'] ?></span>
</p>
Now the functions:

<?php
$juan = isset($_GET['john']) ? $_GET['john'] : '';
$famdat = isset($_GET['fam']) ? $_GET['fam'] : '';
$skp = isset($_GET['skp']) ? $_GET['skp'] : 0;

//$skp = 0;
$resultdat = 0;
$max = 1;
require_once 'classes/FileMaker/FileMaker.php';
$_FMP_CONN = new FileMaker();
$_FMP_CONN->setProperty('database', 'Conch Philcoll V3');
$_FMP_CONN->setProperty('hostspec', 'http://192.168.130.164');
$_FMP_CONN->setProperty('username', 'php');
$_FMP_CONN->setProperty('password', 'php');

$_FMP_FIND = $_FMP_CONN->newFindCommand('WEB');

$fixnum = $juan; //isset($_REQUEST['']) ? $_REQUEST['fam'] : '';


$_FMP_FIND->addFindCriterion('Fix Number', $fixnum);
$_FMP_FIND->addFindCriterion('FAMILY', $famdat);

$lop = isset($_REQUEST['lop']) ? $_REQUEST['lop'] : 'and';


$_FMP_FIND->setLogicalOperator($lop);


$_FMP_FIND->setRange($skp, $max);
$_FMP_FIND->addSortRule('Fix Number', 1, FILEMAKER_SORT_ASCEND);
$_FMP_COUT = clone($_FMP_FIND);

$_FMP_RSLT = $_FMP_FIND->execute();

//GET THE RECORD
$records = $_FMP_RSLT->getRecords();

//var_dump($j);
function generateURLImage($juan) {
return 'http://192.168.130.1/images/PhilippineCollection/web/' . $juan . '.jpg';
}
//for the navigation
function getStatusLinks($ur, $rs, $skp, $max) {
$links = array (
'first' => 'First',
'prev' => 'Prev',
'records' => array (
'rangestart' => 0,
'rangeend' => 0,
'foundcount' => 0
),
'next' => 'Next',
'last' => 'Last'
);
$fetchcount = $rs->getFetchCount();
$foundcount = $rs->getFoundSetCount();
$total = $rs->getTableRecordCount();

if ($total == 0 || $fetchcount == 0) {
return $links;
} else {
if ($fetchcount > 0) {
if ($skp > 0) {
$links['first'] = '<a href="' . $ur. '&amp;skp=0">First</a>';
if ($skp > $max) {
$prevskip = $skp - $max;
$links['prev'] = '<a href="' . $ur. '&amp;skp=' . $prevskip . '">Prev</a>';
}
}
if ($foundcount - $skp > $max) {
$nextskip = $skp + $max;
$links['next'] = '<a href="' . $ur. '&amp;skp=' . $nextskip . '">Next</a>';
$lastskip = $foundcount - $max;
$links['last'] = '<a href="' . $ur. '&amp;skp=' . $lastskip . '">Last</a>';
}
$links['records']['rangestart'] = max($skp, 1);
$links['records']['rangeend'] = min($foundcount + $skp, $fetchcount + $skp);
$links['records']['foundcount'] = $foundcount;
}
}
return $links;
}
//$ur = 'details.php?fam=' . $famdat . '&amp;spc=' . $spcdat . '&amp;qty=' . $qtydat . '';
$ur = 'details.php?fam=' . $famdat . '&amp;spc=' . $spcdat . '&amp;john='.'';
$statusLinks = getStatusLinks($ur, $_FMP_RSLT, $skp, $resultdat);


please i really need your help....

Hello Jonathan,

I gone thru some of your books and purchased one last, and everything seems to be very useful.

I have one question,

How can I check a record is present in filemaker table via php? since in mysql, we can check via select query and I don't how to check the same in filemaker-PHP

Can you please help me ASAP -- my mail is mhari@angleritech.com

Thanks in advance.

I've just started working with the PHP Filemaker API and have a really basic question. The documentation and examples all say that I need to include require_once('filemaker.php') in my php code yet the code that was generated by the php assistant only has require_once('fmview.php').

What am I missing?

Thanks.

Hi Jonathan,

I'm new to PHP for Filemaker 9.0. I used to put javascript to check for missing fields in my forms, but with PHP naming the fields: "<?php echo getFieldFormName('NameFirst', 0, $record);?>" This doesn't seem to work in Javascript anymore.

-Thanks,
Richard

Hello Jonathan,

I really very happy to see your mail and help on sorting out the PHP-filemaker API issues.

I need one guidance from you, I have created a small PHP application based on the book written by you and I found the below error when executing the sample exercise, can you please help me ?

Error:
Call to undefined method FileMaker_Error::getrecords()

Thanks in advance..

Regards,
Hari

Hello,
When I am trying to build a site through the PHP assistant with a file that has password protection, the PHP assistant will not connect to that file. The file does show up in the list after connecting to the webserver but when I subsequently supply the correct accountname and password (they do work with 'open remote'..) the PHP assistent returns the message that my login is invalid. Any idea what might be causing this? Win2003server, FMserver9v2.
Thanks,
Sander

Jonathan,

I have a question I can't find the answer to. I was looking at using your script FMPtoiCAL to be able to add events to my ical but the ical is running on my server in my office on a static ip and tiger server.

I changed this line in your script to read:

tell application "iCal" of machine "my.ip.address.here"

when I first tried to close the applescript window in FMP script editor, the computer sat for a while then can back with an error saying it could not connect.

after some research I opened port 3031 on my server and had better luck. FMP seemed to try and talk with the server. I was asked my name and password and then after a few seconds I get the error "remote access isn't allowed". This is an error in a FMP window.

Do you know if this is saying my FMP can not do the remote acces or is this a message that FMP received from tiger server and is relaying to me?

I have gone to my server and turned on Apple Remote Desktop and Remote Apple Events in my sharing and I tried turning off my fire wall completly with the same error as a result.

any ideas?

thank you so much for your time and your amazing software,

David
www.audioperception.com

I have perhaps the most basic question but I can't seem to find the correct search term to clarify any results as I google it.

I have read the book but perhaps I have passed over the answer or have spent to much time with MySQL.

I built a database of Art that I have built and published using the PHP SA. I defined fields for Artists, Size, Colors, Available, Sold etc.

I have a standard PHP page with the artists names and bios. I would like to create a simple link that goes to recordlist.php and shows all of that particular artists work that is currently available.

Namely can I modify this URL to give me just one artists work that is currently available, having artists and available as two fields in my database.

recordlist.php?-skip=0&-db=SOTA&-max=10&-lay=Form%20View&

Or do I always have to do a form that executes a search or is the url enough of a command for filemaker like on the findrecords.php page.

Thanks,
Matt

Hi,
I have a small site (contacts) generated with php site assistant.
Let's say in the record list page I have the first 25 records of a found set.
I have the option to sort them let's say by Last name by clicking on the underlined column header.
Everything works as expected, but when I click on Next (25 records) the sort order is lost and contacts are again presented in an order that is not by Last name...
What gives?

Meixfy <a href="http://jzycrfhjulvh.com/">jzycrfhjulvh</a>, [url=http://ubigixikztpx.com/]ubigixikztpx[/url], [link=http://qyzgiepbkimt.com/]qyzgiepbkimt[/link], http://auurznusvmog.com/

I love your example of using FileMaker as a content management system for our website. I'm not the greatest at PHP and am getting stuck on how to develop a secondary navigation menu under the main menu. Do you have any other resources on this topic?

Jon

Hi Jonathan,

Iam working in lot of php & filemaker integrated projects now. I have a problem in a client PHP server, and the issue is -- I can able to login to PHP assistant in the client server, but when I am doing step by step to create PHP files -- when I reached the layout group, I could not able to see any tables or layout in the white box under the text layout group..

Can you please help me ?

Hari

A quick question...

Is it possible to check if a field in a filemaker layout is editable in browse mode from PHP?
($field->isAutoEnter() or $field->getType() are not enough)

In other words... if I want to display not editable data in an "edit record" form in my website, do I have to manually define which fields are editable or can I get some info from the layout?

Thanks in advance!

I have just about got my Filemaker PHP site done. All I need to do is add a link that will find all the records where Field "CG ' equals "D". I can see that the PHP publisher by FM, produced this link for find all:

http://192.168.26.13/search/recordlist.php?-db=usna61&-sortorderone=ascend&-max=25&-sortordertwo=ascend&-lay=Web&-action=findall&-sortfieldtwo=First%20Name&-skip=0&-sortfieldone=Last%20Name&

Is there a way to create a similar link that will find all the records where the field "CG" contains "D"? Thanks, for any advise.

I'm trying to use getRepetitionCount() to get me the number of repetitions for a field in my layout but I can't figure out how to get it to work. I need a loop to do stuff with all the repetitions but I can't get the repetition count.

What's the right way to do that?

Thanks

<?php

# For security reasons, these lines should be

# included from a file above the web directory

define('FM_HOST', '127.0.0.1');

define('FM_FILE', 'Product Catalog');

define('FM_USER', 'esmith');

define('FM_PASS', 'm4rg0t');

#

# this is the include for the API for PHP

require_once ('FileMaker.php');

#

# instantiate a new FileMaker object

$fm = new FileMaker(FM_FILE, FM_HOST, FM_USER, FM_PASS);

#

# create a new search transaction

$request = $fm->newFindAllCommand('web_invoice');

#

# execute the search transaction

$result = $request->execute();

#

# check for errors

if (FileMaker::isError($result)) {

    die('<p>' . $result->getMessage() . ' (error ' . $result->code . ')</p>');

}

#

# Get the layout as an object

$layout_object = $result->getLayout();

#

# Get the field as an object

$field_object = $layout_object->getField('items');

#

# Get the max number of repetitions from the field 

#    (NOTE: this is the number of repetitions defined 

#    in the field options dialog for the field - NOT the 

#    number of reps visible on the layout.)

$max_reps = $field_object->getRepetitionCount();

#

# Output to browser

echo 'Items can have a max of '. $max_reps .' repetitions.';

I have a FileMaker Server Advanced Trial version: 9.0.3.325 on a windows 2003 server.

I have found a "bug" in a PHP API, in fact when you do a search, with a php page, some special charaters (like é, ç,...) acts like wildcards.

So FileMaker considers some charaters like : é, ç is equal wildcards * or @.

I have a file and database to explain you the problem with your API PHP. You can try it in attach file.
Try to search
User: ==ééé;
Pass: anything

and it returns all records ....!

Can you help me? Have you a solution?

if ( !ctype_alnum($_POST['USERNAME']) or !ctype_alnum($_POST['PASSWORD'])) {

    die('Only alphnumeric characters are allowed in the username and password fields.');

}

Hello Jonathan,

I am using Filemaker Developer 9.0 with a Windows Vista. I have experienced problems with Windows Vista and suspect this problem might be associated with it.
I designed several runtime applications, most recently using the Filemaker 9.0 Advanced. I use MindVision Installer Vise 3.0 to install my Filemaker Runtime applications on the end user's operating systems.
I tested the program and everything seems to be installed properly and function as usual, except for this dialog; "The account and password you entered cannot be used to access this file. Please try again. filemaker.com/intl.
I designed this application to include a start up script which loads a default password. I enter all of the passwords associated with this runtime application and cannot access it after the install.
I upgraded from Filemaker Pro 7.0 Developer to Filemaker Pro 9.0 Developer several months ago.

Any help would be greatly appreciated.

Steve

I have a PHP form that is loaded on my server and on my clients server. The page works on my server but it does not work on my clients server.

I receive the following error message when trying it on my clients server.

Fatal error: Call to undefined method FileMaker_Error::getFirstRecord() in /Library/WebServer/Documents/Bluewater/browserecords.php on line 117

First of all, just wanted to tell you that your book is great! I wrote my first functional PHP script - and with FileMaker integration - in only one evening!

I have a couple of questions:

1) I'm using FMS9 on both a PowerMac G4 (Tiger) and a Dual-CPU PowerMac G5 (Leopard; with 3GB of RAM). On both machines, "java" and "fmserver" often uses as much as 70% of CPU and at least 1GB of virtual RAM when idle. And over time (~6-8 hours), all physical RAM is used up. These machines are only used for FMS PHP web publishing, serving a ~1.2GB .fp7 file. Is this behaviour normal?

2) I have a HTML/PHP search form which returns some records. If there're lots of records to be returned, how can I limit each page to show only 20 results, with a "Next" link to display the next 20 results?

Thanks!

Im getting an error message:

Fatal error: Call to undefined method FileMaker_Error::getRecords() in /Library/WebServer/Documents/tss/RAR.php on line 19

FOR the following page called RAR.php, based on the example code in Chapter 6 -> Viewing Filemaker Data ->Retrieving All Records on page 95-97 of "Web Publishing with PHP and Filemaker 9" (Jonathan Stark :] )

Before you view the code i realise some tags may be unneccessary ie set property. The main problem is the getRecords() command. yes the connection object ($fm = new Filemaker blah blah) is functional and yes the layout has the fields and so on. everything on the filemaker server is neat and beautiful. Whats going on? Whats worng with my method?


--------------------------------- RAR.php---------------------------------
<?php <-this is line 1 and so on.
define('FM_HOST', '10.15.216.75');
define('FM_FILE', 'StaffD');
define('FM_USER', 'Touch');
define('FM_PASS', 'touch');
#2nd approach (including either C&P method
include ('FileMaker.php');
require_once ('FileMaker.php');
#Create New FILEMAKER connection object for particular user
$fm = new FileMaker (FM_FILE, FM_HOST, FM_USER, FM_PASS);
#different approach to defining FM Layout Object/s
$fm->setProperty('database', 'StaffD');
$fm->setProperty('hostspec', '10.15.216.75');
$fm->setProperty('username', 'Touch');
$fm->setProperty('password', 'touch');
#Creating Method to process object
$findCommand =& $fm->newFindAllCommand('Data');
$result = $findCommand->execute();
$records = $result->getRecords();
#Error Message Compiler
if (FileMaker::isError($result)) {
echo "<p>Error: " . $result->getMessage() . "</p>";
exit;
}
#loop through records compiling row html
$rows = '';
foreach ($records as $record) {
$rows .= '<tr>';
$rows .= '<td>'.$record->getField('Code').'</td>';
$rows .= '<td>'.$record->getField('Name I Surname').'</td>';
$rows .= '</tr>';
}
?>
<html>
<head>
<title>rar</title>
</head>
<body>
<table border="1">
<tr>
<th>Code</th>
<th>Name I Surname</th>
</tr>
<?php echo $rows; ?>
</table>
</body>
</html>



THANKS (not from RAR.php)

I have a php add records form that was generated by the PHP site assistant. There are two instances where the data received from the form is being posted into the wrong filemaker fields. I have checked and double checked the form fields and they are displaying correctly and appear to be coded correctly. Everything works fine but the data shows up in the wrong fields in filemaker.

any ideas?

hi

read your book and it was very helpful.

Question:
i have a form to submit a new record to FM database. everything is workign fine. I am trying to figure out how to show the fields i submit on a response page. Much like a receipt for the submission. how can i post a new record to the database, then be able to show some fileds of that submission on the response page. on ecrucial field is the time stamp of submission. please help thanks
Dave M

I am not much of a computer guy. I have been building a database for my company using filemaker adv 8.5. There is three tables I am dealing with in this problem. Table Types, Machines, and Equipment Rented. The PK in table types is a FK in table Machines. The PK in table Machines is a FK in table Equipment Rented. Using a portal layout for Table Equipment Rented, Equipment Rented::Type is a drop down list that displays all values for Types::Type from which the user can select the appropriate type of machine. Based upon the Type value selected, the next field which is another drop down list displays only the related records from Equipment Rented::ID from which the ID of the machine can be selected. This basically narrows down a few hundred machines to maybe a dozen. Thus each machine has a unique ID number and each machine has a type to describe basically what the machine does. I have been able to get these to fields to work in my layout. The problem is with the last field. It is Machines::Name. The Name column in the Machines table contains the exact name of the machine, which is not unique, but very specific where as the Type is very generic. Once the Type is selected, the Name field reflects the first record in the Machines table. It does not change once the appropriate ID is selected. I need the Name field to reflect the appropriate name for the ID selected. It will do this correctly if I do not use type to filter the records and just enter the machine ID. But I cannot remember hundreds of machine ID's. I can look at a dozen ID's and know which one I want to select.

Any help would be...well helpful.

Thanks for your time.

Charles

Hi Jonathan,

In your fine book you suggest keeping connection info above the web root directory. How do I actually write the path to the private directory?

I'm hosted at fmgateway but their support just said to keep the connection files in the httpdocs directory.

The directory structure looks like this

httpdocs (this is the web root)
httpsdocs
private (this is where I want to put the files)

Thanks

Pete

HI Jonathan,

I have the below interesting question for you,

1. I have a filemaker file in client server with table name "table1"
2. I have few records in that table,

Name No

AA 1
BB 2
CC 3

3. I like to create a page,

3.1 which can receive data from the other page
3.2 Assign that received data to a specific field in the same page
3.3 find that record and show the result in the same page. Please note "in the same page"


For example
-----------

1. I will pass (thru url passing - page1.php?name = 12) the value "12" to the page1.php
2. I will find & show the records using the value that I got from the last page (thru url passing - page1.php?name = 12)

Known Solution
--------------

1. I can able to do this operation with the help of submiting this page to the other one. But I can't able to get the value,find the record & show the result in the same page itself.

This is one of our client urgent requirement.

Could you please help me ?

Thank you.

Regards,
Hari

Hi Jonathan, thanks for all the scrips on your site. I was playing with the FMP to iCal script and it seemed it does not work anymore correct on iCal3. There must have been some changes. Do you know how I can get it to work? It seemed they changed the all day events and other minor things.

Thanks
Thomas Marinello

Dear Jonathan,

Thankyou for the excellent book "Web Publishing with PHP and FileMaker 9". I've read through quite a large portion of your book, your hints/alerts/gotchas are great as I've started understanding some of the code FileMaker server 9 PHP tool generates to build php pages.

I do have a question though regarding Value lists. Is it possible to create dynamic valuelists related to a previous value using arrays?

i.e if I have a form with two value lists, Type and Animal(values displayed depend on whether type has the value land or water).

If the field type has the value "land", then the values displayed in animal should drop down to include, "Lion, Tiger, Cheetah"

Alternatively if type field contains the value "water" I want "Shark, Dolphin, Whale" to be displayed.

My aim is to try and recreate this FileMaker behaviour (I have this form already working in FM using the related feature when generating valuelists) on the web without using the submit button using the valuelist in FileMaker called animal.

Many Thanks

AJ

must be simple, but I feel i'm banging my head against a wall.
How do I get numerical input from text valuelist? ie, valuelist asks London, Paris, Washington but data entry is 1,2, or 3 ?

I have a DB with 27,000 real estate listings. Created with Site assistant and modified a little.

Doing a search provides a number of records in list view (say we find 500).
Clicking next will go to the next set of 10. As it should.
Clicking a link will provide the detail page. As it should.
Clicking back in the browser shows the all 27,000 listings not the second set of 10 as it should. It shows the second set of the 27,000 listings.

Clicking Back botton again sometimes provides the second set of 10 of the original 500. This will also ask you to re-post the data.

Any suggestions?

Also: Periodically the price of the house will show up as zero and some times it will show up correct????? Periodically, not all the time.

Here is the formating for that field. It is the same on the detail page and works all the time????

Code:

<?php echo nl2br ($english_format_number = number_format($record->getField('List Price', 0),0));




Thanks

Site link:
Link to the Site www.MLSMAX.com

I have a filemaker calculation that uses the carriage return character, ¶, to delineate lines. However when I display that field in a web page using php, the carriage return characters are not being interpreted correctly resulting in the fm field contents being displayed on one line. I've tried to use a concatenated text field in the fm calculation where that field contains the typed <return> key. no difference in web page display though. i've looked for control character use within the fm calculation - but no luck their either. i also tried field encoding using Unicode.
any idea how i can get the carriage return character to be interpreted correctly by the web page?
any feedback would be greatly appreciated.
thank you, greg

I have used PHP Site Assistant to create my forms, which works very well. When I have created a set of checkboxes pulling from a value list, the list does not have line breaks after each value. Is it possible to edit the code created by PHP Site Assistant to include the line breaks? The code that the assistant creates is convenient, especially if I have a larger value list. I would prefer this method rather than coding in each value by hand.

<td class="field_data">
<?php getInputChoices("checkbox", $layout->getValueList('New Vendor', $record->getRecordId()), $record->getField('PreviousStatus', 0) , getFieldFormName('PreviousStatus', 0, $record));?>
</td>

How or where would I add my line break to the above auto-generated code?

I am trying to build a very simple entry form using FileMaker and the PHP Site Assistant. On this form I have value list I want to display using radio buttons for choices.

When I preview the web page the value list runs in a row. I would like to display one choice under another choice.

I am editing the page in Dreamweaver CS3. Is there a way to make this work? Can't figure this out.

Hi,

My question relates to the usage og "setLogicalOperator()" in FM9 php API.

According to FileMakers manual p 35, the setLogicalOperator should work with Compound Find. I am unable to get this to work and I can not find any examples that uses this.
I am trying to mimick a FM-client's Find/Constrain function - but as I get an "call to undefined method" when I try to use it.

Could you help me to verify whether the manual is wrong og maybe guide me through another way of simulating a "Constrain" through php?

My original search requires that I search within the same portal for multiple criteria - searching directly within portal's table will unfortunately require a lot of coding, which I would like to avoid.


Kind regards, Rasmus Roland

Hi Jonathan,

I am trying to perform a compound find in php / filemaker to do the following:

find all records where field1 is less than 40
or
where field2 is less than 30
and
where field3 is equal to a specific value.

Here's my code thats not working.
$compoundFind = $fm->newCompoundFindCommand('projects');

$firstFind = $fm->newFindRequest('projects');
$firstFind->addFindCriterion('field1','<40');
$firstFind->addFindCriterion('field2','<30');

$firstFind->setLogicalOperator(FILEMAKER_FIND_OR);

$compoundFind->add(1,$firstFind);

$secondFind = $fm->newFindRequest('projects');
$secondFind->addFindCriterion('field3', $_GET["q"]);

$compoundFind->add(2,$secondFind);



$result = $compoundFind->execute ();


Can you offer any help on how to achieve this?
Many Thanks,

Hello Jonathan,
Container field help:
I've been trying to extract a container field from one of my databases using your examples and information. to help understand the implementation, i setup a single php file in which i've combined the functionality of the two files you use. I get an error when trying to display the image. the data displayed in the browser window is this:

Icon Path URL: %2Ffmi%2Fxml%2Fcnt%2Fdata.jpg%3F-db%3DWEB_Users%26amp%3B-lay%3DWEB1%26amp%3B-recid%3D10%26amp%3B-field%3DacctPicContract%281%29

errMsgImage: Communication Error: (6) Could not resolve host: localhost%2Ffmi%2Fxml%2Fcnt%2Fdata.jpg%3F-db%3DWEB_Users%26amp%3B-lay%3DWEB1%26amp%3B-recid%3D10%26amp%3B-field%3DacctPicContract%281%29; No data record of requested type


my php code is:
<?php
require_once ('FileMaker.php');
$fm = new FileMaker('WEB_Users');
$record=$fm->getRecordByID('WEB1','10');

$IconPathURL=urlencode($record->getField('acctPicContract'));
echo '<b>Icon Path URL:</b>&nbsp;&nbsp;'.$IconPathURL;
echo '<br />';

$IconImg=$fm->getContainerData($IconPathURL);

if (FileMaker::isError($IconImg)) {
echo '<br />errMsgImage:&nbsp;&nbsp;'.$IconImg->getMessage();
die();
}

echo '<img src="'.$IconImg.'" />';
?>

i know i'm communicating with the db because i can get other fields (text type) from it, plus the container field path information is extracted and displayed in the browser. i found another 2 file example of extracting container data by building a href link for which i modified it to point to my database and that technique does extract and display the container image. However i want to use your implementation for my design.

I've been spinning my wheels trying to figure out what my issue is.
Any feedback would be greatly appreciated.

thank you
greg

Hi
I bought your book and im very satisfied with it.
But i missed a section when it comes to databases with more then 100 records.
I have "large" amount of datas that is 20000 records. If i try the following:
...
$record = $fm->newFindCommand('Test');
$record->addFindCriterion ('categorie', '1');
$result = $record->execute();

if (FileMaker::isError($result))
{
dosomethingwitherror()
exit;
}

$records = $result->getRecords();
...

i never get this records (if searchcriterion points to 900 records). if i try the same with searchcriterion points to about 600 records it works fine. the layout contains about 40 fields...
and all 900 found records together are about 800kb. what am i doing wrong or whats the difference between getting/finding 600 or 900 records??

please please help me. thx!!

Hi

I have been playing with the idea of a Filemaker / PHP website to schedule parent-teacher conferences. The parameters are multiple teachers over multiple days with each day containing multiple slots. I am trying to make it flexible enough so that the length of the slots could be determined in the database. Ideally the parent when logging in will see all of the teachers that they can make appointments with and have a box representing each timeslot that they could click to reserve the slot. There is a fair bit of logic to apply, If the block is booked by someone else they can't change it. If the slot has been booked by them they can change it. They can only reserve 1 block per student per teacher and they can not book the same time with more than 1 teacher.

I am not asking how to achieve all of this I just wanted to describe the basic rules. I have already got it so that the parent logs in and the webpage displays the result of a portal that contains the teachers that they need to schedule an appointment with. My difficulty is displaying and allowing entry into the timeslots. Ideally the parent would see all the teachers that they need to schedule an appointment with so they can get an overview of the times available. I would like the portal to have teacher name then slot 1, slot 2, slot 3 etc. The next row would be teacher 2, slot 1, slot 2 etc. The end result would be a grid. While I know I can have a field for each slot in the teacher table I would much rather have a teacher table and then a related table for the teacher time slots. This would be more flexible but getting the portal and subsequent PHP page is where I am struggling. Essentially what I want to do is a portal within a portal. I know this is not possible in FMP but I wondered if there is a way to achieve this using PHP. I tried your JSON demo and it was going in the right direction but it seemed to be more useful for displaying data than entering it.

Sorry to make this question so lengthy but any suggestions ideas that point me in the right direction would be great.

All the best

Danny Dawson

I exactly used the php script form your book "php and Filemaker and I get in my localhost server the following error notice:

Call to undefined method FileMaker_Error::getRecords()

My script is as follows

<?php
define( 'FM_HOST', '127.0.0.1' );
define( 'FM_FILE', 'paracrinedb1' );
define( 'FM_USER', 'admin' );
define( 'FM_PASS', 'Domperidone' );
include ('file:///C|/xampp/htdocs/FileMaker.php');
$fm = new FileMaker(FM_FILE, FM_HOST, FM_USER, FM_PASS);
$request = $fm->newFindAllCommand('Signals');
$result = $request->execute();
$records = $result->getRecords();

$rows = '';
foreach ($records as $record) {
$rows .= '<tr>';
$rows .= '<td>'.$record->getFields('ID') .'</td>';
$rows .= '<td>'.$record->getFields('Name') .'</td>';
$rows .= '</tr>';
}
?>

<table border="1">
<tr>
<th>ID</th>
<th>Name</th>

</tr>
<?php echo $rows;
?>
</table>

8VqhZc <a href="http://ebkfkadkliko.com/">ebkfkadkliko</a>, [url=http://suttuvxiuxih.com/]suttuvxiuxih[/url], [link=http://qbgvtrfiiwzn.com/]qbgvtrfiiwzn[/link], http://towgxcfvounq.com/

PB1PzW [url=http://groups.google.com/group/LeahOwens-qnr/web/download-ringtone-mp3.html]download ringtone mp3[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/free-ringtone-tones.html]free ringtone tones[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/free-ringtones-lg.html]free ringtones lg[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/free-ringtones-nextel.html]free ringtones nextel[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/mp3-ringtone-phone.html]mp3 ringtone phone[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/phone-ringtone-send.html]phone ringtone send[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtone-bluetooth.html]ringtone bluetooth[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtone-mp3-download.html]ringtone mp3 download[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtone-wav.html]ringtone wav[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtones-2.html]ringtones 2[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtones-boost.html]ringtones boost[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtones-converter.html]ringtones converter[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtones-file.html]ringtones file[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtones-for-blackberry.html]ringtones for blackberry[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtones-mac.html]ringtones mac[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtones-maker.html]ringtones maker[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtones-on-iphone.html]ringtones on iphone[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtones-usb.html]ringtones usb[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/ringtones-wallpapers.html]ringtones wallpapers[/url]
[url=http://groups.google.com/group/LeahOwens-qnr/web/send-ringtone-phone.html]send ringtone phone[/url]

Per your answer to Question 2 how are you getting a url with a file type extension in your calling page? (I understand the $_GET global array) I'm getting the following:

<?php
require_once("FileMaker.php");

$fm = new FileMaker('myDB', "http://fmserver.myhost.com","user", "password");

$record = $fm->getRecordById("myLayout", $_GET['RecID']);
echo $record->getField("data") //where data is a container field.

/**Output with inserted pdf:
* /fmi/xml/cnt/data.cnt?-db=myDB&-lay=myLayout&-recid=169&-field=data(1)
*
* with inserted word doc:
* /fmi/xml/cnt/data.cnt?-db=myDB&-lay=myLayout&-recid=167&-field=data(1)
*
* with pasted jpg:
* /fmi/xml/cnt/data.jpg?-db=myDB&-lay=myLayout&-recid=166&-field=data(1)
*/
?>

Interesting enough if you surf to the XML output directly the browser displays the image and prompts you to use the correct helper application for the inserted files.

PHP is 5.2 on Linux FMS is 9.0.3.325 on Windows Server 2003.

thanks,
Norm Fox

Hi Jonathan,

do you know if it is possible to change the port to connect the wpe IIS from FileMaker-PHP API?

The PHP API runs on a external server, FileMaker WPE+Server on an internal server.

Regards

Uwe

Hi Jonathan,

I've been dabbling with FileMakers API for PHP and have built up a small site. I'd like to put my system in production, and on our web server, a Windows 2003 Server with IIS 6 and SSL with 128bit encryption level selected.

Can you tell me if FileMakers standard API for PHP will work with this type of encryption. At present I am trying to get FileMakers sample database to work with PHP (I used the standard PHP install from FileMaker Server 9.v3, PHP 5.2.4), but I keep getting error 22 when I try to view the sample. As soon as I uninstall the certificate, it works. Incidentally when the certificate is installed SSL works perfectly with IWP.

Any help would be very much appreciated.

Many Thanks

Abs

P.S I have uncommented the line
$__FM_CONFIG['curlOptions'] = array(CURLOPT_SSL_VERIFYPEER => false);

in the filmaker-api file.

I crashed a hd and used "data rescue" to get files back but cannot open them. I get "The account and password you entered cannot be used to access this file. Please try again." and I have tried every combo, hd whatever I've got that I can think of. Any ideas on how to open?using fm 8.5 on mac G3 10.3. Thank you. I haver also tried opening using a G4 on 10.4.9.

how to display a particular image in a particular time slot9

I saw a question below about the use of the "neq" operator. First, the PHP site assistant does not, by default, give you a "Not Equals" operator in the rendered html pages. I added the option to one of my fields. However, even though I see the "neq" -> "!=" operator show up in the "addFindCriterion" method of Find.php, the command doesn't work.

Any ideas?

Thanks

Using the Mailto and Open URL commands in version 9, with IWP envoked, you always get a blank browser window that comes up just before the command opens a new e-mail message.

The command I'm using is as such:

Open URL [no dialog ; "mailto:"&Sales Orders::Approved by&"?Subject=An order requires your approval....... "]

What command can I use to close the blank web page that is generated by using this command?

Much obliged for any help you can offer

Jonathan, do you know how to manipulate the operator for a specific field in a Find request? How, for example, do we search for all names beginning with "J" and ending with "K" for a field named "Author Name"?

Hi Jonathan,

I tried your custom function SubtractValues ( list ; list2 ) found at briandunning.com.

It is showing function not found , highlighting SubtractValues. I added that to the function parameters. Then it is highlighting ( after SubtractValues and the dialoude box says " An operator is expected here ".

Thanks.

Sujat

Hi Jonathan,
I have a Filemaker DB table having a field of type 'Container'
I want to upload image directly to that field using Filemaker PHP API.
I don't want to upload an image to hard-disk & entering the URL path to that field.
I'm tired of finding solution for that.

Hi Jonathan,

You ecourage the use of Textmate on a Mac, with your FileMaker snippets. Do you recommend anything for us PC users, where we can use your snippets?

Many Thanks

Jalz

Hello Mr. Stark:

I've been attempting to get the Filemaker API for PHP to work consistently for several months now. I had it accessing a FM 9 database yesterday but when I start up my virtual machine today, I get a message indicating that the browser cannot find the filemaker.php file. No changes were made.

Do you have a definitive source on how to make this work? I've worked through the instructions in your book several times and those have not worked for me.

I've done a manual installation of PHP 5 and the FM API for PHP but the results always come back to the problem where it works for a day and then quits.

Thanks!

Rick Rose

I'm upgrading an old FileMaker 6 CDML web solution to FileMaker Pro 9 and the PHP API with FileMaker Server 9. I've combined all files into one multi table file and used the PHP Site Assistant to generate the basic search pages which is working fine.

The CDML site was setup so that when a new search was performed it would create a new record in a table to track searches and then the user could select articles that they found along the way which would be stored in a shopping cart. At the end of the process they could view selected articles and have them emailed to them.

Is there an equivalent with the FileMaker PHP API to search a table but also create a new record in another table which will store selected articles in a related table? I'm new to PHP and learning all of this as I go - have just also started reading your Web Publishing with PHP and FileMaker 9 which looks helpful but I'm a bit lost at this stage.

Many thanks
Andrew

I have an FMP connection. Using the PHP API, I would like to do the following:

find ALL records that have the Title field containing the word "Gold" AND have the title field Containing the words "Wave 34". i can't seem to get this.

Here is my code (which isn't working):

$findCommand = $fm->newFindCommand('web__ACT_Activity__465');
$findCommand->setLogicalOperator(FILEMAKER_FIND_AND);
$findCommand->addFindCriterion('titleFull__t', "$color");
$findCommand->addFindCriterion('titleFull__t', "$searchWave");
$findCommand->addSortRule('dateStart__d', 1, FILEMAKER_SORT_ASCEND);
$result = $findCommand->execute();


Using this I get 6 records - which corresponds to just using the "WAVE 34" part?

Any help is much appreciated.

Thanks.

Hello,

Im working with Filemaker pro, Filemaker server and web publishing with PHP and the Filemaker API. What I want to do is display Data from portals in seperate tables in my php/html page. Ive got the php script right for the portals to be parsed and its working but when i display my php/html page, records are created where the portal data is supposed to be but no data from the portal is displayed. I checked the source code in my browser for my html/php page and it created 33 empty rows upon execution of the page which is the exact number of records that were supposed to be displayed. The only problem is they were empty rows with no data. I'm thinking it might have to do with the relationships in my filemaker database but i'm not sure. Here is the php/html code of the page:

[code removed]

Im new to PHP, but Im picking up on it very well. I have your book and It has been helping me throught the process of recreating this layout that I am working with. If you need to see a copy of the database i could send that over via e-mail. Thank you for your time and consideration.