Echo数组行作为变量sqlserver

Question

I have a problem that I think i understand the issue but I'm stuck for a resolution.

I have a sql query running in PHP as follows:

$sql = "select COUNT(*) From dbo
Where dbo.table.STATUS < 4";

$Backlog = sqlsrv_query($conn,$sql);
if( $Backlog === false) {
    die( print_r( sqlsrv_errors(), true) );
}
while( $Row = sqlsrv_fetch_array( $Backlog, SQLSRV_FETCH_NUMERIC) ) {
      echo $Row[0];
}

My connection to the source is fine and if I put this out via a basic PHP page I get the result of the query printed on the page.

However, I'm trying to call $Backlog on a different page with some CSS formatting:

<?php echo "<div class =second_row_label>Incident Back Log</div><div class =top_num>".$Backlog."</div></div></a>"; ?>

And it's here I'm getting the Resource ID #x error.

From scanning the various pages I believe $Backlog is my resource so the question is, how can I call the result as the variable $Backlog on the second sheet?

Answer 1

If I understand your question correctly I think sessions will solve your problem.

Store your values to $_SESSION variables. You can then use those $_SESSION variable on any page that includes session_start()