I have nooby PHP question that I can't figure out!
I loop through rows from my database:
$data = array();
while($row = sqlsrv_fetch_array($queryResult, SQLSRV_FETCH_ASSOC)){
$data[] = $row;
}
$data now contains an array within an array how can I have it so that its still just a single array?
Thanks all
That's because each $row is an associative array. If you just want data to be an array of values from one column, specify that column:
$data = array();
while($row = sqlsrv_fetch_array($queryResult, SQLSRV_FETCH_ASSOC)){
$data[] = $row['column_name_you_want'];
}
$data you can always do something like this $data[0]['column_name'] to access column_name` in the first row, etc.
It a more obvious way:
$data = array();
while($row = sqlsrv_fetch_array($queryResult, SQLSRV_FETCH_NUMERIC){
$data = array_merge( $data, array_values($row) );
}
while($row = sqlsrv_fetch_array($queryResult, SQLSRV_FETCH_NUMERIC)) {This should get you all values returned from all columns and rows as a single dimension array
$data = array();
while($row = sqlsrv_fetch_array($queryResult, SQLSRV_FETCH_ASSOC)){
$values = array_values($row);
foreach($values as $value)
{
$data[] = $value;
}
}
while($row = sqlsrv_fetch_array($queryResult, SQLSRV_FETCH_ASSOC)) {I see this is an old question, but I was also looking for a solution to this. Came up with the following which works for me:
function mssql_query($conn, $query, array $bind = array()) {
$stmt = sqlsrv_query($conn, $query, $bind);
if( $stmt=== false ) {
// do something with the error information
// die(print_r(sqlsrv_errors(), true));
return array();
}
sqlsrv_execute($stmt);
$data = array();
while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
array_push($data, $row);
}
return $data;
}
Which can be used directly in a foreach loop:
foreach(mssql_query($conn, $query) as $row) {
echo $row['column'];
}
Or assigned to a variable for counting etc.
$conn is of course the connection (from PHP.net):
$serverName = "server.example.com"; // remember to append instance if applicable
$connectionInfo = array( "Database"=>"dbname", "UID"=>"username", "PWD"=>"password" );
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
