how to print counted sql query using php

Question

I try to count the event-code. What are the changes I need to do to achieve it?
Please help me with that.

My code:

$serverName = "IE3PDT1QJ67P4"; 
$connectionInfo = array( "Database"=>"TestEventsDB");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
 echo "Connection established.<br />";
}
else{
    echo "Connection could not be established.<br />";
    die( print_r( sqlsrv_errors(), true));
}
$sql = "SELECT count(EventCode)  FROM AlarmPointEvent where AlarmPoint=24001";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
  die( print_r( sqlsrv_errors(), true) );
}

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
  echo $row['EventCode']."<br>";
}

sqlsrv_free_stmt( $stmt);

?>

you should give the column a name with count(EventCode) AS EventCodeCount and then you can use $row['EventCodeCount'] — xander
– xander, Commented Mar 1, 2018 at 12:07

Zain Farooq · Accepted Answer · 2018-03-01 12:09:24Z

2

Do some change here

   $sql = "SELECT count(EventCode) as total_event FROM AlarmPointEvent where AlarmPoint=24001";

and here

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
  echo $row['total_event']."<br>";
}

answered Mar 1, 2018 at 12:09

Zain Farooq

2,9664 gold badges24 silver badges49 bronze badges

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

1 Comment

Zain Farooq Over a year ago

I glad that I am of your help

Siva · Accepted Answer · 2018-03-01 12:10:18Z

1

You will set a alies name for count,

$serverName = "IE3PDT1QJ67P4"; 
$connectionInfo = array( "Database"=>"TestEventsDB");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
 echo "Connection established.<br />";
}
else{
 echo "Connection could not be established.<br />";
 die( print_r( sqlsrv_errors(), true));
}
$sql = "SELECT count(EventCode) as eventcount  FROM AlarmPointEvent where AlarmPoint=24001";
 $stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
  die( print_r( sqlsrv_errors(), true) );
 }

while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
 echo $row['eventcount']."<br>";
}

sqlsrv_free_stmt( $stmt);

?>

answered Mar 1, 2018 at 12:10

Siva

1,5271 gold badge19 silver badges29 bronze badges

Collectives™ on Stack Overflow

how to print counted sql query using php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related