将具有相同id的行合并到数组中 - Merge rows in the same id into array

Merge rows in the same id into array

本文关键字：合并数组 id | 更新日期: 2023-09-27

我有句子表：

======================================================================
|  id_row  |  id_document |   id_sentence   |       sentence         | 
======================================================================
|     1    |       1      |       0         | Example sentences A    |
|     2    |       1      |       1         | Example sentences B    |
|     3    |       2      |       0         | Example sentences C    |
|     4    |       2      |       1         | Example sentences D    |
======================================================================

我想将具有相同id_document的句子合并到数组中，如=>Array( [1] => Array ( [0] => Example sentences A [1] => Example sentences B ) [2] => Array ( [0] => Example sentences C [1] => Example sentences D ))

这是代码：

<?php
require_once 'conf.php';
$sql = mysql_query('SELECT sentence FROM sentence group by id_document') or die(mysql_error());
while ($row = mysql_fetch_array($sql)) {
    $sentence[] = $row['sentence'];
}
print_r($sentence);
?>

但是，我只是在每个不同的id_document中得到一句话。帮帮我。谢谢：）

对id_document上的数组进行索引，并向数组中添加新条目，如下所示：

while ($row = mysql_fetch_array($sql)) {
    $sentence[ $row['id_document'] ][] = $row['sentence'];
}

您可以编写：

while ($row = mysql_fetch_array($sql))
{
   $sentence[$row['id_document']][] = $row['sentence'];
}

while ($row = mysql_fetch_array($sql))
  $sentence[$row['id_document']][] = $row['sentence'];

这是我的最终代码：

<?php
require_once 'conf.php';
$sql = mysql_query('SELECT sentence, id_document FROM sentence ') or die(mysql_error());
while ($row = mysql_fetch_array($sql)) {
   $sentence[$row['id_document']][] = $row['sentence'];
}
print_r($sentence);
?>