doutou3725 2018-09-08 18:25

已采纳

根据数组的索引显示不同的HTML元素

I am using Python to scrape through a webpage and then download its table data, <td> elements, and store them in file as JSON. Afterwards, I use PHP to process that data and display it in a table:

<?php
    $file_content = file_get_contents("./file.txt");
    $decoded_json = json_decode($file_content); // $decoded_json becomes an array with 72 elements (each of the elements is a string)
?>

Each row of the table where I got data from has 24 columns. Basically I have 3 rows now (72 elements in an array). I need to create 3<tr> and 24 <td> for each row - dynamically because each time number of rows I scrape may change. Also, I need to add <input type="checkbox"> next to 18th, 21st, and 24th column in my table. Here is what I have so far (it looks at least somewhat close to what I want to achieve):

<table>
    <?php
        $i = 0;
        while ($i <= count($decoded_json)) {
            if ($i % 24 === 0) {
                echo "<tr><td>$decoded_json[$i]</td></tr>";
                $i++;
            } else {
                if ($i % 18 === 0 || $i % 21 === 0 || $i % 24 === 0) {
                    echo "<td>$decoded_json[$i]</td>";
                    echo '<td><input type="checkbox"></td>'; // It does not echo checkboxes correctly because of $i. 
                    $i++;
                } else {
                    echo "<td>$decoded_json[$i]</td>";
                    $i++;
                }  
            }
        }
    ?>
</table>

Questions:

Is this a feasible approach at all?

If yes:

How can I make sure only 1 row is created for each 24 elements in an array (even if my array consists of thousands of elements)? Right now 1 row is created for each 23 elements, and 1st element of 24 is always left out.
How can I add a checkbox next to 18th, 21st, and 24th column of each row? Because I increment $i on every iteration, number is growing, but I guess I have to keep it between 1-24 for every row.

If no:

Which approach would you recommend to use? I prefer PHP.

P.S. I hope I was clear. If not, please ask for clarification. My title may look vague but I did not know how to specify my question in 1 sentence.

Edit (replying to @ggorlen comment): Here is the file content:

["first", "768.51", "4,680", "0", "0%", "0", "0", "0%", "0", "0", "0%", "0", "0.00", "0.00%", "2", "0", "0%", "0", "0.00", "0.00%", "1", "768.51", "100.00%", "4,677", "second", "547.80", "27,392", "0", "0%", "0", "0", "0%", "0", "0", "0%", "0", "44.30", "8.09%", "138", "503.50", "91.91%", "27,254", "0", "0%", "0", "0", "0%", "0", "third", "509.41", "59,777", "0", "0%", "0", "0", "0%", "0", "0", "0%", "0", "0.00", "0.00%", "1", "412.94", "81.06%", "9,972", "22.15", "4.35%", "6,118", "74.32", "14.59%", "43,686"]

Here is what I want to get (sort of; I just need checkboxes next to the 18th, 21st, and 24th columns of each row):

<html><head><title>The Website Title</title></head>
<body>

<table border="1">

<td>first</td><td align="right">768.51</td> <td align="right">4,680</td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">0.00</td> <td align="right">0.00%</td> <td align="right"></td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">0.00</td> <td align="right">0.00%</td> <td align="right"><a >1</a></td><td align="right">768.51</td> <td align="right">100.00%</td> <td align="right"><a >4,677</a></td></tr>

<tr>
<td>second</td><td align="right">547.80</td> <td align="right">27,392</td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">44.30</td> <td align="right">8.09%</td> <td align="right"><a >138</a></td><td align="right">503.50</td> <td align="right">91.91%</td> <td align="right"><a >27,254</a></td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td></tr>

<tr>
<td>third</td><td align="right">509.41</td> <td align="right">59,777</td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">0</td> <td align="right">0%</td> <td align="right">0</td><td align="right">0.00</td> <td align="right">0.00%</td> <td align="right"><a>1</a></td><td align="right">412.94</td> <td align="right">81.06%</td> <td align="right"><a >9,972</a></td><td align="right">22.15</td> <td align="right">4.35%</td> <td align="right"><a>6,118</a></td><td align="right">74.32</td> <td align="right">14.59%</td> <td align="right">43,686<</td></tr>

</table>


</body></html>

</div>

展开全部

写回答
好问题 0 提建议
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

duanbing2963 2018-09-08 21:54

关注

Your code is close. The idea is to formulate the 1d array in terms of rows and columns somehow. My approach was to increment the outer row loop by the number of desired columns (24).

For each row, I echo the opening <tr> tag, then iterate over all the columns in an inner loop and place cells and checkboxes as appropriate. Each cell's index is $row + $col ($col + $row < count($decoded_json) is a safety check). Finally, I close the row's </tr> and move on to the next row, which begins 24 indices further in the array.

Here's a repl to test with.

$columns = 24;
$checkboxes = array_flip([17, 20, 23]);

for ($row = 0; $row < count($decoded_json); $row += $columns) {
    echo '<tr>';

    for ($col = 0; $col < $columns && $col + $row < count($decoded_json); $col++) {
        echo '<td>' . $decoded_json[$row+$col] . '</td>';

        if (array_key_exists($col, $checkboxes)) {
            echo '<td><input type="checkbox"></td>';
        }
    }

    echo '</tr>';
}

Here's the tidied HTML output:

