dongqian2021 2013-11-16 01:57
浏览 26
已采纳

PHP foreach行为$ var,行名和行号重复[duplicate]

This question already has an answer here:

I coded a simple function to loop trough and display all variables in the sql table. However foreach $row displays the rows two times, 1 time as a row name and 1 time as a row number.

1 : $row['NAME'] Name form

2 : $row[0]' Number form

PHP :

<?php

include "condetails.php";
$query = "select * from pagedetails";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
  foreach($row as $var => $val) {
    echo "VARNAAM :".$var;
    echo "<br />";
    echo "VALUE".$val;
    echo "<br />";
    echo "<br />";
  }
}

?>

OUTPUT :

VARNAAM :0 VALUE1

VARNAAM :id VALUE1

VARNAAM :1 VALUEdddd

VARNAAM :h1txt VALUEdddd

</div>
  • 写回答

3条回答 默认 最新

  • doukuang1897 2013-11-16 02:00
    关注

    It's displayed twice because mysql_fetch_array() grabs the column name and its number.

    If you want just the column names try using mysql_fetch_assoc(), keep in mind mysql_* functions are depreciated and you should be using PDO / MySQLi :)

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?