blocks|key|834848|text|在使用while循环迭代时构建一个数组。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|834849|$result+=+mysql_query("SELECT+*+FROM+`Departments`");
$results+=+array();
while($row+=+mysql_fetch_assoc($result))
{
+++$results[]+=+$row;
}|code-block|syntax|javascript|834850|或者，如果您使用的是PDO，则可以使用do+this+automatically。|834851|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/book.pdo.php|1|http://php.net/manual/en/pdostatement.fetchall.php^0|3|5|0|0|A|3|0|J|L|1|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|D|@$9|11|A|12|1|13]|$9|14|A|15|1|16]]|E|$]]|$1|M|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]|U|$5|P|Q|R|E|$S|V]]]]

Build an array up as you iterate with the <code>while</code> loop.

<pre><code>$result = mysql_query("SELECT * FROM `Departments`");
$results = array();
while($row = mysql_fetch_assoc($result))
{
 $results[] = $row;
}
</code></pre>

Alternatively, if you used <a href="http://php.net/manual/en/book.pdo.php" rel="noreferrer">PDO</a>, you could <a href="http://php.net/manual/en/pdostatement.fetchall.php" rel="noreferrer">do this automatically</a>.

blocks|key|619326|text|这将会起到作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|619327|$rows+=+array();
$result+=+mysql_query("SELECT+*+FROM+`Departments`");
while($row+=+mysql_fetch_assoc($result))
{
++$rows[]+=+$row;
}|code-block|syntax|javascript|619328|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This will do the trick:

<pre><code>$rows = array();
$result = mysql_query("SELECT * FROM `Departments`");
while($row = mysql_fetch_assoc($result))
{
 $rows[] = $row;
}
</code></pre>

blocks|key|619369|text|这是我创建(多维)数组最快的方法之一。我不确定您是否希望将所有结果平滑到一个数组中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|619370|//+Read+records
$query+=+"SELECT+*+FROM+`Departments`";+
$query+=+mysql_query($query);

//+Put+them+in+array
for($i+=+0;+$array[$i]+=+mysql_fetch_assoc($query);+$i%2B%2B)+;

//+Delete+last+empty+one
array_pop($array);|code-block|syntax|javascript|619371|您可以使用print_r($array)查看结果。|619372|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This has been one of the fastest ways for me to create (multi-dimensional) arrays. I'm not sure if you want all of your results smooshed into one array or not. 

<pre><code>// Read records
$query = "SELECT * FROM `Departments`"; 
$query = mysql_query($query);

// Put them in array
for($i = 0; $array[$i] = mysql_fetch_assoc($query); $i++) ;

// Delete last empty one
array_pop($array);
</code></pre>

You can use print_r($array) to see the results.

blocks|key|619403|text|我的最爱如下；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|619404|$result=odbc_exec($conn,$sql);
if+($result)+{
++++while($found_results[]+=+odbc_fetch_array($result))+{+}+
++++array_pop($found_results);+//pop+off+the+empty+line+from+while+loading
}|code-block|syntax|javascript|619405|你不需要弹出最后一行，但是如果你省略它，它会留下一个空格。显然，mysql也是如此。|619406|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

my fav is the following;

<pre><code>$result=odbc_exec($conn,$sql);
if ($result) {
 while($found_results[] = odbc_fetch_array($result)) { } 
 array_pop($found_results); //pop off the empty line from while loading
}
</code></pre>

you dont need to pop the last line, but it does leave a blank if you omit it.
works the same for mysql obviously.

blocks|key|619426|text|如果您的Departments表中有多个列，并且希望保存在不同的数组中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|619427|$result+=+mysql_query("SELECT+*+FROM+`Departments`");
$dept_id+=+array();
$dept_name=array();
while($row+=+mysql_fetch_assoc($result))
{
//fetches+and+store+all+results+in+id+column+on+your+departments+table
$dept_id=+$row['id'];
//fetches+and+store+all+results+in+name+column+on+your+departments+table++++
$dept_name=$row['name'];
}|code-block|syntax|javascript|619428|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you have multiple columns in your Departments table and you want to save in different array.

<pre><code>$result = mysql_query("SELECT * FROM `Departments`");
$dept_id = array();
$dept_name=array();
while($row = mysql_fetch_assoc($result))
{
//fetches and store all results in id column on your departments table
$dept_id= $row['id'];
//fetches and store all results in name column on your departments table 
$dept_name=$row['name'];
}
</code></pre>

If I am fetching data from a MySQL database and using a while loop to iterate through the data how would I add each one to array?

<pre><code>$result = mysql_query("SELECT * FROM `Departments`");
while($row = mysql_fetch_assoc($result))
{

}
</code></pre>

Populate PHP Array from While Loop

SQL数据库

数据库

MySQL

如果我从MySQL数据库获取数据，并使用while循环遍历数据，我如何将每个数据添加到数组中？$result = mysql_query("SELECT * FROM `Departments`");while($row = mysql_fetch_assoc($result)){}

问从While循环填充PHP数组
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从While循环填充PHP数组EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从While循环填充PHP数组
EN