php数组范围问题 - 从数组返回最后一行

问题描述：

I am changing mysqli connections to prepared statements, I always come across this issue, when I am putting values in an array, I'm wondering if someone could explain why I do this incorrectly every time. When I print the returned array from the function it only shows me the last stored values in the array, as opposed to every row in the array.

function getResults($db) {
    $statement = $db->prepare("SELECT inv_id, serial_num, equip_id, equip_title, equip_cat, input_date, date_modified FROM equip_inv");

    $statement->execute();
    $statement->store_result();
    $num_of_rows = $statement->num_rows;
    $statement->bind_result($invId, $serial, $equipId, $equipTitle, $equipCat, $inputDate, $dateMod);

    while ($statement->fetch()) {
        $resultArray = array();
        $resultArray['inv_id'] = $invId;
        $resultArray['serial_num'] = $serial;
        $resultArray['equip_id'] =  $equipId;
        $resultArray['equip_title'] = $equipTitle;
        $resultArray['equip_cat'] = $equipCat;
        $resultArray['input_date'] = $inputDate;
        $resultArray['date_modified'] = $dateMod;
    }

    return $resultArray;
}

我正在将mysqli连接更改为预处理语句，当我将值放入数组时，我总是遇到这个问题，我想知道是否有人可以解释为什么我每次都做错了。当我从函数中打印返回的数组时，它只显示数组中最后存储的值，而不是数组中的每一行。 p>

  function getResults（$ db）{
 $ statement = $ db-＆gt; prepare（“SELECT inv_id，serial_num，equip_id，equip_title，equip_cat，input_date，date_modified FROM equip_inv  “）; 
 
 $ statement-＆gt; execute（）; 
 $ statement-＆gt; store_result（）; 
 $ num_of_rows = $ statement-＆gt; num_rows; 
 $ statement-＆gt; bind_result（$ invId  ，$ serial，$ equipId，$ equipTitle，$ equipCat，$ inputDate，$ dateMod）; 
 
 while（$ statement-＆gt; fetch（））{
 $ resultArray = array（）; 
 $ resultArray [  'inv_id'] = $ invId; 
 $ resultArray ['serial_num'] = $ serial; 
 $ resultArray ['equip_id'] = $ equipId; 
 $ resultArray ['equip_title'] = $ equipTitle; 
 $  resultArray ['equip_cat'] = $ equipCat; 
 $ resultArray ['input_date'] = $ inputDate; 
 $ resultArray ['date_modified'] = $ dateMod; 
} 
 
返回$ resultArray; 
}  
  code>  pre> 
  div>

答

You're reseting $resultArray in each loop. You can create a new array $results = array(); and push $resultArray to it in each loop. Try :

function getResults($db){


$statement = $db->prepare("SELECT inv_id, serial_num, equip_id, equip_title, equip_cat, input_date, date_modified FROM equip_inv");

$statement->execute();
$statement->store_result();
$num_of_rows = $statement->num_rows;
$statement->bind_result($invId, $serial, $equipId, $equipTitle, $equipCat, $inputDate, $dateMod);
$results = array();

while ($statement->fetch()){
    $resultArray = array();
    $resultArray['inv_id'] = $invId;
    $resultArray['serial_num'] = $serial;
    $resultArray['equip_id'] =  $equipId;
    $resultArray['equip_title'] = $equipTitle;
    $resultArray['equip_cat'] = $equipCat;
    $resultArray['input_date'] = $inputDate;
    $resultArray['date_modified'] = $dateMod;
    $results[] = $resultArray;
    }
    return $results;
}

php数组范围问题 - 从数组返回最后一行

相关推荐