|
Extracting data from database 13 Years, 2 Months ago
|
Karma: 0
|
|
Hi,
on my website I want to present data which are submitted to the database via a Proforms form.
Each submission represents a dataset, containing 7 data fields.
Unfortunately Proform stores these data not in rows (one row for each data set, with fields in separate columns) but, as is shown on the attached image, one coloumn for the datasets (stiid), one coloumn for the entries (eid) and one coloumn for the content of the submissions. All content is stored consecutively in a single coloumn.
I need to present the data in a table, showing rows, one row for each submission.
I am not very familiar with SQL and PHP, so I hoped to find a good solution with ARI Data Tables, but i cannot find any way to make rows out of the content coloumn.
I really hope, you can help me. If you want, I can give you a temporary administration access to the website.
|
|
|
|
|
|
|
Re:Extracting data from database 13 Years, 2 Months ago
|
Karma: 760
|
|
Hello,
Could we see structure of your database (tables of Proforms extension) with sample data?
Regards,
ARI Soft
|
|
|
|
|
|
|
Re:Extracting data from database 13 Years, 2 Months ago
|
Karma: 0
|
|
|
|
|
|
|
|
|
Re:Extracting data from database 13 Years, 2 Months ago
|
Karma: 760
|
|
Do you need a flexible solution or you want to show data for specific form?
Regards,
ARI Soft
|
|
|
|
|
|
|
Re:Extracting data from database 13 Years, 2 Months ago
|
Karma: 0
|
|
All I need is just a table, which shows the submitted data in the frontend. Additionally it would be an advantage to be able to edit these data (from backend of frontend) and delete single rows, but this is not a must!
best regards
Bert
|
|
|
|
|
|
|
Re:Extracting data from database 13 Years, 2 Months ago
|
Karma: 760
|
The extension doesn't provide ability to add, edit or delete data. If you want to show data as on provided screenshot, the next SQL query can be used in "ARI Data Tables" module:
| Code: |
SELECT
SI1.content AS `Name`,
SI2.content AS `Col2`,
SI3.content AS `Col3`,
SI4.content AS `Col4`,
SI5.content AS `Col5`,
SI6.content AS `Datum`,
SI7.content AS `Telefon`,
SI8.content AS `Ma-Nr`
FROM
#__m4j_storage_items SI1 INNER JOIN #__m4j_storage_items SI2
ON SI1.stid = SI2.stid
INNER JOIN #__m4j_storage_items SI3
ON SI1.stid = SI3.stid
INNER JOIN #__m4j_storage_items SI4
ON SI1.stid = SI4.stid
INNER JOIN #__m4j_storage_items SI5
ON SI1.stid = SI5.stid
INNER JOIN #__m4j_storage_items SI6
ON SI1.stid = SI6.stid
INNER JOIN #__m4j_storage_items SI7
ON SI1.stid = SI7.stid
INNER JOIN #__m4j_storage_items SI8
ON SI1.stid = SI8.stid
WHERE
SI1.cid = 1
AND
SI2.cid = 2
AND
SI3.cid = 3
AND
SI4.cid = 4
AND
SI5.cid = 5
AND
SI6.cid = 6
AND
SI7.cid = 7
AND
SI8.cid = 8
ORDER BY
SI1.stid
|
Regards,
ARI Soft |
|
|
|
|
|
|
