我也不知道是什么问题,
我有个数组(从数据库中取出来的)
Array
(
[0] => 2
[testconment_id] => 2
[1] =>
[testconment_userid] =>
[2] => 2
[testconment_testid] => 2
[3] =>
[testconment_typeid] =>
[4] =>
[testconment_flag] =>
[5] => 你好啊啊啊啊
[testconment_content] => 你好啊啊啊啊
[6] => 2012-05-02 05:25:03
[testconment_date] => 2012-05-02 05:25:03
)通过循环取值
foreach($commentList as $v){
$commentTemp["id"]=$v["testconment_id"];
$commentTemp["userid"]=$v["testconment_userid"];
$commentTemp["testid"]=$v["testconment_testid"];
$commentTemp["typeid"]=$v["testconment_typeid"];
$commentTemp["flag"]=$v["testconment_flag"];
$commentTemp["content"]=$v["testconment_content"];
$commentTemp["date"]=$v["testconment_date"];
array_push($commentArray,$commentTemp);
}
我将$commentArray打印出来
Array
(
[0] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
[1] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
[2] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[3] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[4] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
[5] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
[6] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[7] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[8] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[9] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[10] => Array
(
[id] => ?
[userid] => ?
[testid] => ?
[typeid] => ?
[flag] => ?
[content] => ?
[date] => ?
)
[11] => Array
(
[id] => ?
[userid] => ?
[testid] => ?
[typeid] => ?
[flag] => ?
[content] => ?
[date] => ?
)
[12] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
[13] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
)
成这样了!!是怎么回事啊!!
我有个数组(从数据库中取出来的)
Array
(
[0] => 2
[testconment_id] => 2
[1] =>
[testconment_userid] =>
[2] => 2
[testconment_testid] => 2
[3] =>
[testconment_typeid] =>
[4] =>
[testconment_flag] =>
[5] => 你好啊啊啊啊
[testconment_content] => 你好啊啊啊啊
[6] => 2012-05-02 05:25:03
[testconment_date] => 2012-05-02 05:25:03
)通过循环取值
foreach($commentList as $v){
$commentTemp["id"]=$v["testconment_id"];
$commentTemp["userid"]=$v["testconment_userid"];
$commentTemp["testid"]=$v["testconment_testid"];
$commentTemp["typeid"]=$v["testconment_typeid"];
$commentTemp["flag"]=$v["testconment_flag"];
$commentTemp["content"]=$v["testconment_content"];
$commentTemp["date"]=$v["testconment_date"];
array_push($commentArray,$commentTemp);
}
我将$commentArray打印出来
Array
(
[0] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
[1] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
[2] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[3] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[4] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
[5] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
[6] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[7] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[8] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[9] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
[10] => Array
(
[id] => ?
[userid] => ?
[testid] => ?
[typeid] => ?
[flag] => ?
[content] => ?
[date] => ?
)
[11] => Array
(
[id] => ?
[userid] => ?
[testid] => ?
[typeid] => ?
[flag] => ?
[content] => ?
[date] => ?
)
[12] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
[13] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] => 2
[flag] => 2
[content] => 2
[date] => 2
)
)
成这样了!!是怎么回事啊!!
你用循环得到有14个元素的二维数组是正确的,虽然不是你期望的去掉循环就对了
Array
(
[0] => Array
(
[id] => 2
[userid] => 2
[testid] => 2
[typeid] =>
[flag] =>
[content] => 你好啊啊啊啊
[date] => 2012-05-02 05:25:03
)
)
去掉循环, 就成这种了
Array
(
[0] => Array
(
[id] =>
[userid] =>
[testid] =>
[typeid] =>
[flag] =>
[content] =>
[date] =>
)
)
$commentTemp["id"] = $commentList["testconment_id"];
.....也可以
$v = $commentList;
$commentTemp["id"] = $v["testconment_id"];
.....
不知道怎么弄啊!!! public function querySql($sql){
$data_array = parse_ini_file("database.ini",true);
$connect = @mysql_connect($data_array["url"],$data_array["username"],$data_array["pass"]) or die ("Unable to connect database server!");
mysql_query("set names '".$data_array["incode"]."'");
$query = mysql_db_query($data_array["basename"],$sql ,$connect);
$arrary;
if(!$query){
echo "数据库连接错误";
}else{
$arrary = mysql_fetch_array($query);
}
$close = @mysql_close($connect) or die ("Unable to close database server connect!");
return $arrary;
}
这个数我的数据库代码,我取出的始终只有一条数据!!
else{
while($arrary = mysql_fetch_array($query,MYSQL_ASSOC)){
$arr[]=$arrary;
}
}
......
return $arr;
}