Outputting a select count(name) value in php pdo with mySql

Question

$stmt = $conn->prepare('select count(names) as names from names where names = :name');
$stmt->bindParam(':name', $name);
$stmt->execute();

How do I output the value of names when doing a select count() using PDO without having to use a while loop or something similar?

I need the count value of names (1, 3 or 5 or whatever it is).

A a somewhat funny related question http://stackoverflow.com/questions/16233323/why-is-pdo-fetchcolumn-not-working-here — Your Common Sense, May 03 '13 at 07:07

score 1 · Answer 1 · answered May 03 '13 at 06:48

1

The select count(..) from ..-Statement always only outputs this column (the count of rows), so you cannot access the names. You will have to execute a statement only for getting the names, OR you can actually output the name by yourself, because you already have it in $name ;)

answered May 03 '13 at 06:48

Florian Müller

7,448
25
78
120

I only need the count. Not the name. – Norman May 03 '13 at 06:49

score 1 · Accepted Answer · answered May 03 '13 at 06:52

1

$count = $stmt->fetchColumn();

fetchColumn()

answered May 03 '13 at 06:52

Nathan Q

1,892
17
40

1

`execute` returns boolean. This will trigger `Call to a member on a non-object` error. – Leri May 03 '13 at 06:55

Outputting a select count(name) value in php pdo with mySql

2 Answers2