PHP Display Data In Horizontal Style From MySql

Question

I am trying to display all my site members info with avatar and some information in members page of my WordPress site.For this, I have written following code.It is displaying data with one single user in a row.What I am trying is to display multiple users like 4 to 5 members horizontally in a single row then start 2nd row similar like this https://stackoverflow.com/users Following is my code.how can achieve this

 <?php

    global $wpdb;
    $result = $wpdb->get_results( "SELECT id,display_name as pt,user_registered as re FROM wp_users  group by id"); /*mulitple row results can be pulled from the database with get_results function and outputs an object which is stored in $result */

    foreach($result as $row)
    {
     echo '<table><tr>';      
     echo '<td>'.get_avatar( $row->id,40 );
     echo '</td><td>'.$row->id."  ".$row->pt. "<br>" .$row->re. "</td></tr> 
    </table>";

    }

 ?>

I would recommend using css flexbox instead of using tables. Then you can make it responsive by making it wrap and much much more. Here's a pretty extensive guide: css-tricks.com/snippets/css/a-guide-to-flexbox — M. Eriksson
– M. Eriksson, Commented Nov 1, 2017 at 7:02
The query is nonsensical so one has to reject the premise of the question — Strawberry
– Strawberry, Commented Nov 1, 2017 at 7:40

julianstark999 · Accepted Answer · 2017-11-01 07:08:30Z

1

I prefer to solve the problem by using an count and define a fixed number of columns.

<?php

    global $wpdb;
    $result = $wpdb->get_results( "SELECT id,display_name as pt,user_registered as re FROM wp_users  group by id"); /*mulitple row results can be pulled from the database with get_results function and outputs an object which is stored in $result */

    $count = count($result);
    $columns = 5;

    echo '<table><tr>';

    foreach($result as $i => $row) {
        echo '<td>' . get_avatar( $row->id,40 ) . '</td>';
        echo '<td>' . $row->id . '  ' . $row->pt . '<br>' . $row->re . '</td>';

        $i++;
        if($i != $count && $i >= $columns && $i % $columns == 0)
            echo '</tr><tr>';
    }

    echo '</tr></table>';

?>

answered Nov 1, 2017 at 7:08

julianstark999

3,6241 gold badge30 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ritesh Khatri · Accepted Answer · 2017-11-01 07:18:06Z

0

Try with this,

<?php
global $wpdb;
$result = $wpdb->get_results( "SELECT id,display_name as pt,user_registered as re FROM wp_users  group by id");

?>

<div class="container">
<?php foreach($result as $row) { ?>
<div class="row">
  <div class="col-lg-3">
     <?php get_avatar( $row->id,40 ); ?><br>
     <?php echo $row->id." ".$row->pt;?><br>
     <?php echo $row->re;?>
  </div>
</div>
<?php } ?>
</div>

answered Nov 1, 2017 at 7:18

Ritesh Khatri

1,31115 silver badges30 bronze badges

Collectives™ on Stack Overflow

PHP Display Data In Horizontal Style From MySql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related