Search the Community

Showing results for tags 'php'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Categories

  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 16 Discussions
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Server 15
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker

Categories

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

Found 76 results

  1. XML error: No memory at line 1 Greetings, this error occurred when the Filemaker API cannot generate a bunch of records. (1000+ records and above) I've adjusted the time out settings for PHP even the memory limits. Is there any possible solution for this? According to some information, the error turns out that the 10 MB XML scripts is unchangeable. thanks.
  2. FREE fmREST.php – Simplifies & manages PHP connections to FileMaker 16’s REST-based Data API. The newly released FileMaker Server 16 now offers REST access to your FileMaker databases. There’s more about that how this impacts PHP developers here. The bottom line is that to use REST as part of your PHP solution, you would usually need to write a series of cURL functions and you would have to manually manage connecting & disconnecting from your server, and saving your tokens. This is a pain! We know it’s a pain, because we have spent the last several weeks rolling REST functionality into soSIMPLE Calendar. We created this class file to make it easier to manage dynamic REST sessions for soSIMPLE and our custom development. The goal of the class file was to help PHP developers start using the new REST engine as quickly and easily as possible. We’ll also be updating it with new features. If you’d like to add something to it, please let us know. What fmREST.php does: Makes every REST call available as a PHP function. Automatically login into FileMaker Server whenever you call any REST functions Saves your token for 15 minutes to reuse Checks for a broken or disconnected token and automatically reconnects and runs your function again Where do I get it? You can download the fmREST class file here.
  3. 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?
  4. 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.
  5. Hi all We have a web based tickets portal which creates new messages in our filemaker database - this is for customers' use. It does this using the PHP API (the website was developed by a third party). We would like the owners of tickets to be notified when the customer has added a message to one of the tickets that they are in charge of. Is there a way for filemaker/filemaker server to trigger a 'send email' script when a new record is created via the web portal? Or would it be simpler for this action to occur on the web side? Many thanks
  6. 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!
  7. Hi, I have a field called 'mytournament1'. I also have a field called 'mytournament1played'. With a form, I create the variable $tournament to bring 'mytournament1' to my results page. $tournament = $_GET['tournament']; I'd like to force the results page to search for the field 'mytournament1played' for each record by using the variable $tournament and combining the word 'played' or the variable $played. $played = 'played'; $tournamentplayed = $tournament . $played; $tournamentplayed2 = $record->getField('$tournamentplayed'); (I want it to deliver) $record->getField('mytournament1played'); I know the 1st '$record->getField' line is wrong. Can I combine 2 variables that spell out a database field name (mytournament1played) that can be used to call up a field in a search? i.e. if ($tournamentplayed2!='1') { thanks in advance for your help!
  8. I am tasked with troubleshooting a web registration form that queries a Filemaker Pro v12 database via a Filemaker PHP API. The web form had been running well for a couple of months after major revision, when all of a sudden: All dropdowns are empty All radio buttons are missing These symptoms appear to be browser-independent. The appearance of these symptoms is mysterious: Nobody has modified the PHP code for the web form - I've done a compare with a backup done at the time when the web form was not broken and it is identical to what is currently on the server. The Filemaker Pro layout that the web form is querying is just fine - all the value lists for the dropdowns and radio buttons are present. I've created a stripped-down version of the web form: https://campmeetings.cccsda.org/test_form.php and I've also attached the php source code file. The date and record fields are populating correctly. Notice the empty dropdown list after "Church I attend." Could this be caused by an incompatibility between the FMP PHP API and PHP libraries on the server? Perhaps due to a PHP update on the server? Any ideas how to troubleshoot this? test_form.php
  9. 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
  10. 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.
  11. Greetings - I got my start with CWP using FMwebstudio as the front end library to the FileMaker API (Dreamweaver). That library is no longer maintained. One of very cool things about that library was a dynamic field capability, fmsLiveInputField, where the changes you made in a web page were updated into the database in real time. I used it for event registration where the total attending and fees due automatically updated. I'd like to replicate this functionality ... display the total due, a show a few other live calculations. I prefer a PHP solution but realize javascript might be a better approach these days. I'm not a javascript guru so your help pointing me in the right direction would be helpful. And I do not want to use WebDirect due to the public pacing nature of this site and unpredictability in users active. Thanks!
  12. Hello! Another post... Please help me out. I am trying to create an array from a value list within Filemaker Pro (Using PHP API) The idea is to create an array of names from a value list I have set up... Then put them into an option tag. e.g. $staff = array(FileMaker Value List) ^^ I know that's incorrect, but it shows what I want to do Then with that array I want to be able to Create a HTML option list (I know how I would do that) --- I am just really struggling with creating the array... Here is what I have $database = "comms__web"; $hostname = "###.###.#.#"; $username = "web"; $password = "################"; $layoutname = "Web"; $valueListName = "MIS"; //CREATE FILEMAKER OBJECT $fm = new FileMaker($database, $hostname, $username, $password); //GET THE LAYOUT AS AN OBJECT. $layoutObject = $fm->getLayout($layoutName); //GET THE VALUE LIST $valueList = $layoutObject->getValueList($valueListName); However it doesn't actually appear to pick up the list... Please help me out Thanks,
  13. Hello all So I'm pretty new to Filemaker and CWP - I have created a form which people fill out and it stores the data in a filemaker solution. The idea being a script is then run which will notify a user if the form has been submitted. Now I have the script for that and all the Filemaker side completed, as well as the data entry from the PHP form, but I am really struggling with running a script with a parameter... It runs the script, but not the parameter attached. For a bit of context, Someone fills out the form and it is entered into the database, a script is then called with the parameter being an ID, the script then checks the ID with the parameter ID and then sends a notification to the user with the details from the record where the IDs match... but it will not pass the ID parameter into the script from the web application. Here is my script require_once ('FileMaker.php'); $fm = new FileMaker(); $fm->setProperty('database', 'comms__web'); $fm->setProperty('hostspec', 'http://192.168.X.XXX'); $fm->setProperty('username', 'web'); $fm->setProperty('password', 'XXXXXXXXXXXXXXXX'); $newPerformScript = $fm->newPerformScriptCommand('Web','TestScript','test'); $result = $newPerformScript->execute(); Please help me out here... Been trying to research this issue and nowhere really actually helps. Cheers Jack
  14. Server: Windows R2 2008 SP1 FileMaker Server 13 Connections via PHP I have several databases that users connect to via a web browser using php. All has been working correctly until Friday 1/3. I have been assured by IT that the server has not changed. However, the PHP connections are no longer reliable. Sometimes, the user can log in fine. Other times, a user logs in, submits a request, and it looks fine to the user. However, the "Error: Did not receive an XML document from the server." is thrown. Other times, the error is thrown and the user knows something is wrong. Sometimes the form will display the correct information, and sometimes the form cuts off. No change has been made to the code other than adding a date picker. I'd appreciate any help as I'm truly stumped by this. I've included the php files in case you see any issues. Thanks.
  15. hello, i'm a beginner, i have problem with a php script, i run it (1/2 minutes), reaches the command execute() and then it stop with no error message. this is the script: $fm_a = new FileMaker($file, $host, $username, $password); $a_table = $fm_a ->newFindCommand('layout_name'); $a_table->addFindCriterion('online', '1'); $a_result = $a_table->execute(); if (FileMaker::isError($iconografia_result)) { ....... where i'm a wrong? thanx for your time and collaboration Simone
  16. We are an established vertical market application developer in need of additional programming assistance for the web portion of our solution. We customize each of our FileMaker and companion web site solutions to meet the needs of our clients. The web site architecture is based on a YII MVC design. Programmer should have knowledge of FileMaker PHP API, PHP, HTML, YII (or other MVC), Tortoise SVN and basic Windows server configuration. Ongoing work would be available, all work is remote to our development servers.
  17. Good Morning, Stumped with a FileMaker Server 14 installation and getting the PHP web pages to work. Machine Specs: Mac OS X El Capitan v10.11.2 Mac Pro (Mid 2012) Processor: 3.2GHz Quad-Core Intel Xeon Memory: 12Gb FileMaker Server 14.0.4.412 installed SuperContainer 2.93 installed When viewing the FM 14 Console: FM Server is Green Web Server is Greyed out, PHP is enabled and XML is enabled (See attachment of screen shot) Web Publishing Engine is Green ODBC/JDBC is Green When trying to run the test page (Server > Open Test Page and clicking Test PHP Custom Web Publishing) Getting Not Found, The requested URL /fmi-test/phptest.php was not found on this server When I hit the server from a browser, I noticed it's hitting from the Web Server Path and NOT the FM Server path. FM Server: Library > FileMakerServer > HTTPServer > htdocs Web Server: Library > WebServer > Documents The web server path is serving up HTML and showing the PHP code and not processing it. Can anyone help with correcting this problem? We would greatly appreciate it.
  18. I have the same exact solution files setup on 2 separate server stacks. Everything is working perfectly one one, but on the other I'm getting this Communication Error (22) and I cannot figure out why.The message says specifically... The files are exactly the same, though. The FileMaker files themselves and the PHP files. The usernames and passwords are all exactly the same in both places. It's just that they are running on different server stacks. Both, though, are a combination of FileMaker (in-house) with a web server hosted by the same hosting provider.I have a very basic script setup to test the connection to FileMaker by displaying the available data sources, and it works perfectly (as well as everything else I do via PHP API) from one server. The same exact script on a different site hitting a different FileMaker server (with a copy of the same FM files on it) is giving me the 22 error.Everything points to the credentials being wrong or the FMPHP privilege not being set for the user, but that is simply not the case. Again, it's a mirror of something that works elsewhere, and of course I did check those credentials numerous times to be sure.The router at both FileMaker servers (working and not working) is setup with the same port forwarding rules, but that said, I am not quite as confident in the router configuration of the location where the connection is not working correctly as I am the other place. I am not finding any information while Googling about this issue being caused from network config, though. Everything just says to check the credentials, but I have, and that is not the problem.Any information I can get on how to potentially fix this would be greatly appreciated.
  19. I would like to edit a value list via a web interface- I have done this using a field ("Use values from field"), but that [I incorrectly assumed, see doughemi's suggestion below!] requires adding/editing a record for each value, while (if possible) the textarea box would allow the editing of the whole value list at once. Genx showed how to display a value list... $layout = $fm->getLayout('my_template'); $list = array_map("htmlentities",(array)$layout->getValueList('my_list')); I am hoping there is some easy way to send back an edited valuelist… We are using Filemaker Server 11 (not advanced). Thanks in advance!
  20. View File PayPal Notify FileMaker Overview Get data from PayPal transactions pushed into FileMaker automatically, instantly when the transactions occur. No more wasting time with manual data entry from PayPal into FileMaker! Our FileMaker PayPal IPN solution connects directly to FileMaker Server hosted databases using FileMaker’s PHP API. This provides instant, seamless integration of PayPal IPN into FileMaker. FileMaker PayPal IPN Data Solution File A FileMaker database that stores all of the PayPal IPN data. This needs to be hosted on a FileMaker Server FileMaker PayPal IPN PHP Solution Files A PHP application that processes the PayPal IPN data and updates the FileMaker solution file accordingly. This needs to be hosted on a web server with PHP 5.3 or higher installed What Can I Do With It? The basic functionality of the solution is to automatically save data about any transaction that hits your PayPal account to your FileMaker system. What this does for you is opens the door to automate tasks that could potentially chewing hours, days, even weeks of time! With a couple of simple table relationships and FileMaker scripts, the possibilities are endless. Just a Few Examples Create new orders in your FileMaker system when payments are received in PayPal. Update the PayPal payment status of orders in your FileMaker system. Update FileMaker product / order details when an order is refunded. Trigger FileMaker scripts based on IPN transaction types or payment status. Flag orders where a customer has filed a dispute with PayPal. The best part is that this all happens automatically, instantly when the transaction hits PayPal! Submitter angelleye Submitted 01/17/2016 Category Solutions FM Version FM Version: 1
  21. Version 1.0.2

    Overview Get data from PayPal transactions pushed into FileMaker automatically, instantly when the transactions occur. No more wasting time with manual data entry from PayPal into FileMaker! Our FileMaker PayPal IPN solution connects directly to FileMaker Server hosted databases using FileMaker’s PHP API. This provides instant, seamless integration of PayPal IPN into FileMaker. FileMaker PayPal IPN Data Solution File A FileMaker database that stores all of the PayPal IPN data. This needs to be hosted on a FileMaker Server FileMaker PayPal IPN PHP Solution Files A PHP application that processes the PayPal IPN data and updates the FileMaker solution file accordingly. This needs to be hosted on a web server with PHP 5.3 or higher installed What Can I Do With It? The basic functionality of the solution is to automatically save data about any transaction that hits your PayPal account to your FileMaker system. What this does for you is opens the door to automate tasks that could potentially chewing hours, days, even weeks of time! With a couple of simple table relationships and FileMaker scripts, the possibilities are endless. Just a Few Examples Create new orders in your FileMaker system when payments are received in PayPal. Update the PayPal payment status of orders in your FileMaker system. Update FileMaker product / order details when an order is refunded. Trigger FileMaker scripts based on IPN transaction types or payment status. Flag orders where a customer has filed a dispute with PayPal. The best part is that this all happens automatically, instantly when the transaction hits PayPal!

    $499.99

  22. 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!
  23. Hello FMP security experts! Is it possible to lock down records "per user" in a database that is accessed via a PHP web interface that uses a table based login (as opposed to an "Account based" login)? The database needs to allow for multiple users who can only access their own records. This is no problem with an account based solution where the concept: Get(AccountName) = RecordOwner is used within the privilege set to only allow the active user access to his/her own records. However, since this solution needs to scale to around 100 users, I considered using a table based login in order to ease account management for that many users. The problem is that since the table based login uses a single "default" style login, let's call that login "webuser", if I use Get(AccountName), it's not actually reflective of the user actually logged in! I just can't seem to get my head wrapped around this. I tried using a field called "AccountName" in the User table so that AccountName = RecordOwner could still be used for the privilege set security setting, but since the records are always related to the AccountName of the user that created them, this equation (AccountName = RecordOwner) always rings true and allows for all records to be viewed by everyone logged in. The unique factor in the Get(AccountName) security paradigm is that the active "Account Name" might not be the same as the Record Owner name which allows or disallows access. However, using a field in the User table creates a scenario where if that User and their records are related, they are always related. I haven't been able to come up with a way to say: if the user is "webuser", then make the current account = the actual active account. Then use this info to limit viewing within the privilege set. Is this scenario even possible at all using PHP with table based logins? If not, I'll stop trying, lol! If it is, I need some help seeing how to do it. One last question, even if it is possible to do this via table based logins, should I be using Account based logins anyways? Thanks in advance for your help!
  24. LS, We currently have this worker machine running, but I want to get rid of it. The worker runs a FM-script every 5 mins and exports some data, which is then uploaded to an ftp server and then processed by the website. The script does several xml-exports. It starts by searching for certain products , then it exports the data to and xml file ( xml-result ). After that is does a go-to-related script-step ( matching all records ) to commercial descriptions of the products and then exports this data as an xml file. We go back to the found set of products and then repeat the proces for more related product data. As said, all data is exported and the uploaded to an ftp-server. Preferably I would like to keep the xml-result structure of the data as the website is already familiar with this structure. How do I go about doing this migration. I was able to perform an xml-query and get my result. The thing is : how do I proceed with these goto-related records finding ? Or should I just go with PHP ? Much thanks in advance !
  25. (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.