e-mail : customdataservicesinfo@gmail.com
Microsoft Excel, Adobe Acrobat, and Claris FileMaker can all be extended with open-source PHP, PDO, and cURL to enable securable asynchronous data interactions with many types of SQL databases and a wide variety of REST APIs.
Forms created with these applications can perform calculations and use native functions to send query parameters to PHP scripts. The scripts can look-up information, execute SQL Create-Read-Update-Delete transactions, call stored procedures, or communicate with practically any REST API, and then filter and return query results to designated form fields in real-time.
Each type of form provides different features, capabilities, and functionalities. Forms can work independently or communicate with other forms in processes. Any form can interact with unlimited forms, databases, APIs, in any sequence.
Microsoft Excel spreadsheets can use the WEBSERVICE() function to dynamically execute queries on SQL databases or REST APIs and return filtered query results directly to spreadsheet cells without local ETL processes. PHP scripts can return scalar or aggregate results as text, JSON, or XML, updating related spreadsheet calculations in the process. Spreadsheets can optionally be converted to dynamic HTML forms with SpreadSheetConverter.
Adobe Acrobat Reader forms can be used as programmable interaction runtimes. Documents converted to PDF forms can post query parameters to PHP scripts that interact with databases or APIs and return filtered results to designated form fields in real-time. Acrobat Reader forms are more securable than HTML forms because they are not susceptible to XSS, CSRF, or session attacks and can be password protected, encrypted, flattened, and digitally signed.
Claris FileMaker provides advanced form generation and hosting capabilities, with integrated authentication, calculation and script engines, process automation tools, and multi-user session management. FileMaker forms can be securely shared with up to 1,000 users via Windows or Apple desktop app or WebDirect forms. FileMaker forms can be extended with PHP, PDO, and cURL to enable real-time data exchanges with SQL databases or APIs.
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.
