Getting number of rows in a sql server table using php

Question

I am trying get the number of rows (or number of primary keys) in a table using PHP and then outputting the result in to a webpage. I am new to SQL server and this wouldn't give me any results

//code above omitted and connected to the database
$query_count = "SELECT COUNT(*) FROM ElectronicShop";
$data_count = sqlsrv_query($connectString, $query_count) or die(print_r(sqlsrv_errors(SQLSRV_ERR_ALL), true));
//$row_count = sqlsrv_fetch_row($data_count);
echo "<br>ROW COUNT:".sqlsrv_fetch_object($data_count)."<br>";

Perhaps RTFMing would help: php.net/sqlsrv_fetch_object. You're fetching an OBJECT representing a row of results from your query, not the actual value of the count you did. Since you're fetching an object, your echo is trying to output that object, and will fail since whatever class that object is, it won't have a toString()-type auto method. — Marc B
– Marc B, Commented Jul 21, 2014 at 14:34

Syscall · Accepted Answer · 2022-01-16 10:05:58Z

2

Maybe

//code above omitted and connected to the database
$query_count = "SELECT COUNT(*) AS myCounter FROM ElectronicShop";
$data_count = sqlsrv_query($connectString, $query_count) or die(print_r(sqlsrv_errors(SQLSRV_ERR_ALL), true));
//$row_count = sqlsrv_fetch_row($data_count);
$row = sqlsrv_fetch_object($data_count);
echo "<br>ROW COUNT:".$row->myCounter."<br>";

From the doc: https://php.net/sqlsrv-fetch-object

edited Jan 16, 2022 at 10:05

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

answered Jul 21, 2014 at 14:38

ImmortalPC

1,7001 gold badge14 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Getting number of rows in a sql server table using php

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related