1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
| <tr>
<td>
<?PHP
include("connect.php");
$GetIss = 'SELECT client.idclient, client.clientname, issuetask.noissue, issuetask.title, issuetask.priority, project.noproject, issuetask.iduser, project.priority
FROM CLIENT, ISSUETASK, PROJECT, USER
WHERE client.idclient = project.idclient
AND issuetask.iduser = user.iduser
AND project.noproject LIKE "%'.mysql_real_escape_string($_GET["Keyword"]).'%"
ORDER BY noproject ASC';
$ResultGetIss = mysql_query($GetIss);
?>
<table class="sorTableView">
<thead>
<tr>
<th data-sort="string" class="userTdTitle" scope="col" width="15%">#Issue</th>
<th data-sort="string" class="userTdTitle" scope="col" width="35%">Title</th>
<th data-sort="string" class="userTdTitle" scope="col" width="25%">Client</th>
<th data-sort="string" class="userTdTitle" scope="col" width="15%">Responsible</th>
<th data-sort="int" class="userTdTitle" scope="col" width="10%">Priority</th>
</tr>
</thead>
<tbody>
<?PHP
$KeyW = $_GET["Keyword"];
if ($KeyW=='')
{
// Le tableau sera vide lorsque l'utilisateur arrivera sur la page
}
else
{
while($ResultIss = mysql_fetch_array($ResultGetIss))
{
?>
<tr>
<td class='userTd1'>
<a href="edittask.php?IDIssue=<?PHP echo $ResultIss["idissue"]; ?>"><?PHP echo $ResultIss["noproject"]."-".$ResultIss["noissue"]; ?></a>
</td>
<td align='center' class='userTd1'><?PHP echo $ResultIss["title"]; ?></td>
<td align='center' class='userTd1'>
<a href="admin_client_info.php?IDClient=<?PHP echo $ResultPro["idclient"]; ?>"><?PHP echo $ResultPro["clientname"]; ?></a>
</td>
<td align='center' class='userTd1'><?PHP echo $ResultIss["responsible"]; ?></td>
<td align='right' class='userTd1'><?PHP echo $ResultIss["priority"]; ?></td>
</tr>
<?PHP
}
}
?>
</tbody>
</table>
</td>
</tr> |