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: 108
Joined: Thu Dec 14, 2017 5:08 pm
Contact:

Displaying results from a result set using PHP

Post by Magical » Mon Feb 05, 2018 6:11 pm

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: 108
Joined: Thu Dec 14, 2017 5:08 pm
Contact:

Re: Displaying results from a result set using PHP

Post by Magical » Mon Feb 05, 2018 11:04 pm

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: 92
Joined: Sun Apr 24, 2011 9:18 am
Location: UK

Re: Displaying results from a result set using PHP

Post by lummis » Tue Feb 06, 2018 10:50 pm

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: 108
Joined: Thu Dec 14, 2017 5:08 pm
Contact:

Re: Displaying results from a result set using PHP

Post by Magical » Wed Feb 07, 2018 3:29 pm

Thanks!!! I just saw that extension. Appreciate it. Do you have link for the Data Table?


User avatar
Magical
 
 
Posts: 108
Joined: Thu Dec 14, 2017 5:08 pm
Contact:

Re: Displaying results from a result set using PHP

Post by Magical » Fri Feb 09, 2018 3:08 pm

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

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 4 guests