Get number of rows in SQL-Server with PHP

Question

I am fairly new to SQL-Server and PHP, but I'm trying to get the total number of rows in my table with PHP.

This is the code I am using, it connects just fine, however it won't print the number of rows:

<?php
$serverName = "SERVER1\SQLEXPRESS";
$connectionInfo = array( "Database"=>"petitionlist");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false )
{
     ?>
        <b>Error: </b>Could not connect to the server database.
     <?php
     die( print_r( sqlsrv_errors(), true));
}
$tsql = "Select Count(*) from SignatureTable";
$stmt = sqlsrv_query( $conn, $tsql);
if( $stmt === false )
{
     ?>
     <b>Error: </b>
     <?php
     die( print_r( sqlsrv_errors(), true));
}
    ?>
    <b>Result:</b><br />
    <?php
print_r(sqlsrv_fetch_object($stmt));

sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);
?>

If I execute the "Select Count(*) from SignatureTable" command on the SQL Server Studio it returns the correct number. So It's not my server, it's my code.

What does that code print? What happens if you give that result field an alias (which is definitely a good idea to make addressing that field easier)? — user1233508
– user1233508, Commented Sep 9, 2012 at 6:16

petrosg · Accepted Answer · 2012-09-09 07:06:20Z

3

I believe that your call to

print_r(sqlsrv_fetch_object($stmt));

might be wrong. At least looking at the documentation in regards to how the call is made, indicates that there might be an error there.

http://www.php.net/manual/en/function.sqlsrv-fetch-object.php

You might want to try using fetch instead of fetch-object. I would suggest following the example.

http://www.php.net/manual/en/function.sqlsrv-fetch.php

answered Sep 9, 2012 at 7:06

petrosg

1181 silver badge6 bronze badges

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

Comments

Shahzad Barkati · Accepted Answer · 2016-12-21 01:09:42Z

2

Check it:

http://www.php.net/manual/es/function.sqlsrv-num-rows.php

"sqlsrv_num_rows() — Retrieves the number of rows in a result set"

Like:

$row_count = sqlsrv_num_rows( $stmt);
echo 'numRows: ',$row_count;

edited Dec 21, 2016 at 1:09

Shahzad Barkati

2,5506 gold badges28 silver badges34 bronze badges

answered Sep 9, 2012 at 5:52

Eduar Carvajal

412 bronze badges

1 Comment

user1233508 Over a year ago

Are you really suggesting to do a SELECT * just to see the row count?

Collectives™ on Stack Overflow

Get number of rows in SQL-Server with PHP

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related