Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Extracting data from database
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Extracting data from database
#19224
Extracting data from database 12 Years, 6 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.
The administrator has disabled public write access.
 
#19225
Re:Extracting data from database 12 Years, 6 Months ago Karma: 746
Hello,

Could we see structure of your database (tables of Proforms extension) with sample data?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#19227
Re:Extracting data from database 12 Years, 6 Months ago Karma: 0
Does this help?
File Attachment:
File Name: Ari_tables_problem.zip
File Size: 299546
The administrator has disabled public write access.
 
#19230
Re:Extracting data from database 12 Years, 6 Months ago Karma: 746
Do you need a flexible solution or you want to show data for specific form?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#19237
Re:Extracting data from database 12 Years, 6 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
The administrator has disabled public write access.
 
#19266
Re:Extracting data from database 12 Years, 6 Months ago Karma: 746
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
The administrator has disabled public write access.
 
Go to topPage: 1