Getting only 1 as row count in php

Question

Is there any mistake in this code ? or my error is somewhere else .

$conn = mysqli_connect("localhost","root","root","sajan")
or die("Unable to connect to MySQL");   
$sql_count = "SELECT count(*) FROM user";
$result = $conn->query($sql_count);
$total_row = $result_count->num_rows;

Your query returns exactly one row, the first column of which is the count of rows in the table. You need to `fetch` the row and read the column. — , Mar 20 '15 at 06:26
because you are calculating count, obviously you will get a single row containing the count — Kuldeep Dangi, Mar 20 '15 at 06:26

score 1 · Answer 1 · answered Mar 20 '15 at 06:27

1

Yes count will aggregate and give you only 1 value,You need to do this instead

$sql_count = "SELECT count(*) as total FROM user";
$result = $conn->query($sql_count);
$arrayresult = $result->fetch_array();
echo $arrayresult['total]

answered Mar 20 '15 at 06:27

rahulinaction

344
4
14

score 0 · Answer 2 · answered Mar 20 '15 at 06:30

if you need both data and results count you must use this

$conn = mysqli_connect("localhost","root","root","sajan")
or die("Unable to connect to MySQL");   
$sql_count = "SELECT * FROM user";
$result = $conn->query($sql_count);
$total_row = $result->num_rows;

if you just need the count rahul solution is good and optimal that is

$sql_count = "SELECT count(*) as total FROM user";
$result = $conn->query($sql_count);
$arrayresult = $result->fetch_array();
echo $arrayresult['total]

score -3 · Answer 3 · edited Feb 01 '21 at 18:25

-3

$conn = mysqli_connect("localhost","root","root","sajan")
or die("Unable to connect to MySQL");   
$sql_count = "SELECT count(*) FROM user";
$result = $conn->query($sql_count);
$total_row = $result->num_rows;

will do the trick, you're referencing $result_count; which is not set.

edited Feb 01 '21 at 18:25

Dharman

30,962
25
85
135

answered Mar 20 '15 at 06:27

WongFaiHung

76
3

you point it right but it still will result a single row. because its calculating the count not data in query – Kuldeep Dangi Mar 20 '15 at 06:28

Getting only 1 as row count in php

3 Answers3