我有一个表格可以更新学校的房间状态。表格具有状态:准备好,工作,计划且未准备就绪。
文件中回声的代码是:
<?php
$mysqli = new mysqli("localhost", "root", "", "angular");
$result = $mysqli->query("SELECT * FROM c246 ORDER BY id DESC LIMIT 2");
while($row = mysqli_fetch_array($result)) {
echo "<div class='room_status_info'>";
echo "<h3 class='room_numer'><b class='status_info'>Romnummer:</b> " . htmlentities($row['roomnumber']) . "</h3>";
echo "<br>";
echo "<p class='room_status'> <b class='status_info'>Status:</b> " . htmlentities($row['status']) . "</p>";
echo "<br>";
echo "<p class='time_updated'> <b class='status_info'>Oppdatert:</b> " . htmlentities($row['updated']) . "</p>";
echo "<br>";
echo "<p class='informasjon_rom'> <b class='status_info'>Informasjon:</b> " . htmlentities($row['information']) . "</p>";
echo "<br>";
echo "<p class='updated_by'> <b class='status_info'>Oppdatert av:</b> " . htmlentities($row['updated_by']) . "</p>";
echo "</div>";
}
?>
现在,我想为状态文本添加颜色。我有一个称为:colorcode的行,在更新房间时,我可以从下拉列表中选择颜色代码。
颜色代码在mysql中,但现在我想知道。我将如何将该颜色代码添加到状态文本?
在这里颜色应该是:
echo "<p class='room_status'> <b class='status_info'>Status:</b> " . htmlentities($row['status']) . "</p>";
文本状态不会有颜色,而是其后的文字。htmlentities($ row ['status'])
希望任何人都有一些答案。
如果我正确解释了您的问题,则要显示数据库中的彩色输出,并带有您先前定义的颜色。
这样的事情会做技巧
echo "<p class='room_status'> <b class='status_info' style='color: #'. $row['colorcode']: .' >Status:</b> " . htmlentities($row['status']) . "</p>";
sukhdev mohan
<b class='status_info'>Status:</b>
将其添加到其中:
<b class='status_info' style='color: htmlentities($row['colorcode'])'>Status:</b>