gpt4 book ai didi

php - 如何更改已输出到 mysql while 循环中的特定文本的格式?

转载 作者:行者123 更新时间:2023-11-29 02:34:03 25 4
gpt4 key购买 nike

我的数据库:

 --------------------------------------------
| id | col1 | col12 | col3 | col4 |
--------------------------------------------
| id | item1 | 40000 | $400 | 1 |
| id | item1 | 60000 | $300 | 0 |
| id | item1 | 80000 | $200 | 0 |
| id | item1 | 10000 | $800 | 1 |
--------------------------------------------

我的查询:

$sqlCommand = "SELECT * FROM table ORDER BY id"; 
$query = mysql_query($sqlCommand) or die (mysql_error());
$var = '';

while ($row = mysql_fetch_array($query)) {
$id = $row['id'];
$var1 = $row['col1'];
$var2 = $row['col2'];
$var3 = $row['col3'];
$var3 = $row['col4'];

$var .= "<div id='div1'><img src='$var1'/></div>
<div id='div2'>$var2</div>
<div id='div3'>$var3</div>
<div id='div4'>$var4</div>";

}

我希望它如何输出数据是在 col3 中具有“1”的项目应该是粗体并且可能是不同的颜色,而其他文本则保留页面字体/文本设置的内容。

如下

---------------------------------------------------
| id | col1 | col12 | col3 |
---------------------------------------------------
| id | item1 | 40000 | $400 |
| id | item1 | 60000 | $300 |
| id | item1 | 80000 | $200 |
| id | item1 | 10000 | $800 |
---------------------------------------------------

这在 while 循环中可能吗?如果不能,我还能怎么做?

最佳答案

$sqlCommand = "SELECT * FROM table ORDER BY id"; 
$query = mysql_query($sqlCommand) or die (mysql_error());
$var = '';

while ($row = mysql_fetch_array($query)) {
$id = $row['id'];
$var1 = $row['col1'];
$var2 = $row['col2'];
$var3 = $row['col3'];
$var4 = $row['col4'];
if($var4==1) { $style = "font-weight:bold"; }
$var .= "<div id='div1'><img src='$var1'/></div>
<div style="$style" id='div2'>$var2</div>
<div style="$style" id='div3'>$var3</div>
<div style="$style" id='div4'>$var4</div>";

}

关于php - 如何更改已输出到 mysql while 循环中的特定文本的格式?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/8120686/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com