Closed

MySql Query for wpdatatables and radar chart engine

hi, i need a mysql query to build a wpdatatables table that then i'll use as base for radar chart engine (wpdatatables engine [login to view URL]).

My logged user submit a formidable form with:

- three numerical field: NameField1, NameField2, NameField3, NameField4. Each of them can have a range value from 0 to 100.

- an hide text field that save the current logged user id

- a data field with the date of submit.

I need that the query (and then the table) dinamically display values only for the logged user. Moreover the radar chart to work need that the table must be like this:

LabelsForNameFields, ValueFields2018, ValueFields2019, .... (based on entries)

NameField1, 99, 87, ...

NameField2, 98,55, ...

NameField3, 37, 56, ...

NameField4, 14, 37, ...

Formidable form database schema Link: [login to view URL]

I tested this addon: Formidable Forms integration for wpDataTables but isn't useful because it creates only this type of table:

Data,NameField1, NameField2, NameField3, NameField4

10/10/2018, 99,98,37,14

10/10/2019,87,55,56,37

....

Radar Chart can't work with this type of table.

Skills: MySQL, WordPress

See more: edit csv mysql query, asp mysql query, 2013 lost connection mysql query, wpdatatables licence, wpdatatable charts, wpdatatables documentation, wpdatatables create chart, what is wpdatatables, wpdatatables maps, wpdatatables pie chart, wpdatatables login, mysql query report, php mysql query table, mysql query record bash, mysql query csv file, write mysql query, optimize mysql query software, mysql query php table css, php mysql query format table, mysql query search

About the Employer:
( 0 reviews ) Civitanova Marche, Italy

Project ID: #18200585

6 freelancers are bidding on average €168 for this job

coolguyinus2004

[login to view URL] this schema is different but what you need for table with datas like - three numerical field: NameField1, NameField2, NameField3, NameField4. Each of them More

€277 EUR in 3 days
(203 Reviews)
7.2
abstractsoftweb

Hello There, HOPE ARE YOU DOING WELL ..!! Project Analyst: Going through your project description we understand that you are looking for an experienced team of professional developers and designers to work on yo More

€200 EUR in 3 days
(75 Reviews)
6.9
Vedtechnology

I have gone through your requirements and would like to be considered to work on your projects. Having been in the Software Industry since a while, I have worked on websites previously for a variety of products. The More

€240 EUR in 10 days
(37 Reviews)
4.3
shivam31

Hi I read your project about developing wp database queries. I can complete this project in less time. Looking forward to work and discuss more about this project with you. Thanks Shivam Kataria

€70 EUR in 1 day
(26 Reviews)
4.0
Manavx

Hi, I have 3+ years of industry experience, with expertise in MySql. I can easily do this project for you in budget and on time. Hope to hear from you soon.

€66 EUR in 3 days
(5 Reviews)
3.3
aswadakdas

Customer's satisfaction is my goal *** *** Also 100% Completion is happy of me and client. *** *** Rest 1% is my creative idea and honest effort. *** Looking to be your Good Venture along with your project! Bes More

€155 EUR in 3 days
(2 Reviews)
1.6