douchigu1723 2016-07-10 17:28
浏览 62


//Called at start of page
while( $row = mysqli_fetch_assoc($result)){
    $dataset[] = $row;

//Called in middle of page, inside <table><tbody>
$dSize = count($dataset);
for( $i = 0; $i < $dSize; $i++){
//foreach($dataset as $row){
    $row = $dataset[$i];
    $thisIsId = true;
    echo "<tr>";
    $rSize = count($row);
    for( $j = 0; $j < $rSize; $j++){
    //foreach($row as $value){
        $value = $row[$j];
        //Next line output ex: <td id='r1c2' class='editable'>Bob
        echo "<td id='r$i" . "c$j'" . ($thisIsId ? "" : " class='editable'")  . ">$value";
        $thisIsId = false;

I'm trying to fill out a table that contains customer information, but $value keeps returning null. The foreach loops that are commented out are left there because these loops worked except I wasn't able to assign an id to the element based on $i and $j (obviously).

If I add a console.log of json_encode($row) after the line $row = $dataset[$i];, I get a JSON object that has all of the values filled out appropriately. As soon as I go into the nested for loop, I keep getting null values for $value AND $row[$j] if I just call that directly.

The ternary operator exists to check if it's the first column (the ID column) because that's the only cell that is not editable.

I've tried using global $row because I ran into a problem with scope in PHP before but it didn't seem to solve anything. I also tried renaming the $row variable to make sure it wasn't a conflict with when I use $row at the beginning of the page, but that also didn't solve anything.

tl;dr Why is $value returning null when used in a for loop but not when used in a foreach loop?

  • 写回答

2条回答 默认 最新

  • dongyi2534 2016-07-10 17:35

    mysqli_fetch_assoc returns an associative array and not an ordered array :

    So the key are the name of the column in your table that's why you cannot loop over it using a for loop. Use a foreach loop instead.

    You should have a E_NOTICE error raised (Undefined index) in your nested loop.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥15 web课程,怎么做啊😭没好好听课 根本不知道怎么下手
  • ¥15 做一个关于单片机的比较难的代码,然后搞一个PPT进行解释
  • ¥40 matlab简单代码修改补充
  • ¥15 python提取.csv文件中的链接会经常出现爬取失败
  • ¥15 数据结构中的数组地址问题
  • ¥15 maya的mel里,怎样先选择模型A,然后利用mel脚本自动选择有相同名字的模型B呢。
  • ¥15 Python题,根本不会啊
  • ¥15 会会信号与系统和python的来
  • ¥15 关于#python#的问题
  • ¥20 oracle RAC 怎么配置啊,配置