将一行添加到另一行 - Adding a row to another row

Adding a row to another row

本文关键字：一行添加 | 更新日期: 2023-09-27

我正在尝试将名字和姓氏行放在一行中。这是我到目前为止的代码，

$sql = "SELECT firstname, lastname, phone, department FROM tl_member ORDER BY firstname LIMIT 29";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    echo "<table><tr><br><hr><th align='left'>Naam</th><th align='left'>telefoon<th align='left'>phone</th><th>afdeling</tr>";
// output data in rows
  while($row = $result->fetch_assoc()) {
           echo "<tr><td>" .$row["firstname"]."</td><td>" .$row["lastname"]."</td><td>" .$row["phone"]."</td><td>" .$row["department"]."</tr>";
    }               
echo "</table>";
} else {
echo "0 results";
}

名字和姓氏现在分开显示我希望他们在一起吗？

快到了！您只需要将名字和第二个名字放在同一个 td 中

即可

echo "<tr><td>" . $row["firstname"] . " " . $row["lastname"] . "</td><td>" . $row["phone"] . "</td><td>" . $row["department"] . "</tr>";

我想你的意思是：

$sql = "SELECT firstname, lastname, phone, department FROM tl_member ORDER BY firstname LIMIT 29";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    echo "<table><tr><br><hr><th align='left'>Naam</th><th align='left'>telefoon<th align='left'>phone</th><th>afdeling</tr>";
// output data in rows
  while($row = $result->fetch_assoc()) {
           echo "<tr><td>" .$row["firstname"]." " .$row["lastname"]."</td><td>" .$row["phone"]."</td><td>" .$row["department"]."</tr>";
    }               
echo "</table>";
} else {
echo "0 results";
}

Huum..

诸如此类？

$sql = "SELECT firstname, lastname, phone, department FROM tl_member ORDER BY firstname LIMIT 29";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "<table><tr><br><hr><th align='left'>Naam</th><th align='left'>telefoon<th  align='left'>phone</th><th>afdeling</tr>";
// output data in rows
while($row = $result->fetch_assoc()) {
       echo "<tr><td>" .$row["firstname"]." ".$row["lastname"]."</td><td>" .$row["phone"]."</td><td>" .$row["department"]."</tr>";
}               
echo "</table>";
} else {
echo "0 results";
}

我相信

你的意思是在同一行/单元格中？喜欢这个？

while($row = $result->fetch_assoc()) {
    echo "<tr><td>" .$row["firstname"] . $row["lastname"]."</td><td>" .$row["phone"]."</td>
    <td>".$row["department"]."</tr>";
}

以

这种方式编写查询：

$sql = "SELECT firstname, lastname, phone, department,concat(firstname,'',lastname) fullname FROM tl_member ORDER BY firstname LIMIT 29";
$result = $conn->query($sql);

要获取全名，您需要使用：$row["全名"]