Jump to content

Search the Community

Showing results for tags 'php'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
  • FileMaker Platform
    • FileMaker Pro Advanced 17
    • FileMaker Pro 16
    • Command Line Data Migration Tool
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • Legacy FileMaker Platform Discussions
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 75 results

  1. Hello, I am trying to convert a custom web publishing site in php, from FM Server 12 to FM Server 15. We've updated the Windows machine that hosts it (to a shared server on the recommendation of IT) and installed FM Server 15. Direct opening of the existing scripts always yields 0 results, though the database hasn't changed. Is there some setting, somewhere, that I am oblivious to? I've consulted user's manuals, IIS settings, web postings, ... Attached is a copy of the website I am running. I can point you to the existing website, though I doubt it would be useful. The beginning part of this website are script tracking errors. I've been inserting them, trying to track down where this error is creeping up. So please ignore. Please ask any additional questions, I am sure there are many. Cheers, Tony PublicPortal.zip
  2. jstewart30

    PHP getting blank page

    Running FMS 13 and trying to run a simple PHP page from my website to access a database, but I'm only getting a blank page. Not sure if it's a port forwarding issue or a PHP issue, or something else. If I put my .php file and the includes ("FileMaker.php" file and "FileMaker" folder from the FMS PHP .zip file) in the fmi-test folder on my FM server and access it locally (http://localhost/fmi-test/myphpfile.php), the PHP file works fine and returns data, so I don't think it has any inherent issues, and presumably my FMS is set up correctly. Putting the same .php file and includes on my web server, though, results in a blank page only. The includes are in the same directory as the php file itself. Here's the php file (I've changed the IP address and database names to protect the innocent but they're correct): <?php error_reporting(E_ALL); ini_set('display_errors', 1); include_once('FileMaker.php'); /* have also used require, include, and require_once with no change */ $fm = new FileMaker("MyDatabase", "http://myfilemakerserver:8888", "Admin", ""); /*no password*/ $findCommand = $fm->newFindCommand("MyDatabase"); $findCommand->addFindCriterion("Phone", "303-555-1234"); $findCommand->setRange(0, 1); $result = $findCommand->execute(); if (FileMaker::isError($result)) { echo($result->getMessage()); return; } $record = $result->getFirstRecord(); $name = $record->getField("Customer Name"); $status = $record->getField("Status"); echo("$name - $status"); ?> Infuriatingly I get no errors or feedback, just a blank page when I run this file from my website (but again it works fine locally on the FM server machine). I've confirmed PHP is working on my website as I can do a simple phpinfo() file in the same directory and it runs fine and displays the PHP info. If I direct a web browser to the same "http://myfilemakerserver:8888" (not the real address obviously, but it is port 8888) I get the "Filemaker Database Server Website" page, so the port forwarding seems to be correct. I have port 8888 forwarding to port 80 of my FM Server. I don't have port 443 forwarded to that machine as that's being used for another device on our network, but I assume if I'm not making "https" requests that it should work fine (but maybe that's my problem?). I assume it's just something simple but I've been beating my head against a wall for the better part of the day on this. Any help would be greatly appreciated.
  3. Hi, As we know that we have option to configure FileMaker Server with PHP (which is installed on IIS).. Like the way.. I have another question.. Do we able to configure FileMaker server with PHP Which is installed on Apache (with Linux machine).. Please clarify.. If you already experienced please help us to configure Filemaker 12 server with Apache.. Many Thanks ~Guru
  4. Kara Amsinger

    EMAILING BLANK FORMS

    I have setup through the PHP site assistant to be able to fill out a questionnaire online and the info submitted is entered into a new record, then the same info is emailed to me. About a month ago this process was working perfectly and now I was going back in to finish one last thing and come to realize that when I hit submit it sends me blank emails. But when I go into my database the information is there in it's own record. And when I run the SMTP Email Script from within the database it will then email me the all the information in the record. I have created new forms, pasted in old code that were back when it was working and nothing seems to get it back to the point where it emails me the sumbitted info. Any ideas of where I can start looking to fix the problem? I have several files of php code for this setup that I can attach if needed. Just didn't want to clutter the post with a bunch of code.
  5. I have a php script that takes two PDF files and merges them into one file. I am using this in conjunction with the insert from URL script step. The way the script works is it takes two PDFs in container fields and base64encode each files. Then, those two base 64 strings are POSTed via insert from URL. I've tested the script forwards and backwards and it does combine the PDF files reliably. The issue is when posting from FileMaker. What typically happens is the first page is combined twice and that's my resultant PDF. My php script checks that both inputs are different and throws an error is they are identical. I don't get any errors there. Is there a way to POST a file from insert from URL?
  6. Hi, I'm trying to install in a drupal site the connection with Filemaker. I am developing the drupal site in my machine using MAMPRO as a web server and I have my database file hosted in a shared Filemaker server. After installing in Drupal, the Filemaker modules, and the FX folder with FX.php in the libraries folder, whenever I try to use the filemaker module I get the following notice "Can not find FX.php. Please place FX.php at sites/all/libraries/fxphp/FX." I'm sure that I've installed in that location the FX folder. So I am lost. I'd appreciate any help, thks. Armando
  7. Hi there,  I am having the problems in accessing the data stored in container fields using  php. The containers are not remotely stored. A screenshot is attached showing the database settings for container field. I am able to access data stored in other fields from a remote computer using php api. But when I try to access the container fields... For: $image=$record->getField('container field');     $attach=$fm->getContainerData(urlencode($image));     if (FileMaker::isError($attach)) {       echo "Error: " . $attach->getMessage() . "n";     }  I get:: Error: getContainerData() does not support remote containers  For: echo $fm->getContainerDataURL(urlencode($record->getField('containerfield')));  I get a url in response simlilar to :: http://HOSTIP/fmi/xml/cnt/Untitled.jpg?-db=DATABASENAME&-lay=LAYOUTNAME&-recid=253&-field=containerfield  When try to open the url in a browser I get a  xml in return that has ::   <error code="959"/>   My server has php and xml access enabled for the privilege set I am using.  Thanks in advance   Â
  8. AngeloCit

    keep format input

    hi, i have a INPUT that has special format FILEMAKER 13 as might make PHP take the same format? and that save register from PHP also in FileMaker the same format display? Thanks...
  9. I am attempting to use Filemaker as an ODBC datasource in place of MySQL. I am currently running PHP 5.5.3 and am attempting to create a PDO that will utilize the Filemaker ODBC connection. However, I am unable to successfully connect to the database as I am getting an error that says "Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in /Applications/MAMP/htdocs/OMIS/core/init.php:6 Stack trace: #0 /Applications/MAMP/htdocs/OMIS/core/init.php(6): PDO->__construct('odbcriver={Fi...', 'odbc', 'odbc') #1 {main} thrown in/Applications/MAMP/htdocs/OMIS/core/init.php on line 6" I know that the both the Filemaker ODBC Driver and the DSN for the database exist but I'm still getting the error. The code I'm using to temporarily test the connection is: PHP Code: $dsn = 'odbc:Driver={FileMaker ODBC};Server=localhost;Database=cwp_data;'; $pdo = new PDO($dsn, "odbc", "odbc"); I do have some questions. First, does the 'Server' param need to be where the DSN is configured (localhost in this case) or where the database is hosted (external server). Second, is the PDO being handled correctly here? I am unable to find any resources on using a Filemaker database with the PDO class, so I'm sort of winging it here. I'm still researching the topic so it's entirely possible that I've missed something.
  10. Total newbie questions about a simple PHP search using addFindCriterion to match checkbox value. I have 3 checkboxes in a field called "myChoices_field" containing the following choices - where "airport" is selected. [ ] air [x] airport [ ] air vent So that means that "myChoices_fld" contains only the value "airport". If I do a search via PHP looking for a record that matches only the choice "air" - this is what I would use: $findCommand->addFindCriterion('myChoices_field', "air"); I should expect it NOT to match anything since "air" does not equal to "airport". However - I'm getting back the record that matches "airport". Clearly - it's just doing a substring match. How can I search a checked value that actually just searches the whole checked value - not do a substring search? I'm I completely missing where to find this in the documentation? Pointing me to the documentation would help greatly. Thanks!
  11. My question may be as simple as how do I enter a date in DD/MM/YYYY format using a radio button? (If you can answer that, ignore the rest). I have a simple form for online Timesheets that we have been using for years (thousands have been entered without almost no work on my part since I set it up). Now we want to change the date format from MM/DD/YYYY to DD/YY/YYYY. Everything works except where I auto-enter the "Period Ending" Date. An assistant updates the global value for the "Period Ending" Date in FileMaker every two weeks- this date needs to be auto-entered in new Timesheets (but must be modifiable by workers). Since addrecord.php is creating a new record I use a valuelist that finds that date [a related, global value] in a global table that consists of one record with various global values for the Timesheets table. <?php $fieldValue = "test " . $record->getField('Period Ending', 0) ; ?> <?php getInputChoices("radiobutton", $layout->getValueListTwoFields('Timesheet Period Ending Date', (isset($master_record)) ? $master_record->getRecordId() : $record->getRecordId()), $fieldValue, getFieldFormName('Period Ending', 0, $record, true, 'RADIOBUTTONS', 'text'), 'text', $submitDateOrder);?> is the ending date for the Current Pay Period.this appears as 2-Week Period Ending (MM/DD/YYYY): [Entry field with 07/04/2015 autoentered]07/04/2015 is the ending date for the Current Pay Period.And really works well (don't ask me about 'test ', it is ignored). To change the date format I tried doing a calculation [Day ( timesheets Period Ending global ) & "/" & Month ( timesheets Period Ending global ) & "/" & Year ( timesheets Period Ending global )] to change the order but it submits it in the MM/DD/YYYY format (other date fields ARE dealt with properly!!!). <?php $fieldValue = $record->getField('Period Ending', 0) ; ?> <?php getInputChoices("radiobutton", $layout->getValueListTwoFields('Timesheet Period Ending Date calc', (isset($master_record)) ? $master_record->getRecordId() : $record->getRecordId()), $fieldValue, getFieldFormName('Period Ending', 0, $record, true, 'RADIOBUTTONS', 'text'), 'text', $submitDateOrder);?> is the ending date for the Current Pay Period.2-Week Period Ending (DD/MM/YYYY): [Entry field with 04/07/2015 autoentered]04/07/2015 is the ending date for the Current Pay Period.This is entered as April, while in the other date fields in the same form 04/07/2015 is entered as July. I am doing this with Filemaker Server 11, using PHP/Apache on a mac mini client.
  12. I'm having great success with the PHP site assistant aside from one major issue. I'm not able to display images stored in Supercontainer. The code below will return a broken link. If I take the reference link and paste it into any web browser on any computer on any network, the link works fine. What obvious step am I missing? <td rowspan="8" class="field_data"> <?php echo "<img src='http://74.119.147.179:80/SuperContainer/Files/CKD_Files/PDT/2009/1035/90101463440377643/IMG_6944.jpg' title='Error' alt='Error' />";?> </td>
  13. Hi all, I'm new here so I hope I get everything right. I've done a search already, but I can not find my issue listed. Sorry if it's been covered before. OK, here goes..... VMWare Server running on HP Prolient G7 tin 2 Virtual Cores 4Gb RAM Windows Server 2012 R2 DataCenter x64 IIS v8.5 (Default for 2012 R2) FileMaker Server 12 FileMaker Pro 12 Advanced with Bonjour JRE v7 This is a brand new build specificity for this use. I've installed FileMaker Server 12 on to the above setup with Custom Web Publishing using PHP I followed the deployment wizard and deployed for a single machine setup. I allowed FMS to install the provided version of PHP with it's own configuration. There is NO SSL configuration on the server at present. The admin console shows three green ticks to indicate that everything is happy. However, when I run the PHP Custom Web Publishing Test, I get the page displayed correctly, (PHP is working) and it identifies the name of the server, but below the main information box, I get the following error message: The PHP connection to the FMServer_Sample database failed. The PHP test was not able to communicate with the Web Publishing Engine. Make sure you have PHP publishing enabled and the database has the fmphp extended privilege enabled. (Error 22; Unknown error) The sample database is installed and it is listed in the admin console, status, normal and dots across the line. I can't imagine that it wasn't installed with the correct Extended Privileges for CWP and I would not be 100% confident to know what I should check for. I am viewing the CWP Test webpage on both the server and a client and getting the same error message. Can anyone suggest any further areas that I should be looking at? Cheers in advance, Barry.
  14. (Long story short.) I'm moving a complex solution from a local network to a hosted service. The solution uses (and needs to use) external authentication. In order to divorce the solution from the local network completely, we will no longer be using our active directory on the local network. Setting up security groups and users on the hosted server and configuring FM server to authenticate against it was very easy. Only one problem remains, How can users change their passwords? This isn't really a Filemaker question as the question becomes, how can you let a user change their password on windows servers if they do not have desktop access(on the server)? I have done a couple of google searches and found enough to know I could write some sort of custom solution (or likely adapt one that is already out there) but before going down that rabbit hole.... I thought I would ask the helpful people here.
  15. Hi, we are using a little sync script via php, which allows us to store all data from a FileMaker DB into our internal MySQL-Database. The only problem iam unable to solve is how to download images from container fields and store them local on our web server. I tried something like: foreach($recordsPersons as $recordPersonsData) { //saving images to /srv/www/htdocs/ $url_orig = urlencode($recordPersonsData->getField('FotoDatei')); // Search for the extension of the file $url = substr($url_orig, 0, strpos($url_orig, "?")); $url = substr($url_orig, strrpos($url_orig, ".") + 1); // Send the correct Content-Type header if($url == "jpg"){ header('Content-type: image/jpeg'); } else if($url == "gif"){ header('Content-type: image/gif'); } else{ header('Content-type: application/octet-stream'); } // save file local. file_put_contents('/srv/www/htdocs/testfilepicture.jpg', $fm->getContainerData($url_orig)); } I was using this reference: http://blog.myfmbutler.com/?p=104 This Code-Snipped works well, but only writes "getContainerData() does not support remote containers" into testfilepicture.jpg.. We are using FileMaker Server 14. Any Ideas? Thanks in advance and Cheers
  16. dpistolenma

    mac PHP API Slowness

    Hey there, I'm currently building a web interface that interacts with our filemaker solution (FM Server 13) and have run into some performance issues. We have a table which has 161,000 records, and I am exposing 6 of its fields via a layout. When I run a filemaker find command via the API, looking for specific values in 3 of these fields, it takes extremely long for the results to be returned (up to a minute sometimes). The result is usually 1 or 2 records. For what its worth, I have another table with 73,000 records that does not have performance issues. I've tried to use xdebug to profile my PHP code, and the majority of the response time is this one findCommand and curl_exec, so I don't think the slowness is on the webserver. I've also looked at the statistics page on the server and when the call is made there are tens of thousands of "remote calls" for the client used by the PHP API, not sure if this is normal or not. I thought about maybe increasing the PHP memory limit on the server, but not sure which php.ini is used by FileMaker Web Services. We're running OSX mavericks and I changed the value in a php.ini file that I found in "FileMaker Server/Web Publishing/publishing-engine/php/mavericks/lib/" from 128M to 1024MB but did not see any performance increase (though I am not sure that the change took effect, nor that that is right PHP ini file). Anyone have any other ideas? The server that it is running on has 64GB of RAM, and finds are quick when using a filemaker software client.
  17. I have this same solution I'm installing to 3 separate FM servers, but on one of them I can't get passed this Communication Error 22 for some reason. The error says it's the username or password, but it is imply not. I am using as basic as it gets with a username of "php" and a password of "1111". I also tried my regular admin account, but I get the same problem. I do have the FMPHP privilege set for both of these accounts... The server is on Windows with a fresh update of Java and then a fresh install of FMS14. Deployment seems to go smoothly, and everything shows nice green lights. The CWP test page loads just fine, too, which you can see in these images... I have also forwarded all of the ports that should be open for this machine. I am able to use Open Remote and open files from this server within FM Pro, but for some reason I cannot get the PHP API connection to work on this server. Again, I have the same thing setup on multiple servers. Here is a working example that spits out the available data sources. Here is the exact same test script that is hitting my other FileMaker server at a different location, but it's returning the error. I can't think of what else to look at. Any information on how I can get this working would be greatly appreciated. Thanks!
  18. Hi, I am relatively new to FileMaker. I am a PHP developer currently working on a project that involves the FMS custom web publishing PHP API. I was able to successfully connect using the API, but the connection is no longer working. The error message says only "Unable to open file". My research says that this could be due to the database file not being open, or to a permissions issue. I can see in the FMS admin console that the database file is open, with "normal" status. The FMWEBDIRECT and PHP columns both have full circles, indicating that the database should be accessible through the PHP API. Both the web server and the web publishing engine are on, with green checks, and PHP is activated. I am using the same username and password that worked previously. I checked again in the database security settings and confirmed that the username and password are still correct and that the user account has the "fmphp" privelege. What else should I look for? In the web publishing error log I see entries that say: 127.0.0.1:63876 [USERNAME] - 802 563 "fmi/sml/fmresultset.xml?-db=[DB]&-lay=[LAYOUT]&-findany" Does the PHP API use the XML API? Also, here is the full var_dump() of the error object: object(FileMaker_Error)#6 (9) { ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["error_message_prefix"]=> string(0) "" ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> string(3) "802" ["message"]=> NULL ["userinfo"]=> NULL ["backtrace"]=> array(7) { [0]=> array(6) { ["file"]=> string(90) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/PEAR.php" ["line"]=> int(945) ["function"]=> string(11) "__construct" ["class"]=> string(10) "PEAR_Error" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> NULL [1]=> string(3) "802" [2]=> NULL [3]=> NULL [4]=> NULL } } [1]=> array(7) { ["file"]=> string(101) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Error.php" ["line"]=> int(52) ["function"]=> string(10) "PEAR_Error" ["class"]=> string(10) "PEAR_Error" ["object"]=> *RECURSION* ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> NULL [1]=> string(3) "802" } } [2]=> array(7) { ["file"]=> string(129) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/Parser/FMResultSet.php" ["line"]=> int(48) ["function"]=> string(15) "FileMaker_Error" ["class"]=> string(15) "FileMaker_Error" ["object"]=> *RECURSION* ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } [1]=> NULL [2]=> string(3) "802" } } [3]=> array(7) { ["file"]=> string(122) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/CommandImpl.php" ["line"]=> int(84) ["function"]=> string(5) "parse" ["class"]=> string(28) "FileMaker_Parser_FMResultSet" ["object"]=> object(FileMaker_Parser_FMResultSet)#5 (17) { ["Vcb5e100e"]=> string(3) "802" ["Vf5bf48aa"]=> array(3) { ["build"]=> string(10) "10/27/2016" ["name"]=> string(31) "FileMaker Web Publishing Engine" ["version"]=> string(10) "15.0.3.308" } ["V1ea7e575"]=> array(7) { ["database"]=> string(0) "" ["date-format"]=> string(0) "" ["layout"]=> string(0) "" ["table"]=> string(0) "" ["time-format"]=> string(0) "" ["timestamp-format"]=> string(0) "" ["total-count"]=> string(1) "0" } ["V9f81f3c0"]=> array(0) { } ["Vaae0d98d"]=> array(2) { ["count"]=> string(1) "0" ["fetch-size"]=> string(1) "0" } ["Vae581270"]=> array(0) { } ["V6e52c40b"]=> array(0) { } ["Ve13f1c92"]=> NULL ["V43432a31"]=> NULL ["V51bc3e3b"]=> NULL ["V26005321"]=> NULL ["V6468d939"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["V5431b8d4"]=> resource(28) of type (Unknown) ["V6de51026"]=> bool(false) ["_result"]=> NULL ["_layout"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(563) "" } } [4]=> array(7) { ["file"]=> string(130) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/Command/FindAnyImpl.php" ["line"]=> int(17) ["function"]=> string(10) "_getResult" ["class"]=> string(32) "FileMaker_Command_Implementation" ["object"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(563) "" } } [5]=> array(7) { ["file"]=> string(103) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Command.php" ["line"]=> int(137) ["function"]=> string(7) "execute" ["class"]=> string(40) "FileMaker_Command_FindAny_Implementation" ["object"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [6]=> array(7) { ["file"]=> string(64) "/Library/FileMaker Server/HTTPServer/htdocs/newsletter/index.php" ["line"]=> int(32) ["function"]=> string(7) "execute" ["class"]=> string(17) "FileMaker_Command" ["object"]=> object(FileMaker_Command_FindAny)#3 (1) { ["_impl"]=> object(FileMaker_Command_FindAny_Implementation)#4 (19) { ["_findCriteria"]=> array(0) { } ["Vd65662c5"]=> array(0) { } ["Va9136a07"]=> array(0) { } ["Vf951bdce"]=> NULL ["V83f28691"]=> NULL ["V85fd701e"]=> NULL ["V6da136ea"]=> NULL ["V568aa2ec"]=> NULL ["_fm"]=> &object(FileMaker_Implementation)#2 (3) { ["V73ee434e"]=> array(9) { ["charset"]=> string(5) "UTF-8" ["locale"]=> string(2) "en" ["logLevel"]=> int(3) ["hostspec"]=> string(16) "http://127.0.0.1" ["recordClass"]=> string(16) "FileMaker_Record" ["prevalidate"]=> bool(false) ["database"]=> string(11) "DD_Personal" ["username"]=> string(14) "xxxx" ["password"]=> string(12) "xxxx" } ["Vea4b3413"]=> NULL ["V9a3dcbce"]=> NULL } ["_layout"]=> string(23) "BW Newsletter2Go Import" ["V7a2db0ea"]=> NULL ["_script"]=> NULL ["_scriptParams"]=> NULL ["_preReqScript"]=> NULL ["_preReqScriptParams"]=> NULL ["_preSortScript"]=> NULL ["_preSortScriptParams"]=> NULL ["V0b9a204c"]=> string(16) "FileMaker_Record" ["_recordId"]=> NULL } } ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["callback"]=> NULL } Any help would be much appreciated!
  19. We have a (fortunately) backup server we are trying to bring up and we testing our PHP/CWP solutions on it as the last step. Up to this point, everything seemed to be working fine: all the canned server tests (well, IWP and CWP) had worked OK; a couple of add-ons appeared to be working fine; client access was good; custom IWP solutions were good. Then we ran into a problem with the CWP solutions that we have. We have a login system where you start at an Index page, it reroutes you Login if you aren't logged in. The initial redirection and showing of the login page works OK. But when you log in, it apparently fails to authenticate you and just returns error: "XML error: Not well-formed (invalid token) at line 1" (or something like that). The failed login attempt doesn't show up in the FMS logs, either. So it is almost as if it isn't even contacting the server. These CWP pages are working fine under the live server (thankfully), which is configured very similarly: Windows 2008 R2 FMSA 12.05 SSL two plugins that run as tomcat processes IIS 7.5 (using URL re-write for HTTPS redirection) We have even had them running on an OSX based server without problems. I think that I discovered the apparent cause of the CWP problems, at least, but I would like to know WHY, and how to fix it if someone knows: I had to remove the 'hostspec' definition from the dbaccess.php file we use. remove the 'hostspec' definition from "dbaccess.php" = works define 'hostspec' in "dbaccess.php" = fails remove the 'hostspec' definition from "dbaccess.php" = works I found this because the canned FMS CWP test does not use a 'hostspec' definition. I suspect that it may have something to do with the php.ini or various other FMS configuration files around there. You see, we didn't have SSL installed at first, but installed it after FMS was setup. So during the installation of SSL, I have previously discovered that there are a few files you have to manually adjust (I posted about them here), even if you do a redeployment. But, it could also be because of some IIS redirection issue, it seems. Any ideas? Thanks, Justin
  20. I have a website that is displaying FileMaker data using the PHP API. Is there a way for the web site to display the basic text formatting from a FileMaker field? For example, a few words in the comments field are bold in FileMaker and I would like them to also be bold on the website. Thanks for any ideas.
  21. I am rewriting our 15 satellite offices to be on one web server, instead of individual FMP software solutions. I am rewriting anyway because my files are large and too much code and layouts are not used that happens from 20 years of adding on, it is just time... They will be able to share the database direct, but when it comes to iPad and iPhone, just downloading Filemaker Go and then emailing them the revised smaller designed layouts will give them the data access to the server database, correct? There is no need for webdirect. I would also like to have our customers forms update directly into our database from our website. So, my plan is to use PHP to connect the web data into the same Filemaker Server. Again, no need for webdirect and no need for those additional licenses, correct? Upgrading from Filemaker 12 to Filemaker 13 does not require us to use webdirect? Thanks
  22. I have a script that performs a find based on related fields. Here's a very simplified version of script Go To Layout ["Primary_Table"] Enter Find Mode [] Set Field [related_table::name] Perform Find I have the <<related_table::name>> field on the Primary_Table layout. If I run this within Filemaker Pro it works and finds desired subset. If I run it as a Server script it works and finds desired subset. But, if I trigger it from PHP it finds ALL the records in the Primary_Table. The following, however, does work and finds a subset of records from Primary_Table: Go To Layout ["Primary_Table"] Enter Find Mode [] Set Field [Primary_Table::id] Perform Find In other words, I can trigger scripts with PHP that successfully do finds when all the find fields are native to the Primary_Table, but as soon as I try to add criteria that's in a related table to Primary_Table it finds ALL Primary Table records. I've tried authorizing all layouts to the php user so I don't think it's a permissions issue. Is this a known issue, or should it work in principal and I'm missing something? Hopefully not since otherwise it's going to mean a much longer script to find what I need (the actual script does a search using fields from 3 different related tables, 2 of which are 3 tables away from Primary_Table, so I'll need to do a ton of Go To Related Records steps. Thanks for the help!
  23. Hi All I am experiencing a very odd problem with a web form we created for our clients. The web form worked absolutely perfectly on the Apache server we started the clients off on. We're now trying to move them to a new IIS server on a much more powerful machine, however there have been some issues. On entry of the first page a record is created in the database & when the form is posted, that record is edited & continues to be edited on subsequent form pages after filemaker's record ID and the primary key are stored as session variables. NOTE: There is an included page prior to the code I have entered below which sets $ID & $recordID to the value of the session variables for the ID's. A few items of code had to be re-written & these elements now work fine, however I have just noticed a new problem & I have no idea how it is happening... The first step on the first page is to test for the existence of 2 variables. If these variables do not exist a record is created in the database and the 2 variables are set (see below). if (!isset($ID) AND !isset($recordID)){ $stepTwoEdit = $fm->newAddCommand('webCandidateFormStepTwo'); $result = $stepTwoEdit->execute(); if (FileMaker::isError($result)){ echo $result->code; die(); } $record=$result->getRecords(); $recordID=$record[0]->getRecordId(); $ID=$record[0]->getField('ID'); session_start(); $_SESSION['recordID']=$recordID; $_SESSION['ID']=$ID; session_write_close(); }//if record has not yet been created in the database create it so that we have an id Now this code works perfectly. I have echo-ed the variables onto the page and they are being set correctly & I have done tests to verify that the newAddCommand is only being performed once by echo-ing text inside the if statement. So it appears to all be working correctly, until you go and look in FileMaker. Blank records are being continuously created by the server, despite the fact that the newAddCommand is not being repeated. This command is called once and only once. These records are not just created on page refreshes or on navigation between form pages - they just keep being created every x seconds (there's no consistent interval)... Any ideas?!? Really need to get these clients onto our new server asap, so help would be massively appreciated! Thanks in advance! x
  24. Hi all I'm new to PHP in general, as well as the FM PHP API. So please be patient as the question might not actually make any sense. We need our clients to be able to access some records in our database (hosted on Filemaker Server 13). We would like them to do this through a website, which is being developed by a 3rd party. The website would use PHP to pull data from our database. As I understand it, if the database were SQL, then you can have your web server completely separate from the database server. PHP would just connect using credentials and manipulate data as per user requests. Is this same route possible with FileMaker? Can you have PHP pages connect to FMS, which resides on a different server? Or do the website/PHP files have to reside on either the primary FM server or the web FM server (which would be linked to the primary FM Server)? If the last scenario is the case, can the to FM servers link over the web or would they have to be on the same internal network/domain? It's quite a straight forward question I think, but I can't find a specific answer anywhere. Any help appreciated.
  25. Implementing a set of conditional value lists on a FileMaker layout is a relatively easy task. So, my question is how does one translate this to a PHP solution based on that layout? I understand that it can be done and that Jonathan Stark detailed one method for doing this in an article for the now dead Adviser magazine (an article that I can't seem to find anywhere). Can someone tell me how to get started doing this (getting the second value list field to populate correctly on a PHP created page) or point me in the direction of resources that will help me learn how to complete this task? I need this knowledge for several upcoming projects. Thank you for any and all help that you can provide B-
×

Important Information

By using this site, you agree to our Terms of Use.