www.wysiwygwebbuilder.com

I am very new to WYSIWYG Web Builder (15) so please forgive my question if it is obvious to you.

I am setting up a page to display a Bootstrap Table. The table page uses a Master Page

When publishing online the form is appearing in the correct place with all the Master Page details but without any data in the table. I am confident the MySQL access details are correct as I am using the same details in another site which works (not built in WYSIWYG)

I have entered the fields I want to display (4 out of about 10):
pupilfirst, pupilsurname, pupildob, referrer

and I have entered the Headers names which are displaying:
First Name,Surname,DoB,Referrer

The published table has the following embedded in it:-
Immediately below the "Boostrap Table" banner:
\n"; foreach ($row as $cell) { echo " \n"; } echo " \n"; } ?>

and in the from area it says: " . $cell . "

Regards
Trevorm

Did you set a primary key?
See also the note about this in the documentation.

Hi

Thank you very much for your prompt reply.

I can see where ID is called for in MySQL CRUD instructions but I cannot see it in either the instructions or in properties of the Bootstrap Table. Can you tel me where it is please?

Sorry, you are right. The ID is not required for thew Bootstrap Table.
In that case, the only reason I can think of is that the settings are not valid.

Thanks again for your help.

I have checked the setting out again, the settings are not wrong. I am at a complete loss as to what I am doing wrong.
I have also tried the MySQL Crud (including the ID) and get the same results. Clearly it is something I have or have not done.
I am accessing the same database from another Web site (built in different design app) using the same settings so I am confident the actual DB access details are right.

Thanks anyway - I really thought WYSIWYG Web Builder was going to resolve my data presentation issues but it appears not.

Are there any errors in the PHP error log on the server?

Note that if there were any known issues then these would have already been fixed.
I can ensure you that the extensions work otherwise I would not have made them available.
I am pretty sure that there is an error in the configuration.

I do not have the Bootstrap Table extension but I do have MySQL CRUD.
In MySQL CRUD did you include the ID field in the list as well as specifying it as the Primary Key?

Sorry, my mistake, it doesn't need it in the list.

In MySQL CRUD does it just say "No Result" where the output should be?

Pablo, I do not think the extension is at fault - it is me.

WWBMan - No it does not say "No result" it says: " . $cell . "

The only way I can help you with this, is when I know all your settings.

Hi again Pablo,

I have sent three images showing my settings to you via email at your website "info@" your website address as this is the only other contact I have for you acquired from you kindly supplying info about the software before purchase.

I could not see how to send images via an email on the forum.

Regards,
Trevorm

All settings seems to be correct, as far as I can see.
However, as described in the manual, the ID must be visible in the listview.

If after changing this the extension still does not work, then please check the server error log.

Thanks Pablo

I’ll sort that out and check error log if needs be.

Trevorm

HI Paplo,

We are getting somewhere but a strange occurrence now !

I have republished the page with ID enabled in list view as you said. However, now I am getting file not found if the page is selected from the menu of the web site . The file is definitely there I can see in the server folder.

Strange thing is that if I go directly to the page, it appears perfectly.

Due to security issues I cannot put the site or page URL in the forum as it contains highly sensitive data. I have emailed you the links for site and page respectively but would ask you to treat this with the strictest confidence. Thank you.

Usually you will get this error if there is an error in the PHP code. In this case, the settings.
Please check the server PHP log for errors.

Just to eliminate this but did you set the page extension to PHP in Page Properties?

Pablo

Just to keep the Forum up to date I would like to report you have solved all my issues with regard to presentation of MySQL data on the page by email. Thank you so much for your patience.

Final issue with page not displaying although I had set the page to PHP extension before raising this issue on the forum, I had not republished ALL pages so the menu was still calling for the html page. I also did not pick up that whilst I had added to ID field to the list I had not checked (ticked) the list view box in the CRUD Properties.

Thanks also WBBman for contribution.