Anonga Tisam ano

Introduction

A single page standalone PHP script to help manage formidable forms data in the front-end.

To add a see the URL below, note that

Here's a quick tutorial on how to include REST API documentation into your PHPMaker Project.

Generate your PHPMaker project into a folder e.g. C:\wamp64\www\datamart\docs
Create a folder in the root called api e.g. C:\wamp64\www\datamart\docs\api
Copy and Paste the api.php code and the index.html code into the folder
Find the configuration part of code at the bottom of the api.php and configure it to your needs. The configuration part of code should look like the section of code below:

Create a REST API for MYSQL Views and display the appropriate REST API endpoints based on whether the MYSQL database view is updateable or not

	<?php
	/** Load WordPress Environment */
	define('WP_PATH', './dashboard/');
	define('WP_USE_THEMES', false);
	require(WP_PATH . 'wp-load.php');

	/ Get Edit Link, HTML Table of the record /
	if (isset($_REQUEST["entry_id"])) {
	$entry_id = $_REQUEST["entry_id"];
	$response['edit_link'] = "./dashboard/?frm_action=edit&entry=" . $entry_id;

	/**
	* Description: Gets a URL parameter value. Similar to PHP $_GET
	* @param {string} param
	*/
	function $_GET(param) {
	var vars = {};
	window.location.href.replace(location.hash, '').replace(/[?&]+([^=&]+)=?([^&]*)?/gi, // regexp
	function (m, key, value) { // callback
	vars[key] = value !== undefined ? value : '';
	});

	<?php
	/**
	* The Formidable-SQL plugin
	*
	* Generates SQL code for Formidable Form Entries.
	*
	* @link ano.tisam.com
	* @since 1.0.0
	* @package Formidable_Sql
	*

	<!DOCTYPE html>
	<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<meta charset="UTF-8">
	<title>ServiceDesk Service Swagger</title>
	<link rel="stylesheet" type="text/css" href="https://unpkg.com/swagger-ui-dist@3.12.1/swagger-ui.css">


	</head>
	<body>

	<?php
	/**
	* Remove all non alpha numeric characters except a space
	* @param string $string The string to cleanse
	* @return string
	*/
	function alphanumeric( $string ){
	return preg_replace('/[^a-zA-Z0-9]/', '', filter_var($string,FILTER_SANITIZE_STRING));
	}

	/*
	The format for converting UUID's to integers is as follows

	CONV(LEFT(HEX(`uuid_from_bin` (`uuid_v5` (<a static uuid value>,<the uuid field>))),8),16,10) AS id

	MYSQL User Defined Functions

	uuid_from_bin
	and uuid_v5