COUNT returning array?

Question

I'm trying to get the number of images in each gallery by using the below query in a foreach statement

$total = $connect->query("SELECT COUNT(*) FROM photos WHERE gallery = '$row[id]'");

To print this out I'm then using $total[0] which returns Array - how do I retrieve the number?

query()-functions usually return a resource, not an array. Without knowing what kind of object $connect is, we can't know. — Langdi
– Langdi, Commented Aug 26, 2013 at 23:16
Whats echo '<pre>'.print_r($total,true).'</pre>'; look like? — Lawrence Cherone
– Lawrence Cherone, Commented Aug 26, 2013 at 23:18
@T.J.Crowder I use PDO prepare statements in my db class, that should protect me from 1st order injection right? I'm still getting the hang of MySQL etc. :L — JoshMc
– JoshMc, Commented Aug 26, 2013 at 23:37

Luis Tellez · Accepted Answer · 2013-08-26 23:19:20Z

2

Do this:

$total = $connect->query("SELECT COUNT(*) as nImages FROM photos WHERE gallery = '$row[id]'");

then you can read it like this

$total[0]["nImages"]

answered Aug 26, 2013 at 23:19

Luis Tellez

3,0331 gold badge23 silver badges30 bronze badges

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

Comments

Vahid Hallaji · Accepted Answer · 2013-08-26 23:24:15Z

1

if $connect is mysqli object:

$total = $connect->query("
    SELECT COUNT(*) AS `count` FROM photos WHERE gallery = '$row[id]'
")->fetch_assoc();

// $total['count']

Notice: Use PDO library and param binding to prevent sql injections.

edited Aug 26, 2013 at 23:24

answered Aug 26, 2013 at 23:19

Vahid Hallaji

7,5576 gold badges46 silver badges52 bronze badges

Comments

mezod · Accepted Answer · 2014-09-14 16:46:02Z

0

you can alternatively use fetchColumn instead of query

answered Sep 14, 2014 at 16:46

mezod

2,4113 gold badges23 silver badges31 bronze badges

Comments

William Howley · Accepted Answer · 2020-04-22 19:45:03Z

I had the same issue, and oddly enough the array key was the COUNT(*) text so I litterally have to reference it to get the value I wanted.

[allUsers] => Array
                (
                    [0] => Array
                        (
                            [COUNT(*)] => 606
                        )

                )

In order to access it I literally had to access the array key.

$selectResult[0]['COUNT(*)']; 

Array
(
    [savedInfo] => Array
        (
            [allUsers] => 606
        )

)

Only thing to note is, to program this strongly so you dont run into an error, when I am saving the data I look to see if the original response is an array or not. So not sure if this fix is dirty or not.

Collectives™ on Stack Overflow

COUNT returning array?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related