需要在表格的标题中通过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.
更多推荐
发布评论