Fetch multiple records from php/mysql

Question

I am fetching records as follows:

$aResult = array();
$sql     = "SELECT notes FROM table WHERE user_id = '$user_id'";
$result  = $conn->query($sql);

while($row = mysqli_fetch_array($result)){
    $aResult['query_result'] = $row;
}

This returns only the last record in the table. I need to return all records from the sql statement.

Answer 1

change you $aResult['query_result'] = $row; to $aResult['query_result'][] = $row;

You've override the result each time, so you just get one.

Answer 2

It seems your loop constantly overwrites the value and hence you will only ever seen the last row. I think you might see better results if you do something like:

while($row = mysqli_fetch_array($result))
{
    $aResult[] = $row;
}

so that each new row gets appended to your array

Answer 3

Try with following code, currently You are initiating the values to the same array key :

$aResult = array();
$sql     = "SELECT notes FROM table WHERE user_id = '$user_id'";
$result  = $conn->query($sql);

while($row = mysqli_fetch_array($result)){
    $aResult['query_result'][] = $row;
}

for more Detail On Array