Saving form results in MYSQL

Hi kris_tian,

I’m sorry, but I really do not understand your question.

Could you indicate the version of the plugin you are using?
Do you want store the value of a specific field in your own database?
Could you indicate the structure of your database?

If you are using the Developer version of the plugin, please visit the following link to our technical blog:

https://blog.net-factor.com/how-store-data-sent-different-database/

Best regards.

Thanks for the reply!
I’m a newb, sorry for not being able to describe it properly.

I want all form data in an array so it can populate to a BLOB field in my Mysql database. I read the page you linked to. Can I use $Params to do this?

Thanks again!
Kris

Quick update:
It works! Thanks to your link we were able to figure it out with serialize($Params) and the data is now stored the way we want it.

Forgot to mention in the previous post that it is the Developer version.

Thanks again!
Kris

Hi Kris,

Please, remember create in your computer a backup of all modified files, because, they can be necessary in futures updates of the plugin.

Best regards.

Hi
As another user trying to use the Form Controls with Mysql Datasource Connection, I have modified cp_calculatedfieldsf_insert_in_database.php, I am stuck at a stage whereas when i preview, I get only text and no radio buttons
for the user inlet fill area?
Test connection : connection okey
Do i have to fill query structure or custom query to add mysql variables for
each line?
Thanks

Hi,

The cp_calculatedfieldsf_insert_in_database.php file is not used by the “DS” controls in the form, this file is only for saving the submitted data in your own database. Plase, visit the following link with the instructions about the use of this file:

https://cff.dwbooster.com/documentation#third-party-database

Best regards.

Hi
However the link page does not give the full information and I am stuck at query structure!
Should i fill on the field Type: Radio Btns DS as follows
Query Structure
Column for values: $field1′, ‘$field2’, ‘$field3
Column for text :field1, field2, field3
Table name: my_users
Conditions: publish
Order by: display_name ASC
Limit:100
When i test the query, ? get the following
Array
(
)
I also get no selection radio buttons on the form preview

Hi,

You are talking about the Radio Btns DS fields, in this case you don’t need the “cp_calculatedfieldsf_insert_in_database.php” file.

In the “Column for values” you simply should enter the name of the column in the table, whose values are used as the values of Radio buttons, but only one column.

In the “Column for texts”, should be entered the name of the column in the table, whose values are used as the labels of Radio buttons, but only one column.

To create complex queries yo should tick the “Custom Query” option, and create the complete query by yourself.

Please, visit the following link:

https://cff.dwbooster.com/documentation#datasource-fields-settings

Best regards.

Hi,

About the “Conditions” attribute, if you are using the query to get for example the published posts, it would be: post_status=”publish”

You should indicate the columns and the values that satisfy the conditions.

Best regards.

Hi
It does not save post_status=”publish” but do save as post_status=publish
But i do not see any selection button.
Do you mean that as a similar example for Field Type: Radio Buttons

Using Field Type: Radio Btns DS
Select a Choice – First Choice, Second Choice, Third Choice
I can not use query structure but i have to use Custom Query?
Do you have any sample custom Query ?
Best Regards

Hi,

Could you send me the structure of your database’s table, the name of the column you want use for radio buttons values, and the column to use for label, and please, the column to use for filtering with the corresponding value?

Best regards.

I am just trying to create basic maintenance form similar to excel
mainly radio buttons. What will be saved, round selected circles or Yes, No
or NA
Say Valve 1
1) Radio Button
Valve 1 Checked
Yes, No, NA

2) Pressure Noted
Value: 10 Bar

Hi,

Please, don’t change the question, or I cannot help you. In your previous entries, you are requesting my support to configure a Radio Btns DS field to populate its data from a table on database. I need the following data to help you with the query:

– The name of the database’s table.
– Its structure ( the columns names and their data types)
– The column you want to use for values, and the column you want to use for labels.
– The column to use for filtering and the corresponding value.

Best regards.

I am just after the basic single line report and nothing complicated provide i get the radio buttons for yes, no or n/a!

-database’s table: my_users radio button, txt
-the structure – selection yes, no, n/a (radio button) text

Hi,

If you need a radio btns field with the options: yes, no, and n/a, then won’t be needed the a database connection. However, if you want to populate the values from a database, I will need the database structure for help you to create the query, and you are not sending the correct information:

Table name: ….

Columns:
– ColumnX for values with data type …
– ColumnY for lables with data type …

Conditions:
– ColumnZ with data type … and the value for filtering ….

I’m sorry, but if you don’t send the correct information I cannot help you.

Best regards.