PHP-databaskonstruktion

Log | Files | Refs

reports.php (1126B)

      1 <?php
      2     require 'utils/imports.php';
      3 
      4     $searchQuery = $_GET['query'] ?? null;
      5 
      6     $pageContent = '';
      7 
      8     $pageContent .= "<h3>Reports</h3>" . tableFactory::createCardTable("Report");
      9     
     10     $pageContent .= "<hr>";
     11 
     12     $pageContent .= "<h3>Archived Reports</h3>";
     13 
     14     $pageContent .= '<div class="mt-3 mb-3">';
     15     $pageContent .= '    <form class="form-inline" action="" method="GET">';
     16     $pageContent .= '        <div class="form-group">';
     17     $pageContent .= '            <input type="text" class="form-control" id="query" name="query" placeholder="Search for old report" value="' . htmlspecialchars($_GET['query'] ?? '') . '">';
     18     $pageContent .= '        </div>';
     19     $pageContent .= '        <button style="margin-left:0.5em;" type="submit" class="btn btn-primary">Search</button>';
     20     $pageContent .= '    </form>';
     21     $pageContent .= '</div>';
     22 
     23     $sqlQuery = $searchQuery ? "SELECT * FROM ArchivedReport WHERE Title LIKE '%{$searchQuery}%';" : "SELECT * FROM ArchivedReport;";
     24     $pageContent .= tableFactory::createCustomTable($sqlQuery, "ArchivedReport");
     25 
     26     include 'utils/pageTemplate.php';
     27 ?>