Issue with counting rows using MySQLi

Question

When trying to execute my MYSQLi statement that's supposed to count rows. I don't get an error when I do a query but when I try and echo the result, it just breaks the html lines below the echo.

Here is my code:

$db = doDB();
$sql = "SELECT COUNT(*) From `Keys`";
$stmt = $db->query($sql)->fetchColumn();

doDB() Function:

function doDB() {
 $dbHost = 'localhost';
 $dbName = '';
 $dbUser = '';
 $dbPass = '';

 $db = new mysqli($dbHost, $dbUser, $dbPass, $dbName);
 return $db;
}

devpro · Accepted Answer · 2016-01-29T08:18:48.483

1

After long discussion you can get count like that:

$result = $db->query("SELECT COUNT(*) From `Keys`");
$row = $result->fetch_row();
echo $row[0];

Note that this credit goes to @deceze.

edited Jan 29 '16 at 08:18

answered Jan 29 '16 at 08:17

devpro

16,184
3
27
38

1

Some error handling would be nice, but yeah.... – VolkerK Jan 29 '16 at 08:17
This works. Thank you. Sorry for all the confusion. – stat.us Jan 29 '16 at 08:21
@stat.us: also say thanks to deceze who suggest u to show your connection function. :) – devpro Jan 29 '16 at 08:22

Issue with counting rows using MySQLi

1 Answers1