php - html代码中的printf

Question

我想将这段 PHP 代码放入 html 回显中...

*$sql="SELECT SUM(((annual + holiday)+overtime_earned*1.5)/24) FROM leave_balance WHERE user ='$user'";

  if ($result=mysqli_query($con,$sql))
    {
    // Fetch one and one row
    while ($row=mysqli_fetch_row($result))
      {
      printf ("%s \n days off",$row[0] );
      }
    // Free result set
    mysqli_free_result($result);
  }*

'PHP CODE OUTPUT' 是我想要输出 php 代码的地方。

echo "<ul class='nav navbar-nav'>" .
                   "<li><a href='members.php?view=$user' class='active'>PHP CODE OUTPUT</a></li>" .

有更好的方法吗？

Answer 1

我在下面简化了您的代码:

$sql="SELECT SUM(((annual + holiday)+overtime_earned*1.5)/24) FROM leave_balance WHERE user ='$user'";
$result=mysqli_query($con,$sql);
$row=mysqli_fetch_row($result);
echo "<ul class='nav navbar-nav'><li><a href='members.php?view={$user}' class='active'>{$row[0]} days off</a></li>";
mysqli_free_result($result);

另一种方法是将其存储为变量:

$daysoff = $row[0];
echo "{$daysoff} days off";