function GenerateFMTable($headings, $data, $feedbackNotMessage, $conn) { //headings echo '<div class="z-depth-1 row center white"> <div class="col s12"> <ul class="row center">'; foreach ($headings as $key => $heading) { echo '<li class="col s3 sortCell' . $key . '">' . $heading . '</li>'; } echo '</ul> </div> </div>'; //and body echo '<ul class="collapsible popout z-depth-1 sortable" data-collapsible="accordion">'; while ($row = $data->fetch_assoc()) { $tags = GetTagsString($row['FeedbackID'], $conn); $text = sanitizeOut($row['Text']); echo '<li> <div class="collapsible-header"> <div class="row center">'; if ($feedbackNotMessage) { echo '<div class="col s3 sortCell0">' . sanitizeOut(AnonOrUserName($row)) . '</div>'; echo '<div class="col s3 sortCell1 truncated">' . $text . '</div>'; } else { //TODO: //echo '<div class="col s3 sortCell0">' . sanitizeOut('TODO FROM') . '</div>'; //echo '<div class="col s3 sortCell1">' . sanitizeOut('TODO TO') . '</div>'; } echo '<div class="col s3 sortCell2 truncated" title="' . $tags . '">' . $tags . '</div>'; //alt-text for many tags and narrow windows echo '<div class="col s2 sortCell3">' . sanitizeOut($row['Edited']) . '</div>'; echo '<div class="col s1">'; echo '<a href="FeedbackDetails.php?FeedbackID=' . sanitizeOut($row['FeedbackID']) . '" class="secondary-content">'; echo '<i class="mdi-content-send right"></i> </a> </div> </div> </div>'; echo '<div class="collapsible-body white">'; echo '<p>' . $text . '</p>'; echo '</div> </li>'; } echo '</ul>'; }
function DisplayDetailsBar() { $conn = connectToDB(); $FeedbackID = $_GET['FeedbackID']; SanitizeIn($FeedbackID); $sql = "SELECT `FeedbackID`, `FirstName`, `LastName`, `Anonymous`, DATE_FORMAT(`Edited`,'%M %d, %Y') AS `Edited` " . "FROM `Feedbacks`, `Users` WHERE `FeedbackID`='" . $FeedbackID . "' AND `Users`.`UserID`=`Feedbacks`.`UserID`"; $feedback = GetSingleDbValue($sql, $conn); if ($feedback) { echo '<td>' . sanitizeOut($feedback['FeedbackID']) . '</td>'; //<td>CS is okay</td> echo '<td>' . AnonOrUserName($feedback) . '</td>'; //<td>Dr.Beane</td> echo '<td>' . sanitizeOut($feedback['Edited']) . '</td>'; } $conn->close(); }