我正试图从mysql数据库中获取数据,但遇到了一些问题。我有一个表单,用户可以在其中输入文本,我可以将其发送到数据库,但在显示时,如果文本太长,则文本不适合表。我希望在20个字符之后有一个新行。这怎么可能?即使我将表格宽度设置为某些像素,文本也会从表格中移出。
这一行有很长的文本,我希望每20个字符有一行新行
echo "<td>" . $row['lastname'] . "</td>";
<?php
$con=mysqli_connect("localhost","root","","users");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM users");
echo "<table border='1' width='640px'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>
参见wordwrap
。类似于:
echo wordwrap($yourString, 20, '<br>');
但是,使用CSS(word-wrap: break-word
)