alaguna

CFDB is compatible with PHP 7
September 21st, 2016Michael SimpsonNo comments
If running a scanning tool, it may report Errors for deprecated code.
72 | ERROR | Extension ‘mysql_’ is deprecated since PHP 5.5 and deprecated since PHP 5.6 and removed since PHP 7.0 – use mysqli instead.

The code contains both the new “mysqli” and old “mysql_” for both new and old versions of PHP. The old code is not run under PHP 7.

The following is unit test code that is not run on your site. This is a “mock” version of an existing WP function. You can blame WP for the name.
48 | WARNING | Function name “__” is discouraged; PHP has reserved all method names with a double underscore prefix for future use

https://cfdbplugin.com/?p=1544

I have tested it using local by flywheel and is working fine with php 7.1.7. But live website is using 5.6.36

Under the CFDB options on the dashboard, in the saving tabs, there is an option that reads “Do not save forms in DB named (comma-separated list, no spaces)” put the names of Example: form1,form2

I don’t use the editing exstension but I did do what you asked. What I did was I created an unique field on the form and is defined as an “Increment Value Field”. This means that every time a new submission is added this field adds a value of “1” basically having a unique identifier. (I used caldera forms instead of Contact Form)I believe that submitted time can be used as that field. With caldera forms I can pass parameters with no coding. Anyway, since I dont have the editing extension (because I don’t want the user to edit it, just to see it) this is how I do it.

[cfdb-datatable (with headers filters etc..)
After that short code the following code (using text on the page) instead of “visual mode”:

$('td[title="WhateverUniqueRecordIdentifierYouHave"] div').each(
    function () {
      $(this).html('<a class="modal-link" href="https://yourwebsite/yourpage/?parametervalue=' + $(this).html() + '">' + 'See Detail...</a>');
    })
})(jQuery);
</script>

That code will display a column as a clickable link on the table.
Line 1. The field that stores the unique record identifier.
Line 3. The class “modal-link” I use it because, instead of opening another page, that shortcode used in conjunction with “WP Post Popup” plugin, will open any page or post as a pop up. So I point it to another page on which I have another [cfdb-datatable] shortcode (in your case I guess that you would use the premium shortcode that gives you the ability to edit the table). What this part of the address /?parametervalue=’ does is asign whatever field is rendered as a clickable link as a parameter for the other page. The part that says “See Details…” is what is shown on the text of the link istead of the actual value. So basically when the users click on that a page opens up with that parameter and on that page I have a shortcode of [cfdb-datatable] that uses a filter with filter=”ParameterField”=$_GETparametervalue)”

I did that and use it as a master/detail way of seeing the submisions. Anyway sounds kind of confusing but it’s really not that difficult. Anyway I did it using this as a base and changed the code to fit my needs. I suggest to read it, even the comments because is valuable information there. Help Here. ** Note on that link I tried the part that says

New in version 2.8

Shortcodes in version 2.8+ allow you to add additional text before and after the short code. Include the above script with the short code like this (in between markers {{AFTER}} and {{/AFTER):
with no luck. I just put the code after the shortcode and works great. Hope this helps in any way.

• This reply was modified 6 years, 3 months ago by alaguna.

Maybe this will help.Here
I did it and it works great, the last part where it says “New in version 2.8” didn’t worked for me. I used the original instructions. And if you combine that info with parameters is a powerful tool.

Resolved.

Jesus Christ, it was so easy! I just had to select the las shortcode! the export link. I does exactly what I wanted.