table {
  border-collapse: collapse;
  font-family: monospace;
}

tr,
td {
  padding: 0.6em;
  border: 1px solid black;
}

<table>
  <tr>
    <td>first</td>
    <td>768.51</td>
    <td>4,680</td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td>0.00</td>
    <td>0.00%</td>
    <td>2</td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td><input type="checkbox"></td>
    <td>0.00</td>
    <td>0.00%</td>
    <td>1</td>
    <td><input type="checkbox"></td>
    <td>768.51</td>
    <td>100.00%</td>
    <td>4,677</td>
    <td><input type="checkbox"></td>
  </tr>
  <tr>
    <td>second</td>
    <td>547.80</td>
    <td>27,392</td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td>44.30</td>
    <td>8.09%</td>
    <td>138</td>
    <td>503.50</td>
    <td>91.91%</td>
    <td>27,254</td>
    <td><input type="checkbox"></td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td><input type="checkbox"></td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td><input type="checkbox"></td>
  </tr>
  <tr>
    <td>third</td>
    <td>509.41</td>
    <td>59,777</td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td>0</td>
    <td>0%</td>
    <td>0</td>
    <td>0.00</td>
    <td>0.00%</td>
    <td>1</td>
    <td>412.94</td>
    <td>81.06%</td>
    <td>9,972</td>
    <td><input type="checkbox"></td>
    <td>22.15</td>
    <td>4.35%</td>
    <td>6,118</td>
    <td><input type="checkbox"></td>
    <td>74.32</td>
    <td>14.59%</td>
    <td>43,686</td>
    <td><input type="checkbox"></td>
  </tr>
</table>

</div>

展开全部

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

编辑

预览

报告相同问题？

关注问题

matlab索引超出数组元素的数目 matlab
2022-05-07 05:37

回答 1 已采纳 s太大了，y1长度为201，把s改成小于201的数
tp5出现以下报错未定义数组索引 title php
2021-12-23 05:31

回答 2 已采纳 $data变量没有 title 这个key1、先打印$data，看下里面的数据是否正确2、使用的时候，加一层判断 htmlentities(array_key_exists('title', $da
end运算符必须用在数组索引表达式中 matlab 有问必答
2022-04-07 11:18

回答 2 已采纳检查一下变量y的数据类型和维度，和x对比一下，如果和x一样应该不会有这个问题的。
前端开发中获取数组元素索引号
2021-07-23 07:22

爱前端的小张的博客 DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=dev
php 提示未定义数组索引是什么什么 apache composer mvc nginx php
2020-09-10 03:57

回答 2 已采纳 https://www.cnblogs.com/weilianguang/p/10974428.html
数组索引必须为正整数或逻辑数 matlab
2022-04-10 04:25

回答 2 已采纳你这不是1是小写的L吧看了半天
索引无效，数组索引必须为正整数或逻辑值 matlab
2022-04-27 00:21

回答 1 已采纳看看 I 的size再看看tempY1和tempY2的值
【JavaScript】数组 ④ ( JavaScript 数组新增元素 | 先修改数组长度再填充元素 | 通过索引值追加数组元素 | 使用 push 函数追加数组元素 )
2024-03-29 14:41

韩曙亮的博客一、JavaScript 数组新增元素 1、先修改数组长度再填充元素 2、通过索引值追加数组元素 3、使用 push() 函数追加数组元素
matlab中出现‘数组索引必须为正整数或逻辑值’ matlab
2021-11-15 07:21

回答 1 已采纳 i不能从0开始，你这里需要从2开始 for i = 2:2:27 matlab下标不允许出现0或者负数
错误：位置 2 处的索引无效。数组索引必须为正整数或逻辑值。求结果 matlab
2022-05-19 14:03

回答 1 已采纳 I有时候不是正整数，改成：I=floor(5*i)-4
索引无效，数组索引必须为正整数或逻辑数 matlab
2022-04-27 00:26

回答 2 已采纳应该是tempY小于0了，加个判断看看
获取数组元素的索引号
2022-10-08 08:34

吃不饱的我的博客获取数组索引号
如何从输入数组中获取输入元素的索引号
2021-04-03 21:49

在jQuery环境中，如描述中提及的，我们可以结合HTML元素来获取特定元素的索引。jQuery的`index()`方法用于获取元素在它的兄弟元素中的位置。假设我们有多个类名为"text-box"的元素，可以使用以下代码获取第一个匹配...
html 数组替换元素,使用JavaScript替换数组中的项
2021-06-29 02:20

weixin_39903538的博客方法1：使用splice()方法avaScript中的数组类型为我们提供了splice()方法，该方法通过在所需索引处删除和插入新元素来帮助我们替换现有数组的项。语法：Array.splice(start_index,delete_count,value1,value2,value3...
基于js实现数组相邻元素上移下移
2020-10-14 23:32

图片`<img>`元素用于表示上移和下移的按钮，当鼠标悬浮在图片上时显示，且只有当当前行不是数组的第一个元素或最后一个元素时，才显示对应的按钮。 4. 注意事项：在实现上移和下移时，需要考虑到数组的第一个元素和...
没有解决我的问题, 去提问

码龄粉丝数原力等级 --

根据数组的索引显示不同的HTML元素

1条回答默认最新

码龄粉丝数原力等级 --

根据数组的索引显示不同的HTML元素

1条回答 默认 最新

1条回答默认最新