includes/searcher.php
/**
   * CONTENTdm Table Renderer
   *
   * Queries the database for any data that would matter coming from the
   * `manuscripts` table.
   *
   * All manuscript-type data will return the same headers:
   * - Thumbnail
   * - Title
   * - Description
   *
   * @param String $type
   *   The media type.
   *
   * @return String
   */
CONTENTdm Table Renderer
Queries the database for any data that would matter coming from the
`manuscripts` table.

All manuscript-type data will return the same headers:
- Thumbnail
- Title
- Description

@param String $type
The media type.

@return String
CONTENTdm Table Renderer Queries the database for any data that would matter coming from the ` manuscripts ` table . All manuscript - type data will return the same headers : - Thumbnail - Title - Description @param String $type The media type . @return String
private function renderContentTable($type) {
    global $application;
    $html  = "";
    $media = "";
    if ($type === "manuscripts") {
      $media = "media LIKE '%Manuscripts'";
    } else {
      $media = "media ILIKE '" . $type . "'";
    }
    $prepare = $this->connection->prepare("
      SELECT descri, media, pointer, title
      FROM   manuscripts
      WHERE  (" . $this->renderQuery("content") . ")
        AND  $media
    ");
    $prepare->execute($this->populateArray("content"));
    foreach ($prepare->fetchAll() as $key=>$result) {
      $html .= "<tr>";
      $html .= "<td>"
        . "<a href=\"" . $application->getURL() . "view-content.php?pointer=" . $result["pointer"] . "\">"
        . "<img src=\"" . $application->buildManuscriptThumbURL($result["pointer"]) . "\" class=\"img-responsive\" alt=\"Thumbnail of " . $result["title"] . "\">"
        . "</a>"
        . "</td>";
      $html .= "<td>"
        . "<a href=\"" . $application->getURL() . "view-content.php?pointer=" . $result["pointer"] . "\">" . $result["title"] . "</a>"
        . "</td>";
      $html .= "<td>" . $result["descri"] . "</td>";
      $html .= "</tr>";
    }
    return $html;
  }
private function renderContentTable ( $ type ) { global $ application ; $ html = " " ; $ media = " " ; if ( $ type === " manuscripts " ) { $ media = " media LIKE '%Manuscripts' " ; } else { $ media = " media ILIKE ' " . $ type . " ' " ; } $ prepare = $ this -> connection -> prepare ( " 
      SELECT descri, media, pointer, title
      FROM   manuscripts
      WHERE  ( " . $ this -> renderQuery ( " content " ) . " )
        AND   $ media " ) ; $ prepare -> execute ( $ this -> populateArray ( " content " ) ) ; foreach ( $ prepare -> fetchAll ( ) as $ key => $ result ) { $ html .= " <tr> " ; $ html .= " <td> " . " <a href= \" " . $ application -> getURL ( ) . " view-content.php?pointer= " . $ result [ " pointer " ] . " \" > " . " <img src= \" " . $ application -> buildManuscriptThumbURL ( $ result [ " pointer " ] ) . " \"  class= \" img-responsive \"  alt= \" Thumbnail of  " . $ result [ " title " ] . " \" > " . " </a> " . " </td> " ; $ html .= " <td> " . " <a href= \" " . $ application -> getURL ( ) . " view-content.php?pointer= " . $ result [ " pointer " ] . " \" > " . $ result [ " title " ] . " </a> " . " </td> " ; $ html .= " <td> " . $ result [ " descri " ] . " </td> " ; $ html .= " </tr> " ; } return $ html ; }
CONTENTdm Table Renderer
 Queries the database for any data that would matter coming from the
 `manuscripts` table.
CONTENTdm Table Renderer Queries the database for any data that would matter coming from the ` manuscripts ` table .
// Render the thumbnail with a link. // Render the title with a link. // Render the description.