PHP count row returns error

Question

i'm using the following to count the number of rows in my table:

$book_count = query("SELECT status FROM scifi_book WHERE read = $uid");
(count($book_count));
echo $book_count;

and i get the following error:

Notice:  Array to string conversion on line 167

(which is the line echo $book_count;)

FIY, the query function is defined and works fine. Never had any issues to insert, select, update and delete.

Am I missing something here?

What does query() return? And where does $follower_count in your question come from? — andrewsi
– andrewsi, Commented Jul 5, 2013 at 18:18
@andrewsi this was a mistake when i copy pasted my code.Just edited it. — Caro_deb
– Caro_deb, Commented Jul 5, 2013 at 18:22

Brian · Accepted Answer · 2013-07-05 18:20:25Z

2

Try this:

$book_count = query("SELECT status FROM scifi_book WHERE read = $uid");
echo count($book_count);

Also, you need to use print_r($book_count) since your $book_count is not a string.

answered Jul 5, 2013 at 18:20

Brian

5,0288 gold badges42 silver badges60 bronze badges

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

4 Comments

Racso Over a year ago

I don't understand the last statement (use print_r because $book_count is not a string). May you elaborate, please?

Racso Over a year ago

Ah, got it. He also echoes the variable content; didn't see that before.

Brian Over a year ago

@Racso: you use echo for strings, $book_count is an array object returning query results. To echo array use print_r

Caro_deb Over a year ago

Thanks, works like a charm ! I'll be able to accept your answer in 6 minutes

Racso · Accepted Answer · 2013-07-05 18:26:50Z

2

Suggestion: if you only use that query for getting the count, this may be a bit better:

$book_count = query("SELECT count(*) FROM scifi_book WHERE read = $uid");

answered Jul 5, 2013 at 18:26

Racso

2,4691 gold badge20 silver badges24 bronze badges

Comments

Nathaniel Granor · Accepted Answer · 2013-07-05 18:21:13Z

1

your query function seems to return an array, not a string. Instead of echo $follower_count use print_r($follower_count) to see what's inside the query response.

answered Jul 5, 2013 at 18:21

Nathaniel Granor

3261 silver badge9 bronze badges

Comments

vee · Accepted Answer · 2013-07-05 18:26:57Z

1

The reason you are seeing that error is because you are echoing Array which is the returned by your query function. echo construct only works on strings, please see the documentation here: http://www.php.net/manual/en/function.echo.php.

Had you used print_r or var_dump then you wouldn't have seen that error. So as @A.S. Roma and Nathaniel Granor suggest use print_r

answered Jul 5, 2013 at 18:26

vee

38.7k7 gold badges76 silver badges80 bronze badges

Comments

Sysrq147 · Accepted Answer · 2013-07-05 18:28:16Z

1

$book_count = query("SELECT status FROM scifi_book WHERE read =".$uid);
(count($book_count));
echo $book_count;

answered Jul 5, 2013 at 18:28

Sysrq147

1,3674 gold badges28 silver badges49 bronze badges

Collectives™ on Stack Overflow

PHP count row returns error

5 Answers 5

4 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related