FOR in php and sqlsrv

Question

FOR in php and sqlsrv

Navigation

#1 by (3 votes)

0

I have to make a FOR in PHP using SQLSRV. I'm using the penultimate version of PHP and not the last one, as I can not update PHP.

php sql-server

asked by anonymous 05.11.2014 / 17:32

1 answer

Permission of files in Linux How do I make a query to return the value of another table? [duplicate]

score 3 · Accepted Answer

Something you can use is sqlsrv_fetch_array

$sql = "SELECT FirstName, LastName FROM SomeTable";
$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['LastName'].", ".$row['FirstName']."<br />";
}