How can you count rows when in while loop?

Question

0.00/5 (No votes)

See more:

Hi when i run a rowCount() it gives me a seperate count, how can i do count for EVERYTHING thats displayed?
For example, the while loop is looping through lots of 'words' and displaying necessary information regarding this, when i do rowCount, it will print the row count for that particular word on each item displaying

What i want is to have a rowCount of HOW many items are being displayed?

This is how its displaying:

ITEM 1 | - information | & then row count of word in DB e.g 3
ITEM 2 | - information | & then row count of word in DB e.g 2

What I have tried:

while($dbRow=$dbQuery->fetch(PDO::FETCH_ASSOC))  
    {
		   echo $dbQuery->rowCount()."\n"; // ROW COUNT
            echo "".$dbRow["Name"].""."<br><img src=Breakfast/".$dbRow['
Picture']."' width='150' height='150' />"."".$dbRow["Instructions"]."<input type='submit' name='submit' value='Completed' class='button-recipe'>";
 }
	}

Posted 29-Mar-18 14:00pm

Member 13637584

Updated 30-Mar-18 4:28am

Add a Solution

Comments

Richard MacCutchan 30-Mar-18 4:50am

Your question is not clear; exactly what are you trying to count?

Member 13637584 30-Mar-18 15:05pm

Hi, i want a count of how many actual rows are being displayed?

Richard MacCutchan 31-Mar-18 3:48am

Being displayed where?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

W∴ Balboos, *GHB* · Answer 1 · 2018-03-30T04:30:00

If you need to count in a do, while, or foreach loop, you need your own counter.

More than likely, you'll need the results of the count outside of the loop, so it must have a scope outside the loop. In general, then, you count as follows:

PHP

int i = 0;  // this is your counter
aLoop {
 // do what you need to do, then
  i++;   // count what you need to count;
 // continue with your loop or leave it.
} // end of aLoop

As you go through such a loop, you can count more than one thing. How should be obvious to you.