| |
| In Query: |
|
<![CDATA[
$sqlquery="Select DATE_FORMAT(posted_date,'%m/%d/%Y') as postdate
from bookmarklet_details where project_id='$project_id'";
]]>
|
| |
| In php variable: |
|
Code for Current date:
<![CDATA[
date(" F d, Y g:i A");
]]>
|
| |
| Output: |
 |
| |
|
Code for day:
<![CDATA[
<?php
$displayDate=date('Y-m-d');
echo "Backup of " .date("l",strtotime($displayDate));
?>
]]>
|
| |
| Output: |
 |
| |
|
Code for date -value come from database:
<![CDATA[
$query =mysql_query("select * from backup_history where
backup_date < '$displayDate' order by backup_date desc limit 1");
$totalrecords=mysql_num_rows($query);
if($totalrecords>0)
{
$row = mysql_fetch_assoc($query);
$previousDate= $row['backup_date'];
echo date(" F d, Y ",strtotime($previousDate));
}
?>
]]>
|
| |
| Output: |
 |