Creating 'Browse user' page

Question

I have a table for users already created so for example I will run a query which will SELECT * FROM users WHERE accType='1' and I am looking to run a foreach loop on the results and put each result into this element

<div class="title-desc-wrap col-xs-12 col-md-8">
<div class="title-wrap "><h4><a href="LINK TO USERS PROFILE">User Name</a></h4></div> 
<div class="excerpt-wrap">PROFILE PICTURE</div>
</div>

I want to restrict the page to only show 8 users on each page. How would I go about structuring this foreach loop in PHP?

The first part can be answered here - stackoverflow.com/questions/848905/… as for the pagination maybe this will help stackoverflow.com/questions/10742378/… and stackoverflow.com/questions/20366413/… — Nick R
– Nick R, Commented Mar 25, 2014 at 16:47
Just putting this out there accType='1' should be accType=1. — Eisa Adil
– Eisa Adil, Commented Mar 25, 2014 at 16:49

Braydos1986 · Accepted Answer · 2014-03-26 13:28:03Z

0

Not too sure on foreach but for a for loop, if you are placing the results into an array, you could;

<?php
for($count = 0; $count < 8; $count++) {
$holder = $array_name['$count'];
echo "<a href=LINK TO USERS PROFILE>". $holder['userName'] ."</a>";
echo "<div class=excerpt-wrap>". $holder['ProfilePic'] ."</div>";
}

then for the next page;

<?php
for($count = 8; $count < 16; $count++) {
$holder = $array_name['$count'];
echo "<a href=LINK TO USERS PROFILE>". $holder['userName'] ."</a>";
echo "<div class=excerpt-wrap>". $holder['ProfilePic'] ."</div>";
}

and so on, bit basic but it should work.

edited Mar 26, 2014 at 13:28

answered Mar 25, 2014 at 17:01

Braydos1986

1016 bronze badges

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

Collectives™ on Stack Overflow

Creating 'Browse user' page

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related