Displaying results from a result set using PHP

This section is for posting questions which are not directly related to WYSIWYG Web Builder.
Examples of off topics: web server configuration, hosting, programming related questions, third party scripts.

Note that these questions will generally not be answered by the administrators of this forum.
Post Reply
User avatar
Magical
 
 
Posts: 111
Joined: Thu Dec 14, 2017 5:08 pm
Contact:

Displaying results from a result set using PHP

Post by Magical »

Greetings

Looking for tips on displaying the result of a mysql view where the number of records returned can vary. I can use echo and do the field by field but I have a membership list and need to display the names of all the selected members and they keep growing.
User avatar
Magical
 
 
Posts: 111
Joined: Thu Dec 14, 2017 5:08 pm
Contact:

Re: Displaying results from a result set using PHP

Post by Magical »

Figured it out. Construct the final string in PHP and the <br>
Use a textbox with the "Do not encode HTML characters," enabled.
in the textbox simply add the <?php echo $constructed_string;?>
Give it enough room to grow and you can show table data.
lummis
 
 
Posts: 211
Joined: Sun Apr 24, 2011 9:18 am
Location: UK

Re: Displaying results from a result set using PHP

Post by lummis »

Or you could use the Dataviewer extension - or the Responsive Data Table (paid for) extension. For a membership list it is also possible to get the output in alphabetical order if your MySQL table have been set up with a "lastname" field, by using the filter in the extension and inserting "lastname IS NOT NULL ORDER BY lastname".
User avatar
Magical
 
 
Posts: 111
Joined: Thu Dec 14, 2017 5:08 pm
Contact:

Re: Displaying results from a result set using PHP

Post by Magical »

Thanks!!! I just saw that extension. Appreciate it. Do you have link for the Data Table?
User avatar
Magical
 
 
Posts: 111
Joined: Thu Dec 14, 2017 5:08 pm
Contact:

Re: Displaying results from a result set using PHP

Post by Magical »

This is great! Love the layouts in the mobile breakpoints.
Post Reply