对于每个数组中的PHP [英] For each in Array PHP
问题描述
我想一个PHP文件中的回声出在我的阵列中的每个日期。现在我的code是
的foreach($ result_array为$日期){
回声$日期;
}
这导致
ArrayArrayArrayArrayArrayArray
如何修改我的code键来显示每个日期而不是阵列?
的修改的
我建立的阵列,像这样......
$ result_array =阵列();
$ result_set =的mysql_query(SELECT DISTINCT`saledate` FROM`phoneappdetail` WHERE salebarn ='OSI'); 而($行= mysql_fetch_array($ result_set)){
$ result_array [] = $行;
}
它打印数组,因为 $日期
为阵,修改你的脚本是这样的:
的foreach($ result_array为$日期){
回声的$ date ['saledate'];
}
了解更多关于 mysql_fetch_array 是如何工作的,则返回数组(索引,联想或两者),所以你需要选择你要使用的字段。
手动注意:
这个扩展的使用气馁。取而代之的是,库MySQLi或PDO_MYSQL
分机应该被使用。另请参见MySQL的:选择一个API指南和
有关详细信息,相关FAQ。替代这个功能
包括:
mysqli_fetch_array()
PDOStatement对象::获取()
块引用>I want to echo out each date in my Array within a PHP file. Right now my code is
foreach ($result_array as $date) { echo $date; }
which results in
ArrayArrayArrayArrayArrayArray
How can I modify my code to show each date rather then Array?
EDIT
I'm building the array like so...
$result_array = array(); $result_set = mysql_query("SELECT DISTINCT `saledate` FROM `phoneappdetail` WHERE salebarn = 'OSI'"); while ( $row = mysql_fetch_array($result_set) ) { $result_array[] = $row; }
解决方案It prints Array because
$date
is array, modify your script like this:foreach ($result_array as $date) { echo $date['saledate']; }
Read more on how mysql_fetch_array works, it returns array (indexed, associative or both), so you need to choose which field you want to use.
Note from manual:
Use of this extension is discouraged. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
mysqli_fetch_array()
PDOStatement::fetch()
这篇关于对于每个数组中的PHP的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!