This code is not serious at all ... but it works. So, it's better than nothing while waiting for a more brilliant add-on
File: date.php
<html><body>
<form method="POST" action="DateCompleted.php">
Date: <input type="date" name="search1" size="12"><br>
<input type="submit" value="OK">
</form></body></html>
File DateCompleted.php:
<?php
$search = $_POST['search1'];
$db = mysql_connect('HOP', 'HOP', 'HOP');
mysql_select_db('HOP',$db);
$sql = 'SELECT itemstatus.dateCompleted,itemstatus.itemId,items.title,items.desiredOutcome,lookup.parentId FROM itemstatus,items,lookup
WHERE itemstatus.itemId=items.itemId AND itemstatus.itemId=lookup.itemId AND itemstatus.dateCompleted="'.$search.'"';
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
echo '<TABLE BORDER="1"><CAPTION> Completed items on'.' '.$search.'</CAPTION>';
while($data = mysql_fetch_assoc($req))
{
$sql2 = 'SELECT items.title FROM items WHERE items.itemId="'.$data['parentId'].'"';
$req2 = mysql_query($sql2) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$data2 = mysql_fetch_assoc($req2);
echo '<TR>
<TH>';
echo $data2['title'] ;
echo '</TH>
<TH>';
echo $data['title'] ;
echo '</TH>
<TH>';
echo $data['desiredOutcome'] ;
echo '</TH>
</TR>';
}
echo '</TABLE>';
mysql_close();
?>
gtd-php
Author
