Display Data from Remote MySQL table
Jim Wyrsch created the topic: Display Data from Remote MySQL table
How do I display data from a remote MySQL table to a form? I would like to show it in an dataview/Excel fashion.
I created an Insert Query mapping a form to the remote table. However, the only add query options are Insert, Update, and Delete. There is no Select query option.
Please Log in or Create an account to join the conversation.
-
Topic Author
- Jim Wyrsch
- Offline
- Fresh Boarder
-
- Posts: 2
- Thank you received: 0
6 years 7 months ago
Agapi G. replied the topic: Display Data from Remote MySQL table
Hello Jim!
Thank you for posting your question!
Single, Multiple Choice and Select Box fields of Form Maker have Select Options from database option I have posted a screenshot below. You can use these fields to display information from your MySQL tables.
However, unfortunately it cannot be displayed as a table or dataview. Probable single/multiple choice fields can provide similar display.
Thanks! Have a wonderful day!
Kind regards,
Agapi G.
Web-Dorado team
Please Log in or Create an account to join the conversation.
6 years 7 months ago
Arturo Portillo replied the topic: Display Data from Remote MySQL table
Hi:
i have a problem with this solution... the field does not display the options!
Please Log in or Create an account to join the conversation.
-
- Arturo Portillo
- Offline
- Fresh Boarder
-
- Posts: 2
- Thank you received: 0
6 years 7 months ago
Jim Wyrsch replied the topic: Display Data from Remote MySQL table
That is helpful. Is there a way or method to populate a Text Input field?
Please Log in or Create an account to join the conversation.
-
Topic Author
- Jim Wyrsch
- Offline
- Fresh Boarder
-
- Posts: 2
- Thank you received: 0
6 years 7 months ago
Agapi G. replied the topic: Display Data from Remote MySQL table
Hi Arturo and Jim!
Arturo, could you please submit a support ticket through
this form
and send us temporary WordPress administrator access to your website? Our development team will check the issue as soon as possible and figure out a solution.
Also please mention the link to this forum topic in your message.
Jim, unfortunately these values cannot be populated into a text input field in Form Maker.
Thanks! Have a great day guys!
Kind regards,
Agapi G.
Web-Dorado team
Please Log in or Create an account to join the conversation.
6 years 7 months ago