Display single MySQL record

All WYSIWYG Web Builder support issues that are not covered in the forums below.
Forum rules
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901

MUST READ:
http://www.wysiwygwebbuilder.com/getting_started.html
WYSIWYG Web Builder FAQ
Post Reply
trevorm
 
 
Posts: 45
Joined: Sat Mar 14, 2020 3:43 pm

Display single MySQL record

Post by trevorm » Sat May 23, 2020 1:06 pm

Hi,

I have a need to search a MySQL DB and display a single record in a form style rather than a table.

i.e. display fields from a MySQL record where the fields of a single record are placed in a form.

Is this possible or this there an extension that enables this?

I am not a programmer so I need a, more or less, ready made a solution like an extension

User avatar
Pablo
 
Posts: 20144
Joined: Tue Mar 28, 2006 12:00 pm
Location: Europe
Contact:

Re: Display single MySQL record

Post by Pablo » Sat May 23, 2020 1:09 pm


trevorm
 
 
Posts: 45
Joined: Sat Mar 14, 2020 3:43 pm

Re: Display single MySQL record

Post by trevorm » Sat May 23, 2020 3:35 pm

Hi Pablo,

MySQL Connector appears to be perfect for my requirements. Thanks.

I'm having an issue when publishing - Blank white page displays with error code 500. I have checked the DB connection details these are correct

I appreciate that error 500 is a very general error code and does not help much.

Not even a breadcrumb menu that is on the page or the Master page objects are displaying.

Please can you answer the following:

Do you need all the fields in the MySQL db added to the MySQL Connector field list or just the ones you need?

Does the MySQL Connector Extension have to dragged to the page after setting up the form objects? Or does it not matter.

Does the MySQL Connector Extension have to be in the same Layout Grid as the Form Objects or just present on the same page?

User avatar
Pablo
 
Posts: 20144
Joined: Tue Mar 28, 2006 12:00 pm
Location: Europe
Contact:

Re: Display single MySQL record

Post by Pablo » Sat May 23, 2020 4:55 pm

If you have a blank page then this usually indicate a syntax error on the page.

I suggest to enable error reporting on the server to get a more useful error message.

Note that this (free) extension does not come with support.

lummis
 
 
Posts: 126
Joined: Sun Apr 24, 2011 9:18 am
Location: UK

Re: Display single MySQL record

Post by lummis » Sat May 23, 2020 5:46 pm

Do you need all the fields in the MySQL db added to the MySQL Connector field list or just the ones you need?
You can select a single field or as many as you want to display.
Does the MySQL Connector Extension have to dragged to the page after setting up the form objects? Or does it not matter.
It doesn't matter.
Does the MySQL Connector Extension have to be in the same Layout Grid as the Form Objects or just present on the same page?
Just present on the same page - I tend to place it outside the boudaries of the page, either to the right or below.

Brian

trevorm
 
 
Posts: 45
Joined: Sat Mar 14, 2020 3:43 pm

Re: Display single MySQL record

Post by trevorm » Mon May 25, 2020 7:46 am

Thank you for you suggestions

Post Reply