Michael Simpson

In Manipulating Form Data Before it is Saved you can add PHP code to do something whenever a submission is received.

I don’t see any URL in your example, only SQL. But instead of doing complex SQL, let the plugin do it for you. Then if you want to expose that via a URL, then I suggest to create an WordPress AJAX URL that wraps it. See: https://codex.wordpress.org/AJAX_in_Plugins

Basically:

You need code to register the URL and a function to handle the request:
add_action( ‘wp_ajax_my_action’, ‘my_action_callback’ ); // Must be logged in
or
add_action( ‘wp_ajax_nopriv_my_action’, ‘my_action_callback’ ); // Open to everyone

In your my_action_callback function you can code any additional security checks before continuing. Then process any $_REQUEST parameters you choose to to pass to the Accessing Form Data via PHP or it might be easier to create a shortcode string from the user input and call do_shortcode and let that just echo the output back to the calling browser.

Put all that code in your theme’s functions.php file or use my Add Shortcodes Actions and Filters plugin to give you a place to put it.

I recommend against writing SQL. I suggest to follow Accessing Form Data via PHP to retrieve the data you want, and expose that via the API that you create.

I don’t know the full context of your question but this might be what you are looking for:
http://cfdbplugin.com/?page_id=1435

Thank you very much.

I’ll additionally consolidate the “if” statements and add that change to my next update.

// See if wp-jalali is active and if so, have it convert the date
// using its 'jdate' function
else if (is_plugin_active('wp-jalali/wp-jalali.php') && function_exists('jdate')) {
    if (CF7DBPlugin::$customDateFormat) {
        return jdate(CF7DBPlugin::$customDateFormat, $time);
    } else {
        return jdate(CF7DBPlugin::$dateFormat . ' ' . CF7DBPlugin::$timeFormat, $time);
    }
}

• This reply was modified 9 years, 7 months ago by Michael Simpson.

http://cfdbplugin.com/?page_id=1420

They are stored in the DB, not on the file system.