PHP SQL COUNT AND GET DATA

Just add a GROUP BY id:

SELECT id, COUNT(id)
FROM tblExample
GROUP BY id;

Demo

Update:

The query you posted:

SELECT count(id), id 
FROM tblExample;

Won't work in most of the RDBMS and it shouldn't. In SQL Server, you will got an error; saying that:

Column 'id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Strangely though, MySQL allow this(The OP didn't say what RDBMS he is using), and in this case, it will get an arbitrary value (this is also depends on an option to set), for the id column, and the COUNT in this case would be all the id's count.

But it is not recommended to do so.