将表的记录作为数组获取php mySQL [关闭]

问题描述：

The query is:

How can I fetch the abbr from manualtab into an array. Code:

 $connection = mysql_connect('localhost', 'root', '') or die ('Unable to connect!');
 mysql_select_db('mydb') or die ('Unable to select database!');
 $query = 'SELECT abbr FROM manualtab';
 $result = mysql_query($query) or die ('Error in query');
 $row = mysql_fetch_row($result);

查询是： p>

如何将abbr从manualtab提取到数组。代码： p>

  $ connection = mysql_connect（'localhost'，'root'，''）或die（'无法连接！'）; 
 mysql_select_db（'mydb'  ）或死（'无法选择数据库！'）; 
 $ query ='SELECT abbr FROM manualtab'; 
 $ result = mysql_query（$ query）或die（'查询错误'）; 
 $ row =  mysql_fetch_row（$ result）; 
  code>  pre> 
  div>

答

$array = array();
while ($row = mysql_fetch_row($result))
{
  $array[] = $row;
}

答

If you mean, fetching every abbr in an array, then:

$abbr = array();
while ($row = mysql_fetch_row($result))
{
    $abbr[] = $row[0];
}

is a way to do it.

答

That does the job, unless you want to fetch all values, in which case you'll need to loop:

 $connection = mysql_connect('localhost', 'root', '') or die ('Unable to connect!');
 mysql_select_db('mydb') or die ('Unable to select database!');
 $query = 'SELECT abbr FROM manualtab';
 $result = mysql_query($query) or die ('Error in query');
 $row_list = array();
 while($row = mysql_fetch_assoc($result)) {
   $row_list[] = $row;
 }

 var_dump($row_list);
     /* row_list now contains:
     array(
        array( 'abbr' => ... ),
        array( 'abbr' => ... ),
        array( 'abbr' => ... ),
            ...
     ) */

将表的记录作为数组获取php mySQL [关闭]

相关推荐