Page 1 of 1

Displaying results from a result set using PHP

Posted: Mon Feb 05, 2018 6:11 pm
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.

Re: Displaying results from a result set using PHP

Posted: Mon Feb 05, 2018 11:04 pm
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.

Re: Displaying results from a result set using PHP

Posted: Tue Feb 06, 2018 10:50 pm
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".

Re: Displaying results from a result set using PHP

Posted: Wed Feb 07, 2018 3:29 pm
by Magical
Thanks!!! I just saw that extension. Appreciate it. Do you have link for the Data Table?

Re: Displaying results from a result set using PHP

Posted: Wed Feb 07, 2018 3:36 pm
by BaconFries

Re: Displaying results from a result set using PHP

Posted: Fri Feb 09, 2018 3:08 pm
by Magical
This is great! Love the layouts in the mobile breakpoints.