php - 为 If/else php 插入内联 css/样式

Question

我需要根据状态设置表格样式。例如 Completed = Green & Pending = Orange

PHP 代码。从Mysql中拉取数据

    $query = mysql_query("SELECT * FROM cashouts WHERE uid = ".$Auth->getLoggedId()." ORDER BY id DESC LIMIT $offset, $showPerPage");
    while($row = mysql_fetch_object($query))
    {
    $username = $row->username;

    $amount = $row->amount;
    $status = $row->status;
    $method = $row->method;      
    $priority = $row->priority;          

    if($status == 'Complete' && !empty($row->payment_date))
    $date = date("d M, Y",strtotime($row->payment_date));    
    else
    $date = date("d M, Y",strtotime($row->request_date));


 $payments[] = array('date' => $date, 'amount' => $amount, 'method' => $method, 'status' => $status, 'cycle' => $priority);

我的tpl/html文件代码

    <tbody>

    {if $payments ne ""}
    {foreach item=payment from=$payments}
    <tr>
    <td>{$payment.date}</td>
    <td>${$payment.amount}</td>
    <td>{$payment.method}</td>
    <td>{$payment.status}</td>
    <td>{$payment.cycle}</span></td>
    </tr>
    {/foreach}
    {/if}

    </tbody>

我需要的是 if status = Completed then

    <td style="color: Green;">{$payment.status}</td>

Else if status = Pending then

    <td style="color: Orange;">{$payment.status}</td>

Answer 1

在您的 SQL 选择语句中添加 CASE。

CASE status
    WHEN 'Completed' THEN 'Green'
    WHEN 'Pending' THEN 'Orange'
    ELSE ''
End As color

$color = $row->color

<td style="color: {$payment.color};">{$payment.status}</td>