e-mail : customdataservicesinfo@gmail.com
FileMaker, Excel, and Acrobat forms can all be extended with open-source PHP to enable asynchronous data interactions with SQL databases or REST APIs.
Forms created with these applications can use calculations to build and native functions to send user-supplied variable parameters to PHP scripts that can look-up information, execute Create-Read-Update-Delete transactions, call stored procedures, or interact with APIs, and then return results to the form.
Dynamic 2-way data interactions, triggered as users insert, update, select, or click, calculating, querying, filtering, and refreshing form elements in real-time.
Each type of form provides different features, capabilities, and advantages. Every type can interact with any mixture of databases or APIs in any sequence.
Claris FileMaker Pro provides a versatile form builder with advanced calculation and process automation controls as well as native multi-user authentication and session management. Filemaker desktop, web, or mobile forms can be securely shared with up to 1,000 users via Windows or Apple desktop application or WebDirect forms interfaces that can be extended with PHP to enable real-time interactions with multiple SQL databases or REST APIs.
Microsoft Excel spreadsheets can also be extended with PHP to dynamically execute queries on SQL databases or REST APIs, returning remotely filtered results to active cells without requiring local ETL processes. PHP scripts can return scalar or aggregate results as text, JSON, or XML, updating dynamic arrays and linked spreadsheet calculations in the process. Extended spreadsheets can optionally be converted to dynamic HTML and JavaScript forms.
Adobe Acrobat Reader forms can be used as programmable interaction runtimes. Any document can be converted to PDF and extended with PHP, PDO, and cURL to send query parameters to databases or APIs, filter, and return results to designated form fields in real-time. More securable than HTML forms, Acrobat Reader forms are not susceptible to XSS, CSRF, or session attacks, and can be password protected, encrypted, flattened, or digitally signed.
PHP is a popular general purpose server scripting language, currently used on approximately 75% of websites globally. PHP Data Objects and cURL code libraries provide simple, scriptable, securable methods for dynamically performing or scheduling SQL or REST API interactions. PHP is open-source technology, meaning no licensing costs, transaction fees, or subscriptions are required to own and use simple, reliable, industrial strength code.
PHP Data Objects (PDO) provide securable and comparatively injection-resistant methods for managing user interactions with MySQL, Oracle, PostgreSQL, or SQL Server databases. The PDO data-access abstraction layer maps filtered and typed query input parameters to placeholders in SQL prepared statement templates, executes queries or transactions based on the parameters, processing and returning formatted query results in real-time.
PHP incorporates libcurl, a versatile code library that simplifies connections and real-time interactions with REST APIs, among a wide variety of other things. Like a digital Swiss Army knife, libcurl provides scriptable methods for connection and interaction tasks involving http, https, ftp, gopher, telnet, dict, file, or ldap protocols, HTTPS certificates, HTTP POST, HTTP PUT, FTP or HTTP file uploads, proxies, cookies, or resource or directory user authentication.
