ODBC，PHP while循环将数据分配给数组

问题描述：

I want to loop though my query and assign each data field to an array.

 $query ="SELECT * FROM Reservations WHERE Room_ID = '145' ";

    $result = odbc_exec($connect,$query);
     while(odbc_fetch_row($result)){
      $reservation = odbc_result($result, 1);
      $reservation2 = odbc_result($result, 2);
      $reservation3 = odbc_result($result, 3);
      $reservation4 = odbc_result($result, 4);

     }

What I am trying to do is

$content = array(); 
while($info = mysql_fetch_array($result))
{
$content[] = $info;
}

I guess I could check to see the total number of rows and then just do a for loop that increments the $result.

我想循环查询并将每个数据字段分配给一个数组。 p>

  $ query =“SELECT * FROM Reservations WHERE Room_ID ='145'”; 
 
 $ result = odbc_exec（$ connect，$ query）; 
 while（odbc_fetch_row（$ result））{\  n $ reservation = odbc_result（$ result，1）; 
 $ reservation2 = odbc_result（$ result，2）; 
 $ reservation3 = odbc_result（$ result，3）; 
 $ reservation4 = odbc_result（$ result，4）  ; 
 
} 
  code>  pre> 
 
 我要做的是 p> 
 
 
  $ content = array（）  ;  
while（$ info = mysql_fetch_array（$ result））
 {
 $ content [] = $ info; 
} 
  code>  pre> 
 
 我想我可以查看 查看总行数，然后只做一个增加$ result的for循环。 p> 
  div>

答

I think you're looking for odbc_fetch_array.

while ($info = odbc_fetch_array($result)) {
    $content[] = $info;
}

ODBC，PHP while循环将数据分配给数组

相关推荐