-
Notifications
You must be signed in to change notification settings - Fork 0
/
matchedItemsUserFound.php
38 lines (31 loc) · 1.01 KB
/
matchedItemsUserFound.php
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
<?php
//Select any matched items, this user has found and display them
$matchedItems = 0;
$sql = "SELECT * FROM Matched";
$matchedResult = $conn->query($sql);
while($matchedRow = $matchedResult->fetch_assoc())
{
if($matchedRow["FinderID"] == $sessionId)
{
$sql = "SELECT ID, FinderId, ItemName, Descript, Location, Date FROM Items";
$itemsResult = $conn->query($sql);
while($row = $itemsResult->fetch_assoc())
{
if($row["ID"] == $matchedRow["ItemID"])
{
$displayId = $matchedRow["MislayerID"];
$sqlDisplay = "SELECT Name, isInstitution FROM Users WHERE ID = '$displayId'";
$displayResult = $conn->query($sqlDisplay);
$dRow = mysqli_fetch_assoc($displayResult);
$matchedItems++;
//update the number label of the item.
include "showMatchedItemsUserFound.php";
}//if
}//while
}//if
}//while
if($matchedItems == 0)
{
echo "You have no matched items <br><br>";
}//if
?>