需要在表格的标题中通过php添加日期(Need to add Date via php in header of table)

需要在表格的标题中通过php添加日期(Need to add Date via php in header of table)

我有一个页面，我想在表格的标题中显示昨天的日期。 我尝试了这段代码，但无法显示日期值。 请帮忙！

<?php $con=mysqli_connect("localhost","root","") or die("Failed to connect with database!!!!"); mysqli_select_db($con,"db"); $result = mysqli_query($con,"SELECT * FROM `table`"); echo "<table border='1' align='center'> <tr><th colspan='9'>DATA <?php echo date("d/M/Y",strtotime("-1 days")); ?></th></tr> <tr> <th>COLUMN A</th> <th>COLUMN B</th> </tr>"; echo "</table>"; mysqli_close($con); ?>

I have a page where i want to display yesterday's date in the header of the table. I tried this code but not able to display the date value. Please Help!

<?php $con=mysqli_connect("localhost","root","") or die("Failed to connect with database!!!!"); mysqli_select_db($con,"db"); $result = mysqli_query($con,"SELECT * FROM `table`"); echo "<table border='1' align='center'> <tr><th colspan='9'>DATA <?php echo date("d/M/Y",strtotime("-1 days")); ?></th></tr> <tr> <th>COLUMN A</th> <th>COLUMN B</th> </tr>"; echo "</table>"; mysqli_close($con); ?>

最满意答案

作为@Ranjith所说的替代方案，您也可以这样做：

<?php $con=mysqli_connect("localhost","root","") or die("Failed to connect with database!!!!"); mysqli_select_db($con,"db"); $result = mysqli_query($con,"SELECT * FROM `table`"); ?> <table border='1' align='center'> <tr> <th colspan='9'> DATA <?=date("d/M/Y",strtotime("-1 days"));?&t; </th> </tr> <tr> <th>COLUMN A</th> <th>COLUMN B</th> </tr>"; </table>"; <? mysqli_close($con);

在PHP代码中你可以使用?>和<? 在PHP和HTML之间切换。 <?=是echo的简短形式。

As an alternative to what @Ranjith said, you could also do this:

<?php $con=mysqli_connect("localhost","root","") or die("Failed to connect with database!!!!"); mysqli_select_db($con,"db"); $result = mysqli_query($con,"SELECT * FROM `table`"); ?> <table border='1' align='center'> <tr> <th colspan='9'> DATA <?=date("d/M/Y",strtotime("-1 days"));?> </th> </tr> <tr> <th>COLUMN A</th> <th>COLUMN B</th> </tr>"; </table>"; <? mysqli_close($con);

in PHP-code you can use ?> and <? to switch between PHP and HTML. The <?= is a short form for an echo.